topic Re: DQL query on disk free space in DQL

DQL query on disk free space

akashsaini — Thu, 13 Feb 2025 13:15:15 GMT

Hi Team,

We require DQL query on disk free space with OS type.

Information require through dql query --

disk free space for /opt/ directory
os type-like Linux ubuntu , AIX

Thanks in advance !

Re: DQL query on disk free space

gbaudart — Thu, 13 Feb 2025 15:59:54 GMT

Hi @akashsaini,

You can try this query :

timeseries avg(dt.host.disk.free), by: { dt.entity.host, dt.entity.disk } | fieldsAdd dt.entity.host.name = entityName(dt.entity.host) | fieldsAdd dt.entity.disk.name = entityName(dt.entity.disk) | lookup [fetch dt.entity.host | fieldsAdd osType2=osType], sourceField:dt.entity.host, lookupField:id, fields:{osType2} | fieldsAdd DiskFree = arrayAvg(`avg(dt.host.disk.free)`) | fieldsKeep dt.entity.host.name,dt.entity.disk.name, osType2, DiskFree

Let me know if it works

Re: DQL query on disk free space

akashsaini — Mon, 17 Feb 2025 08:38:15 GMT

Thanks Gbaudart,

query perfectly working.

Please confirm the disk free space in GB ?

Re: DQL query on disk free space

gbaudart — Mon, 17 Feb 2025 20:15:20 GMT

Hi @akashsaini,
Normally, the unit will match the magnitude of your result. You can change the unit in the query display options.

Re: DQL query on disk free space

manog1978 — Mon, 07 Apr 2025 10:09:07 GMT

I am creating a Dashboad to pull the disk usage for windows and Linux Servers, for example in windows server (C. D. e) and Linux Server ,(/tmp, /root) can you please advise. should i use Query based or Metric based.

Re: DQL query on disk free space

manog1978 — Mon, 07 Apr 2025 10:56:40 GMT

the following query works for percentage based, i would like to get the GB how much used and how much free.

timeseries avg(dt.host.disk.free), by: { dt.entity.host, dt.entity.disk }
| fieldsAdd dt.entity.host.name = entityName(dt.entity.host)
| fieldsAdd dt.entity.disk.name = entityName(dt.entity.disk)
| lookup [fetch dt.entity.host
| fieldsAdd osType2=osType], sourceField:dt.entity.host, lookupField:id, fields:{osType2}
| fieldsAdd DiskFree = arrayAvg(`avg(dt.host.disk.free)`)
| fieldsAdd DiskUsage = 100 - DiskFree
| fieldsKeep dt.entity.host.name, dt.entity.disk.name, osType2, DiskFree, DiskUsage

| sort DiskUsage asc

Re: DQL query on disk free space

alagurajpl — Tue, 28 Apr 2026 07:10:02 GMT

Hi @manog1978

You can use this query for available space in value.

timeseries max(dt.host.disk.avail), by: { dt.entity.host, dt.entity.disk }

| fieldsAdd dt.entity.host.name = entityName(dt.entity.host)

| fieldsAdd dt.entity.disk.name = entityName(dt.entity.disk)

| lookup [fetch dt.entity.host

| fieldsAdd osType2=osType], sourceField:dt.entity.host, lookupField:id, fields:{osType2}

| fieldsAdd DiskFree = arrayAvg(`max(dt.host.disk.avail)`)

| fieldsKeep dt.entity.host.name,dt.entity.disk.name, osType2, DiskFree