Hi,
There's no ready report for this unfortunately.
I'm using following workaround:
1. Get standard user report and put it in Excel so you have a list of users in column A. Use =trim() if needed.
2. I'm taking a log file for last 3 months based on following user activity - data entry, - import from flat file, - import from Excel. Conditions may vary depending on your environment.
3. Put this log into second spreadsheet, use trim again to make sure users ID are the same as in A.
4. Use vlookup on the first sheet in B (=IFERROR(VLOOKUP(A169;Sheet0!A:B;2;FALSE);"NO ACTIVITIES IN COGNOS FOR LAST 3 MONTHS"))
You're done.
Regards,
Andrejs
------------------------------
Andrejs kuliks
------------------------------
Original Message:
Sent: Tue February 18, 2020 09:26 PM
From: Wai Wai
Subject: How to extract user usage from cognos
Hi
Can anyone lighten me how to extract the user usage from Cognos 10.2? And also would like to know how can I check the active users and inactive users together with their specific roles and group name. Also would like to extract those info from Cognos.
Thanks and Best Regards,
Wai Wai
------------------------------
Wai Wai Data Engineer
------------------------------
#CognosAnalyticswithWatson