View 5.0 Logon Report per Entitled User

[OrkanNamedMork]

We have a lot of outside vendors connecting to numerous View pools. Unfortunately the departments they're serving internally are not good at auditing vendor employee turnover. I need a way to audit user logons say for users who have not logged on in the last 90 days. We're playing around with the View SCOM MP, but the report there appears to not be current. The attribute it pulls is "SMS_G_System_SYSTEM_CONSOLE_USER.Time Stamp", but this value on cross check with View admin events appears dated.

Is there an existing report in the SCOM MP that would fill this need? If not, is there a query against the View database tables that would provide this info?

[mittim12]

You could query the Events database for users and the 'AGENT_CONNECTED'  message. 

[nickjo68]

Hello - We are looking to do the same thing.  Would you happen to have a sample SQL query I might be able to use as a base for the logic?  I'm attempting to find inactive users that have not logged in within 60 days.  I am not using SCOM MP.

Thank You.