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]] 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.
