2017-08-07

Oracle EM 12c - reporting filesystem usage across all hosts

Environment:
Oracle Enterprise Manager 12c Cloud Control.

in SYSMAN schema:

select target_name, mountpoint,
round((freeb/1073741824),2) as "Free, GiB",
round((sizeb/1073741824),2) as "Size, GiB",
round((usedb/1073741824),2) as "Used, GiB",
round((((sizeb-freeb)/sizeb)*100),2) as "Used, %"
from MGMT$STORAGE_REPORT_LOCALFS
where filesystem_type not in ('iso9660','devtmpfs') -- excluding some filesystems
order by "Used, %" desc

Attention! (sizeb-freeb)/sizeb is not the same as usedb/sizeb
Use% of df command shows the same as (sizeb-freeb)/sizeb

Creating the report:





No comments:

Post a Comment