Reporting on Veeam nworks CI’s using the Service Manager data warehouse.

Cameron Fuller did a great job of documenting the process of pulling in Veeam nworks CI’s from Operations Manager here.

One additional step that is required for reporting is to author a management pack that will create views in the Service Manager data warehouse, where you should be doing your reporting.

I have written a management pack that you can import into Service Manager that will create 4 views, one each for VMhosts, VMguests, VMclusters and VM Datastores.

Please feel free to change the management pack name and be sure to seal it before importing into Service Manager. There are no relationship facts yet. I do plan to add those later as I have time.

 

<ManagementPack ContentReadable=”true” SchemaVersion=”2.0″ OriginalSchemaVersion=”1.1″ xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsl=”http://www.w3.org/1999/XSL/Transform”>

  <Manifest>

    <Identity>

      <ID>EPEnergy.nworks.VMware.VEM.Datawarehouse</ID>

      <Version>1.0.0.0</Version>

    </Identity>

    <Name>EP Energy nworks VMware VEM Datawarehouse</Name>

    <References>

      <Reference Alias=”System”>

        <ID>System.Library</ID>

        <Version>7.5.8501.0</Version>

        <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>

      </Reference>

      <Reference Alias=”SystemHW”>

        <ID>System.Hardware.Library</ID>

        <Version>7.0.8427.0</Version>

        <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>

      </Reference>

      <Reference Alias=”Windows”>

        <ID>Microsoft.Windows.Library</ID>

        <Version>7.5.8501.0</Version>

        <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>

      </Reference>

                                <Reference Alias=”DWBase”>

                                                <ID>Microsoft.SystemCenter.Datawarehouse.Base</ID>

                                                <Version>7.5.1561.0</Version>

                                                <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>

       </Reference>

      <Reference Alias=”InstanceGroup”>

        <ID>Microsoft.SystemCenter.InstanceGroup.Library</ID>

        <Version>7.5.8501.0</Version>

        <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>

      </Reference>

                  <Reference Alias=”VEM”>

        <ID>nworks.VMware.VEM</ID>

        <Version>5.7.0.1054</Version>

        <PublicKeyToken>65c40f14a98ce59b</PublicKeyToken>

      </Reference>

    </References>

  </Manifest>

<Warehouse>

    <Dimensions>

                                <Dimension ID=”VMGUESTComputerDim” Accessibility=”Public” InferredDimension=”true” Target=”VEM!nworks.VMware.VEM.VMGUEST” HierarchySupport=”IncludeExtendedClassProperties” Reconcile=”true” />

                    <Dimension ID=”VMHOSTComputerDim” Accessibility=”Public” InferredDimension=”true” Target=”VEM!nworks.VMware.VEM.VMHOST” HierarchySupport=”IncludeExtendedClassProperties” Reconcile=”true” />

                                <Dimension ID=”VMCLUSTERDim” Accessibility=”Public” InferredDimension=”true” Target=”VEM!nworks.VMware.VEM.VMCCR” HierarchySupport=”IncludeExtendedClassProperties” Reconcile=”true” />

                                <Dimension ID=”VMHOSTDATASTOREDim” Accessibility=”Public” InferredDimension=”true” Target=”VEM!nworks.VMware.VEM.VMHOSTDATASTORE” HierarchySupport=”IncludeExtendedClassProperties” Reconcile=”true” />                       

                </Dimensions>

</Warehouse>

<LanguagePacks>

    <LanguagePack ID=”ENU” IsDefault=”true”>

        <DisplayStrings>

            <DisplayString ElementID=”EPEnergy.nworks.VMware.VEM.Datawarehouse”>

                <Name>EP Energy nworks VMware Datawarehouse Management Pack</Name>

            </DisplayString>

        </DisplayStrings>

    </LanguagePack>

</LanguagePacks>

</ManagementPack>

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.