SQL query to list enhanced and legacy MCS profiles for specific probes

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Need a query to list the enhanced and legacy MCS profiles for a number of probes for cleanup and/or reference purposes.

Environment

• DX UIM 23.4 CU3 or higher

Resolution

--List enhanced and legacy mcs profiles for specific probes for cleanup and/or reference purposes

SELECT

   cr.hub,
   cr.robot,
   st.templateName,
   st.probe,  
   CASE WHEN st.templateName LIKE '%(Enhanced)%' THEN 'Enhanced' ELSE 'Legacy' END AS profile_type,
   count(*) as 'No. of Profiles'

FROM SSRV2Profile sp inner join SSRV2Template st on sp.template=st.templateId

inner join CM_DEVICE cd on cd.cs_id=sp.cs_id  and cd.probe_name='controller'
inner join CM_NIMBUS_ROBOT cr on cd.dev_id=cr.dev_id

 

where st.probe in ('cdm', 'dirscan', 'processes', 'ntevl', 'logmon')

 

group by cr.hub,cr.robot, st.templateName, st.probe order by 'profile_type' desc

 

Example output:

 

uim