Just got this example: PowerCLI C:\scripts> Get-VM “your virtual machine” | Select VMHost
VMHost ------ server.company.corp requires powercli for vsphere … Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure – Windows Hosting [cid:image002.gif@01CDF887.776259A0] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Dzikowski, Michael Sent: Wednesday, February 19, 2014 9:56 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] SCCM 2012 to inventory VMs I just pinged one of the VMware dudes here. He hasn’t heard of a way to natively obtain information about a host, from a guest VM. However, it looks like there is some info out there on the web: http://www.virtuallyghetto.com/2011/01/how-to-extract-host-information-from.html and http://onebyte8bits.wordpress.com/2011/03/10/query-esx-hostname-from-vm-using-powercli/ Sounds like this could help: C:\Program Files\VMware\VMware Tools>vmtoolsd.exe –cmd “info-get guestinfo.hypervisor.hostname” Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure – Windows Hosting [cid:image002.gif@01CDF887.776259A0] From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of slkissin...@sbcglobal.net<mailto:slkissin...@sbcglobal.net> Sent: Tuesday, February 18, 2014 6:21 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] SCCM 2012 to inventory VMs I disagree about v_gs_virtual_machine or v_gs_virtual_machine_64 being useful when it's VMware. If it's HyperV guests, it's great. There is no known way (I even asked VMware) if there was a way from a CLIENT to tell what it’s VMware HOST was. apparently the only known way is to gather than information from the Host--not the client. Of course, that was over a year ago. Maybe there’s a way now. If anyone knows of a way to detect that… ask a client “who is your VMware host”, I sure would be interested so we can have a custom hinv for that. I could see that going stale--if your guest is moved to another host--but something is better than nothing (which is what we have now). But essentially we have a custom global condition rule for detecting virtual machines--any kind of virtual machine--of this: wmi type, root\cimv2 win32_computersystem model model like ‘%virtual%’ if it returns anything it must be a virtual. If you run a select csys.model0, count(*) from v_gs_computersystem where csys.model0 like ‘%virtual%’ group by csys.model0 you’ll see about how many of each type you may have. that’ll show counts of VMware, HyperV, VirtualBox and Parallels Virtual Platform. I’m pretty sure that’s the main players--and they all show up with that. From: Jason Sandys<mailto:ja...@sandys.us> Sent: Tuesday, February 18, 2014 2:59 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> There’s also a couple of WMI classes that ConfigMgr creates called Win32Reg_SMSGuestVirtualMachine and Win32Reg_SMSGuestVirtualMachine 32 (v_GS_VIRTUAL_MACHINE and v_GS_VIRTUAL_MACHINE_64 in SQL). These info is populated from the registry and definitely works for Hyper-V guests and to my knowledge also works for VMware guests. J From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Tuesday, February 18, 2014 12:35 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: RE: [mssms] SCCM 2012 to inventory VMs Yeah its in the computer system info. Here is a quick SQL query. select Name0, Manufacturer0, Model0 from v_GS_COMPUTER_SYSTEM Daniel Ratliff From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of JRIT Sent: Tuesday, February 18, 2014 1:26 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] SCCM 2012 to inventory VMs Is there a way to know when a VM inventoried by SCCM in from Hyper-V or VMware? The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
<<inline: image001.png>>