inner join orion.vim.Hosts as h on h.HostID = Nodes.RelyHost.HostID
join orion.vim.clusters as vmc on h.ClusterID = vmc.ClusterID
where vmc.DisplayName = 'Cluster A','Cluster B'
and Nodes.CustomProperties.Department != 'Team A'
I'm trying to make this logic happen in an alert to set a custom property against a managed node. This should apply to NPM and VMAN. I want to find all nodes/VMs that reside in Cluster A and Cluster B, and set the custom property, "Department" to be "Team A". I've made similar alerts for setting custom properties, but not involving VMAN. I validated the above SWQL condition, but for some reason, it's not applying against any nodes as it should. No nodes currently have the custom property, "Department" set to Team A. What error am I making here?
