RandolTech: 2015

Friday, December 18, 2015

Getting those users to reboot

The problem: You have a bunch of workstations in your environment that are pending restart (see my post "Reboot Pending configuration item and baseline" for info on determining that they are pending restart). Because these workstations are pending restart they are not receiving updates, or anything else that uses Windows Installer for that matter, and so they don't get notified by the update engine that they are pending restart. The users, completely oblivious, go on about their business never restarting their machines and you cannot manage them. This is most common on laptops where they just close the lid (sleep/hibernate) and never actually turn it off.

Compounding this problem, if you were to just send reboots at the machines on any given day, the users will start ringing the help desk that something is amiss. Even if you send them a countdown with a nice message that it is your company's IT that needs the computer restarted and give them a good long time to choose to restart it themselves they will still ring the help desk saying things like "I think its a virus".

The solution: Ok, this is really clever if I do say so myself. Here's how to solve this, step-by-step, without causing a bunch of calls to the help desk.

Create a package (packaged program model) that contains no source files. I called mine "Reboot Machine - User Interactive" because I also have one that reboots machines with no user interaction and no real warning but that's an item for another post.
Create a program for that package with the following settings:
Ensure that your client settings for Computer Restart are set to a nice long time, mine is set to 28 hours and the dialog box which they cannot close is set to a nice long time, mine is set to 4 hours. This is the "nag screen"... they have 24 hours until they get a nag screen they cannot close and 4 hours after that restart is forced.
Make a collection that contains members of your workstation software updates deployment collection (workstations only!!! don't send this at your servers or other machines that shouldn't be rebooted) that are also pending restart. Be sure both of those criteria are true for this collection... getting this collection wrong may result in unexpected termination of employment. So, get it right... members of your workstation software updates deployment collection that are also pending restart.
Deploy the program from step 2 to your new collection from step 4 with the following timing. Getting the timing wrong will end up in calls to the help desk as mentioned in the problem description.

The beauty of this is that it is SCCM's restart enforcement doing the work. Your users are used to seeing those particular enforcement dialogues so they don't cause as many help desk calls. When you assign this to happen just after (within a couple hours) the windows updates for the month then you have computers all over your environment enforcing updates with the same dialogues and so the users don't think this is any different. You've managed their expectations... they expect to restart at this time and they expect that restart to look exactly like this. So, they get restarted and you get much better results on your software updates. Okay, so you don't get those better results this month, but next month you will and so long as you keep firing this at them every month your results will stay quite high.

Monday, December 7, 2015

Fix Users cannot self-subscribe to SSRS reports

I locked down some permissions on our SCCM server today and afterward found that my non-admin account could no longer self-subscribe to reports. Here's how to correct that should you find yourself in a similar situation:

Open SQL Server Management Studio

In the "Connect to Server" window, Server Type = Reporting Services, Server Name = YourSQLServerReportingServer
Expand Security > Roles > Right click, properties on ConfigMgr Reports Users
Check and enable Manage individual subscriptions and click OK

That change will be immediate and will allow self-subscription but only to the user's AD alias. In my case (and I'm sure many others) the alias that it wants to use is not a full email address so you will have to continue with this next step. As I said, that change is immediate so just go and see if things work the way you want them. If you have the problem that I do, the email address is no good, then continue with this next part.

On the SSRS server locate the file "RSReportServer.config". Double-check its location to be sure it is actually the one that SSRS is using and not just some random copy. In that file:

In RSReportServer.config, locate the item "<SendEmailToUserAlias>"
Change the value of <SendEmailToUserAlias> from true to false
Stop the SSRS service
Stop the Worldwide Web Publishing service
Start the Worldwide Web Publishing service
Start the SSRS service

When you re-connect to the SSRS server in your browser at this point it will take a long time to open the page as it will re-initialize the site. Will only be slow the first time, but just wanted to warn you it will take a couple minutes on first connect.

That should do it, your users should now be able to self-subscribe.

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

Monday, November 30, 2015

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>