Service Desk Practitioners Forum
cancel

Counting CIs

SOLVED
Go to solution
Highlighted
BertG
Regular Contributor.

Counting CIs

I need to get a count of child CIs that are related to each software CI. Is there a table that links the CI Parent/Child relationship?
5 REPLIES
Piku_1
Outstanding Contributor.

Re: Counting CIs

Hi Bert,

cirelationship is the table which stores all the info about related cis.


hth,
BertG
Regular Contributor.

Re: Counting CIs

Guess I should have included more info, sorry. I am using Service Desk 5.1 I don't see a cirelationship table. There is a cdm_ci_relations table, but it only contains 30 rows and we have thousands of computer CIs related to hundreds of software CIs.
The Pike
Acclaimed Contributor.
Solution

Re: Counting CIs

If not looking at the wrong database, perhaps that is not the right table. How about sd_cicomponents?
BertG
Regular Contributor.

Re: Counting CIs

Excellent. That's exactly the table I needed. Thanks for the help.
BertG
Regular Contributor.

Re: Counting CIs

CI relations maintained in the sd_cicomponents table