Hi Folks,

Here again for Query executor.  Trust me this is getting popular among desktop administrators for the reason it can get what they need to know about their network.

Now in to the subject, i'm going to present a query which can be used to find the computer list which was not scanned for inventory from a specific date.  This would be helpful during the internal/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 the query executor.  Here are the instruction for those who try this for the first time.  Also, folks who don't see this option need to upgrade your build to the latest.  Contact support at desktopcentral-support@manangeengine.com

How to Execute?

1. Goto Admin  Tab -> Tools table -> click on Query Executor
2. Paste the given sql query in the text Area
3. Click on Execute Query
4. The result will be shown.
5. You have the option to export the data into CSV File for further manipulation.

cheers
Romanus