8254689b-b764-4fad-830b-a63cec69fcc0 CentralSite 11.7in String true Computer Name ComputerList ResourceID NetBios_Name0 String true Update List UpdateLists CI_UniqueID Title true 8.3in 0.25cm true 0.5cm 0.5cm true 1.25cm 19cm 1 0.5cm 0cm textbox1 19cm true 0.5cm 1cm Machine Vulnerability Report 1.5cm true 0.5cm 05b2ea99-ba04-453f-ab5e-182d1100de7a 21cm Device Name System.String SCCM Client System.String Site System.String Domain System.String Manufacturer System.String Model System.String Console ID System.String Operating System System.String Service Pack System.String Last Boot System.DateTime Build Date System.DateTime WSUS Client System.String WSUS Scan System.DateTime Hardware Scan System.DateTime Software Scan System.DateTime Chassis Type System.String CentralSite SELECT chcs.NetBiosName AS [Device Name], chcs.Version AS [SCCM Client], chcs.SiteCode AS Site, cs.Domain0 AS Domain, cs.Manufacturer0 AS Manufacturer, cs.Model0 AS Model, cs.UserName0 AS [Console ID], os.Caption0 AS [Operating System], os.CSDVersion0 AS [Service Pack], os.LastBootUpTime0 AS [Last Boot], os.InstallDate0 AS [Build Date], uss.LastWUAVersion AS [WSUS Client], uss.LastScanTime AS [WSUS Scan], chcs.LastHW AS [Hardware Scan], chcs.LastSW AS [Software Scan], CASE WHEN (se.ChassisTypes0 = '1') THEN 'Other' WHEN (se.ChassisTypes0 = '2') THEN 'Unknown' WHEN (se.ChassisTypes0 = '3') THEN 'Desktop' WHEN (se.ChassisTypes0 = '4') THEN 'Low Profile Desktop' WHEN (se.ChassisTypes0 = '5') THEN 'Pizza Box' WHEN (se.ChassisTypes0 = '6') THEN 'Mini Tower' WHEN (se.ChassisTypes0 = '7') THEN 'Tower' WHEN (se.ChassisTypes0 = '8') THEN 'Portable' WHEN (se.ChassisTypes0 = '9') THEN 'Laptop' WHEN (se.ChassisTypes0 = '10') THEN 'Notebook' WHEN (se.ChassisTypes0 = '11') THEN 'Hand Held' WHEN (se.ChassisTypes0 = '12') THEN 'Docking Station' WHEN (se.ChassisTypes0 = '13') THEN 'All in One' WHEN (se.ChassisTypes0 = '14') THEN 'Sub Notebook' WHEN (se.ChassisTypes0 = '15') THEN 'Space-Saving' WHEN (se.ChassisTypes0 = '16') THEN 'Lunch Box' WHEN (se.ChassisTypes0 = '17') THEN 'Main System Chassis' WHEN (se.ChassisTypes0 = '18') THEN 'Expansion Chassis' WHEN (se.ChassisTypes0 = '19') THEN 'SubChassis' WHEN (se.ChassisTypes0 = '20') THEN 'Bus Expansion Chassis' WHEN (se.ChassisTypes0 = '21') THEN 'Peripheral Chassis' WHEN (se.ChassisTypes0 = '22') THEN 'Storage Chassis' WHEN (se.ChassisTypes0 = '23') THEN 'Rack Mount Chassis' WHEN (se.ChassisTypes0 = '24') THEN 'Sealed-Case PC' ELSE se.ChassisTypes0 END AS [Chassis Type] FROM dbo.v_CH_ClientSummary AS chcs LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM AS cs ON chcs.MachineID = cs.ResourceID LEFT OUTER JOIN dbo.v_GS_OPERATING_SYSTEM AS os ON chcs.MachineID = os.ResourceID LEFT OUTER JOIN dbo.v_GS_SYSTEM_ENCLOSURE AS se ON chcs.MachineID = se.ResourceID LEFT OUTER JOIN dbo.v_UpdateScanStatus AS uss ON chcs.MachineID = uss.ResourceID WHERE chcs.MachineID = @CompID =Parameters!CompID.Value true CI_UniqueID System.String Title System.String CentralSite SELECT CI_UniqueID, Title FROM v_AuthListInfo ORDER BY Title true ResourceID System.Int32 NetBios_Name0 System.String CentralSite SELECT ResourceID, NetBios_Name0 FROM v_R_System ORDER BY NetBios_Name0 true Bulletin ID System.String Article ID System.String Name System.String Description System.String DateRevised System.DateTime CentralSite declare @AuthListLocalID as int select @AuthListLocalID=CI_ID from v_AuthListInfo where CI_UniqueID=@AuthListID SELECT ui.BulletinID AS [Bulletin ID], ui.ArticleID AS [Article ID], ui.Title AS [Name], ui.Description, ui.DateRevised FROM v_UpdateComplianceStatus ucsa INNER JOIN v_CIRelation cir ON ucsa.CI_ID = cir.ToCIID INNER JOIN v_UpdateInfo ui ON ucsa.CI_ID = ui.CI_ID WHERE cir.FromCIID=@AuthListLocalID AND cir.RelationType=1 AND ResourceID = @CompID AND Status = '2' --Required ORDER BY ArticleID =Parameters!AuthListID.Value =Parameters!CompID.Value true 20cm 1cm 21.5cm 19cm 36 0.5cm 0cm 5.5cm 19cm 35 0.5cm 0cm WSUS_Scan 24.25cm 3.75cm 34 true 15.75cm 0.63492cm =First(Fields!WSUS_Scan.Value, "ComputerInfo") Site 22.75cm 3.75cm 33 true 15.75cm 0.63492cm =First(Fields!Site.Value, "ComputerInfo") WSUS_Client 23.5cm 3.75cm 32 true 15.75cm 0.63492cm =First(Fields!WSUS_Client.Value, "ComputerInfo") Software_Scan 24.25cm 3.75cm 31 true 4.5cm 0.63492cm =First(Fields!Software_Scan.Value, "ComputerInfo") Hardware_Scan 23.5cm 3.75cm 30 true 4.5cm 0.63492cm =First(Fields!Hardware_Scan.Value, "ComputerInfo") SCCM_Client 22.75cm 3.75cm 29 true 4.5cm 0.63492cm =First(Fields!SCCM_Client.Value, "ComputerInfo") Service_Pack 4.5cm 4cm 28 true 15.5cm 0.63492cm =First(Fields!Service_Pack.Value, "ComputerInfo") Chassis_Type 3.75cm 4cm 27 true 15.5cm 0.63492cm =First(Fields!Chassis_Type.Value, "ComputerInfo") Last_Boot 3cm 4cm 26 true 15.5cm 0.63492cm =First(Fields!Last_Boot.Value, "ComputerInfo") Console_ID 2.25cm 4cm 25 true 15.5cm 0.63492cm =First(Fields!Console_ID.Value, "ComputerInfo") Operating_System 4.5cm 6.5cm 24 true 4.5cm 0.63492cm =First(Fields!Operating_System.Value, "ComputerInfo") Model 3.75cm 4cm 23 true 4.5cm 0.63492cm =First(Fields!Model.Value, "ComputerInfo") Manufacturer 3cm 4cm 22 true 4.5cm 0.63492cm =First(Fields!Manufacturer.Value, "ComputerInfo") Domain 2.25cm 4.25cm 21 true 4.5cm 0.63492cm =First(Fields!Domain.Value, "ComputerInfo") Device_Name 1.25cm 3.5cm 20 true 4.5cm 0.63492cm =First(Fields!Device_Name.Value, "ComputerInfo") 22.75cm 3.5cm 19 true 12cm 0.63492cm Assigned Site: 24.25cm 2.5cm 18 true 12cm 0.63492cm WSUS Scan: textbox20 23.5cm 2.75cm 17 true 12cm 0.63492cm WSUS Client: 24.25cm 2.5cm 16 true 0.5cm 0.63492cm SW Scan: 23.5cm 2.5cm 15 true 0.5cm 0.63492cm HW Scan: textbox19 22.75cm 3.75cm 14 true 0.5cm 0.63492cm SCCM Client: textbox16 21.75cm 6cm 13 true 0.5cm 0.75cm Config Manager Details textbox15 4.5cm 3.5cm 12 true 11.75cm 0.63492cm Service Pack: 3.75cm 3.5cm 11 true 11.75cm 0.63492cm Chassis Type: 3cm 3.5cm 10 true 11.75cm 0.63492cm Device Bootup: textbox4 2.25cm 3cm 9 true 11.75cm 0.63492cm Console ID: 3.75cm 3.75cm 8 true 0.5cm 0.63492cm Model: 4.5cm 3.75cm 7 true 0.5cm 0.63492cm Operating System: textbox6 3cm 3.75cm 6 true 0.5cm 0.63492cm Manufacturer: textbox5 2.25cm 3.75cm 5 true 0.5cm 0.63492cm Domain: textbox3 1.25cm 3.75cm 4 true 0.5cm 0.63492cm Device Name: textbox2 0.25cm 3.25cm 3 true 0.5cm 0.63492cm Device Details 2UpdatesMissing6.75cm19.08451cm

DateRevised 4 true =Fields!DateRevised.Value Bulletin_ID 3 =Fields!Bulletin_ID.Value Article_ID 2 =Fields!Article_ID.Value Name 1 =Fields!Name.Value Description =Fields!Description.Value 2.05282cm

textbox9 9 true =Fields!DateRevised.Value Date Revised textbox34 8 true =Fields!Bulletin_ID.Value Bulletin ID textbox25 7 true =Fields!Article_ID.Value Article ID textbox26 6 true =Fields!Name.Value Name textbox27 5 true Description 0.69718cm

2.5cm 2.5cm 2.5cm 5.08451cm 6.5cm 2.75cm0.5cm Bulletin_ID_1 5.75cm 2cm 1 true 5cm 0.63492cm =Count(Fields!Bulletin_ID.Value, "UpdatesMissing") textbox23 5.75cm 4.5cm true 0.5cm 0.63492cm Missing Security Updates: 25.2cm en-US true 0.75cm 5.75cm true 1cm 0.63492cm ="Page: " + Globals!PageNumber.ToString() + "of " + Globals!TotalPages.ToString() 2cm true 0.5cm 29.7cm