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

0 Comments   [ + ] Show comments

Answers (0)

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ