Client Management Suite

Does anyone know which tables i could use to generate my own Patch Compliance report?

The default one, 'Windows Compliance by Computer' doesn't show the associated User and the query is a stored procedure as below, so though it would be easier to just create a new one...

                            exec spPMWindows_ComplianceByComputer                            
                            @OperatingSystem = '%Operating_System%',
                            @DistributionStatus = '%Distribution_Status%',
                            @FilterCollection = '%FilterCollection%',
                            @StartDate = '%Release_Date_From%',
                            @EndDate = '%Release_Date_To%',
                            @pCulture = '%_culture%',
                            @ScopeCollectionGuid = '%ScopeCollectionGuid%',                    
                            @TrusteeScope = '%TrusteeScope%',
                            @VendorGuid    = '%VendorGuid%'   

Can you clarify what do you mean by "associated User "?

Thanks,

Robert

Hi Robert,

The default report lists the Computers and the compliance status, however we normally like to have a column next to the computer name to display the Primary User of that computer as well.

It just helps the technicians troubleshoot as the computer names are not easily recognisable...

The primary user of the computer is reported in the basic inventory table Inv_AeX_AC_Primary_User.

I suggest you take the original procedure spPMWindows_ComplianceByComputer, copy it and modify by adding join to the table Inv_AeX_AC_Primary_User based on the computer guid.

... on an article I wrote.

The article is for replicating data, but you can extract the SQL queries to get the compliance information you need into a table or in memory:

https://www-secure.symantec.com/connect/articles/how-implement-patch-management-compliance-reporting-grs-smp-7x