Hello support,
I want to ask you how to process a result from a sql query which retrieve all tablespace name which occupation like this :
TABLESPACE_NAME SIZE(MB) USED(MB) MAX_EXT PCT_MAX_SIZE ------------------------------ ---------- ---------- ---------- ------------ tbs_1 411133.94 391752.13 430077.89 91 tbs_2 30720 18890 20480 92
The query returns all tablespaces where there occupation exceed 90% (several rows).
I would like to know how to proceed in prtg to deal with all the rows of the results and retrieve messages like :
'warning the tablespace tbs_1 is 91% full' 'warning the tablespace tbs_2 is 92% full'
Thank you very much for your help.
Regards.
Loubia
Add comment