In many shops year on year a capacity planning will be done to find out how much space to be added. If you want to find out what are the mountpoint to which storage as to be added, you can get those information from OEM. Our client shop has more than 1000 targets. No way there to generate report from oem to find out what are the mountpoint reaching threshold.
If you know the sysman pwd, you can use below query to find out potential mountpoint to which you need to add space.
select b.host_name,b.target_name,a.key_value,a.message,a.collection_timestamp from MGMT_CURRENT_SEVERITY a,mgmt_targets b where a.target_guid= b.target_guid and (a.message_nlsid like 'host_file%' or a.message_nlsid like 'DiskGroup%' or a.message_nlsid like 'archFull%') order by b.host_name asc,b.target_name asc,a.key_value asc,a.collection_timestamp desc
convert this post to pdf.