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:
Please log in to answer
Posted by:
Hobbsy
8 years ago
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:
-
Awesome! Thanks for the help - captains1stm8 8 years ago
