Kace 1000 reportes on a specific label
Hi guys,
I would like to create a report specific to a label.
The report has to give me a list with all the computers that are loged on on a specific time and from an specific IP range.
The label i created is the IP range.
So i would like to see wich computer is still logen on after working hours on that specific IP range and to get this as a report on my email address.
Thankx,
Diana
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
dugullett
11 years ago
You could do this two ways. As for logon times I would take a look at this http://itninja.com/blog/view/how-to-find-user-log-on-and-log-off-time You could report on the last check in, or AMP connection but those will occur regardless of if they are logged in or not.
SELECT NAME, LAST_SYNC FROM MACHINE M WHERE IP LIKE '192.168.10%'
OR....
SELECT NAME, LAST_SYNC FROM MACHINE M LEFT JOIN MACHINE_LABEL_JT MLJT ON MLJT.MACHINE_ID = M.ID LEFT JOIN LABEL L ON L.ID = MLJT.LABEL_ID WHERE L.NAME = '<LABEL_NAME>'
