Warranty status by department

[sqldba01]

Need a report with warranty status by department.  I'd like to have department based off of the last logged on 'user' field and then drill into the AD user information to pull their department or manager or something to help inform managers and facilitate budgeting. I know last logged on is not always the owner or user. Thanks for any help.

[Tim_N · Accepted solution]

Hello @sqldba01 

In order to track every user that logs onto a system, you'll need to use LsPush. Introduction to the LsPush scanning agent for Windows (lansweeper.com)

LsPush is a script-based "agent" that must be ran through a GPO, scheduled task, logon script, etc. This is an important tool to use if you'd like to have more frequent scans based on specific triggers. 

See if this helps you provide the details on each user as you are looking for.