I need a report to show systems currently connected to the KACE system
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.
Community Chosen Answer
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.