The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Counting CIs

SOLVED
Go to solution
Highlighted
BertG
Occasional 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
Occasional Visitor

Re: Counting CIs

Hi Bert,

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


hth,
BertG
Occasional 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
Honored Contributor
Solution

Re: Counting CIs

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

Re: Counting CIs

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

Re: Counting CIs

CI relations maintained in the sd_cicomponents table
//Add this to "OnDomLoad" event