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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User Activity

Status
Not open for further replies.

Wajid55

Programmer
Apr 6, 2006
48
CA
I want to check when was the last time user Ran a report or may be logged into InfoView.

Is there a way to do this?
 
To get the last login, query the user InfoObject for SI_LAST_ACCESS.

There are two ways to find out when a user ran a report.

1. If you're looking for a specific report, get the SI_OWNER property of the instance and find the most recent one where the owner is the user you're looking for.

2. If you're looking in general for any report, you either have do step 1 to look at all instances of all reports or, if you have auditing turned on you can go to the auditing database and get the information. You can look in the "Activity" universe to get the information you need for querying this data.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
What is the exact name of the table which i am queriing?

user_infoobject or something else?
 
Where can I find these SI tables and their structure? or somekind of data dictionary?
 
You can't query the CMS tables directly - you have to go through the SDK, like in Excel through VBA or from a program you've written. Most of the information you need is stored in a BLOB in binary format that you can't access except through the SDK>

To get user information from the CMS, you need to query the SI_SYSTEMOBJECTS table.

TO get the "Last Scheduled" information, you need to connect to your auditing database and look at the AUDIT_EVENT table (you can query this directly). This table includes a UserName field. Check the Event_Type table to get the EVENT_TYPE_ID value(s) that are like "Scheduling" (there are 4 of them, but you may not be interested in all of them) to determine the ID's you need. If you're interested in when a user opened a report, you can also look for the "View" events and the "Open" events.

Depending on the total information you need in your report, you could also write a report against the Activity universe to get the last login and report activity information for users.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top