For you BDNA customers there's also an example here: http://myitforum.com/myitforumwp/2012/03/22/hyper-v-hostguest-reports-for-configmgr-using-normalize-cm/
From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Friday, September 19, 2014 7:41 AM To: '[email protected]' Subject: [mssms] RE: Report\Query on list of guest VM's select sys.Name0,sys.Virtual_Machine_Host_Name0 from v_R_System sys LEFT JOIN v_GS_VIRTUAL_MACHINE vm on vm.ResourceID = sys.ResourceID where Virtual_Machine_Host_Name0 = @vhost prompt SQL Select distinct Virtual_Machine_Host_Name0 from v_R_System From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Lassiter, Brandon Sent: Thursday, September 18, 2014 7:24 PM To: '[email protected]' Subject: [mssms] Report\Query on list of guest VM's Would anyone be able to help with a prompted query or report that when entering a computer name it will return what Hyper-V guests are on the computer name entered in the prompt? Brandon Lassiter ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
