Systems Management

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.

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