/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Kace 1000 reportes on a specific label

03/11/2013 3344 views

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

Comments


All Answers

2

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>'

 
Answered 03/11/2013 by: dugullett
Red Belt

 
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