This report will give you a list of all Amp Agents who have lost connection in the last X minutes (Im using 60 here)

************************************************* 
SELECT ASSET_HISTORY.NAME AS COMPUTER_NODE, ASSET_HISTORY.CHANGE_TYPE, ASSET_HISTORY.TIME AS DISCONNECT_TIME 
FROM ASSET_HISTORY 
LEFT JOIN MACHINE ON ASSET_HISTORY.NAME = MACHINE.NAME 
WHERE ASSET_HISTORY.CHANGE_TYPE = 'Disconnection' 
AND NOW() < DATE_ADD(ASSET_HISTORY.TIME, INTERVAL 60 MINUTE) 
ORDER BY ASSET_HISTORY.TIME ASC 
LIMIT 1000 
*************************************************


You can change the timeframe to anything you want by changeing the interal number.

Below is the output.


**Note- I limited the ouput to 1000 records because the history can be quite large. I dont advise changing that unless you know what you are doing. Besides if you have more than 1000 agents that lost connection in the last hour you proabably shouldnt me running reports :)