This should do it:
WHERE type LIKE DAT%
PS. Obviously with the proper apostrophes that this forum wont let me post!
Message was edited by: homeless on 7/17/12 8:21:43 PM CDT
If you want to check how many computers have latest DAT installed (same as ePO repository) why don't you use (as you said) DAT compliance report setting as "Configure criteria" that "DAT Version (VirusScan Enterprise) is within X verisions of repository" =1?
This will show as compliant any computer having only same DAT version as ePO repository
1 of 1 people found this helpful
Thanks Ronald! I got the following query to work:
SELECT version FROM dbo.EPOAvertLatestUpdates WHERE dbo.EPOAvertLatestUpdates.type = 'DAT_32'
I specifically did not want to use the the EPO report...I needed to get the value of the latest version of the DAT for use in an external script.