Skip to content

Instantly share code, notes, and snippets.

@Ioan-Popovici

Ioan-Popovici/HW BIOS by Manufacturer and Model for Collection.rdl

Last active January 22, 2020 13:10
Show Gist options
  • Save Ioan-Popovici/fadadb00adebe58f6376ad598b05efa6 to your computer and use it in GitHub Desktop.
Save Ioan-Popovici/fadadb00adebe58f6376ad598b05efa6 to your computer and use it in GitHub Desktop.
Download ZIP
Lists the Hardware info of a Computer Collection including BIOS version and Computer model.
Raw
HW BIOS by Manufacturer and Model for Collection.rdl
<?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">
<Description>Lists BIOS, hardware and operating system information by manufacturer and model.</Description>
<Author>Popovici Ioan @ SCCM-Zone.com</Author>
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="DataSource">
<DataSourceReference>/ConfigMgr_A01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}</DataSourceReference>
<rd:SecurityType>None</rd:SecurityType>
<rd:DataSourceID>33f94ec3-1e39-4466-a6ee-65619da20a87</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="HardwareData">
<Query>
<DataSourceName>DataSource</DataSourceName>
<QueryParameters>
<QueryParameter Name="@CollectionID">
<Value>=Parameters!CollectionID.Value</Value>
</QueryParameter>
<QueryParameter Name="@UserSIDs">
<Value>=Parameters!UserSIDs.Value</Value>
</QueryParameter>
<QueryParameter Name="@ExcludeVirtualMachines">
<Value>=Parameters!ExcludeVirtualMachines.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>/*
.SYNOPSIS
Gets the Hardware info of a Computer Collection.
.DESCRIPTION
Gets the Hardware info of a Computer Collection including BIOS version and Computer model.
.NOTES
Created by Ioan Popovici
This query is part of a report should not be run separately.
.LINK
https://SCCM.Zone/HW-BIOS-Manufacturer
.LINK
https://SCCM.Zone/HW-BIOS-Manufacturer-CHANGELOG
.LINK
https://SCCM.Zone/HW-BIOS-Manufacturer-GIT
.LINK
https://SCCM.Zone/Issues
*/
/*##=============================================*/
/*## QUERY BODY */
/*##=============================================*/
/* Testing variables !! Need to be commented for Production !! */
--DECLARE @UserSIDs AS VARCHAR(16) = 'Disabled';
--DECLARE @CollectionID AS VARCHAR(16) = 'A01000B3';
--DECLARE @ExcludeVirtualMachines AS VARCHAR(3) = 'YES';
SELECT DISTINCT
Manufacturer = System.Manufacturer0
, Model =
CASE
WHEN System.Model0 LIKE '10AA%' THEN 'ThinkCentre M93p'
WHEN System.Model0 LIKE '10AB%' THEN 'ThinkCentre M93p'
WHEN System.Model0 LIKE '10AE%' THEN 'ThinkCentre M93z'
WHEN System.Model0 LIKE '10FLS1TJ%' THEN 'ThinkCentre M900'
WHEN Product.Version0 = 'Lenovo Product' THEN ('Unknown ' + System.Model0)
WHEN System.Manufacturer0 = 'LENOVO' THEN Product.Version0
ELSE System.Model0
END,
DeviceName = System.Name0
, UserName = CONCAT(Computers.User_Domain0 + '\', Computers.User_Name0) -- Add user domain to UserName
, BIOSName = BIOS.Name0
, BIOSVersion = BIOS.Version0
, SMBIOSVersion = BIOS.SMBIOSBIOSVersion0
, BIOSSerialNumber = BIOS.SerialNumber0
, OperatingSystem =
CONCAT(
REPLACE(OperatingSystem.Caption0, 'Microsoft ', ''), -- Remove 'Microsoft ' from OperatingSystem
REPLACE(OperatingSystem.CSDVersion0, 'Service Pack ', ' SP') -- Replace 'Service Pack ' with ' SP' in OperatingSystem
)
, OSVersion = OSLocalizedNames.Value
, OSBuildNumber = OperatingSystem.Version0
, OSInstallDate = OperatingSystem.InstallDate0
FROM fn_rbac_R_System(@UserSIDs) AS Computers
JOIN fn_rbac_GS_OPERATING_SYSTEM(@UserSIDs) AS OperatingSystem ON OperatingSystem.ResourceID = Computers.ResourceID
JOIN fn_rbac_GS_COMPUTER_SYSTEM(@UserSIDs) AS System ON System.ResourceID = Computers.ResourceID
LEFT JOIN fn_GetWindowsServicingStates() AS OSServicingStates ON OSServicingStates.Build = OperatingSystem.Version0
AND Computers.OSBranch01 = OSServicingStates.Branch -- Select only the branch of the installed OS
LEFT JOIN fn_GetWindowsServicingLocalizedNames() AS OSLocalizedNames ON OSLocalizedNames.Name = OSServicingStates.Name
JOIN fn_rbac_ClientCollectionMembers(@UserSIDs) AS Collections ON Collections.ResourceID = Computers.ResourceID
JOIN fn_rbac_GS_PC_BIOS(@UserSIDs) AS BIOS ON BIOS.ResourceID = Computers.ResourceID
JOIN fn_rbac_GS_COMPUTER_SYSTEM_PRODUCT(@UserSIDs) AS Product ON Product.ResourceID = Computers.ResourceID
WHERE Collections.CollectionID = @CollectionID
AND System.Model0 NOT LIKE (
CASE @ExcludeVirtualMachines
WHEN 'YES' THEN '%Virtual%'
ELSE ''
END
)
ORDER BY
Model,
BIOSName,
BIOSVersion
/*##=============================================*/
/*## END QUERY BODY */
/*##=============================================*/</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="Manufacturer">
<DataField>Manufacturer</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Model">
<DataField>Model</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DeviceName">
<DataField>DeviceName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="UserName">
<DataField>UserName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="BIOSName">
<DataField>BIOSName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="BIOSVersion">
<DataField>BIOSVersion</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SMBIOSVersion">
<DataField>SMBIOSVersion</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="BIOSSerialNumber">
<DataField>BIOSSerialNumber</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="OperatingSystem">
<DataField>OperatingSystem</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="OSVersion">
<DataField>OSVersion</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="OSBuildNumber">
<DataField>OSBuildNumber</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="OSInstallDate">
<DataField>OSInstallDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="AdminID">
<Query>
<DataSourceName>DataSource</DataSourceName>
<QueryParameters>
<QueryParameter Name="@UserTokenSIDs">
<Value>=Parameters!UserTokenSIDs.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>/* Get UserSID */
SELECT dbo.fn_rbac_GetAdminIDsfromUserSIDs (@UserTokenSIDs) AS UserSIDs</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="UserSIDs">
<DataField>UserSIDs</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="CollectionInfo">
<Query>
<DataSourceName>DataSource</DataSourceName>
<QueryParameters>
<QueryParameter Name="@UserSIDs">
<Value>=Parameters!UserSIDs.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>/* Get Device Collections */
SELECT
CollectionID,
Name
FROM dbo.fn_rbac_Collection(@UserSIDs)
WHERE CollectionType = 2
ORDER BY
Name;</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="CollectionID">
<DataField>CollectionID</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="ReportDescription">
<Query>
<DataSourceName>DataSource</DataSourceName>
<QueryParameters>
<QueryParameter Name="@ReportName">
<Value>=Parameters!ReportName.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>/* ReportDescription Dataset */
SELECT DISTINCT Description
FROM ReportServer.dbo.Catalog
WHERE Name = @ReportName</CommandText>
</Query>
<Fields>
<Field Name="Description">
<DataField>Description</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
</DataSets>
<ReportSections>
<ReportSection>
<Body>
<ReportItems>
<Tablix Name="Tablix">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>34.11198mm</Width>
</TablixColumn>
<TablixColumn>
<Width>32.01458mm</Width>
</TablixColumn>
<TablixColumn>
<Width>42.38625mm</Width>
</TablixColumn>
<TablixColumn>
<Width>38.20638mm</Width>
</TablixColumn>
<TablixColumn>
<Width>34.90492mm</Width>
</TablixColumn>
<TablixColumn>
<Width>33.3375mm</Width>
</TablixColumn>
<TablixColumn>
<Width>50.25075mm</Width>
</TablixColumn>
<TablixColumn>
<Width>25mm</Width>
</TablixColumn>
<TablixColumn>
<Width>25.4mm</Width>
</TablixColumn>
<TablixColumn>
<Width>40.21667mm</Width>
</TablixColumn>
<TablixColumn>
<Width>17.72708mm</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>6.80433mm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="TH_BiosName">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!BIOSName.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("BIOS Name", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_BiosVersion">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!BIOSVersion.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("BIOS Version", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_SMBiosVersion">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!SMBIOSVersion.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("SMBIOS Version", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_BiosSerialNumber">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!BIOSSerialNumber.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("SerialNumber", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_DeviceName">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DeviceName.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("DeviceName", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_UserName">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!UserName.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("User", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_OperatingSystem">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!OperatingSystem.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("OperatingSystem", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_OSBuildNumber">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!OSBuildNumber.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("Build", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_OSVersion">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!OSVersion.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("Version", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_OSInstallDate">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!OSInstallDate.Value</SortExpression>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("InstallDate", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TH_Total">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Sum(Count(Fields!DeviceName.Value))</SortExpression>
<SortExpressionScope>Model</SortExpressionScope>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("Total", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>6.80433mm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="TV_BiosName">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!BIOSName.Value</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_BiosVersion">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!BIOSVersion.Value</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_SMBiosVersion">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!SMBIOSVersion.Value</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_BiosSerialNumber">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!BIOSSerialNumber.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_DeviceName">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!DeviceName.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_UserName">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!UserName.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_OperatingSystem">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!OperatingSystem.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_OSBuildNumber">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!OSBuildNumber.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_OSVersion">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Label>OS_Version</Label>
<Value>=Fields!OSVersion.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="TV_OSInstallDate">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!OSInstallDate.Value</Value>
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox8">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Tahoma</FontFamily>
<Color>#4d4d4d</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox8</rd:DefaultName>
<Style>
<Border>
<Color>#e5e5e5</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#e6eefc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>6.80433mm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="TV_Computers">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Computers</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox79">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox79</rd:DefaultName>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Row_Merged_0">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<ColSpan>8</ColSpan>
</CellContents>
</TablixCell>
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell>
<CellContents>
<Textbox Name="TV_Total_ComputersModel">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Count(Fields!DeviceName.Value)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>6.35mm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Textbox81">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox80</rd:DefaultName>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox80">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox80</rd:DefaultName>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Row_Merged_1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<ColSpan>8</ColSpan>
</CellContents>
</TablixCell>
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell>
<CellContents>
<Textbox Name="TV_Total_Models">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=CountDistinct(Fields!Model.Value)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>6.80433mm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Textbox84">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox83</rd:DefaultName>
<Style>
<Border>
<Color>#9eb6e4</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#7292cc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox83">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox83</rd:DefaultName>
<Style>
<Border>
<Color>#9eb6e4</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#7292cc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Row_Merged_3">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#9eb6e4</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#7292cc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<ColSpan>8</ColSpan>
</CellContents>
</TablixCell>
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell />
<TablixCell>
<CellContents>
<Textbox Name="TV_Total_Computers">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Count(Fields!DeviceName.Value)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#9eb6e4</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#7292cc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<TablixHeader>
<Size>37.66017mm</Size>
<CellContents>
<Textbox Name="TH_Manufacturer">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!Manufacturer.Value</SortExpression>
<SortExpressionScope>Manufacturer</SortExpressionScope>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("Manufacturer", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember>
<TablixHeader>
<Size>37.57083mm</Size>
<CellContents>
<Textbox Name="TH_Model">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!Model.Value</SortExpression>
<SortExpressionScope>Model</SortExpressionScope>
</UserSort>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("Model", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#7292cc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#4c68a2</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixMember>
</TablixMembers>
</TablixMember>
<TablixMember>
<Group Name="Manufacturer">
<GroupExpressions>
<GroupExpression>=Fields!Manufacturer.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!Manufacturer.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!Model.Value</Value>
</SortExpression>
</SortExpressions>
<TablixHeader>
<Size>37.66017mm</Size>
<CellContents>
<Textbox Name="TV_Manufacturer">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!Manufacturer.Value</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>SkyBlue</BackgroundColor>
<VerticalAlign>Top</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember>
<Group Name="Model">
<GroupExpressions>
<GroupExpression>=Fields!Model.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!Model.Value</Value>
</SortExpression>
</SortExpressions>
<TablixHeader>
<Size>37.57083mm</Size>
<CellContents>
<Textbox Name="TV_Model">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!Model.Value</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<VerticalAlign>Top</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember>
<Group Name="Details" />
<SortExpressions>
<SortExpression>
<Value>=Fields!BIOSName.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!BIOSVersion.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!SMBIOSVersion.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!BIOSSerialNumber.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!DeviceName.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!UserName.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!OperatingSystem.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!OSVersion.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!OSBuildNumber.Value</Value>
</SortExpression>
<SortExpression>
<Value>=Fields!OSInstallDate.Value</Value>
</SortExpression>
</SortExpressions>
<TablixMembers>
<TablixMember />
</TablixMembers>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>TV_Model</ToggleItem>
</Visibility>
</TablixMember>
<TablixMember />
</TablixMembers>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>TV_Manufacturer</ToggleItem>
</Visibility>
</TablixMember>
<TablixMember>
<TablixHeader>
<Size>37.57083mm</Size>
<CellContents>
<Textbox Name="TV_Models">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Models</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#e6eefc</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#c6daf8</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
</TablixMember>
</TablixMembers>
</TablixMember>
<TablixMember>
<TablixHeader>
<Size>37.66017mm</Size>
<CellContents>
<Textbox Name="TV_Total">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Total</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Style>
<Border>
<Color>#9eb6e4</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#7292cc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember>
<TablixHeader>
<Size>37.57083mm</Size>
<CellContents>
<Textbox Name="Textbox85">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style>
<FontFamily>Segoe UI</FontFamily>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox83</rd:DefaultName>
<Style>
<Border>
<Color>#9eb6e4</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>#7292cc</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
</TablixMember>
</TablixMembers>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>HardwareData</DataSetName>
<Top>13.71357mm</Top>
<Left>0.9525mm</Left>
<Height>33.56732mm</Height>
<Width>448.78711mm</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
<Tablix Name="ReportDescriptionTablix">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.47018in</Width>
</TablixColumn>
<TablixColumn>
<Width>8.34071in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.4in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Report_DescriptionLabel">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString("Description", User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>9pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</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>
<TablixCell>
<CellContents>
<Textbox Name="Report_DescriptionText">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString(Fields!Description.Value, User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>9pt</FontSize>
<FontWeight>Normal</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>Report_DescriptionLabel</ToggleItem>
</Visibility>
<Style>
<Border>
<Style>None</Style>
</Border>
<PaddingLeft>5pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>ReportDescription</DataSetName>
<Top>0.03157in</Top>
<Left>0.127cm</Left>
<Height>0.4in</Height>
<Width>9.81089in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
<Line Name="ReportDescriptionLine2">
<Top>0.45796in</Top>
<Left>0.0375in</Left>
<Height>0in</Height>
<Width>17.66878in</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Color>White</Color>
<Style>Double</Style>
<Width>1.5pt</Width>
</Border>
<TopBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>1.5pt</Width>
</TopBorder>
<BottomBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>1.5pt</Width>
</BottomBorder>
<LeftBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>1.5pt</Width>
</LeftBorder>
<RightBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>1.5pt</Width>
</RightBorder>
</Style>
</Line>
</ReportItems>
<Height>4.85761cm</Height>
<Style>
<Border>
<Style>None</Style>
</Border>
<BackgroundColor>#6e7b8b</BackgroundColor>
</Style>
</Body>
<Width>45.10625cm</Width>
<Page>
<PageHeader>
<Height>2.5333cm</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Line Name="ReportDescriptionLine">
<Top>0.6007in</Top>
<Left>0.0375in</Left>
<Height>0in</Height>
<Width>17.66878in</Width>
<Style>
<Border>
<Color>White</Color>
<Style>Double</Style>
<Width>0.75pt</Width>
</Border>
<TopBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>0.75pt</Width>
</TopBorder>
<BottomBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>0.75pt</Width>
</BottomBorder>
<LeftBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>0.75pt</Width>
</LeftBorder>
<RightBorder>
<Color>White</Color>
<Style>Double</Style>
<Width>0.75pt</Width>
</RightBorder>
</Style>
</Line>
<Textbox Name="ReportName">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=SrsResources.Localization.GetString(Globals!ReportName, User!Language)</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontSize>17pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Top>1.63513cm</Top>
<Left>0.12701cm</Left>
<Height>0.89817cm</Height>
<Width>24.91965cm</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Style>
<Border>
<Style>None</Style>
</Border>
<BackgroundColor>#6e7b8b</BackgroundColor>
</Style>
</PageHeader>
<PageFooter>
<Height>0.82022cm</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Textbox Name="txtPage">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>="Page: " + Globals!PageNumber.ToString() + "of " + Globals!TotalPages.ToString()</Value>
<Style>
<FontFamily>Segoe UI</FontFamily>
<FontWeight>Bold</FontWeight>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<Top>0.03528cm</Top>
<Left>0.03175cm</Left>
<Height>0.63492cm</Height>
<Width>2.79292cm</Width>
<Style>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<Style>
<Border>
<Style>None</Style>
</Border>
<BackgroundColor>#6e7b8b</BackgroundColor>
</Style>
</PageFooter>
<PageHeight>29.7cm</PageHeight>
<PageWidth>21cm</PageWidth>
<LeftMargin>2.54cm</LeftMargin>
<RightMargin>2.54cm</RightMargin>
<TopMargin>2.54cm</TopMargin>
<BottomMargin>2.54cm</BottomMargin>
<ColumnSpacing>1.27cm</ColumnSpacing>
<Style />
</Page>
</ReportSection>
</ReportSections>
<ReportParameters>
<ReportParameter Name="UserTokenSIDs">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=SrsResources.UserIdentity.GetUserSIDs(User!UserID)</Value>
</Values>
</DefaultValue>
<Prompt>UserTokenSIDs</Prompt>
<Hidden>true</Hidden>
<cl:ComponentMetadata>
<cl:ComponentId>7b5f538e-1262-4705-a7df-7d4d398a195e</cl:ComponentId>
<cl:SourcePath>/Report Parts/UserTokenSIDs</cl:SourcePath>
<cl:SyncDate>2015-02-25T10:56:20.9331936+01:00</cl:SyncDate>
</cl:ComponentMetadata>
</ReportParameter>
<ReportParameter Name="UserSIDs">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>AdminID</DataSetName>
<ValueField>UserSIDs</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>UserSIDs</Prompt>
<Hidden>true</Hidden>
<cl:ComponentMetadata>
<cl:ComponentId>2c7b7dc1-c255-43f4-b6eb-9836f5be644e</cl:ComponentId>
<cl:SourcePath>/Report Parts/UserSIDs</cl:SourcePath>
<cl:SyncDate>2015-02-25T10:56:21.3863414+01:00</cl:SyncDate>
</cl:ComponentMetadata>
</ReportParameter>
<ReportParameter Name="CollectionID">
<DataType>String</DataType>
<Prompt>Collection</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>CollectionInfo</DataSetName>
<ValueField>CollectionID</ValueField>
<LabelField>Name</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ReportName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=Globals!ReportName</Value>
</Values>
</DefaultValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ReportDescription">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<DataSetReference>
<DataSetName>ReportDescription</DataSetName>
<ValueField>Description</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ExcludeVirtualMachines">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>YES</Value>
</Values>
</DefaultValue>
<Prompt>Exclude Virtual Machines</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>YES</Value>
<Label>Yes</Label>
</ParameterValue>
<ParameterValue>
<Value>NO</Value>
<Label>No</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
</ReportParameters>
<Language>=User!Language</Language>
<CodeModules>
<CodeModule>SrsResources, culture=neutral</CodeModule>
</CodeModules>
<rd:ReportUnitType>Cm</rd:ReportUnitType>
<rd:ReportServerUrl></rd:ReportServerUrl>
<rd:ReportID>1fab2b54-57de-49d3-aea2-75b9febeb7dc</rd:ReportID>
</Report>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment