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)
Please log in to answer
Posted by:
chucksteel
6 years ago
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.