use builtin: formula to get list of host and their properties in that management zone

[ushag]

How can I use a builtin: query to list all my host and their IP 

builtin:pgi.availability.state:filter(in("dt.entity.host",entitySelector("type(~"HOST~"), tag(~"[Environment]IP:~")")))

[anuj-jain08]

Hello @ushag,

You can use below DQL:

smartscapeNodes "HOST"
| filter matchesValue(name,"<your management Zone>")
| fieldsAdd managementZone = name
| fields
    managementZone,
    id,
    host.name,
    os.type,
    os.version,
    cloud.provider,
    aws.region,
    azure.location,
    host.logical.cpu.cores,
    host.physical.memory,
    host.ip_addresses
| fieldsAdd memory_gb = round(toDouble(host.physical.memory) / 1024 / 1024 / 1024, decimals: 1)
| sort host.name asc