Comments
-
Yep. Thanks, Daniel! Good to go on my end. I appreciate the help.
-
Yes, sir. My apologies for the delay.
-
Thanks for the assistance here. I see to have figured it out with the following: SELECT VirtualMachines.Uri, VirtualMachines.DisplayName FROM Orion.VIM.VirtualMachines AS VirtualMachines WHERE VirtualMachines.OldestSnapshotDate <= AddDay(-15, GETDATE()) AND VirtualMachines.ResourcePool.DisplayName NOT LIKE '%MCS-VM%' AND…
-
Thanks for the reply. Although the WHERE query you posted validates successfully, adding the AND query to it makes it invalid. I am unsure if vm.folder.name is correct or not with VMAN. Any guidance there? Even if I did "WHERE vm.folder.name NOT LIKE 'MCS Templates'" as the query, it's invalid.
-
Thanks! Sorry for the much delayed response. I'm circling back to this project. I'd love to be able to do this. Are you still willing/able to assist? SQL and SWQL is still very new to me, so I would love some assistance. I have a few ideas going this route for other custom properties we can set based on installed…
-
Thanks, I understood that part. I have my custom property created, and I use alerts for setting these custom properties. My issue is coming up with the logic within the alert to correlate the SQL identification and assign that to a custom property against the node.
-
Thanks what I'm trying to figure out. I can't seem to make that happen. Since SQL is in App Insight, even though it's on the node, it's not a value or property of the node, so I'm not able to reference it.