/build/static/layout/Breadcrumb_cap_w.png

Report on users logged into the Kace 1000

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

Asked 11 years ago 3729 views
1 Comment   [ + ] Show comment
  • Just logging in, or logging in and doing something? - dugullett 11 years ago

Answers (1)

Posted by: chucksteel 11 years ago
Red Belt
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.

Comments:
  • 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. - jknox 11 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ