RQL query to list the VMs having a public IP address

[C.sasanapuri]

hi can you any one help me out ( RQL query to list the VMs having a public IP address ) 

[EBarragan2]

something like this? config from network where source.network = '0.0.0.0/0' and address.match.criteria = 'full_match' and dest.resource.type = 'Instance' and dest.cloud.type = 'AZURE' and dest.resource.state = 'Active'

[EBarragan2]

config from cloud.resource where cloud.type = 'azure' AND api.name = 'azure-vm-list' AND json.rule = powerState contains "PowerState/running" AND ['properties.networkProfile'].['networkInterfaces'][*].['publicIpAddressId'] exists