cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Query EPO for most recent DAT version

Jump to solution

Hi, I am trying to build a query that will return the most recent DAT file version on the EPO Server. I know that I can run the built in DAT compliance report for all my managed systems, but I only want to know what version is on the EPO Server so I can manually compare it to the version on client computers.

Does anybody have an SQL statement that can achieve this? Thanks!

1 Solution

Accepted Solutions

Re: Query EPO for most recent DAT version

Jump to solution

This should do it:

SELECT version

FROM dbo.EPOAvertLatestUpdates

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

Message was edited by: homeless on 7/17/12 8:23:44 PM CDT
4 Replies

Re: Query EPO for most recent DAT version

Jump to solution

This should do it:

SELECT version

FROM dbo.EPOAvertLatestUpdates

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

Message was edited by: homeless on 7/17/12 8:23:44 PM CDT

Re: Query EPO for most recent DAT version

Jump to solution

Thanks Ronald! I got the following query to work:

SELECT version FROM dbo.EPOAvertLatestUpdates WHERE dbo.EPOAvertLatestUpdates.type = 'DAT_32'

Re: Query EPO for most recent DAT version

Jump to solution

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

Re: Query EPO for most recent DAT version

Jump to solution

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.

More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • Community Help Hub

      New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

    • Find Forum FAQs
    • Learn How to Earn Badges
    • Ask for Help
    Go to Community Help

    Join the Community

      Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

    • Get helpful solutions from McAfee experts.
    • Stay connected to product conversations that matter to you.
    • Participate in product groups led by McAfee employees.
    Join the Community
    Join the Community