Patch Management Solution

 View Only
  • 1.  Report for Patch Management

    Posted Jun 29, 2017 09:18 AM

    Hello,

    I would like to add some additional information to the below report.

    Like domain and some software version.

     

    I'm using below code:

    declare @dt DATETIME

    set @dt = DATEADD(month, -2, GETDATE())

    exec spPMWindows_ComplianceByComputer

    @OperatingSystem = '%',

    @DistributionStatus = 'active',

    @FilterCollection = 'c10e15c9-ad8a-4c9c-a8cb-2eec1f534c15',

    @StartDate = '2011-01-01T00:00:00',

    @EndDate = @dt,

    @pCulture = 'en',

    @ScopeCollectionGuid = '00000000-0000-0000-0000-000000000000',

    @TrusteeScope = '{2E1F478A-4986-4223-9D1E-B5920A63AB41},{582029E2-FC5B-4717-8808-B80D6EF0FD67},{B760E9A9-E4DB-404C-A93F-AEA51754AA4F}',

    @VendorGuid = '9d5f6bb8-8adf-49d1-9d84-2932ca46ce1e',

    @CategoryGuid = '00000000-0000-0000-0000-000000000000'

     

    How to modify it?

    Thank you in advance.

     



  • 2.  RE: Report for Patch Management

    Posted Jun 29, 2017 11:27 AM

    If you clone the Stored Procedure "spPMWindows_ComplianceByComputer" and create your own, amend that to return the fields you require, then clone the Report and amend it to use your new SP when you run the Report it will have the Fields you added.