SCCM Health Dashboard 0 /ConfigMgr_RDC/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None efb25c8b-ee4e-4b48-aed0-ae77634aecc9 DataSource1 select WSts.SiteCode ,WSts.WSUSServerName ,WSts.WSUSSourceServer ,WSts.SyncCatalogVersion ,WSts.LastSuccessfulSyncTime ,WSts.LastSyncErrorCode ,WSts.ReplicationLinkStatus ,( Select top 1 WSc.SyncCatalogVersion from vSMS_SUPSyncStatus AS WSc order by WSc.SyncCatalogVersion desc ) - WSts.SyncCatalogVersion as 'Outdated' ,( Select top 1 WSc.SyncCatalogVersion from vSMS_SUPSyncStatus AS WSc order by WSc.SyncCatalogVersion desc ) - WSts.SyncCatalogVersion + WSts.LastSyncErrorCode as 'Error Level' from vSMS_SUPSyncStatus AS WSts true SiteCode System.String WSUSServerName System.String WSUSSourceServer System.String SyncCatalogVersion System.Int32 LastSuccessfulSyncTime System.DateTime LastSyncErrorCode System.Int32 ReplicationLinkStatus System.Int32 Outdated System.Int32 Error Level System.Int32 DataSource1 SELECT DR.SiteCode ,REPLACE(LEFT (NALPath, CHARINDEX('.', NALPath) - 1),'["Display=\\','') as ServerName ,(Select top 1 DP.Description from vDistributionPoints DP where DP.NALPath = DR.NALPath ) SiteName ,DR.Drive ,DR.BytesTotal/1024/1024 as 'GigabytesTotal' ,DR.BytesFree/1024/1024 as 'GigabytesFree' ,DR.PercentFree ,NALPath FROM v_DistributionPointDriveInfo Dr SiteCode System.String ServerName System.String SiteName System.String Drive System.String GigabytesTotal System.Int64 GigabytesFree System.Int64 PercentFree System.Int32 NALPath System.String DataSource1 select DP.DPID ,DP.SMSSiteCode as SiteCode ,left (DP.ServerName, CHARINDEX('.',DP.ServerName)-1) as Name ,( SELECT top 1 DPs.MessageState FROM vSMS_DPStatusDetails DPs where DPs.MessageState > 2 and DPs.LastStatusTime > DATEADD(d, -7, getdate()) and DPS.DPName = DP.ServerName order by DPs.MessageState desc ) as status ,( SELECT top 1 case when Dps.MessageState = 1 then 'Success' when Dps.MessageState = 2 then 'In Progress' when Dps.MessageState = 3 then 'Warning' when Dps.MessageState = 4 then 'ERROR' else '' end as Status FROM vSMS_DPStatusDetails DPs where DPs.MessageState > 2 and DPs.LastStatusTime > DATEADD(d, -7, getdate()) and DPS.DPName = DP.ServerName order by DPs.MessageState desc ) as StatusMsg from v_DistributionPoints DP where ( SELECT top 1 DPs.MessageState FROM vSMS_DPStatusDetails DPs where DPs.MessageState > 2 and DPs.LastStatusTime > DATEADD(d, -7, getdate()) and DPS.DPName = DP.ServerName order by DPs.MessageState desc ) > 2 DPID System.Int32 SiteCode System.String Name System.String status System.Int32 StatusMsg System.String DataSource1 select SiteStatus.SiteCode ,(left (ServerName, CHARINDEX ('.', ServerName) -1 )) as Server ,SiteInfo.SiteName as ChildSiteName ,SiteStatus.Updated 'Time Stamp' ,Case SiteStatus.Status When 0 Then 'OK' When 1 Then 'Warning' When 2 Then 'Critical' Else ' ' End AS 'Site Status' ,Case SiteInfo.Status When 1 Then 'Active' When 2 Then 'Pending' When 3 Then 'Failed' When 4 Then 'Deleted' When 5 Then 'Upgrade' Else ' ' END AS 'Link Status' --,SiteStatus.Status + (SiteInfo.Status-1 ) as Status , -- 0 - OK -- 10 - Warning -- 100 - Alert ( Case SiteStatus.Status When 0 Then 0 When 1 Then 10 When 2 Then 100 Else 10 End ) + ( Case SiteInfo.Status When 1 Then 0 When 2 Then 10 When 3 Then 100 When 4 Then 100 When 5 Then 10 Else 10 END ) AS 'Status' From V_SummarizerSiteStatus SiteStatus Join v_Site SiteInfo on SiteStatus.SiteCode = SiteInfo.SiteCode Order By SiteCode SiteCode System.String Server System.String ChildSiteName System.String Link Status System.String Time Stamp System.DateTime Site Status System.String Status System.Int32 DataSource1 SELECT msys.MAC_Addresses0, Count(rsys.Name0) AS SystemCount , (Select top 1 NN.ProductName0 from v_GS_NETWORK_ADAPTER NN where nn.MACAddress0 = msys.MAC_Addresses0 ) as ProductName0, (Select top 1 NN.AdapterType0 from v_GS_NETWORK_ADAPTER NN where nn.MACAddress0 = msys.MAC_Addresses0 ) as AdapterType0 FROM dbo.v_R_System rsys RIGHT OUTER JOIN v_RA_System_MACAddresses msys ON rsys.ResourceID = msys.ResourceID where (Select top 1 NN.AdapterType0 from v_GS_NETWORK_ADAPTER NN where nn.MACAddress0 = msys.MAC_Addresses0 ) = 'Ethernet 802.3' and (Select top 1 NN.ProductName0 from v_GS_NETWORK_ADAPTER NN where nn.MACAddress0 = msys.MAC_Addresses0 ) not in ('Juniper Network Agent Miniport','VMware Virtual Ethernet Adapter for VMnet1','VMware Virtual Ethernet Adapter for VMnet8') GROUP BY msys.MAC_Addresses0 HAVING Count(rsys.Name0) > 1 ORDER BY SystemCount DESC ,ProductName0, AdapterType0 MAC_Addresses0 System.String SystemCount System.Int32 ProductName0 System.String AdapterType0 System.String DataSource1 select rsys.ResourceID, rsys.AD_Site_Name0, rsys.Name0, rsys.User_Name0, msys.MAC_Addresses0, (SELECT TOP 1 Caption0 FROM v_GS_OPERATING_SYSTEM OS where os.ResourceID = rsys.ResourceID) as Operating_System_Name_and0, rsys.Creation_Date0 from dbo.v_R_System rsys RIGHT OUTER JOIN dbo.v_RA_System_MACAddresses msys ON rsys.ResourceID = msys.ResourceID order by msys.MAC_Addresses0 ResourceID System.Int32 AD_Site_Name0 System.String Name0 System.String User_Name0 System.String MAC_Addresses0 System.String Operating_System_Name_and0 System.String Creation_Date0 System.DateTime DataSource1 select Name0, count (*) as counter from v_R_System where Name0 <> 'Unknown' Group by Name0 HAVING Count(*) > 1 Name0 System.String counter System.Int32 DataSource1 select PackageID ,SiteCode ,(Select top 1 Name from v_Package PN where PS.PackageID = PN.PackageID) as Name ,State ,case state when 0 /*Package Installation complete*/ then 0 when 1 /*Waiting to install package*/ then 1 when 2 /*Retrying package installation*/ then 1 when 3 /*Package installation failed*/ then 1 when 4 /*Waiting to remove package*/ then 1 when 5 /*Retrying package removal*/ then 1 when 6 /*Package removal failed*/ then 2 when 7 /*Content updating*/ then 1 when 8 /*Content monitoring*/ then 1 when 9 /*Package distribution cancellation initiated*/ then 2 when 10 /*Package distribution cancelled*/ then 2 else 2 end as StateLevel ,SummaryDate ,InstallStatus ,REPLACE(LEFT (ServerNALPath, CHARINDEX('.', ServerNALPath) - 1),'["Display=\\','') as server from v_PackageStatusDistPointsSumm PS where state <> 0 order by StateLevel desc PackageID System.String SiteCode System.String Name System.String State System.Int32 StateLevel System.Int32 SummaryDate System.DateTime InstallStatus System.String server System.String DataSource1 SELECT DISTINCT IP_Subnets0 as Subnet ,( Select top 1 S2.ResourceID from v_R_System S2 LEFT OUTER JOIN v_RA_System_IPSubnets P2 ON S2.ResourceID = P2.ResourceID LEFT OUTER JOIN v_RA_System_IPAddresses A2 ON S1.ResourceID = A2.ResourceID LEFT OUTER JOIN v_RA_System_SMSAssignedSites B2 ON S1.ResourceID = B2.ResourceID where B2.SMS_Assigned_Sites0 IS NULL and A2.IP_Addresses0 is not null and P2.IP_Subnets0 is not null and p2.IP_Subnets0 = P1.IP_Subnets0 ) as 'Example System ID' ,( Select top 1 S2.Name0 from v_R_System S2 LEFT OUTER JOIN v_RA_System_IPSubnets P2 ON S2.ResourceID = P2.ResourceID LEFT OUTER JOIN v_RA_System_IPAddresses A2 ON S1.ResourceID = A2.ResourceID LEFT OUTER JOIN v_RA_System_SMSAssignedSites B2 ON S1.ResourceID = B2.ResourceID where B2.SMS_Assigned_Sites0 IS NULL and A2.IP_Addresses0 is not null and P2.IP_Subnets0 is not null and p2.IP_Subnets0 = P1.IP_Subnets0 ) as 'Example System Name' FROM v_R_System S1 LEFT OUTER JOIN v_RA_System_IPSubnets P1 ON S1.ResourceID = P1.ResourceID LEFT OUTER JOIN v_RA_System_IPAddresses A1 ON S1.ResourceID = A1.ResourceID LEFT OUTER JOIN v_RA_System_SMSAssignedSites B1 ON S1.ResourceID = B1.ResourceID WHERE B1.SMS_Assigned_Sites0 IS NULL and A1.IP_Addresses0 is not null and IP_Subnets0 is not null order by IP_Subnets0 Subnet System.String Example System ID System.Int32 Example System Name System.String DataSource1 SELECT SiteCode ,REPLACE(LEFT (SiteSystem, CHARINDEX('.', SiteSystem) - 1),'["Display=\\','') as server ,[Role] ,[Status] ,Case Status When 0 Then 'OK' When 1 Then 'Warning' When 2 Then 'Critical' Else ' ' End AS 'Site Status' ,DownSince ,TimeReported FROM v_SiteSystemSummarizer where status <> 0 --Order By SiteCode Union SELECT SiteCode ,(left (MachineName, CHARINDEX ('.', MachineName) -1 )) as Server ,ComponentName as Role ,Status ,Case Status When 0 Then 'OK' When 1 Then 'Warning' When 2 Then 'Critical' Else ' ' End AS 'Site Status' ,LastContacted ,LastHeartbeat FROM vSMS_ComponentSummarizer where Status <> 0 order by SiteCode SiteCode System.String server System.String Role System.String Status System.Int32 Site Status System.String DownSince System.DateTime TimeReported System.DateTime 9.27838mm 4.94167mm =Max(Fields!Error_Level.Value) 1 NoOutput None WSUS_OK NaN 1 NaN 1 None External 1 2 1 99999 1 Red 1 ThreeSymbolUnCircledCross External 1 1 NoOutput 1 1 NoOutput Orange 1 ThreeSymbolUnCircledExclamation External 0 1 0 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External WSUS_Sync White WSUS_Sync 5.91603mm 78.85486mm 4.94167mm 9.27838mm 1.59244in 1.61577in 2.1991in 0.5729in 0.4977in 0.25694in true true Site Code Textbox13 2pt 2pt 2pt 2pt true true Content Version Textbox15 Middle 2pt 2pt 2pt 2pt true true Last Successful Sync Time Textbox42 Middle 2pt 2pt 2pt 2pt true true Status Textbox17 Middle 2pt 2pt 2pt 2pt 2 0.25694in true true =Fields!SiteCode.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!SyncCatalogVersion.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!LastSuccessfulSyncTime.Value LastSuccessfulSyncTime White 2pt 2pt 2pt 2pt =Fields!Outdated.Value 1 NoOutput None NaN 1 NaN 1 None External 1 0 1 0 1 Green 1 TrafficLightUnrimmed External 1 1 NoOutput 1 1 NoOutput Orange 1 Circle External 2 1 NoOutput 9999999 1 NoOutput Red 1 Circle External 0 ThreeUnrimmedTrafficLights 4 4 92 92 =CStr(Fields!Error_Level.Value - Fields!LastSyncErrorCode.Value) + " updates outstanding" true Gainsboro DiagonalLeft Gray None 0pt External External WSUS_Sync White =Sum(Fields!LastSyncErrorCode.Value) 1 NoOutput None Tablix3 NaN 1 NaN 1 None External 1 0 1 0 1 Green 1 TrafficLightUnrimmed External 1 1 NoOutput 99 1 NoOutput Red 1 Circle External 0 ThreeUnrimmedTrafficLights 4 4 92 92 ="Last ErrorCode " + CStr(Fields!LastSyncErrorCode.Value) true Gainsboro DiagonalLeft Gray None 0pt External External WSUS_Sync White After WSUS_Sync =Fields!Outdated.Value NotEqual 0 0.46913in 0.28938in 0.51388in 6.47791in 1 =IIf(Sum(Fields!Outdated.Value, "WSUS_Sync") = 0, True, False) White true true WSUS Sync Textbox46 0.23291in 0.28938in 0.23622in 2.82903in 2 =IIf( (Max(Fields!Error_Level.Value, "WSUS_Sync")+1) < 2 , "#69be28", "IndianRed") Middle 2pt 2pt 2pt 2pt 9.27838mm 25mm 4.94167mm =Max(Fields!status.Value) 1 NoOutput None DP_Status_Quick NaN 1 NaN 1 None External 1 4 1 4 1 Red 1 ThreeSymbolUnCircledCross External 2 1 NoOutput 3 1 NoOutput Orange 1 ThreeSymbolUnCircledExclamation External 1 1 1 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External DP_Status White true true =max(Fields!status.Value) White 2pt 2pt 2pt 2pt DP_Status 57.42632mm 79.20733mm 4.94167mm 34.27838mm 3 1.59244in 1.61577in 1.36577in 0.25694in true true Site Code Textbox13 2pt 2pt 2pt 2pt true true Server Textbox15 Middle 2pt 2pt 2pt 2pt true true Warning type Textbox42 Middle 2pt 2pt 2pt 2pt 0.25694in true true =Fields!SiteCode.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!Name.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!StatusMsg.Value LastSuccessfulSyncTime White 2pt 2pt 2pt 2pt After DP_Status =Fields!status.Value GreaterThan =Parameters!DP_Status_Var.Value 2.4971in 0.28937in 0.51388in 4.57398in 4 =Microsoft.VisualBasic.Interaction.IIf(MAX(Fields!status.Value, "DP_Status") < Parameters!DP_Status_Var.Value, True, False) White true true Distibution Status 2.26088in 0.28937in 0.23622in 2.82903in 5 =IIf( Max(Fields!status.Value, "DP_Status") <> 4, "#69be28", "IndianRed") Middle 2pt 2pt 2pt 2pt 9.27838mm 25mm 4.94176mm =Min(Fields!GigabytesFree.Value) 1 NoOutput None WSUS_OK3 NaN 1 NaN 1 None External 1 0 1 =Parameters!MinFreeSpace.Value 1 Red 1 ThreeSymbolUnCircledCross External =Parameters!MinFreeSpace.Value 1 NoOutput =Parameters!MinFreeSpace.Value*2 1 NoOutput Orange 1 ThreeSymbolUnCircledExclamation External =Parameters!MinFreeSpace.Value*2 1 999999999 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External DitriFreeSpace White true true =Min(Fields!GigabytesFree.Value) White 2pt 2pt 2pt 2pt DitriFreeSpace 76.47887mm 79.20747mm 4.94176mm 34.27838mm 6 1.59244in 1.61577in 2.1991in 0.5729in 0.4977in 0.25694in true true Site Code Textbox13 2pt 2pt 2pt 2pt true true Server Textbox15 Middle 2pt 2pt 2pt 2pt true true Site Discription Textbox42 Middle 2pt 2pt 2pt 2pt true true Free Spce Textbox17 Middle 2pt 2pt 2pt 2pt 2 0.25694in true true =Fields!SiteCode.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!ServerName.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!SiteName.Value LastSuccessfulSyncTime White 2pt 2pt 2pt 2pt true true =Fields!Drive.Value + ":" Drive White 2pt 2pt 2pt 2pt true true =Fields!GigabytesFree.Value GigabytesFree White 2pt 2pt 2pt 2pt After DitriFreeSpace =Fields!GigabytesFree.Value LessThan =Parameters!MinFreeSpace.Value*2 3.2472in 0.28937in 0.51388in 6.47791in 7 =Microsoft.VisualBasic.Interaction.IIf(Min(Fields!GigabytesFree.Value, "DitriFreeSpace") > (Parameters!MinFreeSpace.Value*2), True, False) White true true Distibution Points Free Space Textbox46 3.01098in 0.28937in 0.23622in 2.82903in 8 =IIf( Min(Fields!GigabytesFree.Value, "DitriFreeSpace") > Parameters!MinFreeSpace.Value, "#69be28", "IndianRed") Middle 2pt 2pt 2pt 2pt 9.27838mm 25mm 4.94174mm =Max(Fields!Status.Value) 1 NoOutput None WSUS_OK4 NaN 1 NaN 1 None External 1 100 1 999 1 Red 1 ThreeSymbolUnCircledCross External 10 1 NoOutput 99 1 NoOutput Orange 1 ThreeSymbolUnCircledExclamation External 0 1 9 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External Secondary_Links White true true =MAx(Fields!Status.Value, "Secondary_Links") White 2pt 2pt 2pt 2pt Secondary_Links 24.9685mm 79.20763mm 4.94174mm 34.27838mm 9 1.59244in 1.61577in 2.1991in 0.98425in 1.0706in 0.25694in true true Site Code Textbox13 2pt 2pt 2pt 2pt true true Server Textbox15 Middle 2pt 2pt 2pt 2pt true true Site Discription Textbox42 Middle 2pt 2pt 2pt 2pt true true Site Status Textbox57 Middle 2pt 2pt 2pt 2pt true true DB Link Textbox17 Database Replication Middle 2pt 2pt 2pt 2pt 0.25694in true true =Fields!SiteCode.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!Server.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!ChildSiteName.Value LastSuccessfulSyncTime White 2pt 2pt 2pt 2pt true true =Fields!Site_Status.Value Site_Status White 2pt 2pt 2pt 2pt true true =Fields!Link_Status.Value Drive White 2pt 2pt 2pt 2pt After Secondary_Links =Fields!Status.Value GreaterThan 9 1.21923in 0.28938in 0.51388in 7.46216in 10 =Microsoft.VisualBasic.Interaction.IIf(Sum(Fields!Status.Value, "Secondary_Links") > 9, false, True) White true true Site Links Textbox46 0.98301in 0.28938in 0.23622in 2.82903in 11 =IIf( max(Fields!Status.Value, "Secondary_Links") > 99, "IndianRed", "#69be28") Middle 2pt 2pt 2pt 2pt 9.27838mm 25mm 4.94176mm =Count(Fields!MAC_Addresses0.Value) 1 NoOutput None WSUS_OK5 NaN 1 NaN 1 None External 1 1 1 NoOutput 999999999999999 1 NoOutput Orange 1 ThreeSymbolUnCircledExclamation External 0 1 0 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External DupliMacCount White true true =Count(Fields!MAC_Addresses0.Value) White 2pt 2pt 2pt 2pt DupliMacCount 133.98951mm 79.20721mm 4.94176mm 34.27838mm 12 0.98425in 1.59244in 1.61578in 1.41134in 1.49611in 0.98425in 0.25694in true true Resource ID Textbox38 2pt 2pt 2pt 2pt true true MAC Address Textbox13 2pt 2pt 2pt 2pt true true Computer Textbox15 Middle 2pt 2pt 2pt 2pt true true User Textbox1 Middle 2pt 2pt 2pt 2pt true true Operating System Name and0 Textbox3 Middle 2pt 2pt 2pt 2pt true true Creation Date0 Textbox5 Middle 2pt 2pt 2pt 2pt 0.25694in true true =Fields!ResourceID.Value ResourceID 2pt 2pt 2pt 2pt true true =Fields!MAC_Addresses0.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!Name0.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!User_Name0.Value User_Name0 Middle 2pt 2pt 2pt 2pt true true =Fields!Operating_System_Name_and0.Value Operating_System_Name_and0 Middle 2pt 2pt 2pt 2pt true true =Fields!Creation_Date0.Value Creation_Date0 Middle 2pt 2pt 2pt 2pt After DupliSystemTable =Lookup(Fields!MAC_Addresses0.Value, Fields!MAC_Addresses0.Value, Fields!SystemCount.Value, "DupliMacCount") GreaterThan 1 5.49751in 0.28936in 0.51388in 8.08417in 13 =Microsoft.VisualBasic.Interaction.IIf(count(Fields!SystemCount.Value, "DupliMacCount") = 0, True, False) White true true Duplicate MAC addresses Textbox46 5.26129in 0.28936in 0.23622in 2.82903in 14 =IIf( Count(Fields!MAC_Addresses0.Value, "DupliMacCount") = 0, "#69be28", "Orange") Middle 2pt 2pt 2pt 2pt 9.27838mm 30.64444mm 4.94176mm =Count(Fields!Name0.Value) 1 NoOutput None WSUS_OK6 NaN 1 NaN 1 None External 1 1 1 NoOutput 999999999999999 1 NoOutput Orange 1 ThreeSymbolUnCircledExclamation External 0 1 0 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External DuplicNameCount White true true =Count(Fields!Name0.Value) White 2pt 2pt 2pt 2pt DuplicNameCount 152.68938mm 79.20695mm 4.94176mm 39.92282mm 15 0.98425in 1.61578in 1.41134in 1.49611in 0.98425in 0.25694in true true Resource ID Textbox40 2pt 2pt 2pt 2pt true true Computer Textbox15 Middle 2pt 2pt 2pt 2pt true true User Textbox1 Middle 2pt 2pt 2pt 2pt true true Operating System Name and0 Textbox3 Middle 2pt 2pt 2pt 2pt true true Creation Date0 Textbox5 Middle 2pt 2pt 2pt 2pt 0.25694in true true =Fields!ResourceID.Value ResourceID1 2pt 2pt 2pt 2pt true true =Fields!Name0.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!User_Name0.Value Name0 Middle 2pt 2pt 2pt 2pt true true =Fields!Operating_System_Name_and0.Value Operating_System_Name_and0 Middle 2pt 2pt 2pt 2pt true true =Fields!Creation_Date0.Value Creation_Date0 Middle 2pt 2pt 2pt 2pt After DupliSystemTable =Lookup(Fields!Name0.Value, Fields!Name0.Value, Fields!counter.Value, "DuplicNameCount") GreaterThan 1 6.24761in 0.28935in 0.51388in 6.49173in 16 =Microsoft.VisualBasic.Interaction.IIf(Count(Fields!counter.Value, "DuplicNameCount") = 0, True, False) White true true Duplicate System Name Textbox46 6.01139in 0.28935in 0.23622in 2.82903in 17 =IIf( Count(Fields!counter.Value, "DuplicNameCount") = 0, "#69be28", "Orange") Middle 2pt 2pt 2pt 2pt 9.27838mm 25mm 4.94176mm =Max(Fields!StateLevel.Value, "PackReplStat") 1 NoOutput None Repl NaN 1 NaN 1 None External 1 2 1 2 1 Red 1 ThreeSymbolUnCircledCross External 1 1 NoOutput 1 1 NoOutput Orange 1 ThreeSymbolUnCircledExclamation External 0 1 0 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External PackReplStat White true true =Max(Fields!StateLevel.Value, "PackReplStat") White 2pt 2pt 2pt 2pt PackReplStat 95.53141mm 79.20772mm 4.94176mm 34.27838mm 18 1.59244in 1.61577in 0.98425in 0.98425in 0.98425in 0.25694in true true Package ID Textbox13 2pt 2pt 2pt 2pt true true Package Textbox15 Middle 2pt 2pt 2pt 2pt true true Server Textbox75 Middle 2pt 2pt 2pt 2pt true true Install Status Textbox77 Middle 2pt 2pt 2pt 2pt true true Summary Date Textbox79 Middle 2pt 2pt 2pt 2pt 0.25694in true true =Fields!PackageID.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!Name.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!server.Value server Middle 2pt 2pt 2pt 2pt true true =Fields!InstallStatus.Value InstallStatus Middle 2pt 2pt 2pt 2pt true true =Fields!SummaryDate.Value SummaryDate Middle 2pt 2pt 2pt 2pt After PackReplStat =Fields!StateLevel.Value GreaterThan 0 3.9973in 0.28938in 0.51388in 6.16096in 19 =Microsoft.VisualBasic.Interaction.IIf(Max(Fields!StateLevel.Value, "PackReplStat") = 2, False, True) White true true Package replications Textbox46 3.76108in 0.28938in 0.23622in 2.82903in 20 =IIf( MAX(Fields!StateLevel.Value, "PackReplStat") = 2, "IndianRed","#69be28") Middle 2pt 2pt 2pt 2pt 9.27838mm 25mm 4.94176mm =count(Fields!Subnet.Value, "Boundary") 1 NoOutput None Repl2 NaN 1 NaN 1 None External 1 1 1 999999 1 Red 1 ThreeSymbolUnCircledCross External 0 1 0 1 Green 1 ThreeSymbolUnCircledCheck External 0 ThreeUncircledSymbols 4 4 92 92 true Gainsboro DiagonalLeft Gray None 0pt External External Boundary White true true =count(Fields!Subnet.Value, "Boundary") White 2pt 2pt 2pt 2pt Boundary 114.58407mm 79.20746mm 4.94176mm 34.27838mm 21 1.59244in 1.61577in 1.96851in 0.25694in true true Subnet Textbox13 2pt 2pt 2pt 2pt true true Example ID Textbox15 Middle 2pt 2pt 2pt 2pt true true Example System Textbox75 Middle 2pt 2pt 2pt 2pt 0.25694in true true =Fields!Subnet.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!Example_System_ID.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!Example_System_Name.Value server Middle 2pt 2pt 2pt 2pt After Boundary 4.74741in 0.28937in 0.51388in 5.17672in 22 =Microsoft.VisualBasic.Interaction.IIf(count(Fields!Subnet.Value, "Boundary") = 0, True, false) White true true Boundery Groups Textbox46 4.51119in 0.28937in 0.23622in 2.82903in 23 =IIf( count(Fields!Subnet.Value, "Boundary") = 0, "#69be28","IndianRed") Middle 2pt 2pt 2pt 2pt 1.59244in 1.61577in 0.98425in 3.67283in 0.25694in true true Site Code Textbox13 2pt 2pt 2pt 2pt true true Server Textbox15 Middle 2pt 2pt 2pt 2pt true true Site Status Textbox57 Middle 2pt 2pt 2pt 2pt true true Component Textbox91 Middle 2pt 2pt 2pt 2pt 0.25694in true true =Fields!SiteCode.Value SiteCode1 2pt 2pt 2pt 2pt true true =Fields!server.Value SyncCatalogVersion Middle 2pt 2pt 2pt 2pt true true =Fields!Site_Status.Value Site_Status White 2pt 2pt 2pt 2pt true true =Fields!Role.Value Role White 2pt 2pt 2pt 2pt After Site_Status_links 1.73311in 2.48847in 0.51388in 7.86529in 24 =Microsoft.VisualBasic.Interaction.IIf(count(Fields!Status.Value, "Site_Status_links") = 0, True,False) White 180.56171mm 262.98538mm 14.55208mm true true true true Health Dashboard Textbox13 0mm 7.35034mm 11.64167mm 164.53891mm #69be28 2pt 2pt 2pt 2pt Embedded thH8A3W14Z FitProportional 3.96875mm 171.88925mm 7.67292mm 24.99987mm 1 297mm 210mm 20mm 20mm 20mm 20mm 0.13cm