How can I get a list of users who are currently logged on in version 8.3. I do not have SDK.
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.
Try this query on the Audit Package (I tested this on 8.2!):
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
Unfortunatly, I do not have the Audit Package installed.. any other ideas??
Quote from: Ricky@MDPD on 21 Oct 2008 12:26:36 PM
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
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.