How to manually run by SQL query the Windows Compliance by Bulletin report?

book

Article ID: 169452

calendar_today

Updated On:

Products

Patch Management Solution for Windows

Cause

N/A

Environment

8.0

Resolution

The following is the SQL query example, that is not limitig the results:

EXEC [dbo].[spPMWindows_ComplianceByBulletin]
      
       @VendorGuid          = '00000000-0000-0000-0000-000000000000',
       @OperatingSystem     = '%',
       @DistributionStatus  = 'Active',
       @ScopeCollectionGuid = '91c68fcb-1822-e793-b59c-2684e99a64cd',
       @StartDate           = '1900-06-29T00:00:00',
       @EndDate             = '2020-06-29T00:00:00',
       @pCulture            = 'en-GB',
       @TrusteeScope        = '{2e1f478a-4986-4223-9d1e-b5920a63ab41}'