I need to run an audit report on which reports are being viewed and who is viewing each individual report. I have CMS_AUDITTABLE to pull the UserName from but I need to be able to associate that UserName (which currently is popluated with an employee number) with the Account Name in the Users: Properties tab to get the Full Name.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
USERS table name
- Thread starter jhuddy
- Start date
If you are using BOE-XI (R2), you are better to use the "AUDITOR" Universe that has all the relationships matched already.
You want to use the following Classes and Measures :
Action Name
Action YYYY-MM-DD
User Name
Number of Actions
The specific Action Name you want to query on is "Reports Viewed Sucessfully".
You want to use the following Classes and Measures :
Action Name
Action YYYY-MM-DD
User Name
Number of Actions
The specific Action Name you want to query on is "Reports Viewed Sucessfully".
- Thread starter
- #3
AndrewBaines
Technical User
Not sure if that's available in auditing or not - never was a big fan.
Easy enough to write an extract to get all the user info out of the CMS table into CSV. Then import that as a new table.
Contact through my website if interested.
Andrew Baines
Easy enough to write an extract to get all the user info out of the CMS table into CSV. Then import that as a new table.
Contact through my website if interested.
Andrew Baines
- Status
Similar threads
- Locked
- Question
- Locked
- Question