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.
Answer Chosen by the Author
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: