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

ushag — Thu, 08 Oct 2026 16:45:28 GMT

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:~")")))

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

anuj-jain08 — Fri, 09 Oct 2026 06:40:33 GMT

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

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

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

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