I am looking for a report that will display cloud (Azure and AWS) servers that are not managed as Orion nodes. Looking for a weekly audit report so we can make sure they are monitored like the on-prem nodes.
Anyone have any thoughts?
SWQL query for finding non-managed Cloud Instances
SELECT TOP 10000 Provider, Name, Type, State, LastSuccessfulPoll, Platform, KeyPairName, PublicDNSName, PrivateDNSName, Region, VirtualMachineID, Status, DetailsUrl, DisplayName
FROM Orion.Cloud.Instances
where NodeID is null
and InstanceType like '%CLOUD%'
Order by Provider, Region, Name DESC