Identifying Obsolete Users

[andy_mason_84]

Hi All,

Anyone have any ideas on whether or not you can pull out a list of users and the last time they logged in from the content store?

Cheers,

AM

[norkos]

Hi,

I'm affraid you cannot get logon information from content store.

This data is stored in the audit store, so you can easily pull it with a report or a select like this:

Code Select Expand

select
ul.COGIPF_USERNAME,
ul.COGIPF_USERID,
max(ul.COGIPF_LOCALTIMESTAMP) as last_logon_time
from
DWH_TU_COGNOS_LG_DV.COGIPF_USERLOGON ul
where
lower(ul.COGIPF_LOGON_OPERATION) = 'logon'
group by
ul.COGIPF_USERNAME,
ul.COGIPF_USERID

NoRkoS

[andy_mason_84]

Brilliant Cheers,

We have all our logging on minimum ... will i still get the information i need?

Cheers,

AM

[norkos]

Unfortunatelly I've got bad news. On minimal logging level Cognos logs only system and service informations - e.g. runtime errors.
User informations are logged only on basic or higher logging levels, so you have to change it to get the informations you need.

But I've got also good news. In Cognos you can set the logging levels very sophisticated, you can set different levels for different services.
In this case you have to change the logging level to basic only for the Content Manager service. So the logon infromations will be stored in the audit store w/o overloading the system.

NoRkoS