I need to create a report that will show what system are currently connected via the amp connection to the server at a certian time.

I need system name, Logged in user, IP address to show next to the entry.

Any help would be awesome.

Thanks

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

The report template for topic -> computer will create this report and show if a machine is connected.  I tested this by just selecting Machine Connected and the other necessary fields from the Fields to Display page.  A '0' is not connected a '1' is connected. 

If you only want the machines that are currently connected you could modify the query like this:

SELECT MACHINE.IP, SC.CLIENT_CONNECTED, MACHINE.NAME AS SYSTEM_NAME, USER_LOGGED  FROM MACHINE  LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID
WHERE SC.CLIENT_CONNECTED LIKE '1'

I just added the WHERE clause to the query the report template created.

You could have also just added the Filter "Machine Connected" = 1 when creating the report at the Filters page.

 

Answered 05/23/2013 by: dimitris
Purple Belt

Please log in to comment

Answers

0

I was able to update one report I found in the system. I did not get the IP information I was after but that is not critial. Here is the SQL information if any one is interested.

select M.USER_LOGGED AS LAST_LOGGED_IN_USER, M.NAME, if (S.CLIENT_CONNECTED, "On", "Off") as POWER_STATE, S.DISCONNECT_TIME
from MACHINE M
join KBSYS.SMMP_CONNECTION S on S.KUID = M.KUID
order by POWER_STATE, M.NAME

Answered 05/24/2013 by: mmeyer@vu.com
Fifth Degree Brown Belt

Please log in to comment
Answer this question or Comment on this question for clarity