Hi,

 

I'm trying to generate a report of users that have or had logged into the Kace appliance. I want to show who has been using the appliance and who hasn't been logging into the appliance. I'm looking for sql code similar to this but instead of event being run, it's a user being logged in.

 

SELECT NAME, USER_TEXT, TIME

FROM ORG1.OBJECT_HISTORY O

WHERE CHANGE_TYPE = 'EVENT'

ORDER BY TIME

1 Comment   [ + ] Show Comment

Comments

  • Just logging in, or logging in and doing something?
Please log in to comment

Answers

1

The OBJECT_HISTORY table doesn't contain login events, only changes to objects which are configured to be tracked. In looking at the tables in the database I don't believe any show when a user has logged in.

Answered 05/24/2013 by: chucksteel
Red Belt

  • I'm pretty sure that is the case. The K1000 only tracks IP addresses in the Access log and that may just be for the admin UI.
Please log in to comment
Answer this question or Comment on this question for clarity