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.

[sqldba01]

Tim_N, 

We do not use LSPush yet. But, would this not simply show the last logged on user vs a history of logins, or a field with most frequent login (or actual owner/user) which would allow a report on the user in AD leading to the department responsible for the device nearing end of warranty for notification and budgeting purposes. Thanks again.

[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.