Hi folks,
I’m here again to talk about Query Executor. Trust me, this feature is getting popular among desktop administrators because it tells them what they need to know about their network.
I’m going to present a query that you can use to find the list of computers which were not scanned for inventory from a specific date. This would be especially helpful during internal or external auditing to check not-scanned computers and validate. Please note, the date should be in mm/dd/yyy hh:mm:ss format.
Query to get unscanned computer list for inventory
select Resource.NAME, Resource.DOMAIN_NETBIOS_NAME, InvClientScanStatus.Last_successful_scan as LAST_SUCCESSFUL_SCAN_DATE_FORMATĀ from ManagedComputer INNER JOIN Resource ON ManagedComputer.RESOURCE_ID = Resource.RESOURCE_ID Inner join invclientscanstatus on resource.resource_id = invclientscanstatus.resource_id where Last_successful_scan < DATE_TO_LONG(04/20/2009 00:00:00);
You need run this in Query Executor. If it’s your first time using Query Executor, the instructions are below. If you don’t see Query Executor as an option, you need to upgrade to the latest build. Contact support at desktopcentral-support@manageengine.com if you have any questions.
How to execute
- Go to the Admin Tab, select the Tools table, and click on Query Executor.
- Paste the given SQL query in the text area.
- Click on Execute Query.
- The result will be shown.
- You can export the data into a CSV file for further manipulation.
Cheers,
Romanus