Patch Management Solution

 View Only

  • 1.  Manually Running spPMWindows_ComplianceByComputer

    Posted May 05, 2013 12:47 PM

    I've been trying to manually run the stored procedure for spPMWindows_ComplianceByComputer without success.  All I get is no results returned.

    I've seen the following post:

    http://www.symantec.com/connect/forums/manually-run-sppmwindowscompliancebycomputer-trusteescope

    but this has not worked either. I tried:

    exec spPMWindows_ComplianceByComputer

    @StartDate = '2012-05-05T00:00:00',

    @EndDate = '2013-05-05T00:00:00',

    @ScopeCollectionGuid = '91c68fcb-1822-e793-b59c-2684e99a64cd',

    @TrusteeScope = 'S-1-5-21-39902033-206846789-253040614-1011'

     

    We're running 7.1 SP2 MP1, does anyone know how to run this stored procedure manually in SQL?


    Thanks :)



  • 2.  RE: Manually Running spPMWindows_ComplianceByComputer
    Best Answer

    Posted May 08, 2013 11:15 AM

    The problem is your TrusteeScope.  Try this:

    spPMWindows_ComplianceByComputer
    @StartDate = '5/5/2012'
    ,@EndDate = '5/5/2013'
    ,@TrusteeScope = '{2E1F478A-4986-4223-9D1E-B5920A63AB41}' --Symantec Administrators



  • 3.  RE: Manually Running spPMWindows_ComplianceByComputer

    Posted May 08, 2013 11:27 AM

    Hi,

    That worked perfectly :)

    Thanks so much for your help, really appreciated !