/build/static/layout/Breadcrumb_cap_w.png

Report Request

Hi, All.  I'm trying to configure a report that shows all the systems (beginning with specific characters) and the last time a user logged into it.  Whether it shows which user is not so important.  Just the date of last logon.

I'm pretty new to the report wizard and am having trouble making sense of it.

Any help would be appreciated.

Thanks!

- Shaun


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: Hobbsy 4 years ago
Red Belt
0

Top Answer

First, please note that the agent does not collect the last logged on time in the inventory, you may be able to pull this back as a custom inventory field, but I used the last startup time from the O/S section.

Using the wizard I generated the following code

SELECT MACHINE.NAME AS SYSTEM_NAME, LAST_REBOOT, USER_LOGGED  FROM MACHINE  WHERE ((MACHINE.NAME like 'I%'))  ORDER BY SYSTEM_NAME, LAST_REBOOT

You will just need to replace the highlighted text with whatever characters you want your machine names to start with. So if you want all machine names starting PC then replace the text with 'PC%'

Comments:

Don't be a Stranger!

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

Sign up! or login

Share

 
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