none
Software Updates Compliance - SQL Views RRS feed

คำตอบ

  • Hello,

    You could run a Query for it. Something like:

    SELECT
    	sys.Netbios_Name0
    	,CASE
    		WHEN stat.Missing <> ''
    			THEN 'Not compliant'
    		ELSE
    			'Compliant'
    	END 'Compliance'
    FROM
    	v_R_System sys
    LEFT OUTER JOIN
    	(SELECT
    		sys.ResourceID
    		,COUNT(ui.ArticleID) 'Missing'
    	FROM
    		v_R_System sys
    		INNER JOIN
    			v_Update_ComplianceStatus usc
    			ON usc.ResourceID = sys.ResourceID
    		INNER JOIN
    			v_UpdateInfo ui
    			ON ui.CI_ID = usc.CI_ID
    		INNER JOIN
    			v_GS_OPERATING_SYSTEM os
    			ON os.ResourceID = sys.ResourceID
    	WHERE
    		ui.CIType_ID != 9
    		AND usc.Status = 2
    		AND ui.IsSuperseded = 0
    	GROUP BY
    		sys.ResourceID) stat
    	ON stat.ResourceID = sys.ResourceID
    GROUP BY
    	sys.Netbios_Name0
    	,stat.Missing

    Note that the above query will return status for all updates in your enviromnent and return:

    Computer Name (Netbios Name), Compliance (Compliant/Not compliant).

    It will not take into account whether or not the updates have been approved/deployed, if it is a server or a workstation or how many updates are actually missing but you could easily add that.


    David Gustafsson

    • ทำเครื่องหมายเป็นคำตอบโดย Immerbonus 20 พฤษภาคม 2562 16:27
    20 พฤษภาคม 2562 14:02

ตอบทั้งหมด