We want to verify the integrity of our CI's. We want to start with making a report of all CI's that have no relations, how can I do this? Its not part of any view I can setup within HPOVSD. Is there an SQL select I can run for this?
You can use the below query to get the list of CI's that has the Related CI's.
select CIRelation.CI_FROM_SEARCH_CODE, CIRelation.CI_TO_SEARCH_CODE from servicedesk.v1033_CI_Relation CIRelation, servicedesk.v1033_configuration_item CI where CI.search_code= CIRelation.CI_FROM_SEARCH_CODE
From your complete CI list subtract these CI's to get the Empty Related CI's.