User has access but not logged in for last 3 months

Question

Hi experts,

I have to create a report for @User has access but not logged in for last 3 months@

We have 3 columns in Usage Tracking that is User_Name, END_DT, Start_DT by using these 3 columns we have to create report for User has access but not logged in for last 3 months.

I am trying to create it but failed, Can anyone help me to write case statement and create that report .

Gianni Ceresa · Answer

Technically usage tracking isn't enough for what you ask: what if the user never logged in the system at all? The user will not exist in the usage tracking table.

To get where you want with the usage tracking table you need a filter that isn't about selecting users but about excluding them.

The easier will be to use an analysis as filter criteria: make an analysis selecting username and with records in the last 3 months.

Then in the original analysis you select any user name of the table excluding those selected by the other analysis (which means you are selecting all users in the table and removing those who have records in the last 3 months).

This will do the job, but remember that you still have a gap: users who never connected a single time. Those can't come from OBIEE/OAS but should come from your enterprise authentication provider because that's the one having the information of who are all the users allowed to use the tool.