/build/static/layout/Breadcrumb_cap_w.png

Login Sharing Report

Hello! 

I'm a bit new to KACE reporting, and am looking to create a report that looks for any one Last User on more than one asset within the past 24 hours. My work around is exporting the entire org and filtering in Excel but I would rather it come straight from KACE.

Any thoughts on how to go about this?

Thanks.

0 Comments   [ + ] Show comments

Answers (1)

Posted by: chucksteel 6 years ago
Red Belt
0
This report will show that data with some caveats:
SELECT VALUE1, COUNT(NAME) as LOGINS, GROUP_CONCAT(NAME) AS COMPUTERS FROM ASSET_HISTORY
WHERE FIELD_NAME = "USER_NAME"
AND TIME > DATE_SUB(NOW(), INTERVAL 24 HOUR)
GROUP BY VALUE1
HAVING LOGINS > 1

The major caveat is that the K1000 only updates the user information at inventory, not at login, so not all logins will be included in this report, and the longer your inventory check-in is, the less accurate it will become. You might have better success tracking this type of information via Active Directory, or whatever other system you are using for authentication.
 
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