Delete in batch targets in Remote Control

Hi mikke,

There is a new menu entry in the Web interface starting from version 9.1.4.0309.
Take a look at this thread.

This new report page is produced using this query:

SELECT DISTINCT A.HWKEY ,A.COMPUTERNAME ,B.IP_ADDRESSES ,B.LOGGED_USER ,A.MANUFACTURER ,A.MODEL ,A.SERIAL_NO ,B.LAST_UPDATE FROM ASSET.ASSET A LEFT OUTER JOIN COMMON.LIVEPOINTS B ON A.HWKEY = B.HWKEY WHERE DATEDIFF (day, B.LAST_UPDATE, CURRENT_TIMESTAMP) > 30 ORDER BY A.HWKEY

Note that the value ‘30’ means “List all targets not reporting for more than 30 days”

If you have and old version of Remote Control you can re-create the same page by clicking on
Reports -> New Report -> Edit SQL -> Edit SQL then put the SQL statement above there.
Once you found a value which suit you the report can be saved by clicking on
Reports -> Save as Custom Report

3 Likes