CA SOI - We need some way to get CIs that are not monitored

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We need some way to identify CIs in CA SOI that are not monitored. 

Environment

Release : 4.2

Resolution

The following queries can be used to determine which CIs are not being monitored.

select distinct label, ciid from CIStaging where ciid is NULL
select distinct label from CIStaging where ciid is NULL