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