Hello
I need to delete lots of targets in Remote Control v9.0. I recall there’s a SQL sentence to do these, as this version does no support batch deletes using the console, but I can’t find the sentence anymore. Can you help me please? Do you have this SQL commands?
Thank you in advance.
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