Was this helpful? Share It!
  • System Center: Virtual Machine Manager Engineering Team Blog

    Update Rollup 2 for System Center Virtual Machine Manager 2008 R2 Service Pack 1 now available

    • 0 Comments

    KBThis article describes the installation instructions for Update Rollup 2 for Microsoft System Center Virtual Machine Manager 2008 R2 Service Pack 1 (SP1) and the issues that are fixed in this update rollup.

    Update Rollup 2 for System Center Virtual Machine Manager 2008 R2 SP1 consists of two update packages. Follow the installation instructions to install the updates for the Virtual Machine Manager (VMM) server and Self-Service Portal.

    Issues that are fixed in Update Rollup 2
    Virtual Machine Manager server update (KB2691812)
    The VMM service leaks memory when you manage a Windows Server 2008 R2 Hyper-V cluster that has HP Cluster Extension Software (CLX) installed.
    This update package also includes the fixes that are documented in the following article in the Microsoft Knowledge Base:

    2562466 (http://support.microsoft.com/kb/2562466/ ) Description of the System Center Virtual Machine Manager 2008 R2 SP1 hotfix rollup package: July 12, 2011

    Virtual Machine Manager Self-Service Portal update (KB2701207)

    The Self-Service Portal may not always display all virtual machines if the self-service user has more than 50 virtual machines assigned to them.

    For all the details and a download link please see the following:

    2691812 - Description of the Update Rollup 2 for System Center Virtual Machine Manager 2008 R2 Service Pack 1

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    KB: Placing a highly available virtual machine on an ESXi Cluster in System Center 2012 Virtual Machine Manager fails

    • 0 Comments

    imageHere’s a new Knowledge Base article we published. This one talks about an issue where placing a highly available virtual machine on an ESXi Cluster in System Center 2012 Virtual Machine Manager fails.

    =====

    Symptoms

    When trying to place a highly available virtual machine on an ESXi 4.0 cluster managed by System Center 2012 Virtual Machine Manager, the Virtual Machine Manager placement engine blocks the placement with the following error:

    The virtual machine <name of the VM> is configured as highly available but the selected host in not highly available.

    Cause

    This will occur if the VMware cluster is configured as non-highly available in the VMware vCenter server. You can verify this using the steps below:
    1. Open vSphere client
    2. Right-click on the cluster
    3. Click Edit Settings
    4. Click Cluster Features. There, the option "Turn ON VMware HA" is not selected

    Resolution

    To resolve this issue complete the steps below:
    1. Open vSphere client
    2. Right-click on the cluster
    3. Click Edit Settings
    4. Click Cluster Features
    5. Select the option "Turn ON VMware HA"
    6. Refresh the ESXi cluster in the System Center 2012 Virtual Machine Manager console.

    More Information

    For more information see the follow:

    http://kb.vmware.com/kb/1008025

    =====

    For the most current version of this article please see the following:

    2712454 - Placing a highly available virtual machine on an ESXi Cluster in System Center 2012 Virtual Machine Manager fails

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    KB: Regional settings default to English when deploying a virtual machine using a template on System Center 2012 Virtual Machine Manager

    • 0 Comments

    imageHere’s a new Knowledge Base article we published. This one talks about an issue where Regional settings default to English when deploying a virtual machine using a template on System Center 2012 Virtual Machine Manager.

    =====

    Symptoms

    Consider the following scenario:
    · A virtual machine is configured to use regional settings other than en-US (example: ja-JP or fr-FR)
    · A VM template is created from this virtual machine using System Center Virtual Machine Manager 2012.
    · Virtual machines that are created using this template are configured to use the en-US regional settings.

    Cause

    Deploying virtual machines using a template in System Center Virtual Machine Manager 2012 will override the guest OS language setting with en-US by default.

    Resolution

    To work around this issue, perform the following steps:
    1. Launch the VMM Console.
    2. Click on Settings option.
    3. Click on PowerShell and execute the below commands on respective Template.
    4. $template = Get-SCVMtemplate | where {$_.Name -eq "Template_Name"}
    5. $settings = $template.UnattendSettings;
    6. $settings.add("oobeSystem/Microsoft-Windows-International-Core/UserLocale","cy-GB");
    7. $settings.add("oobeSystem/Microsoft-Windows-International-Core/SystemLocale","cy-GB");
    8. $settings.add("oobeSystem/Microsoft-Windows-International-Core/UILanguage","cy-GB");
    9. $settings.add("oobeSystem/Microsoft-Windows-International-Core/InputLocale","0452:00000452");
    10. Set-SCVMTemplate -VMTemplate $template -UnattendSettings $settings

    NOTE For Steps 6-9, the regional settings will vary based on the language. Please refer to the following sites for the regional settings that should be used for each language:

    Language Pack Default Values
    http://technet.microsoft.com/en-us/library/cc766191(v=ws.10).aspx

    Default Input Locales
    http://technet.microsoft.com/en-us/library/cc766503(v=ws.10).aspx

    More Information

    Scripts used during MMS 2012 PowerShell session:
    http://blogs.technet.com/b/hectorl/archive/2012/04/16/fi-b322-scripts-used-during-mms-2012-powershell-session.aspx

    =====

    For the most current version of this article please see the following:

    2709539 - Regional settings default to English when deploying a virtual machine using a template on System Center 2012 Virtual Machine Manager

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    KB: The System Center 2012 Virtual Machine Manager console terminates unexpectedly with NullReferenceException

    • 0 Comments

    imageHere’s a new Knowledge Base article we published. This one talks about an issue where the SCVMM 2012 console terminates with NullReferenceException after adding an ESX 4.1 host.

    =====

    Symptoms

    After adding an ESX 4.1 host to System Center 2012 Virtual Machine Manager (VMM) fabric, the VMM console may terminate unexpectedly.
    In reviewing the application log you find the following event:

    Log Name: Application
    Source: Windows Error Reporting
    Event ID: 1001
    Task Category: None
    Level: Information
    Keywords: Classic
    User: N/A
    Description:
    Fault bucket , type 0
    Event Name: VMM20
    Response: Not available
    Cab Id: 0

    Problem signature:
    P1: vmmservice
    P2: 3.0.6019.0
    P3: E.Adhc.Operations
    P4: 3.0.6019.0
    P5: M.V.E.A.VMWareESXHostDataProperties.GetHostManagementPorts
    P6: System.NullReferenceException
    P7: 6b59
    P8:
    P9:
    P10:

    or

    Log Name: Application
    Source: Windows Error Reporting
    Event ID: 1001
    Task Category: None
    Level: Information
    Keywords: Classic
    User: N/A
    Description:
    Fault bucket , type 0
    Event Name: VMM20
    Response: Not available
    Cab Id: 0

    Problem signature:
    P1: vmmservice
    P2: 3.0.6019.0
    P3: VMWareImplementation
    P4: 3.0.6005.0
    P5: M.C.V.VmwVMService.PopulateDistributedNetworkingData
    P6: System.NullReferenceException
    P7: 3b81
    P8:
    P9:
    P10:

    NOTE To ensure you are encountering the issue discussed here, verify that the values shown in the Windows Error report log have the same values for P5 and P6 as seen in one of the above examples

    Cause

    This is a known issue in System Center 2012 Virtual Machine Manager. The issue is related to the absence of a standard VMware virtual switch (vSwitch) on the VMware hosts. The VMM refresher fails to handle such a configuration.

    Resolution

    To verify the problem host perform the following steps:

    Open vSphere Client
    - Open Hosts and Clusters
    - Select Host, Go to Configuration tab
    - Select Networking, you should see no vSphere Standard Switches.

    To workaround this issue, create a vSwitch on each failing host using the VMware management tools such as vSphere client.

    =====

    For the most current version of this article please see the following:

    2709961 - The System Center 2012 Virtual Machine Manager console terminates unexpectedly with NullReferenceException

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    Upcoming Webcast Series: Bare Metal to Private Cloud

    • 0 Comments

    I’ve been spending quite a bit of time with customers over the last 6-12 months helping them plan out and deploy their first private clouds managed by System Center 2012.  To help people get started faster I headed into the Enterprise Engineering Center (EEC) on the Redmond campus, arranged for some really nice hardware, and set up a System Center managed private cloud from bare metal all the way up.  All along the way I recorded everything I did.  In this 8 part webcast series I will show you some of the best practices and process for getting start with your System Center 2012 managed private cloud.  We will deploy a Hyper-V host cluster, Virtual Machine Manager, Operations Manager, Service Manager, Orchestrator, the Cloud Service Process Management Pack, integrate them all together and do so in a high performance and high availability configuration.

    The web cast series starts next week and will be every Tuesday and Thursday at 11:00 AM Redmond time from May 29th through June 28th.  We will take the week of TechEd North America off.  All of the web casts will be available on demand after the initial showing.

    Please register for the sessions, add them to your calendar, and join me over the next few weeks as we go from Bare Metal to Private Cloud!

    -Travis

     

    5/29/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 1 of 8): Beginning with the End in Mind

    http://go.microsoft.com/?linkid=9809577  or  http://bit.ly/JTGtJK

    Abstract:

    In this session, we take a look at the end state of managing a private cloud with Microsoft System Center, including the Cloud Services management pack. The sessions that follow this session describe how to go from bare metal to a private cloud managed by System Center.
    _____________

    5/31/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 2 of 8): Hardware and Prerequisite Software Platform

    http://go.microsoft.com/?linkid=9809578  or  http://bit.ly/KJc41E

    Abstract:

    In this session, we take a look at the hardware used for these sessions as examples of the kind of hardware that you can use to run a private cloud. We’ll also discuss how to install and configure the prerequisite software, such as the Windows Server operating system, SQL Server data management software, and Active Directory Domain Services.
    _____________

    6/5/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 3 of 8): Clustering Hyper-V and Installing a Highly Available Virtual Machine Manager Cluster

    http://go.microsoft.com/?linkid=9809579  or http://bit.ly/KvgVAM

    Abstract:

    In this session, we take a look at how to create a Hyper-V host cluster and install a highly available cluster by using Virtual Machine Manager, a component of Microsoft System Center 2012.

    _____________

    6/7/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 4 of 8): Configuring System Center 2012 - Virtual Machine Manager

    http://go.microsoft.com/?linkid=9809580   or  http://bit.ly/KlsCYU

    Abstract:

    In this session, we talk about how to configure Virtual Machine Manager, a component of Microsoft System Center 2012. We explore how to deploy agents, create a host group, create a cloud, and create virtual networks.

    _____________

    6/19/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 5 of 8): Installing and Configuring System Center 2012 - Operations Manager

    http://go.microsoft.com/?linkid=9809581  or http://bit.ly/J2WDgE

    Abstract:

    In this session, we show how to install a highly available Microsoft System Center 2012 - Operations Manager and deploy agents to manage the private cloud.

    _____________

    6/21/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 6 of 8): Installing and Configuring System Center 2012 - Service Manager

    http://go.microsoft.com/?linkid=9809582   or http://bit.ly/Ms8GtP

    Abstract: 

    In this session, we show how to install a highly available Microsoft System Center 2012 Service Manager, including the configuration management database (CMDB), data warehouse, reporting, self-service portal, and service catalog.

    _____________

    6/26/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 7 of 8): Installing and Configuring System Center 2012 - Orchestrator

    http://go.microsoft.com/?linkid=9809583  or http://bit.ly/JXQgPA

    Abstract:

    In this session, we show how to install a highly available Microsoft System Center 2012 - Orchestrator and installing the System Center and other integration packs for automated administration of the private cloud.

    _____________

    6/28/2012 11:00:00 AM - Bare Metal to Private Cloud (Part 8 of 8): Integrating System Center 2012

    http://go.microsoft.com/?linkid=9809584  or http://bit.ly/JcGHxd

    Abstract:

    In this session, we configure the many integration points between the Microsoft System Center components and also between System Center and Active Directory Domain Services.

  • System Center: Virtual Machine Manager Engineering Team Blog

    KB: Deploying templates to create new VMs using System Center Virtual Machine Manager fails with Error 13204

    • 0 Comments

    imageHere’s a new Knowledge Base article we published this morning. This one describes an issue where deploying templates to create new VMs using System Center Virtual Machine Manager fails with Error 13204.

    =====

    Symptoms

    When deploying templates to create new virtual machines (VMs) using System Center Virtual Machine Manager 2008 (VMM), you may receive the following error in the VMM Admin Console:

    Error 13204
    Boot Configuration Data (BCD) WMI provider is not installed on the Virtual Machine Manager Server.
    Install the BCD WMI provider on %ServerName; and then try the operation again.

    You also notice that the deployment of VMs fails for all hosts and that the failure also happens for most other templates.
    A VMM Trace will show results similar to:

    00025010 11:18:35 AM [6008] at Microsoft.Carmine.WSManWrappers.ErrorContextParameterHelper.ThrowTranslatedCarmineException(ManagementException me)
    00025011 11:18:35 AM [6008] at Microsoft.Carmine.WMIWrappers.WMIObject.GetMethodParameters(String methodName)
    00025012 11:18:35 AM [6008] at Microsoft.Carmine.WMIWrappers.BcdStore.OpenStore(ManagementScope mgmtScope, String File, BcdStore& Store)
    00025013 11:18:35 AM [6008] at Microsoft.VirtualManager.Engine.VmOperations.BCD.Store..ctor(WSManConnectionParameters connParams, String storePath)
    00025014 11:18:35 AM [6008] *** Carmine error was: HostAgentWMIFail (3154); HR: 0x80131501
    00025015 11:18:35 AM [6008] 1778.0994::02/04-19:18:35.468#16:BcdUtil.cs(1248):
    00025016 11:18:35 AM [6008] 1778.0994::02/04-19:18:35.468#16:BcdUtil.cs(1248): Microsoft.VirtualManager.Engine.VmOperations.BCD.BCDWmiProviderNotInstalledException: Error in the application.
    00025017 11:18:35 AM [6008] at Microsoft.VirtualManager.Engine.VmOperations.BCD.Store.HandleEx(WSManProviderException wpe)
    00025018 11:18:35 AM [6008] at Microsoft.VirtualManager.Engine.VmOperations.BCD.Store..ctor(WSManConnectionParameters connParams, String storePath)
    00025019 11:18:35 AM [6008] at Microsoft.VirtualManager.Engine.VmOperations.BCD.BCDFixup.ReadBootManager()
    00025020 11:18:35 AM [6008] at Microsoft.VirtualManager.Engine.VmOperations.BCD.BCDFixup..ctor(String bcdFileDir, String bcdFileName, WSManConnectionParameters tgtConnectionParameters, String tgtDevice, UpdateDeploymentCheckpointDelegate checkpointDelegate)
    00025021 11:18:35 AM [6008] *** Carmine error was: BcdWmiProviderNotInstalled (13204); 0

    Cause

    This can occur if there is WMI corruption on the VMM server. Examining the local WMI Control properties displays the following:


    · Win32_processor: WMI: Invalid namespace
    · Win32_WMISetting: WMI: Invalid namespace
    · Win32_OperatingSystem: WMI: Invalid namespace

    Resolution

    To resolve this issue, rebuild WMI on the VMM server.

    Below are the steps to fix the issue on Windows Server 2008:

    1. Open an elevated command prompt.
    2. Verify the WMI repository is not corrupt by running the following command:

    winmgmt /verifyrepository

    If the repository is not corrupted, a “WMI Repository is consistent” message will be returned. If you get something else, go to step 3. If the repository is consistent, perform a repair.

    3. Run the following commands to repair WMI:

    winmgmt /salvagerepository

    If the repository salvage fails to work, then run the following command to see if it resolves the issue:

    winmgmt /resetrepository

    After the last command, there should be a “WMI Repository has been reset” message returned that verifies the command was successful.


    Below are the steps to fix the issue on Windows Server 2003:

    1. Stop WMI service
    2. From an elevated command prompt run the following:

    cd %windir%\system32\wbem

    3. Re-register dlls by running the following command:

    for /f %s in ('dir /b *.dll') do regsvr32 /s %s

    4. Re-register provider host by running the following command:

    wmiprvse /regserver

    5. Re-register WMI service by running the following command:
    winmgmt /regserver

    6. Restart the WMI service
    7. Recompile the mofs by running the following command:

    for /f %s in ('dir /b *.mof *.mfl') do mofcomp %s

    8. Restart the WMI service
    9. Restart the VMM server

    =====

    For the most current version of this article please see the following:

    2708922 - Deploying templates to create new VMs using System Center Virtual Machine Manager fails with Error 13204

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    KB: Viewing a service on System Center 2012 App Controller as a self-service user may fail with a “Retrieved data is incomplete” warning

    • 0 Comments

    imageHere’s a new Knowledge Base article we published. This one describes an App Controller issue where viewing a service fails with “Retrieved data is incomplete”.

    =====

    Symptoms

    On System Center 2012 App Controller, a self-service user is unable to view a service that includes a computer tier with a load balancer. When the user attempts to view the service in App Controller, they receive a “Retrieved data is incomplete” warning. Viewing the details of the warning displays the following message:

    Category: Warning
    Message: Retrieved data is incomplete.
    Details: Category: Critical
    Message: Microsoft.SystemCenter.CloudManager.Providers.ProviderException
    Description: An unexpected error from VMM was encountered while processing the request.
    Details: Category: Critical
    Message: 11418–ObjectsInaccessible
    Description: You do not have permission to access one or more of the objects required by this operation.
    Web error status: UnknownError
    Web response description: Internal Server Error
    Web response status code: InternalServerError

    Cause

    This is a known issue in System Center 2012 App Controller.

    Resolution

    To work around this issue, perform one of the following steps:

    · To view the service in App Controller, logon to App Controller using an account that’s a member of the Administrators role.

    Or

    · To view the service as a self-service user, use the VMM console.

    =====

    For the most current version of this article please see the following:

    2709415 - Viewing a service on System Center 2012 App Controller as a self-service user may fail with a “Retrieved data is incomplete” warning

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    KB: How to reinstall the System Center 2012 Virtual Machine Manager agent on a host with services deployed

    • 0 Comments

    imageHere’s a new Knowledge Base article we published. This one describes an event you may see when deleting a Favorite in AVIcode or System Center 2012 Operations Manager.

    =====

    Symptoms

    Scenario: A Hyper-V host is managed by System Center 2012 Virtual Machine Manager (VMM) and it is hosting service templates. You want to reinstall the VMM agent on the host.

    If you remove the host from VMM it will retain the VM information but all service template information will be lost. This will prevent any updates to service templates as well as scale out actions.

    Cause

    This is a known issue in System Center 2012 Virtual Machine Manager. Removing a host from a VMM console causes all service template information to be removed for that host.

    Resolution

    Logon directly on to the host where you want to reinstall the agent. Remove the agent and reinstall it manually using the latest agent files. On the VMM server, perform an add host action and select re-associate. This will re-register the host in VMM and the service templates will be restored.

    =====

    For the most current version of this article please see the following:

    2705504 - How to reinstall the System Center 2012 Virtual Machine Manager agent on a host with services deployed

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    KB: P2V fails with GPT partitions in System Center Virtual Machine Manager

    • 0 Comments

    imageHere’s a new Knowledge Base article we published. This one discusses how VMM does not support GPT disks on P2V targets and that to successfully migrate a machine with a GPT disk, you must first convert the disk to MBR format.

    =====

    Symptoms

    A physical to virtual conversion (P2V) may fail in Microsoft System Center Virtual Machine Manager 2008 R2 (VMM) if the source machine contains a GUID Partition Table (GPT) formatted disk. In this scenario, the conversion fails with an error similar to the following:

    Log Name: System
    Source: Service Control Manager
    Event ID: 7031
    Task Category: None
    Level: Error
    Keywords: Classic
    Description:
    The Virtual Machine Manager P2V Agent service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: Restart the service.

    Log Name: Application
    Source: Application Error
    Event ID: 1000
    Task Category: (100)
    Level: Error
    Keywords: Classic
    Description:
    Faulting application name: vmmP2VAgent.exe, version: 2.0.4271.0, time stamp: 0x4a7a0b17
    Faulting module name: vmmP2VAgent.exe, version: 2.0.4271.0, time stamp: 0x4a7a0b17
    Exception code: 0xc000000d
    Fault offset: 0x0000000000038e45
    Faulting process id: 0x6ec
    Faulting application start time: 0x01cbbcc8d4befeb6
    Faulting application path: C:\Program Files\Microsoft System Center Virtual Machine Manager 2008 P2V Agent\bin\vmmP2VAgent.exe
    Faulting module path: C:\Program Files\Microsoft System Center Virtual Machine Manager 2008 P2V Agent\bin\vmmP2VAgent.exe
    Report Id: 1272adba-28bc-11e0-89a1-e41f136885b0

    A VMM trace will show patterns similar to the following:

    Variation 1:

    3488 00003486 120.73740387 [4608] 1200.1610::01/28-18:29:10.912:WsmanAPIWrapper.cs(1415): WSMAN: URL: [http://servername:80] Verb: [INVOKE], method: [GetLUNIDFromFSPath], resource: [http://schemas.microsoft.com/wbem/wsman/1/wmi/root/scvmmaccelerator/VirtualizationSANAccelerator]
    3489 00003487 120.73745728 [4608] 1200.1610::01/28-18:29:10.912:WsmanAPIWrapper.cs(544): HostSessionCache: elements for [S-1-5-18-servername]: [100]
    3490 00003488 120.73786926 [4608] 1200.1610::01/28-18:29:10.912:WsmanAPIWrapper.cs(593): WsmanAPIWrapper::CreateSession: going to use custom timeout for wsman operations: 300 secs.
    3491 00003489 120.84464264 [4608] 1200.1610::01/28-18:29:11.021:BitDeploymentSubtask.cs(771): MapSANWMIErrorCodeToCarmineError: Return value from agent CARMINE_SAN_WMI_NO_UNIQUE_LUN_IDENTIFIER, Mapped carmine error code DeployVMNoUniqueID
    3492 00003490 120.84486389 [4608] 1200.1610::01/28-18:29:11.021:HostProperties.cs(521): Found Disk: UniqueID:0, Name:\\.\PHYSICALDRIVE4, Capacity:624438581760
    3493 00003491 120.84495544 [4608] 1200.1610::01/28-18:29:11.021:WsmanAPIWrapper.cs(1415): WSMAN: URL: [http://servername:80] Verb: [INVOKE], method: [GetLUNIDFromFSPath], resource: [http://schemas.microsoft.com/wbem/wsman/1/wmi/root/scvmmaccelerator/VirtualizationSANAccelerator]
    3494 00003492 120.84500885 [4608] 1200.1610::01/28-18:29:11.021:WsmanAPIWrapper.cs(544): HostSessionCache: elements for [S-1-5-18-servername]: [100]
    3495 00003493 120.84546661 [4608] 1200.1610::01/28-18:29:11.021:WsmanAPIWrapper.cs(593): WsmanAPIWrapper::CreateSession: going to use custom timeout for wsman operations: 300 secs.
    3496 00003494 120.96246338 [4608] 1200.1610::01/28-18:29:11.146:BitDeploymentSubtask.cs(771): MapSANWMIErrorCodeToCarmineError: Return value from agent CARMINE_SAN_WMI_NO_UNIQUE_LUN_IDENTIFIER, Mapped carmine error code DeployVMNoUniqueID
    3497 00003495 120.96269989 [4608] 1200.1610::01/28-18:29:11.146:HostProperties.cs(521): Found Disk: UniqueID:0, Name:\\.\PHYSICALDRIVE5, Capacity:624438581760
    3498 00003496 120.96279144 [4608] 1200.1610::01/28-18:29:11.146:WsmanAPIWrapper.cs(1415): WSMAN: URL: [http://servername:80] Verb: [INVOKE], method: [GetLUNIDFromFSPath], resource: [http://schemas.microsoft.com/wbem/wsman/1/wmi/root/scvmmaccelerator/VirtualizationSANAccelerator]
    3499 00003497 120.96284485 [4608] 1200.1610::01/28-18:29:11.146:WsmanAPIWrapper.cs(544): HostSessionCache: elements for [S-1-5-18-servername]: [100]
    3500 00003498 120.96331024 [4608] 1200.1610::01/28-18:29:11.146:WsmanAPIWrapper.cs(593): WsmanAPIWrapper::CreateSession: going to use custom timeout for wsman operations: 300 secs.
    3501 00003499 121.08226776 [4608] 1200.1610::01/28-18:29:11.271:BitDeploymentSubtask.cs(771): MapSANWMIErrorCodeToCarmineError: Return value from agent CARMINE_SAN_WMI_NO_UNIQUE_LUN_IDENTIFIER, Mapped carmine error code DeployVMNoUniqueID
    3502 00003500 121.08245850 [4608] 1200.1610::01/28-18:29:11.271:HostProperties.cs(521): Found Disk: UniqueID:0, Name:\\.\PHYSICALDRIVE6, Capacity:624455032320
    3503 00003501 121.08254242 [4608] 1200.1610::01/28-18:29:11.271:WsmanAPIWrapper.cs(1415): WSMAN: URL: [http://servername:80] Verb: [INVOKE], method: [GetLUNIDFromFSPath], resource: [http://schemas.microsoft.com/wbem/wsman/1/wmi/root/scvmmaccelerator/VirtualizationSANAccelerator]
    3504 00003502 121.08259583 [4608] 1200.1610::01/28-18:29:11.271:WsmanAPIWrapper.cs(544): HostSessionCache: elements for [S-1-5-18-servername]: [100]
    3505 00003503 121.08300781 [4608] 1200.1610::01/28-18:29:11.271:WsmanAPIWrapper.cs(593): WsmanAPIWrapper::CreateSession: going to use custom timeout for wsman operations: 300 secs.
    3506 00003504 121.23886871 [4608] 1200.1610::01/28-18:29:11.427:BitDeploymentSubtask.cs(771): MapSANWMIErrorCodeToCarmineError: Return value from agent CARMINE_SAN_WMI_NO_UNIQUE_LUN_IDENTIFIER, Mapped carmine error code DeployVMNoUniqueID

    Variation 2:

    00000724 6.41339493 [3268] 0CC4.0378::07/27-03:32:02.851:DifferencingDisksRefresher.cs(630): Virtual disk for VM VMNAME:0041902D-E883-4189-8EFB-B0FE3E050FB1 is on a network path \\servername\share\New Virtual Hard Disk.vhd. We will mark it as unsupported
    00000725 6.41355848 [3268] 0CC4.0378::07/27-03:32:02.851:VmRefresher.cs(4832): VM VMNAME has an invalid bus specification or bad path or path that we cannot access and will be marked unsupported
    00000726 6.41393661 [3268] 0CC4.0378::07/27-03:32:02.851:VmRefresher.cs(4832): Microsoft.VirtualManager.Utils.CarmineException: The specified path \\servername\share\New Virtual Hard Disk.vhd is not valid on the servername server.
    00000727 6.41393661 [3268] Ensure that you have specified a valid path, and then try the operation again.
    00000728 6.41393661 [3268] at Microsoft.VirtualManager.Engine.Backup.DifferencingDisksRefresher.GetDifferencingDisksHierarchyFromVMService(WSManConnectionParameters hostConnectionParameters, Boolean allowPartialObjects)
    00000729 6.41393661 [3268] at Microsoft.VirtualManager.Engine.Backup.DifferencingDisksRefresher.GenerateDiskHierarchy(WSManConnectionParameters hostConnnectionParameters, Boolean allowPartialObjects, UInt32& errorCode)
    00000730 6.41393661 [3268] at Microsoft.VirtualManager.Engine.BitBos.VMRefresherBase.UpdateDisks(IVMComputerSystem vmComputer)
    00000731 6.41393661 [3268] *** Carmine error was: HostAgentBadPathname (2906); 0

    On the client, you may see a VMM trace with errors like the following :

    0639 00000637 28.49589729 [2800] 0AF0.0A00::03/09-21:15:59.638:HostProperties.cs(523): Found Disk: UniqueID:0, Name:\\.\PHYSICALDRIVE4, Capacity:2937995988480
    0640 00000638 28.49621391 [2800] 0AF0.0A00::03/09-21:15:59.638:WsmanAPIWrapper.cs(1415): WSMAN: URL: [http://machinename:80] Verb: [INVOKE], method: [GetLUNIDFromFSPath], resource: [http://schemas.microsoft.com/wbem/wsman/1/wmi/root/scvmmaccelerator/VirtualizationSANAccelerator]
    0641 00000639 28.49632645 [2800] 0AF0.0A00::03/09-21:15:59.638:WsmanAPIWrapper.cs(544): HostSessionCache: elements for [S-1-5-21-72034930-1147432956-5522801-23474-.]: [100]
    0642 00000640 28.49638367 [2800] 0AF0.0A00::03/09-21:15:59.638:WsmanAPIWrapper.cs(593): WsmanAPIWrapper::CreateSession: going to use custom timeout for wsman operations: 300 secs.
    0646 00000644 28.64711952 [2800] 0AF0.0A00::03/09-21:15:59.841:BitDeploymentSubtask.cs(771): MapSANWMIErrorCodeToCarmineError: Return value from agent CARMINE_SAN_WMI_NO_UNIQUE_LUN_IDENTIFIER, Mapped carmine error code DeployVMNoUniqueID

    280 00000278 22.32052803 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(2482): <--CDisk::FindDisk
    281 00000279 22.32100105 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(1687)[00000000001A98: Disk pnp id \\?\mpio.disk&ven_hp&prod_p2000_g3_sas&rev_t200.1&7f6ac24&0&3630434646303031304537454642414237344431303030.{53f56307-b6bf-11d0-94f2-00a0c91efb8b}
    282 00000280 22.32103920 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(1689)[00000000001A98: Disk address Port3Path0Target3Lun4
    283 00000281 22.32107353 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(1691)[00000000001A98: Disk name \\?\PhysicalDrive4
    284 00000282 22.32113457 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(2263): ==>LunIdentifier::FindLunUniqueID
    285 00000283 22.32162285 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(2263): <--LunIdentifier::FindLunUniqueID
    286 00000284 22.32165909 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(1733)[00000000001A98: LUN has no unique storage identifier
    287 00000285 22.32180595 [6536] 1988.1658::03/09-21:16:11.349:sanacceleratorminiprovider.cpp(1740)[00000000001A98: GetLUNIDFromFSPath: Caught exception. Returning error code 9

    Cause

    This behavior is by design. VMM does not support GPT disks on P2V targets. To successfully migrate a machine with a GPT disk, you must first convert the disk to MBR format.

    Resolution

    To allow conversion of machines with GPT partitions, you must first convert the partition to MBR. There are two workarounds that may be used:

    Option 1: Back up data on the physical machine

    1. Back up existing data using your existing backup solution.
    2. Delete any existing partitions on the disk(s)
    3. Right-click on the disk and choose Convert to MBR.
    4. Restore your data using your backup solution
    5. Restart the computer and retry the P2V operation.

    Option 2:

    1. Use the Disk2VHD tool from http://live.sysinternals.com/disk2vhd.exe to convert the partition(s) to VHD files.
    2. Create a new VM and attach the VM from step 1 to the VHD.
    3. Boot the operating system from the OS installation media, and use the appropriate repair steps to make the disk bootable:

    Windows XP and Windows Server 2003:

    KB321626 - "Operating System Not Found" or "Missing operating system" error message when you start your Windows XP-based computer (http://support.microsoft.com/default.aspx?scid=kb;EN-US;321626)

    Windows 7 and Windows Server 2008:

    KB927392 - How to use the Bootrec.exe tool in the Windows Recovery Environment to troubleshoot and repair startup issues in Windows (http://support.microsoft.com/kb/927392/en-us)

    More Information

    You can verify the partition type on the target machine by inspecting the disk configuration in Disk Management (diskmgmt.msc). See 'P2V: Requirements for Physical Source Computers' at http://technet.microsoft.com/en-us/library/cc917954.aspx for more information. GPT requires an EFI or UEFI BIOS to boot; Hyper-V does not have either EFI or UEFI BIOS support.

    =====

    For the most current version of this article please see the following:

    2705349 - P2V fails with GPT partitions in System Center Virtual Machine Manager

    J.C. Hornbeck | System Center & Security Knowledge Engineer

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

  • System Center: Virtual Machine Manager Engineering Team Blog

    Reporting in System Center 2012 Virtual Machine Manager (Part 2 of 3)

    • 0 Comments

    eHello everyone. In the Part 1 we looked at reports that System Center 2012 Virtual Machine Manager (VMM) ships out of the box for our customers; in this part we want to shift gears a bit and talk about what additional things you can do based on the data we already are pumping into the OM Data Warehouse.

    I touched upon the fact that the canned reports that we ship in one sense can be used as templates for your own custom reports; reading between the lines what it really means is that it’s not just the canned reports but the data that we are pushing into the OM Data Warehouse is something you could leverage upon.

    How and Why? Well, every business and every group within an organization will often have very specific requirements when it comes to reporting. This means that very likely there are certain reports that you want tailored to the specific questions you want answered for a particular business related question. Having this data that VMM is pushing into the warehouse, you can build exactly that. As an example, lets look at how we can build a custom report that depicts CPU and Memory usage at a cloud level and at a cloud user level.

    Operations Manager publishes its Data Warehouse Schema and here is some good content on how to build custom reports. http://technet.microsoft.com/en-us/library/gg508710.

    For this example I am going to use Microsoft Business Intelligence Development Studio (BIDS) to create the custom report.

    What VMM Data is available in OM DW for custom reports?

    VMM Library and Discovery MPs define all the types that are pushed into OM DW. To easily view this type information, you could use a tool like MP Viewer (run it from a machine that has System Center Operations Manager console on it). I have pointed out a few properties that we will be using in this custom report.

    clip_image002[1]

    clip_image004[1]

    Creating a sample DW query for VMM Data

    When the VMM-OM connection is established, instance data is being pushed into the OM warehouse and this data is available through the set of views that OM is making available. You should have a basic understanding of Data Warehouse Schema for this query. For our sample report, to report on memory usage say at a cloud level I will have to write a custom SQL query to gather and correlate information from these various views (time to take your SQL developer for a coffee J).

    Here is a SQL query I am going to use (query provided as is):

    DECLARE @GBFactor REAL 

    DECLARE @precision INT 

    DECLARE @daysHistory INT 

    DECLARE @ReportStartTime DATETIME 

    DECLARE @ReportEndTime DATETIME 

     

    SET @daysHistory = 30 /* This report query looks at a static window of past 30 days*/ 

    SET @precision = 1

    SET @GBFactor = 1073741824.0

    SET @ReportStartTime = DATEADD(DAY, @daysHistory * -1, GETUTCDATE()) 

    SET @ReportEndTime = GETUTCDATE() 

     

    SELECT CloudRelation.CloudName, 

           ServiceVMRelation.ServiceName, 

           vME.DisplayName                     AS VM, 

           vOwner.PropertyValue                AS VMOwner, 

           ROUND(perfTable.CPUAvg, @precision) AS DailyAvgCPU, 

           ROUND(perfTable.RAMAvg, @precision) AS DailyAvgMemUsage, 

           perfTable.CollectionDate

     

    FROM   vManagedEntity AS vME 

     

           INNER JOIN  /* SubQuery 1 - VMs have aggregated daily perf data available in DW Perf Views*/

                        ( 

                            SELECT 

                                ManagedEntityRowId, 

                                AVG(CASE  WHEN RName = N'Microsoft.SystemCenter.VirtualMachineManager.2012.VirtualMachine.PercentCPU' THEN Entry.AVG1 END) AS CPUAvg, 

                                AVG(CASE  WHEN RName = N'Microsoft.SystemCenter.VirtualMachineManager.2012.VirtualMachine.Memory'     THEN Entry.AVG1 END) AS RAMAvg, 

                                CollectionDate 

                            FROM  

                            (

                                SELECT 

                                    vRule.RuleSystemName AS RName, 

                                    AVG(perf.vPerfDaily.AverageValue) AS AVG1, 

                                    vManagedEntity.ManagedEntityRowId, 

                                    CONVERT(DATE, perf.vPerfDaily.DateTime, 1) AS CollectionDate 

                                FROM   perf.vPerfDaily, 

                                    vPerformanceRuleInstance, 

                                    vManagedEntity, 

                                    vRule 

                                WHERE  vPerformanceRuleInstance.RuleRowId = vRule.RuleRowId 

                                        AND vPerformanceRuleInstance.PerformanceRuleInstanceRowId =  perf.vPerfDaily.PerformanceRuleInstanceRowId 

                                        AND vPerformanceRuleInstance.InstanceName = vManagedEntity.DisplayName 

                                        AND ( perf.vPerfDaily.DateTime >= @ReportStartTime ) 

                                        AND ( perf.vPerfDaily.DateTime <= @ReportEndTime ) 

                                        AND ( vRule.RuleSystemName IN (  N'Microsoft.SystemCenter.VirtualMachineManager.2012.VirtualMachine.PercentCPU' , 

                                                                N'Microsoft.SystemCenter.VirtualMachineManager.2012.VirtualMachine.Memory' ) ) 

                                GROUP  BY vPerformanceRuleInstance.InstanceName, 

                                   vManagedEntity.ManagedEntityRowId, 

                                   vRule.RuleSystemName, 

                                   perf.vPerfDaily.DateTime

                            ) AS Entry 

                            GROUP  BY 

                                ManagedEntityRowId, 

                                CollectionDate

                            ) AS perfTable 

            ON vME.ManagedEntityRowId = perfTable.ManagedEntityRowId 

     

        INNER JOIN  /* SubQuery 2 - Fetch "Owner" property of a VM */ 

                        ( 

                            SELECT 

                                [ManagedEntityRowId], 

                                [PropertyValue], 

                                MAX(ToDateTime) AS  LatestDate 

                            FROM 

                               [vManagedEntityPropertySet] AS vMEPS, 

                               vManagedEntityTypeProperty AS vMETP, 

                               vManagedEntityType AS vMET 

                            WHERE 

                               vMEPS.PropertyGuid = vMETP.PropertyGuid 

                               AND vMETP.PropertySystemName = 'Owner' 

                               AND vMET.ManagedEntityTypeSystemName = N'Microsoft.SystemCenter.VirtualMachineManager.2012.VirtualMachine' 

                               AND [PropertyValue] != '' 

                            GROUP  BY 

                                [ManagedEntityRowId], 

                                [PropertyValue]) AS vOwner

                            ON vME.ManagedEntityRowId = vOwner.ManagedEntityRowId 

     

        INNER JOIN  /* Subquery 3- Fetch clouds for VM using 'PrivateCloudContainsVirtualMachine' relationship  */ 

                   ( 

                        SELECT 

                            CloudVM.TargetManagedEntityRowId, 

                            vManagedEntity.DisplayName AS CloudName 

                        FROM  

                            (

                                SELECT vRelationship.TargetManagedEntityRowId, 

                                    vRelationship.SourceManagedEntityRowId 

                                FROM   vRelationship 

                                INNER JOIN 

                                    vRelationshipProperty 

                                ON vRelationshipProperty.RelationshipRowId =  vRelationship.RelationshipRowId 

                                INNER JOIN 

                                    vRelationshipType 

                                ON vRelationshipType.RelationshipTypeRowId = vRelationship.RelationshipTypeRowId 

                                    AND vRelationshipProperty.ToDateTime IS NULL 

                                WHERE  vRelationshipType.RelationshipTypeSystemName = N'Microsoft.SystemCenter.VirtualMachineManager.PrivateCloudContainsVirtualMachine'

                            ) AS CloudVM 

                        INNER JOIN 

                            vManagedEntity 

                        ON vManagedEntity.ManagedEntityRowId = CloudVM.SourceManagedEntityRowId

                   ) AS CloudRelation 

        ON vME.ManagedEntityRowId = CloudRelation.TargetManagedEntityRowId 

       

        LEFT JOIN /* Subquery 4 - Fetch Service for VM using 2 relationships */

                  /* LEFT JOIN will return VMs even if they do not belong to any service*/

                       (

                            SELECT 

                                vManagedEntity.DisplayName              AS ServiceName, 

                                vRelationship.SourceManagedEntityRowId  AS ServiceId, 

                                vRelationship.TargetManagedEntityRowId  AS TierId, 

                                TierVMRelation.TargetManagedEntityRowId AS VMId 

                            FROM  

                                vRelationship 

     

                            INNER JOIN vRelationshipType 

                            ON vRelationshipType.RelationshipTypeRowId = vRelationship.RelationshipTypeRowId 

     

                            INNER JOIN 

                                (

                                    SELECT 

                                        vRelationship.TargetManagedEntityRowId, 

                                        vRelationship.SourceManagedEntityRowId 

                                    FROM  

                                        vRelationship 

     

                                    INNER JOIN vRelationshipType 

                                    ON vRelationshipType.RelationshipTypeRowId = vRelationship.RelationshipTypeRowId 

                                    WHERE  vRelationshipType.RelationshipTypeSystemName = N'Microsoft.SystemCenter.VirtualMachineManager.2012.ComputerTierContainsVirtualMachine'

                                ) AS TierVMRelation 

                            ON vRelationship.TargetManagedEntityRowId = TierVMRelation.SourceManagedEntityRowId 

     

                            INNER JOIN vManagedEntity 

                            ON vManagedEntity.ManagedEntityRowId = vRelationship.SourceManagedEntityRowId 

                            WHERE  vRelationshipType.RelationshipTypeSystemName = N'Microsoft.SystemCenter.VirtualMachineManager.2012.ServiceHostsComputerTier'

                       ) AS ServiceVMRelation 

                       ON vME.ManagedEntityRowId = ServiceVMRelation.VMId 

     

        ORDER  BY 

            CloudName DESC, 

            ServiceName DESC, 

            vME.ManagedEntityRowId, 

            CollectionDate 

    ____

    This sample query gets a property (Owner), related objects (Cloud, Service), and daily average perf data (CPU, Memory usage) for a VM object in a given time window.

    It uses a wrapper query that formats the results from following 4 sub queries --

    1- Gets Perf Data for VMs

    2- Fetches Owner property of VMs

    3- Fetches Clouds for VM

    4- Fetches Services for VM, if available

    Creating a Sample Custom Report

    Once you have the query in place you can run it as is to ensure that it is pulling the data you are looking for and tweak it as necessary:

    clip_image006

    You should also see all the available data fields resulting from your query in the Report Data->Datasets section of the designer. In this case I am using the OperationsManagerDW database residing on my SQL Server as my data source using default Windows authentication.

    clip_image008

    From here you can drag and drop and format various form elements you need for the report in a straightforward way. Of course in the process you can define what kind of mathematical computation is required on each of those data fields that the query produces, what kind of interactivity with the report elements you need the report to have (like sorting, collapsing) etc. For the memory usage per cloud chart for our example I am going to format my Chart data to use averages for the DailyAvgMemUsage data field and report it by aggregating it per Cloud. Here is how chart data properties would look like for that pane:

    clip_image010

    I also want to show a tabular view of data supporting my report that can be sorted based on either the daily average memory or CPU usage. So I am going to use a table defined such that the data is being aggregated by VMOwner field and sortable on either the Memory or CPU usage fields.

    clip_image012

    And that’s about it. Click on the preview tab and my custom report appears! There are multiple ways to deploy the report now onto the OM reporting server and just about the easiest way is to deploy it directly from BIDS (you just need to make sure the OM reporting server URL is configured correctly in your project). Once you do that ahoy! Your custom report shows up in the OM reporting console and is ready for consumption.

    clip_image013

    Time to party J. Ah.. here is how the actual report we started out creating looks like:

    clip_image015

    For those of you who are reading the above report keenly.. you would have observed that my memory usage per cloud and per user charts shows up exactly the same – happens to be I have only two users; one in each cloud. Regardless we think it’s a pretty useful custom report to begin with..

    Thank you!

    Chetan Gangwar | Developer | MSFT
    Chaitanya Garikiparthi | Program Manager | MSFT

    Get the latest System Center news on Facebook and Twitter:

    clip_image001 clip_image002

    App-V Team blog: http://blogs.technet.com/appv/
    ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
    DPM Team blog: http://blogs.technet.com/dpm/
    MED-V Team blog: http://blogs.technet.com/medv/
    Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
    Operations Manager Team blog: http://blogs.technet.com/momteam/
    SCVMM Team blog: http://blogs.technet.com/scvmm
    Server App-V Team blog: http://blogs.technet.com/b/serverappv
    Service Manager Team blog: http://blogs.technet.com/b/servicemanager
    System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
    WSUS Support Team blog: http://blogs.technet.com/sus/

    The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
    The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
    The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
    The Forefront TMG blog: http://blogs.technet.com/b/isablog/
    The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

Page 1 of 32 (318 items) 12345»
Was this helpful? Share it!