Loading...

Knowledge Center


How to list all computers that have a specific VirusScan Enterprise or Host IPS hotfix installed
Technical Articles ID:  KB67406
Last Modified:  01/22/2014
Rated:


Environment

McAfee VirusScan Enterprise (VSE) 8.x
McAfee Host IPS (HIP) 8.0
McAfee ePolicy Orchestrator (ePO) 4.x
Microsoft SQL Server 2005
Microsoft SQL Server 2000

Summary

Use the steps in this article to create a custom SQL query to list all of the computers where a specific VSE or HIP hotfix (not a patch) was installed.

Solution 1

To verify whether a specific hotfix has been applied:

  1. Open the Microsoft SQL Server Management Studio or Microsoft SQL Query Analyzer. For detailed instructions about opening the Microsoft SQL query analyzer or the Microsoft SQL Server Management Studio and running queries, see KB56430.

    NOTE: Ensure the query is run against the ePO database.
     
  2. Copy and paste the following Microsoft SQL, and then run it on the Microsoft Query Analyzer or Microsoft SQL Server Management Studio.

    select ln.nodename as Hostname, pp.productversion as Version, pp.hotfix as Patch, ps.value as Hotfix from epoleafnode ln join epoproductproperties pp on ln.autoid = pp.parentid join epoproductsettings ps on pp.autoid = ps.parentid where ps.settingname = 'Fixes' and ps.value like '%517265%'
    order by hostname


    NOTE: This SQL query lists all computers where hotfix (HF517265) was installed. If you need to specify a different hotfix, replace 517265 with the relevant hotfix number.

Solution 2

To check and see all of the hotfixes that have been applied:

  1. Open the Microsoft SQL Server Management Studio or Microsoft SQL Query Analyzer. For detailed instructions about opening the Microsoft SQL query analyzer or the Microsoft SQL Server Management Studio and running queries, see KB56430.

    NOTE: Ensure the query is run against the ePO database.
     
  2. Copy and paste the following Microsoft SQL, and then run it on the Microsoft Query Analyzer or Microsoft SQL Server Management Studio.

    select ln.nodename as Hostname, pp.productversion as Version, pp.hotfix as Patch, ps.value as Hotfix from epoleafnode ln join epoproductproperties pp on ln.autoid = pp.parentid join epoproductsettings ps on pp.autoid = ps.parentid where ps.settingname = 'Fixes'  order by hostname

    NOTE: This SQL query lists all computers and all VSE and HIP hotfixes that have been applied.

Rate this document

Did this article resolve your issue?

Please provide any comments below

Glossary of Technical Terms


Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.
United States - English
© 2003-2013 McAfee, Inc.