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

Comments

Please log in to comment

Answers

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.
Answered 11/20/2017 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share