SWQL question on Virtualization - VMWare

WinterSoldier

Hi,

I have the following query that gives the list of all the VMs. 

SELECT n.Name as [VM],n.IPAddress,n.PowerState,n.GuestState
,Round(n.MemUsage, 0) AS [Memory]
,ROUND(n.CpuLoad, 0) as [CPULoad]
,n.BootTime,n.ProcessorCount,n.VDisksCount,n.DetailsUrl,n.NicCount,n.Status,h.HostName, h.DetailsUrl as [HostURL], d.Name as [Datacenter]
, d.DetailsUrl as [DatacenterURL], c.Name as [Cluster], v.DisplayName AS [Vcenter], c.DetailsUrl as [ClusterURL]
, Case 
When n.NodeID IS NULL Then 'No'
When n.NodeID IS Not Null Then 'Yes'
End as [Managed Node]
FROM Orion.VIM.VirtualMachines n
Join Orion.VIM.Hosts h on n.HostID = h.HostID
Left Outer Join Orion.VIM.Clusters c on c.ClusterID = h.ClusterID
Left Outer Join Orion.VIM.DataCenters d on d.DataCenterID = h.DataCenterID
Left Outer Join Orion.VIM.VCenters v on v.VCenterID = d.VCenterID

How can I add this VMWare tags in the above query? Can anyone help here please?

brscott

1) if you are not seeing the vmware tags listed in that widget, then they are probably not in the database.

2) to directly answer your question: the tags can be accessed two different ways.  given that "n" in your example is Orion.VIM.VirtualMachines, the swql method would be n.tags.name.  The other method would be n.customproperties.<whatever tag> (and you would need to know the tag to custom property mapping.  If you don't want to learn the custom property mapping, then you can use "SWQL studio" and it has tab completion

3) It's fine if you prefer the old school join method (it's better in some ways), but I need to mention for others reading this.  You can access most of the data through the pre-joined swql connections.  Such as instead of joining orion.vim.hosts, you could leave off the join and instead of "h.DetailsUrl as [HostURL]" use "n.Host.DetailsUrl as [HostURL]".  It doesnt stop there, you can keep the chain going with the cluster linked from the host, so isntead of "c.DetailsUrl as [ClusterURL]", you can have "n.Host.Cluster.DetailsUrl as [ClusterURL]"

4) and someone please let me know if this is just me, but... The vmware tags in solarwinds do not include the category, only the value.  So if I have two tags on a vm they are confusing.  one with  "category=owner,value=Brian", and another with "category=oncall_contact,value=John".  In solarwinds, I would just see the tags "John" and "Brian" and no clue what category they go with.  This is further aggravating because I can see the place they should go in the database Orion.VIM.TagCategories.