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

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0
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%'
Answered 03/16/2016 by: Hobbsy
Red Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity