How to get a list of logged on users..!

[Ricky@MDPD]

How can I get a list of users who are currently logged on in version 8.3. I do not have SDK.

[bonniehsueh]

Have you tried the audit reports? They should come with the 8.3 software package. The installation documentation should instructions on how to install the package and reports.

[biejorrun]

Try this query on the Audit Package (I tested this on 8.2!):

Code Select Expand

select COGIPF_USERLOGON.COGIPF_USERNAME as [User Name],
COGIPF_USERLOGON.COGIPF_LOCALTIMESTAMP as [Login Time]
from (
select
COGIPF_USERLOGON.COGIPF_USERNAME,
COGIPF_USERLOGON.COGIPF_LOCALTIMESTAMP,
COGIPF_USERLOGON.COGIPF_TIMEZONE_OFFSET,
COGIPF_USERLOGON.COGIPF_SESSIONID,
COGIPF_USERLOGON.COGIPF_LOGON_OPERATION
from
COGIPF_USERLOGON COGIPF_USERLOGON (nolock)
where
COGIPF_USERLOGON.COGIPF_LOGON_OPERATION = 'Logon'
and COGIPF_USERLOGON.COGIPF_USERNAME <> ''
) COGIPF_USERLOGON
left outer join (
select COGIPF_USERLOGON.COGIPF_USERNAME,
COGIPF_USERLOGON.COGIPF_LOCALTIMESTAMP,
COGIPF_USERLOGON.COGIPF_TIMEZONE_OFFSET,
COGIPF_USERLOGON.COGIPF_SESSIONID,
COGIPF_USERLOGON.COGIPF_LOGON_OPERATION
from COGIPF_USERLOGON COGIPF_USERLOGON (nolock)
where COGIPF_USERLOGON.COGIPF_LOGON_OPERATION <> 'Logon'
and COGIPF_USERLOGON.COGIPF_USERNAME <> ''
) COGIPF_USERLOGOFF on COGIPF_USERLOGOFF.COGIPF_SESSIONID = COGIPF_USERLOGON.COGIPF_SESSIONID
where COGIPF_USERLOGOFF.COGIPF_LOCALTIMESTAMP is null

Good luck!

Regards,

Bjorn

[Ricky@MDPD]

Unfortunatly, I do not have the Audit Package installed.. any other ideas??

[biejorrun]

Unfortunatly, I do not have the Audit Package installed.. any other ideas??

As far as I know, this would only be possible using the Audit package. You can easily install it, it comes with Cognos 8.3. Otherwise, I don't know any other options.

Bjorn

[ducthcogtechie]

You can use the cmtools.exe utility from the bin directory to read out the active users, but i would
advise to install the audit package like biejorrun  says, as that is much easier to use.