We have a weekly audit report that is pulling all of our running nodes showing in Orion VIM tables that are not monitored natively in Orion. We want to replicate this functionality for our Cloud Instances. We are part way there but I am looking for a way to add in the private IP addresses that are assigned to the node. I can see the IP I want to pull in the Cloud VM Details but I can't find it in the schema.
This is our current query.
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%'
and State like 'running'
Order by Provider, Region, Name DESC
