search cancel

Default Disk(s) Enhanced - Determine which Profile does not have a child Disks (Enhanced)

book

Article ID: 254956

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have created Default Disk(s) Enhanced profiles. However, on many of them we suspect we have not create a Child Profile (Disks (Enhanced) so we are not sure if we are monitoring the disks. 

In MCS these profiles appear with a crossed-eye:

 

How can I determine which Default Disk(s) Enhanced Profiles do not have a child Disks (Enhanced) to ensure all disks are monitored

Environment

Release : UIM 20.4

Cause

Guidance

Resolution

The following query will return a list of Default Disk(s) Enhanced MCS profiles that do NOT have a child profile underneath or in other words the "eye-crossed" profiles: 

 

select * from SSRV2Profile where profileName like'%Disk%' and cs_id in
(select cs_id from SSRV2Profile where profileName like '%Disk%' or parentProfile in
(select profileid from SSRV2Profile where profileName like'%Disk%')
group by cs_id HAVING COUNT(*) < 2)




Attachments