Links between OS image and Boot Configuration

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

How to see the links between OS Images and Boot configurations using a SQL Query ?

Environment

Client Automation - Any versions

Resolution

Following SQL Query could be used to find the links between OS Image and Boot Configuration

SELECT osimage.name,bootconfig.name
FROM csm_object osimage 
INNER JOIN csm_link link ON link.child=osimage.id
INNER JOIN csm_object bootconfig ON link.parent=bootconfig.id and bootconfig.class=1004
where osimage.class=1008
order by 1