Database query for the storage details of a computer

Products

• CA Configuration Automation

Issue/Introduction

We would like to have a query for the storage directory and its parameter values(such as free space and total size) of a computer in this relationship:

Environment

CA Configuration Automation 12.9

Resolution

select s.srvr_name 'Server Name', bp.name 'BluePrint', e2.name 'Config Group', g.name 'Directory', p.name 'Param Name', p.value 'Param Value'
from acm_exdir e1
inner join acm_bp_exdir e2 ON e1.exdir_uuid=e2.exdir_uuid
inner join acm_cfg_grp_ex g ON g.direct_uuid= e1.direct_uuid
inner join acm_cfg_param_ex p ON p.cfg_grp_uuid=g.cfg_grp_uuid
inner join acm_comp_bkt b on b.comp_bkt_uuid=e1.comp_bkt_uuid
inner join acm_comp c ON c.comp_uuid=b.comp_uuid
inner join acm_srvr_inst s ON c.srvr_inst_uuid=s.srvr_inst_uuid and s.inst_typ=0
inner join acm_bp bp ON bp.bp_uuid=c.bp_uuid
where
s.srvr_name='<Computer-Name>' and
bp.name='Storage Details (Linux)' and e2.name='Logical Drives' and g.name ='/'