RandolTech: SCCM - Software Updates Compliancy Overview Report (SSRS)

This is my first real forray into SSRS. I had to figure out how to use Report Builder 3.0. My condolences to anyone else who has to use it. I did, however, come up with a pretty cool report. Here is what the output looks like:

I've attached the report for your use but you will need to modify it somewhat.
I suggest using Report Builder 3.0 (or later) to modify the .rdl.

You should only need to set your Data Source to your SCCM database (Report Builder will actively complain about the data source so you can't forget it) then modify the report parameters and upload to your SSRS server.

In Report Build expand Data Sources. Right click the data source SCCMDatabase and delete the existing connection. Set a connection to your SCCM database, there should be a shared one already on your SSRS server that you can use without having to deal with knowledge of how to create these.

In Report Builder expand the Parameters section. Here are the parameters and what need to do with them:

SUG_MasterComplianceList - This is the name of your software updates group that contains every update that you've ever published. This is that list that every company maintains for reporting purposes but it isn't really used for distribution because the size of it would break things. It is a text field that is the display name of that SUG.
SUG_DeploymentCurrent - This is the name of the current deployment SUG. I have it calculating it as current month - 1 (so yeah, last month's updates are the current deployment in my environment). You may need to adjust that calculation. It is also setting the naming convention as "YYYY MM Month" (example: 2015 10 October) so you may need to work it around so that it fits your naming convention. Anything you do to this formula you'll need to do in the other SUG formulas as well.
SUG_DeploymentOneMonthAgo - The SUG that was deployed the month before this current one. It is same naming convention as SUG_DeploymentCurrent and calculated using the same formula so any adjustments that you had to do on that parameter you'll need to do on this one as well. Only difference here is this is -2 rather than -1.
SUG_DeploymentTwoMonthAgo - The SUG that was deployed two months before this current one. It is same naming convention as SUG_DeploymentCurrent and calculated using the same formula so any adjustments that you had to do on that parameter you'll need to do on this one as well. Only difference here is this is -3 rather than -1.
SUG_DeploymentThreeMonthAgo - The SUG that was deployed three months before this current one. It is same naming convention as SUG_DeploymentCurrent and calculated using the same formula so any adjustments that you had to do on that parameter you'll need to do on this one as well. Only difference here is this is -4 rather than -1.
CollID_AllActiveClients - The collection ID of a collection of all computers in your environment that have active SCCM clients. I don't report machines without active clients because that will cause reporting on things that are not manageable by SCCM and thus not an updates distribution problem that can possibly be solved by SCCM. Basically it causes more management questions than it is worth since you can't solve the problem here. Unmanaged machines should be handled in reporting on your SCCM infrastructure client health not in your update distribution compliance. Anyway, this is the actual ID number in the console add the collection ID as a displayed column and then stick that number in here.
CollID_AllActiveClientServers - Collection ID of a collection that contains all your servers (System / Role = Server) that are active clients (System Resource / Activity = 1). This is all of the servers that you could possible update if you were allowed to.
CollID_AllActiveClientWorkstations - Collection ID of a collection that contains all your workstations (System / Role = Workstation) that are active clients (System Resource / Activity = 1). This is all of the workstations that you could possible update if you were allowed to.
CollID_ServersManaged - Collection ID of a collection of all of the servers to which you actually deploy updates. There are always some servers to which you are not allowed to deploy updates because if they go badly it could be disastrous up to loss of human life (medical equipment in health care industry, saw controllers in lumber industry, pipepline pressure controllers in oil/gas industry). So, this collection is excluding those... the "All" collections mentioned earlier include them. This is only things that you are actually updating but it is all of the servers that you are actually updating.
CollID_WorkstationsManaged - Collection ID of a collection of all of the workstations to which you actually deploy updates. There are always some workstations to which you are not allowed to deploy updates because if they go badly it could be disastrous up to loss of human life (medical equipment in health care industry, saw controllers in lumber industry, pipepline pressure controllers in oil/gas industry). So, this collection is excluding those... the "All" collections mentioned earlier include them. This is only things that you are actually updating but it is all of the workstations that you are actually updating.

I hope at someone finds this useful. It took me many hours to get all of the queries right and many, many more hours to wrestle Report Builder into submission to format it correctly and then yet more to change it all to use parameters rather than having to modify each query individually.

If you find this useful please give a +1, leave a comment, or link back to this blog post.
Thanks and enjoy!

Here is the report, copy/paste it then save as a .rdl file:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="SCCMDatabase">
<DataSourceReference>/ConfigMgr_SIT/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}</DataSourceReference>
<rd:SecurityType>None</rd:SecurityType>
<rd:DataSourceID>05a57ed4-2aeb-4036-8f9b-61fd928fdfac</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="DS_OverallComplianceEverything">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_MasterComplianceList">
<Value>=Parameters!SUG_MasterComplianceList.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_AllActiveClients">
<Value>=Parameters!CollID_AllActiveClients.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_MasterComplianceList
set @ThisQueryCollID = @CollID_AllActiveClients
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_OverallComplianceServersAll">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_MasterComplianceList">
<Value>=Parameters!SUG_MasterComplianceList.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_AllActiveClientServers">
<Value>=Parameters!CollID_AllActiveClientServers.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_MasterComplianceList
set @ThisQueryCollID = @CollID_AllActiveClientServers
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_OverallComplianceWorkstationsAll">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_MasterComplianceList">
<Value>=Parameters!SUG_MasterComplianceList.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_AllActiveClientWorkstations">
<Value>=Parameters!CollID_AllActiveClientWorkstations.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_MasterComplianceList
set @ThisQueryCollID = @CollID_AllActiveClientWorkstations
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ProductionComplianceServers">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_MasterComplianceList">
<Value>=Parameters!SUG_MasterComplianceList.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_ServersManaged">
<Value>=Parameters!CollID_ServersManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_MasterComplianceList
set @ThisQueryCollID = @CollID_ServersManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ProductionComplianceWorkstations">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_MasterComplianceList">
<Value>=Parameters!SUG_MasterComplianceList.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_WorkstationsManaged">
<Value>=Parameters!CollID_WorkstationsManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_MasterComplianceList
set @ThisQueryCollID = @CollID_WorkstationsManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceServersCurrentMonth">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentCurrent">
<Value>=Parameters!SUG_DeploymentCurrent.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_ServersManaged">
<Value>=Parameters!CollID_ServersManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentCurrent
set @ThisQueryCollID = @CollID_ServersManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceServersOneMonthAgo">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentOneMonthAgo">
<Value>=Parameters!SUG_DeploymentOneMonthAgo.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_ServersManaged">
<Value>=Parameters!CollID_ServersManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentOneMonthAgo
set @ThisQueryCollID = @CollID_ServersManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceServersTwoMonthAgo">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentTwoMonthAgo">
<Value>=Parameters!SUG_DeploymentTwoMonthAgo.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_ServersManaged">
<Value>=Parameters!CollID_ServersManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentTwoMonthAgo
set @ThisQueryCollID = @CollID_ServersManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceServersThreeMonthAgo">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentThreeMonthAgo">
<Value>=Parameters!SUG_DeploymentThreeMonthAgo.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_ServersManaged">
<Value>=Parameters!CollID_ServersManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentThreeMonthAgo
set @ThisQueryCollID = @CollID_ServersManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceWorkstationsCurrentMonth">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentCurrent">
<Value>=Parameters!SUG_DeploymentCurrent.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_WorkstationsManaged">
<Value>=Parameters!CollID_WorkstationsManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentCurrent
set @ThisQueryCollID = @CollID_WorkstationsManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceWorkstationsOneMonthAgo">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentOneMonthAgo">
<Value>=Parameters!SUG_DeploymentOneMonthAgo.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_WorkstationsManaged">
<Value>=Parameters!CollID_WorkstationsManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentOneMonthAgo
set @ThisQueryCollID = @CollID_WorkstationsManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceWorkstationsTwoMonthAgo">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentTwoMonthAgo">
<Value>=Parameters!SUG_DeploymentTwoMonthAgo.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_WorkstationsManaged">
<Value>=Parameters!CollID_WorkstationsManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentTwoMonthAgo
set @ThisQueryCollID = @CollID_WorkstationsManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="DS_ComplianceWorkstationThreeMonthAgo">
<Query>
<DataSourceName>SCCMDatabase</DataSourceName>
<QueryParameters>
<QueryParameter Name="@SUG_DeploymentThreeMonthAgo">
<Value>=Parameters!SUG_DeploymentThreeMonthAgo.Value</Value>
</QueryParameter>
<QueryParameter Name="@CollID_WorkstationsManaged">
<Value>=Parameters!CollID_WorkstationsManaged.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>declare @ThisQuerySUG VARCHAR(50);
declare @ThisQueryCollID VARCHAR(8);
declare @CI_ID int;
set @ThisQuerySUG = @SUG_DeploymentThreeMonthAgo
set @ThisQueryCollID = @CollID_WorkstationsManaged
select @CI_ID = CI_ID
from CI_ConfigurationItems
where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo
Where Title=@ThisQuerySUG)
select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1)
from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing
from v_UpdateSummaryPerCollection
where CI_ID=@CI_ID and CollectionID=@ThisQueryCollID
) cnt
unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs
left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status
where cs.NumberOfComputers>0
order by StatusNumber</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Status">
<DataField>Status</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="NumberOfComputers">
<DataField>NumberOfComputers</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StatusNumber">
<DataField>StatusNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PercentOfComputers">
<DataField>PercentOfComputers</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
</Fields>
</DataSet>
</DataSets>
<ReportSections>
<ReportSection>
<Body>
<ReportItems>
<Rectangle Name="Rectangle_TotalCompliance">
<ReportItems>
<Textbox Name="Textbox_TotalComplianceTitle">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Total Overall Compliance </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontSize>12pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Total for all systems (including field)</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_OverallComplianceEverything")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<ListLevel>1</ListLevel>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.38472in</Height>
<Width>7in</Width>
<Style>
<Border>
<Style>Solid</Style>
</Border>
<BackgroundColor>Silver</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Rectangle Name="Rectangle_TotalComplianceServers">
<ReportItems>
<Textbox Name="Textbox_TotalComplianceServers">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Total Compliance for All Servers = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_OverallComplianceServersAll")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Compliance for Prod Servers = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ProductionComplianceServers")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.37708in</Height>
<Width>3.5in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_TotalComplianceServers">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Text_OverallComplianceServerStats">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value> Servers </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsTotalComplianceServers" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_OverallComplianceServersAll</DataSetName>
<Top>0.37708in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.38472in</Top>
<Height>0.57708in</Height>
<Width>3.5in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>Solid</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_TotalComplianceWorkstations">
<ReportItems>
<Textbox Name="Textbox_TotalComplianceWorkstations">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Total Compliance for All Workstations = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_OverallComplianceWorkstationsAll")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Compliance for Prod Workstations = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ProductionComplianceWorkstations")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.37708in</Height>
<Width>3.5in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_TotalComplianceWorkstations">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Text_OverallComplianceWorkstationStats">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value> Workstations </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsTotalComplianceWorkstations" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_OverallComplianceWorkstationsAll</DataSetName>
<Top>0.37708in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.38472in</Top>
<Left>3.5in</Left>
<Height>0.57708in</Height>
<Width>3.5in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>Solid</Style>
</Border>
</Style>
</Rectangle>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>1.125in</Top>
<Left>0.5in</Left>
<Height>1in</Height>
<Width>7in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Textbox Name="ReportTitle">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Software Updates Compliance Overview</Value>
<Style>
<FontFamily>Verdana</FontFamily>
<FontSize>20pt</FontSize>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Globals!ExecutionTime</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:WatermarkTextbox>Title</rd:WatermarkTextbox>
<rd:DefaultName>ReportTitle</rd:DefaultName>
<Top>0.5in</Top>
<Left>0.5in</Left>
<Height>0.45in</Height>
<Width>7in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
<BackgroundColor>Silver</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Rectangle Name="Rectangle_ComplianceFourMonth">
<ReportItems>
<Textbox Name="Textbox_TitleComplianceFourMonth">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Compliance for the latest four months deployments</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontSize>12pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Following only includes items that we target with our deployments (production)</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<ListLevel>1</ListLevel>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.45in</Height>
<Width>7in</Width>
<Style>
<Border>
<Style>Solid</Style>
</Border>
<BackgroundColor>Silver</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Rectangle Name="Rectangle_ComplianceFourMonthWorkstations">
<ReportItems>
<Rectangle Name="Rectangle_WorkstationComplianceTwoMonthAgo">
<ReportItems>
<Textbox Name="Textbox_WorkstationComplianceTwoMonthAgo">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>TwoMonthAgoWorkstation</Label>
<Value>=Parameters!SUG_DeploymentTwoMonthAgo.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceWorkstationsTwoMonthAgo")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.45in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_WorkstationComplianceTwoMonthAgo">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerWorkstationComplianceTwoMonthAgo">
<ReportItems>
<Textbox Name="Textbox1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox1</rd:DefaultName>
<Height>0.2in</Height>
<Width>2.95in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsWorkstationComplianceTwoMonthAgo" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceWorkstationsTwoMonthAgo</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>1.25in</Top>
<Height>0.45in</Height>
<Width>3.5in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_WorkstationComplianceThreeMonthAgo">
<ReportItems>
<Textbox Name="Textbox_WorkstationComplianceThreeMonthAgo">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>ThreeMonthAgoWorkstation</Label>
<Value>=Parameters!SUG_DeploymentThreeMonthAgo.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceWorkstationThreeMonthAgo")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.45in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_WorkstationComplianceThreeMonthAgo">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerWorkstationComplianceThreeMonthAgo">
<ReportItems>
<Textbox Name="Textbox5">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox5</rd:DefaultName>
<Height>0.2in</Height>
<Width>2.95in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsWorkstationComplianceThreeMonthAgo" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceWorkstationThreeMonthAgo</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>1.75in</Top>
<Height>0.45in</Height>
<Width>3.5in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_WorkstationComplianceCurrentMonth">
<ReportItems>
<Textbox Name="Textbox_WorkstationComplianceCurrentMonth">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>CurrentMonthWorkstation</Label>
<Value>=Parameters!SUG_DeploymentCurrent.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceWorkstationsCurrentMonth")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.45in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_WorkstationComplianceCurrentMonth">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerWorkstationComplianceCurrentMonth">
<ReportItems>
<Textbox Name="Textbox3">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox3</rd:DefaultName>
<Height>0.2in</Height>
<Width>2.95in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsWorkstationComplianceCurrentMonth" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceWorkstationsCurrentMonth</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.25in</Top>
<Height>0.45in</Height>
<Width>3.5in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_WorkstationComplianceOneMonthAgo">
<ReportItems>
<Textbox Name="Textbox_WorkstationComplianceOneMonthAgo">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>OneMonthAgoWorkstation</Label>
<Value>=Parameters!SUG_DeploymentOneMonthAgo.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceWorkstationsOneMonthAgo")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.45in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_WorkstationComplianceOneMonthAgo">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerWorkstationComplianceOneMonthAgo">
<ReportItems>
<Textbox Name="Textbox4">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox4</rd:DefaultName>
<Height>0.2in</Height>
<Width>2.95in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsWorkstationComplianceOneMonthAgo" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceWorkstationsOneMonthAgo</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.75in</Top>
<Height>0.48333in</Height>
<Width>3.5in</Width>
<ZIndex>3</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Textbox Name="Title_ComplianceFourMonthWorkstations">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Workstation Compliance</Value>
<Style>
<FontFamily>Calibri</FontFamily>
<FontSize>12pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox7</rd:DefaultName>
<Height>0.25in</Height>
<Width>3.5in</Width>
<ZIndex>4</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.45in</Top>
<Left>3.5in</Left>
<Height>2.25in</Height>
<Width>3.5in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>Solid</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_ComplianceFourMonthServers">
<ReportItems>
<Rectangle Name="Rectangle_ServerComplianceTwoMonthAgo">
<ReportItems>
<Textbox Name="Textbox_ServerComplianceTwoMonthAgo">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>TwoMonthAgoServer</Label>
<Value>=Parameters!SUG_DeploymentTwoMonthAgo.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceServersTwoMonthAgo")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.5in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_ServerComplianceTwoMonthAgo">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerServerComplianceTwoMonthAgo">
<ReportItems>
<Textbox Name="Status">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Status</rd:DefaultName>
<Height>0.2in</Height>
<Width>2.95in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsServerComplianceTwoMonthAgo" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceServersTwoMonthAgo</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>1.25in</Top>
<Height>0.45in</Height>
<Width>3.5in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_ServerComplianceThreeMonthAgo">
<ReportItems>
<Textbox Name="Textbox_ServerComplianceThreeMonthAgo">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>ThreeMonthAgoServer</Label>
<Value>=Parameters!SUG_DeploymentThreeMonthAgo.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceServersThreeMonthAgo")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.45in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_ServerComplianceThreeMonthAgo">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerServerComplianceThreeMonthAgo">
<ReportItems>
<Textbox Name="Textbox2">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox2</rd:DefaultName>
<Height>0.2in</Height>
<Width>2.95in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsServerComplianceThreeMonthAgo" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceServersThreeMonthAgo</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>1.75in</Top>
<Height>0.45in</Height>
<Width>3.5in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_ServerComplianceCurrentMonth">
<ReportItems>
<Textbox Name="Textbox_ServerComplianceCurrentMonth">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>CurrentMonthServer</Label>
<Value>=Parameters!SUG_DeploymentCurrent.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceServersCurrentMonth")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.5in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_ServerComplianceCurrentMonth">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerServerComplianceCurrentMonth">
<ReportItems>
<Textbox Name="Text_ServerComplianceCurrentDetails">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsServerComplianceCurrentMonth" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceServersCurrentMonth</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.25in</Top>
<Height>0.4in</Height>
<Width>3.5in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Rectangle Name="Rectangle_ServerComplianceOneMonthAgo">
<ReportItems>
<Textbox Name="Textbox_ServerComplianceOneMonthAgo">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Deployment </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Label>OneMonthAgoServer</Label>
<Value>=Parameters!SUG_DeploymentOneMonthAgo.Value</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value EvaluationMode="Constant"> = </Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>=First(Fields!PercentOfComputers.Value, "DS_ComplianceServersOneMonthAgo")</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
<TextRun>
<Value>%</Value>
<Style>
<FontStyle>Normal</FontStyle>
<FontFamily>Calibri</FontFamily>
<FontWeight>Bold</FontWeight>
<Format>0.00;(0.00)</Format>
<TextDecoration>None</TextDecoration>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Height>0.2in</Height>
<Width>3.5in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>15pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Tablix Name="Tablix_ServerComplianceOneMonthAgo">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>3in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.2in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle_TablixContainerServerComplianceOneMonthAgo">
<ReportItems>
<Textbox Name="NumberOfComputers">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!NumberOfComputers.Value</Value>
<Style />
</TextRun>
<TextRun>
<Value xml:space="preserve"> </Value>
<Style />
</TextRun>
<TextRun>
<Value>=Fields!Status.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>NumberOfComputers</rd:DefaultName>
<Height>0.2in</Height>
<Width>3in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="DetailsServerComplianceOneMonthAgo" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DS_ComplianceServersOneMonthAgo</DataSetName>
<Top>0.2in</Top>
<Left>0.5in</Left>
<Height>0.2in</Height>
<Width>3in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.75in</Top>
<Height>0.45in</Height>
<Width>3.5in</Width>
<ZIndex>3</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
<Textbox Name="Title_ComplianceFourMonthServers">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Server Compliance</Value>
<Style>
<FontFamily>Calibri</FontFamily>
<FontSize>12pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>#366092</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox8</rd:DefaultName>
<Height>0.25in</Height>
<Width>3.5in</Width>
<ZIndex>4</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
<BackgroundColor>LightGrey</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>0.45in</Top>
<Height>2.25in</Height>
<Width>3.5in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>Solid</Style>
</Border>
</Style>
</Rectangle>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>2.25in</Top>
<Left>0.5in</Left>
<Height>2.75in</Height>
<Width>7in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</ReportItems>
<Height>5.5in</Height>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Body>
<Width>8in</Width>
<Page>
<PageFooter>
<Height>0.45in</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</PageFooter>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style />
</Page>
</ReportSection>
</ReportSections>
<ReportParameters>
<ReportParameter Name="SUG_MasterComplianceList">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>0000 - MASTER COMPLIANCE - Windows Updates</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>0000 - MASTER COMPLIANCE - Windows Updates</Value>
<Label>SUG_MasterComplianceList</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="SUG_DeploymentCurrent">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=((Year(DateAdd("M",-1,Today()))) & " " & IIF(((Month(DateAdd("M",-1,Today())))<10),"0","") & (Month(DateAdd("M",-1,Today()))) & " " & (MonthName(Month(DateAdd("M",-1,Today())))))</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>=((Year(DateAdd("M",-1,Today()))) & " " & IIF(((Month(DateAdd("M",-1,Today())))<10),"0","") & (Month(DateAdd("M",-1,Today()))) & " " & (MonthName(Month(DateAdd("M",-1,Today())))))</Value>
<Label>SUG Name 1</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="SUG_DeploymentOneMonthAgo">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=((Year(DateAdd("M",-2,Today()))) & " " & IIF(((Month(DateAdd("M",-2,Today())))<10),"0","") & (Month(DateAdd("M",-2,Today()))) & " " & (MonthName(Month(DateAdd("M",-2,Today())))))</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>=((Year(DateAdd("M",-2,Today()))) & " " & IIF(((Month(DateAdd("M",-2,Today())))<10),"0","") & (Month(DateAdd("M",-2,Today()))) & " " & (MonthName(Month(DateAdd("M",-2,Today())))))</Value>
<Label>SUG Name 2</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="SUG_DeploymentTwoMonthAgo">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=((Year(DateAdd("M",-3,Today()))) & " " & IIF(((Month(DateAdd("M",-3,Today())))<10),"0","") & (Month(DateAdd("M",-3,Today()))) & " " & (MonthName(Month(DateAdd("M",-3,Today())))))</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>=((Year(DateAdd("M",-3,Today()))) & " " & IIF(((Month(DateAdd("M",-3,Today())))<10),"0","") & (Month(DateAdd("M",-3,Today()))) & " " & (MonthName(Month(DateAdd("M",-3,Today())))))</Value>
<Label>SUG Name 3</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="SUG_DeploymentThreeMonthAgo">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=((Year(DateAdd("M",-4,Today()))) & " " & IIF(((Month(DateAdd("M",-4,Today())))<10),"0","") & (Month(DateAdd("M",-4,Today()))) & " " & (MonthName(Month(DateAdd("M",-4,Today())))))</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>=((Year(DateAdd("M",-4,Today()))) & " " & IIF(((Month(DateAdd("M",-4,Today())))<10),"0","") & (Month(DateAdd("M",-4,Today()))) & " " & (MonthName(Month(DateAdd("M",-4,Today())))))</Value>
<Label>SUG Name 4</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="CollID_AllActiveClients">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>SIT00183</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>SIT00183</Value>
<Label>CollID_AllActiveClients</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="CollID_AllActiveClientServers">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>SIT001D2</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>SIT001D2</Value>
<Label>CollID_AllActiveClientServers</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="CollID_AllActiveClientWorkstations">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>SIT001C4</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>SIT001C4</Value>
<Label>CollID_AllActiveClientWorkstations</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="CollID_ServersManaged">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>SIT000DA</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>SIT000DA</Value>
<Label>CollID_ServersManaged</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="CollID_WorkstationsManaged">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>SIT000DE</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>SIT000DE</Value>
<Label>CollID_WorkstationsManaged</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
</ReportParameters>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
<rd:ReportServerUrl>https://myssrsserver.mydomain.com/ReportServer</rd:ReportServerUrl>
<rd:ReportID>2feb86d3-aa7a-40cb-b15a-a26cda990949</rd:ReportID>
</Report>

RandolTech

Monday, November 30, 2015

SCCM - Software Updates Compliancy Overview Report (SSRS)

No comments:

Post a Comment

Translate