Last Users Logged-In Report
We are trying to generate a report that will list all users that have logged into a computer in the last 90 days.
Ideally we would like it grouped by the device name. Also would be preferred to target a select group of computers based on a smart label.
Device -> List of Users on that device-> maybe login date/time would be the fields we need, if possible...
This is about all we came up with and it doesn't really report how we want
select * from ASSET_HISTORY where FIELD_NAME='LAST_USER' group by NAME;
Any help would be appreciated
Be the first to answer this question