0 /ConfigMgr_VSM/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None 11111111-1111-1111-1111-111111111111 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; */ --declare @CollIDServers varchar(8) = 'YOURServersCollID' select top 5 count(cpm.MachineID) Count,cpm.LastErrorCode ErrorCode FROM fn_rbac_CP_Machine(@UserSIDs) cpm left join v_FullCollectionMembership cm on cm.ResourceID=cpm.MachineID where cm.CollectionID=@CollIDServers group by cpm.LastErrorCode order by Count desc 60 true Count System.Int32 ErrorCode System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserTokenSIDs.Value select dbo.fn_rbac_GetAdminIDsfromUserSIDs (@UserTokenSIDs) as UserSIDs UserSIDs System.String AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ select top 5 count(cpm.MachineID) Count,cpm.LastErrorCode ErrorCode FROM fn_rbac_CP_Machine(@UserSIDs) cpm left join v_FullCollectionMembership cm on cm.ResourceID=cpm.MachineID where cm.CollectionID=@CollIDWorkstations group by cpm.LastErrorCode order by Count desc true Count System.Int32 ErrorCode System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled' declare @CollIDServers varchar(8) = 'YOURServersCollID' */ SELECT count(s.ResourceID) Count__Inst_SRV FROM dbo.fn_rbac_R_System(@UserSIDs) s LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = s.ResourceID LEFT OUTER JOIN fn_rbac_ClientDeploymentState(@UserSIDs) cd on cd.SMSID=s.SMS_Unique_Identifier0 WHERE c.CollectionID= @CollIDServers and DateDiff(hh,cd.AssignmentEndTime, GetDate()) <= 24 true Count__Inst_SRV System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ SELECT count(s.ResourceID) Count__Inst_SRV FROM dbo.fn_rbac_R_System(@UserSIDs) s LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = s.ResourceID LEFT OUTER JOIN fn_rbac_ClientDeploymentState(@UserSIDs) cd on cd.SMSID=s.SMS_Unique_Identifier0 WHERE c.CollectionID= @CollIDWorkstations and DateDiff(hh,cd.AssignmentEndTime, GetDate()) <= 24 true Count__Inst_SRV System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDServers varchar(8) = 'VSM0000E' --LC.Servers.Windows */ SELECT coll.Name AS NetBiosName, er.HealthCheckGUID, er.EvalTime, er.ResultCode, er.ResultType, er.ResultDetail FROM fn_rbac_FullCollectionMembership(@UserSIDs) coll LEFT OUTER JOIN fn_rbac_CH_ClientSummary(@UserSIDs) cs ON coll.ResourceID = cs.ResourceID LEFT OUTER JOIN fn_rbac_CH_EvalResults(@UserSIDs) AS er ON cs.ResourceID = er.ResourceID WHERE coll.CollectionID = @CollIDServers AND cs.LastEvaluationHealthy = 2 true NetBiosName System.String HealthCheckGUID System.String EvalTime System.DateTime ResultCode System.Int32 ResultType System.Int32 ResultDetail System.String AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ SELECT coll.Name AS NetBiosName, er.HealthCheckGUID, er.EvalTime, er.ResultCode, er.ResultType, er.ResultDetail FROM fn_rbac_FullCollectionMembership(@UserSIDs) coll LEFT OUTER JOIN fn_rbac_CH_ClientSummary(@UserSIDs) cs ON coll.ResourceID = cs.ResourceID LEFT OUTER JOIN fn_rbac_CH_EvalResults(@UserSIDs) AS er ON cs.ResourceID = er.ResourceID WHERE coll.CollectionID = @CollIDWorkstations AND cs.LastEvaluationHealthy = 2 true NetBiosName System.String HealthCheckGUID System.String EvalTime System.DateTime ResultCode System.Int32 ResultType System.Int32 ResultDetail System.String AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDServers varchar(8) = 'YourServersCollID' --LC.Servers.Windows */ SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count' FROM fn_rbac_R_System(@UserSIDs) as SYS left join fn_rbac_FullCollectionMembership(@UserSIDs) coll ON coll.ResourceID = sys.ResourceID WHERE SYS.Client0=1 and coll.CollectionID = @CollIDServers group by SYS.Client_Version0, SYS.Client_Type0 order by SYS.Client_Version0, SYS.Client_Type0 true Client_Version0 System.String Client_Type0 System.Int32 Count System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count' FROM fn_rbac_R_System(@UserSIDs) as SYS left join fn_rbac_FullCollectionMembership(@UserSIDs) coll ON coll.ResourceID = sys.ResourceID WHERE SYS.Client0=1 and coll.CollectionID = @CollIDWorkstations group by SYS.Client_Version0, SYS.Client_Type0 order by SYS.Client_Version0, SYS.Client_Type0 true Client_Version0 System.String Client_Type0 System.Int32 Count System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDServers varchar(8) = 'YourServersCollID' --LC.Servers.Windows */ select count(r.Name) from fn_rbac_FullCollectionMembership(@UserSIDs) r join (select m2.* from fn_rbac_RA_System_MACAddresses(@UserSIDs) m2 join (select MAC_Addresses0 from fn_rbac_RA_System_MACAddresses(@UserSIDs) group by MAC_Addresses0 having count(MAC_Addresses0) > 1) m3 on m2.MAC_Addresses0 = m3.MAC_Addresses0) m1 on r.ResourceID=m1.ResourceID where r.CollectionID=@CollIDServers true System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ select count(r.Name) from fn_rbac_FullCollectionMembership(@UserSIDs) r join (select m2.* from fn_rbac_RA_System_MACAddresses(@UserSIDs) m2 join (select MAC_Addresses0 from fn_rbac_RA_System_MACAddresses(@UserSIDs) group by MAC_Addresses0 having count(MAC_Addresses0) > 1) m3 on m2.MAC_Addresses0 = m3.MAC_Addresses0) m1 on r.ResourceID=m1.ResourceID where r.CollectionID=@CollIDWorkstations true System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDServers varchar(8) = 'YourServersCollID' --LC.Servers.Windows */ SELECT GSYS.ResourceID,GSYS.Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', GSYS.SMSID0 AS SMS_Unique_Identifier0 into #guid FROM fn_rbac_GS_SYSTEM(@UserSIDs) GSYS JOIN fn_rbac_HS_SYSTEM(@UserSIDs) GHSYS ON GSYS.ResourceID = GHSYS.ResourceID JOIN fn_rbac_RA_System_SMSInstalledSites(@UserSIDs) site ON GSYS.ResourceID=site.ResourceID WHERE GSYS.Name0!=GHSYS.Name0 UNION SELECT GSYS.ResourceID,GSYS.Resource_Domain_OR_Workgr0 as Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', GSYS.SMS_Unique_Identifier0 FROM fn_rbac_R_System(@UserSIDs) GSYS JOIN fn_rbac_GS_SYSTEM(@UserSIDs) GHSYS ON GSYS.ResourceID = GHSYS.ResourceID JOIN fn_rbac_RA_System_SMSInstalledSites(@UserSIDs) site ON GSYS.ResourceID=site.ResourceID WHERE GSYS.Name0!=GHSYS.Name0 UNION SELECT GSYS.ResourceID,GSYS.Resource_Domain_OR_Workgr0 as Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', GSYS.SMS_Unique_Identifier0 --into #guid FROM fn_rbac_R_System(@UserSIDs) GSYS JOIN fn_rbac_HS_SYSTEM(@UserSIDs) GHSYS ON GSYS.ResourceID = GHSYS.ResourceID JOIN fn_rbac_RA_System_SMSInstalledSites(@UserSIDs) site ON GSYS.ResourceID=site.ResourceID WHERE GSYS.Name0!=GHSYS.Name0 ORDER BY GSYS.Name0 select count(*) as CountDuplicates from #guid g LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = g.ResourceID WHERE c.CollectionID= @CollIDServers drop table #guid true CountDuplicates System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ SELECT GSYS.ResourceID,GSYS.Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', GSYS.SMSID0 AS SMS_Unique_Identifier0 into #guid FROM fn_rbac_GS_SYSTEM(@UserSIDs) GSYS JOIN fn_rbac_HS_SYSTEM(@UserSIDs) GHSYS ON GSYS.ResourceID = GHSYS.ResourceID JOIN fn_rbac_RA_System_SMSInstalledSites(@UserSIDs) site ON GSYS.ResourceID=site.ResourceID WHERE GSYS.Name0!=GHSYS.Name0 UNION SELECT GSYS.ResourceID,GSYS.Resource_Domain_OR_Workgr0 as Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', GSYS.SMS_Unique_Identifier0 FROM fn_rbac_R_System(@UserSIDs) GSYS JOIN fn_rbac_GS_SYSTEM(@UserSIDs) GHSYS ON GSYS.ResourceID = GHSYS.ResourceID JOIN fn_rbac_RA_System_SMSInstalledSites(@UserSIDs) site ON GSYS.ResourceID=site.ResourceID WHERE GSYS.Name0!=GHSYS.Name0 UNION SELECT GSYS.ResourceID,GSYS.Resource_Domain_OR_Workgr0 as Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', GSYS.SMS_Unique_Identifier0 --into #guid FROM fn_rbac_R_System(@UserSIDs) GSYS JOIN fn_rbac_HS_SYSTEM(@UserSIDs) GHSYS ON GSYS.ResourceID = GHSYS.ResourceID JOIN fn_rbac_RA_System_SMSInstalledSites(@UserSIDs) site ON GSYS.ResourceID=site.ResourceID WHERE GSYS.Name0!=GHSYS.Name0 ORDER BY GSYS.Name0 select count(*) as CountDuplicates from #guid g LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = g.ResourceID WHERE c.CollectionID= @CollIDWorkstations drop table #guid true CountDuplicates System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDServers varchar(8) = 'YourServersCollID' --LC.Servers.Windows */ declare @LastDate datetime, @NullVal datetime set @LastDate = DATEADD(dd,-convert(int,14),GetDate()) set @NullVal = CONVERT(datetime,'1/1/1980') select count(*) as [Count] from fn_rbac_R_System(@UserSIDs) sys left join ( select ResourceId, MAX(AgentTime) as AgentTime from fn_rbac_AgentDiscoveries(@UserSIDs) group by ResourceId ) as disc on disc.ResourceId = sys.ResourceID left join fn_rbac_GS_WORKSTATION_STATUS(@UserSIDs) hw on hw.ResourceID = sys.ResourceID left join fn_rbac_GS_LastSoftwareScan(@UserSIDs) sw on sw.ResourceID = sys.ResourceID LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = sys.ResourceID WHERE c.CollectionID= @CollIDServers and ((IsNULL(disc.AgentTime,@NullVal) < @LastDate or IsNULL(hw.LastHWScan,@NullVal) < @LastDate or IsNULL(sw.LastScanDate,@NullVal) < @LastDate) and sys.Client0 = 1 ) true Count System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ declare @LastDate datetime, @NullVal datetime set @LastDate = DATEADD(dd,-convert(int,14),GetDate()) set @NullVal = CONVERT(datetime,'1/1/1980') select count(*) as [Count] from fn_rbac_R_System(@UserSIDs) sys left join ( select ResourceId, MAX(AgentTime) as AgentTime from fn_rbac_AgentDiscoveries(@UserSIDs) group by ResourceId ) as disc on disc.ResourceId = sys.ResourceID left join fn_rbac_GS_WORKSTATION_STATUS(@UserSIDs) hw on hw.ResourceID = sys.ResourceID left join fn_rbac_GS_LastSoftwareScan(@UserSIDs) sw on sw.ResourceID = sys.ResourceID LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = sys.ResourceID WHERE c.CollectionID= @CollIDWorkstations and ((IsNULL(disc.AgentTime,@NullVal) < @LastDate or IsNULL(hw.LastHWScan,@NullVal) < @LastDate or IsNULL(sw.LastScanDate,@NullVal) < @LastDate) and sys.Client0 = 1 ) true Count System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDServers.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDServers varchar(8) = 'YourServersCollID' --LC.Servers.Windows */ select count(*) as [Count] from fn_rbac_StatusMessage(@UserSIDs) sm LEFT OUTER JOIN v_R_System s on s.Netbios_Name0=sm.MachineName LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = s.ResourceID where MessageID = 669 and c.CollectionID= @CollIDServers true Count System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value =Parameters!CollIDWorkstations.Value /* DECLARE @UserSIDs VARCHAR(16); SELECT @UserSIDs = 'disabled'; declare @CollIDWorkstations varchar(8) = 'YOURWorkstationsCollID' */ select count(*) as [Count] from fn_rbac_StatusMessage(@UserSIDs) sm LEFT OUTER JOIN v_R_System s on s.Netbios_Name0=sm.MachineName LEFT OUTER JOIN v_ClientCollectionMembers c ON c.ResourceID = s.ResourceID where MessageID = 669 and c.CollectionID= @CollIDWorkstations true Count System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!UserSIDs.Value select com.ComponentName, count(*) as 'Count' from fn_rbac_StatusMessage(@UserSIDs) stat join fn_rbac_ServerComponents(@UserSIDs) com on stat.SiteCode=com.SiteCode and stat.MachineName=com.MachineName and stat.Component=com.ComponentName where Time > DATEADD(ss,-(24*3600),GetDate()) and Severity=0xC0000000 group by com.SiteCode, com.MachineName, com.ComponentName, stat.MessageID order by count(*) desc true ComponentName System.String Count System.Int32 AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ select UPPER (SUBSTRING(PSD.ServerNALPath,13,CHARINDEX('.', PSd.ServerNALPath) -13)) AS [DP Name], count(*) [Targeted] , count(CASE when PSD.State='0' then '*' END) AS 'Installed', count(CASE when PSD.State not in ('0','3','6') then '*' END) AS 'Not Installed', count(CASE when PSD.State in ('3','6') then '*' END) AS 'Error', (CASE when PSD.State='0' then 'OK' when PSD.State not in ('0','3','6') then 'In Progress' when PSD.State in ('3','6') then 'Error' END) AS 'Distribution Point Status' From v_PackageStatusDistPointsSumm psd,SMSPackages P where p.PackageType!=4 and (p.PkgID=psd.PackageID) and ServerNALPath not like '%role00%' and ServerNALPath not like '%bdp00%' group by PSd.ServerNALPath,PSD.State true DP Name System.String Targeted System.Int32 Installed System.Int32 Not Installed System.Int32 Error System.Int32 Distribution Point Status System.String AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!SUCollIDServers.Value declare @SUG as int SELECT @SUG = (select CI_ID FROM v_AuthListInfo where title like '%serv%req%month%' and title not like '%office%' and title not like '%pilot%' and title not like '%critical%' and datediff(mm,getdate(),DateCreated)=0) select usc.CI_ID, usc.NumTotal, usc.NumUnknown as Unknown, usc.NumPresent+usc.NumNotApplicable as Compliant, usc.NumMissing as NotCompliant, usc.CollectionID, coll.Name from v_UpdateSummaryPerCollection usc left join v_Collection coll on coll.CollectionID=usc.CollectionID where CI_ID=@SUG and @SUCollIDServers like '%'+usc.CollectionID+'%' true CI_ID System.Int32 NumTotal System.Int32 Unknown System.Int32 Compliant System.Int32 NotCompliant System.Int32 CollectionID System.String Name System.String AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_ =Parameters!SUCollIDWorkStations.Value declare @SUG as int SELECT @SUG = (select CI_ID FROM v_AuthListInfo where title like '%works%req%month%' and title not like '%office%' and title not like '%pilot%' and datediff(mm,getdate(),DateCreated)=0) select usc.CI_ID, usc.NumTotal, usc.NumUnknown as Unknown, usc.NumPresent+usc.NumNotApplicable as Compliant, usc.NumMissing as NotCompliant, usc.CollectionID, coll.Name from v_UpdateSummaryPerCollection usc left join v_Collection coll on coll.CollectionID=usc.CollectionID where CI_ID=@SUG and @SUCollIDWorkStations like '%'+usc.CollectionID+'%' true CI_ID System.Int32 NumTotal System.Int32 Unknown System.Int32 Compliant System.Int32 NotCompliant System.Int32 CollectionID System.String Name System.String =Fields!Name.Value =Fields!Name.Value =Sum(Fields!Unknown.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN Black Black Software Updates Compliance on Workstations BrightPastel FrameTitle8 No Data Available SUG_Status_WorkStations 36.38876cm 17.55449cm 5.36927cm 17.48392cm White None =Fields!Name.Value =Fields!Name.Value =Sum(Fields!Compliant.Value) False 0.5 NaN NaN NaN 30 true Rotate45 true Axis Title False 0.5 NaN Opposite NaN NaN 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN Black Black Software Updates Compliance on Servers BrightPastel FrameTitle8 No Data Available SUG_Status_CollServers 36.38876cm 0.04331cm 11.223cm 17.1584cm 1 White None =Fields!Distribution_Point_Status.Value =Fields!Distribution_Point_Status.Value NotEqual OK =Fields!Distribution_Point_Status.Value =Sum(Fields!Not_Installed.Value) False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN Black Black Failed Package Distribution Status true BrightPastel FrameTitle8 No Data Available Distribution_Points_Status 7.72169cm 17.55449cm 5.93548cm 17.48392cm 2 White None =Fields!Distribution_Point_Status.Value =Fields!Distribution_Point_Status.Value =Count(Fields!DP_Name.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN 8pt Black Black Distribution Points Status BrightPastel FrameTitle8 No Data Available Distribution_Points_Status 7.72169cm 0.04331cm 5.93548cm 17.1584cm 3 White None =Fields!ComponentName.Value =Fields!ComponentName.Value =Sum(Fields!Count.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN 8pt Black Black 60 0 Site Component Errors BrightPastel FrameTitle8 No Data Available Site_Component_Errors 1.81187cm 17.58976cm 5.76871cm 17.44866cm 4 White None =Fields!Client_Version0.Value =Fields!Client_Version0.Value =Sum(Fields!Count.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN Black Black Count of Servers By Client Version BrightPastel FrameTitle8 No Data Available Count_of_Clients_by_version_Servers 30.14625cm 0.03528cm 6.06612cm 17.16643cm 5 White None =Fields!ErrorCode.Value =Fields!Count.Value Descending =Sum(Fields!Count.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN Error Code: Black Black Client Push Errors on Servers BrightPastel FrameTitle8 No Data Available Servers_Push_Errors 13.96586cm 0cm 6.32617cm 17.20171cm 6 White None true true SCCM Dashboard Textbox26 0.01042in 1.67583in 0.39792in 2.48958in #fdfdfb #fdfdfb #fdfdfb #e1e1e1 Middle 2pt 2pt 2pt 2pt true 0.01389in 0.50169in 13.78076in 7 #2b627f External /Report Parts/visma_menu.png b0ead978-166b-4c08-a249-2ca686afa7d8 /Report Parts/Header 2015-04-15T16:34:21.0270000+02:00 /ConfigMgr_VSM/SCCM - Default Reports/Endpoint Protection/Antimalware activity report VSM00175 48.95004cm 0.85231cm 3.4725cm 33.55281cm 8 2pt /ConfigMgr_VSM/SCCM - Default Reports/Endpoint Protection/Antimalware overall status and history VSM00175 52.72592cm 0.82903cm 3.74767cm 33.57609cm 9 2pt true true Servers Security Status: 2pt 2pt 2pt 2pt =Fields!HealthCheckGUID.Value =Fields!HealthCheckGUID.Value =Count(Fields!NetBiosName.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN 9pt Black Black 80 0 Failed Client Checks on Servers BrightPastel FrameTitle8 No Data Available Servers_Client_Check 20.68008cm 0.03528cm 9.07811cm 17.16643cm 11 White None =Fields!HealthCheckGUID.Value =Fields!HealthCheckGUID.Value =Count(Fields!NetBiosName.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN 9pt Black Black 80 0 Failed Client Checks on Workstations BrightPastel FrameTitle8 No Data Available Workstations_Client_Check 20.68008cm 17.58976cm 9.07811cm 17.44865cm 12 White None =Fields!ErrorCode.Value =Fields!Count.Value Descending =Sum(Fields!Count.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN Error Code: Black Black Client Push Errors on Workstations BrightPastel FrameTitle8 No Data Available Workstations_Push_errors 13.96586cm 17.62504cm 6.32617cm 17.44865cm 13 White None =Fields!Client_Version0.Value =Fields!Client_Version0.Value =Sum(Fields!Count.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN Black Black Count of Workstations By Client Version BrightPastel FrameTitle8 No Data Available Count_of_Clients_by_version_Workstations 30.14625cm 17.58976cm 6.06612cm 17.48393cm 14 White None 7.27858cm 2.82934cm 4.40414cm 2.68964cm 0.81167cm true true Report Textbox35 LightBlue 2pt 2pt 2pt 2pt true true Servers Textbox32 LightBlue 2pt 2pt 2pt 2pt true true Workstations Textbox33 LightBlue 2pt 2pt 2pt 2pt true true Total Textbox40 LightBlue 2pt 2pt 2pt 2pt 0.6cm true true Clients Installed in last 24H Middle 2pt 2pt 2pt 2pt true true =Max(Fields!Count__Inst_SRV.Value, "Server_Clients_Installed_24H") Textbox20 Middle 2pt 2pt 2pt 2pt true true =Max(Fields!Count__Inst_SRV.Value, "Workstation_Clients_Installed_24H") Textbox22 Middle 2pt 2pt 2pt 2pt true true =Max(Fields!Count__Inst_SRV.Value, "Server_Clients_Installed_24H") + Max(Fields!Count__Inst_SRV.Value, "Workstation_Clients_Installed_24H") Textbox41 Middle 2pt 2pt 2pt 2pt 0.6cm true true Duplicate MAC Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!ID.Value, "Servers_with_Duplicate_MAC") /ConfigMgr_VSM/SCCM - Default Reports/Site - Discovery and Inventory Information/Computers with duplicate MAC addresses =Parameters!CollIDServers.Value Textbox21 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!ID.Value, "Workstations_with_Duplicate_MAC") /ConfigMgr_VSM/SCCM - Default Reports/Site - Discovery and Inventory Information/Computers with duplicate MAC addresses =Parameters!CollIDWorkstations.Value Textbox24 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!ID.Value, "Servers_with_Duplicate_MAC")+Sum(Fields!ID.Value, "Workstations_with_Duplicate_MAC") Textbox42 Middle 2pt 2pt 2pt 2pt 0.6cm true true Duplicate GUID Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!CountDuplicates.Value, "Duplicate_GUID_Servers") Textbox161 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!CountDuplicates.Value, "Duplicate_GUID_Workstations") Textbox45 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!CountDuplicates.Value, "Duplicate_GUID_Servers")+Sum(Fields!CountDuplicates.Value, "Duplicate_GUID_Workstations") /ConfigMgr_VSM/SCCM - Default Reports/Site - Discovery and Inventory Information/Computers that might share the same Configuration Manager unique identifier Textbox159 Middle 2pt 2pt 2pt 2pt 0.6cm true true Client not reported in 14 days Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value, "Client_not_Reported_Servers") Textbox47 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value, "Client_not_Reported_Workstations") Textbox48 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value, "Client_not_Reported_Servers")+Sum(Fields!Count.Value, "Client_not_Reported_Workstations") /ConfigMgr_VSM/SCCM - Default Reports/Site - Discovery and Inventory Information/Clients that have not reported recently (in a specified number of days) 14 Textbox49 Middle 2pt 2pt 2pt 2pt 0.6cm true true Fatal Errors by machine Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value, "Fatal_Errors_Servers") Textbox163 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value, "Fatal_Errors_Workstations") Textbox164 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value, "Fatal_Errors_Servers")+Sum(Fields!Count.Value, "Fatal_Errors_Workstations") /ConfigMgr_VSM/SCCM - Default Reports/Status Messages/Fatal errors (by computer name) Textbox165 Middle 2pt 2pt 2pt 2pt After DataSetAdminID 1.81187cm 0cm 3.81167cm 17.2017cm 15 56.47359cm External /ConfigMgr_VSM/Visma Custom Reports/bg_pattern.png 35.10896cm 0.61648cm true true true Textbox23 0.13889in 0.24271in 13.65576in 2pt 2pt 2pt 2pt #616161 External /ConfigMgr_VSM/Visma Custom Reports/bg_pattern.png 21cm 29.7cm 2.54cm 2.54cm 2.54cm 2.54cm 1.27cm