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

Please log in to comment

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

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share