Software License Reconciliation

Provance.ITAssetManagement.Report.SoftwareLicenseReconciliation (Report)

Element properties:

Accessibility	Public
Visible	True

Report Localization:

RN	Software License Reconciliation
*RDL*	Expand this section to see a full description of this report.
RD	The Software License Reconciliation report compares the number of software licenses for a title, against what is installed and what is assigned. Using the Estimated Unit Cost field on a software title it calculates a cost for reconciling under each circum
*RD2*	A red, negative value indicates that the title is either over licensed or under assigned. If a particular title is tracked by assignment, and not by installation, its Installed values are omitted from the report.
RG	Report Generated
A	Publisher
B	Software Title
C	(All)
D	Title
E	Version
F	Estimated Unit Cost for Title
G	Total Licenses
H	Installed
I	Difference
J	Cost
K	Assigned
N	Totals
O	Base Currency
P	No data available.
Q	Reconciling Installed vs. Licensed
R	Reconciling Assigned vs. Licensed
S	Total Cost of Reconciliation
T	Actual
U	Excluded
V	Net

Source Code:

<Report ID="Provance.ITAssetManagement.Report.SoftwareLicenseReconciliation" Accessibility="Public" Visible="true" Target="SoftwareAssetLibrary!Provance.ITAM.SoftwareTitle">

  <Dependencies>

    <Dimension>SoftwareDW!SoftwareTitleDim</Dimension>

    <Dimension>SoftwareDW!SoftwareVersionDim</Dimension>

    <Dimension>SoftwareDW!SoftwareItemDim</Dimension>

    <Dimension>HardwareDW!HardwareAssetDim</Dimension>

    <Dimension>CoreDW!SystemUserDim</Dimension>

    <Dimension>CoreDW!CompanyDim</Dimension>

    <Dimension>DWBase!ComputerDim</Dimension>

    <Dimension>SoftwareDW!SoftwareAdminSettingsDim</Dimension>

    <ReportResource>CoreReport!ReportHeaderR.png</ReportResource>

    <ReportResource>CoreReport!Exceeded.png</ReportResource>

    <ReportResource>CoreReport!Close.png</ReportResource>

    <ReportResource>CoreReport!Good.png</ReportResource>

    <ReportResource>CoreReport!Blank.png</ReportResource>

  </Dependencies>

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="3">

    <Controls>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DimensionInstancePickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="SoftwareTitleId">

            <Prompt>Provance.ServiceManager.Itam.Software.Reports!ReportParameter.AssignedSoftwareTitle.SoftwareTitle</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="IsSingleSelect">

            <Value>True</Value>

          </Property>

          <Property name="DimensionTypeName">

            <Value>SoftwareTitleDim</Value>

          </Property>

          <Property name="DimensionTypeMPName">

            <Value>Provance.ServiceManager.Itam.Software.Datawarehouse</Value>

          </Property>

          <Property name="MaxDimessionInstances">

            <Value>500</Value>

          </Property>

          <Property name="ColumnDefinitions">

            <Value>Name</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.DimensionInstancePickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="PublisherId">

            <Prompt>Provance.ServiceManager.Itam.Software.Reports!ReportParameter.AssignedSoftwareTitle.Publisher</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="IsSingleSelect">

            <Value>True</Value>

          </Property>

          <Property name="DimensionTypeName">

            <Value>CompanyDim</Value>

          </Property>

          <Property name="DimensionTypeMPName">

            <Value>Provance.ServiceManager.Itam.Core.Datawarehouse</Value>

          </Property>

          <Property name="MaxDimessionInstances">

            <Value>500</Value>

          </Property>

          <Property name="ColumnDefinitions">

            <Value>Name</Value>

          </Property>

        </Properties>

      </Control>

    </Controls>

  </ParameterBlock>

  <ReportDefinition>Provance.ITAssetManagement.Report.SoftwareLicenseReconciliation.ReportRdl</ReportDefinition>

  <ReportStrings>

    <ReportString ID="RN"/>

    <!--ReportName-->

    <ReportString ID="RDL"/>

    <!--ReportDescriptionLabel-->

    <ReportString ID="RD"/>

    <!--ReportDescription-->

    <ReportString ID="RD2"/>

    <!--ReportDescription (2nd half)-->

    <ReportString ID="RG"/>

    <!--ReportGeneratedLabel-->

    <ReportString ID="A"/>

    <!--Publisher-->

    <ReportString ID="B"/>

    <!--SoftwareTitle-->

    <ReportString ID="C"/>

    <!--AllParameter-->

    <ReportString ID="D"/>

    <!--Title-->

    <ReportString ID="E"/>

    <!--Version-->

    <ReportString ID="F"/>

    <!--Pricing-->

    <ReportString ID="G"/>

    <!--Licensed-->

    <ReportString ID="H"/>

    <!--Installed-->

    <ReportString ID="I"/>

    <!--InstalledDifference-->

    <ReportString ID="J"/>

    <!--InstalledTotal-->

    <ReportString ID="K"/>

    <!--Assigned-->

    <!--<ReportString ID="L" /> AssignedDifference-->

    <!--<ReportString ID="M" /> AssignedTotal-->

    <ReportString ID="N"/>

    <!--Totals-->

    <ReportString ID="O"/>

    <!--BaseCurrency-->

    <ReportString ID="P"/>

    <!--NoDataAvailable-->

    <ReportString ID="Q"/>

    <!--Reconciling Installed vs. Licensed-->

    <ReportString ID="R"/>

    <!--Reconciling Assigned vs. Licensed-->

    <ReportString ID="S"/>

    <!--Total Cost of Reconciliation-->

    <ReportString ID="T"/>

    <!--ActualInstalledQuantity-->

    <ReportString ID="U"/>

    <!--ExcludedInstalledQuantity-->

    <ReportString ID="V"/>

    <!--NetInstalledQuantity-->

  </ReportStrings>

</Report>