eptesicus

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.