I was creating a report to check if the patch for Microsoft Security Advisory 981374 was installed on computers in my environment (since the patch comes out today). I used the query for the Conficker worm as a starting point and realized that the query is broken.
The part of the query that checks "...AND (dbo.TsysLastscan.CFGcode = 48)" should be "...AND (dbo.TsysLastscan.CFGcode = 49)" instead to check the last Quickfix scan. 48 is the Proxy scan which is disabled, so it is returning no results.
Thanks
Sebouh
