DQL query on disk free space

[akashsaini]

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 !

[gbaudart · Accepted solution]

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

[akashsaini]

Thanks Gbaudart,

query perfectly working.

Please confirm the disk free space in GB ?

[gbaudart]

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