SCCM Co-managed Windows Update Reports

Question

If i have configured sccm co-management & move windows update workload to Intune & deploying windows update using Intune ring then from where i can get windows update reports from SCCM or Intune for intranet / internet facing systems?

solved 0
ManojPalekar 2020-04-27T18:12:38+05:30 2 Answers 293 views Beginner
0

Answers ( 2 )

  2. Guru Vaidya
    1
    2020-04-28T17:28:35+05:30
    Reply

    Clients are co-managed …. they have not left the MECM environment, so I think you still be able to run the default compliance reports or the one what Deepak already mentioned as sql query

  4. Deepak Rai
    2
    2020-04-27T21:57:24+05:30
    Reply

    Clients are still intact with SCCM Right? No matter how you install you can still fetch the compliance status from SCCM DB

    Here.

    Select name0 AS [Machine Name], sys.User_Name0, ui.Title AS [Patch Title], (CASE ucs.status WHEN 2 THEN ‘Required’ WHEN 1 THEN ‘NOT REQUIRED’ WHEN 0 THEN ‘INSTALL STATE UNKNOWN’ WHEN 3 THEN ‘Installed’ END) AS [Install Status] , dbo.v_AuthListInfo.Title as [Update Group],
    ui.ArticleID, (CASE UI.IsExpired WHEN 0 THEN ‘NOT EXPIRED’ WHEN 1 THEN ‘EXPIRED’ END) AS [EXPIRY], (CASE UI.IsSuperseded WHEN 0 THEN ‘NOT Superseded’ WHEN 1 THEN ‘Superseded’ END) AS [SEPERSEDENCE] , (CASE ui.Severity WHEN 0 then ‘none’ when 2 then ‘low’ WHEN 6 then ‘MODERATE’ WHEN 8 THEN ‘IMPORTANT’ WHEN 10 THEN ‘CRITICAL’ END) AS [SEVERITY] , ui.DatePosted AS DateReleased, ucs.LastStatusChangeTime AS DateInstalled
    FROM dbo.v_ClientCollectionMembers INNER JOIN
    dbo.v_R_System AS sys ON dbo.v_ClientCollectionMembers.ResourceID = sys.ResourceID LEFT OUTER JOIN
    dbo.v_CIRelation INNER JOIN
    dbo.v_UpdateInfo AS ui INNER JOIN
    dbo.v_UpdateComplianceStatus AS ucs ON ui.CI_ID = ucs.CI_ID ON dbo.v_CIRelation.ToCIID = ui.CI_ID INNER JOIN
    dbo.v_AuthListInfo ON dbo.v_CIRelation.FromCIID = dbo.v_AuthListInfo.CI_ID ON sys.ResourceID = ucs.ResourceID
    GROUP BY sys.Name0, ui.IsExpired, UI.IsSuperseded, ucs.status, ui.Severity, dbo.v_AuthListInfo.Title, dbo.v_ClientCollectionMembers.CollectionID, sys.User_Name0, ui.ArticleID, ui.Title, ui.DatePosted , ucs.LastStatusChangeTime
    HAVING (ui.IsExpired = 0) AND
    (dbo.v_AuthListInfo.Title like ‘Name of SUG’) AND (dbo.v_ClientCollectionMembers.CollectionID like ‘collectionID’)
    ORDER BY sys.Name0

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .