Desktop Central Query Executor - Swiss Knife for reports

Hi

This blog is about the new feature introduced in Desktop Central.

The new feature is called Query Executor (available under Admin -> Tools -> Query Executor.  This feature is supported from build 60316.  If you don't see this feature you can contact the tech support).  You can use it as SQL query executor.  Being a initial version you can send in your requirement and get the query from the Desktop Central Support Team.  Later, this can be improvised according to the need.

Query Executor can be used to generate custom reports which are not available ready-made with DC and many more what you like to generate out of DC.  For example, regarding the conficker worm, how to get the list of computers where intended patch KB 958644 (Bulletin ID : MS08-067) is installed or computers where the patch is missing.  Below given is the query to achieve the task using DC Query Executor.

Query to get the list of computers where the patch - KB 958644 (MS08-067) is Installed
select resource.name, patch.patchid, patch.bulletinid, affectedpatchstatus.status from affectedpatchstatus inner join patch on patch.patchid = affectedpatchstatus.patch_id inner join resource on resource.resource_id = affectedpatchstatus.resource_id where BULLETINID="MS08-067" and status="Available";
Query to get the list of computer where the patch - KB 958644 (MS08-067) is Missing
select resource.name, patch.patchid, patch.bulletinid, affectedpatchstatus.status from affectedpatchstatus inner join patch on patch.patchid = affectedpatchstatus.patch_id inner join resource on resource.resource_id = affectedpatchstatus.resource_id where BULLETINID="MS08-067" and status="Missing";
Note :  The query will be executed on the last scan data.
Give a try and cast your opinion.
Cheers
Romanus