G.

Comments

  • And that link is super helpful! not sure why i didn't come across it in all my searches.
    in SWQL to get Clusters, Hosts, VMS Comment by G. April 2021
  • I'm just dumb and didn't see that field in hosts.. Your right it has what I wanted.. SELECT vm.GuestDnsName as DNSName, vm.Node.Caption as VM, vm.Host.node.Caption as Host, vm.Host.Cluster.Name as Cluster, vm.GuestState as Status, vm.GuestName as GuestName, vm.IPAddress as IP, vm.Host.DataCenter.Name as DataCenter FROM…
    in SWQL to get Clusters, Hosts, VMS Comment by G. April 2021
  • Although if someone still wants to help further with joining, i would like to get the datacentre.. SELECT vm.GuestDnsName as DNSName, vm.Node.Caption as VM, vm.Host.node.Caption as Host, vm.Host.Cluster.Name as Cluster, vm.GuestState as Status, vm.GuestName as GuestName, vm.IPAddress as IP, hosts.DataCenterID FROM…
    in SWQL to get Clusters, Hosts, VMS Comment by G. April 2021
  • Thanks. That at least gets me the linked tables.
    in SWQL to get Clusters, Hosts, VMS Comment by G. April 2021
  • CISCO but it doesn't show APs at all. I do see routers and switches there (and everything else). Also, the IDs would overlap.
    in Wireless AP names and serial numbers Comment by G. March 2020
  • Thanks @"mesverrum" that was enough for me to work it out. It was indeed because I was not matching on a unique field. When i switched to NodeID and ParentObjectID it works. SELECT n.NodeID, n.IPAddress, n.Caption, n.NodeDescription, n.Description, n.DNS, n.SysName, n.Vendor, n.IOSImage, n.IOSVersion, n.MemoryAvailable,…
    in How to get Routers\Switch information with Service Tag. Comment by G. March 2020
Avatar