Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Manually Running spPMWindows_ComplianceByComputer

Created: 05 May 2013 • Updated: 08 May 2013 | 2 comments
This issue has been solved. See solution.

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-ru...

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 :)

Operating Systems:

Comments 2 CommentsJump to latest comment

Andrew Bosch's picture

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

------------------------------------
Sr. Principal SQA Engineer
Symantec

SOLUTION
Davros's picture

Hi,

That worked perfectly :)

Thanks so much for your help, really appreciated !