Highlighted
Super Contributor.
Super Contributor.
735 views

ucmdb 10.33 count of relationships

Jump to solution

Hi all,

is there a report or a query that can be created in ucmdb in order to have the number of relationships?

Thank you in advance,

Costas

0 Likes
1 Solution

Accepted Solutions
Highlighted
Super Contributor.
Super Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

There's a few ways from the JMX Console:

  •   UCMDB:service=Model Services. Method: retrieveInstancesCount:

specify 'Link' as the className

instanceCount.JPG

  • Mbean: UCMDB:service=Model Services. Method: countCIsByType

Specify 'Link' as the ciType 

 

  • countCIsByType.JPG

     

    Or to get a more granular inventory (this includes all CI Types in use): 

Mbean: UCMDB:service=Model Services. Method: countCIsPerType:

counsCIsPerType.JPG

 

Is that helpful?

Regards,

View solution in original post

8 Replies
Highlighted
Super Contributor.
Super Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

You want a count of the number of CIs a specific CI has links to?

Regards,
0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

No, I want the number of all relationships existing in uCMDB.

Regards

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

There's a few ways from the JMX Console:

  •   UCMDB:service=Model Services. Method: retrieveInstancesCount:

specify 'Link' as the className

instanceCount.JPG

  • Mbean: UCMDB:service=Model Services. Method: countCIsByType

Specify 'Link' as the ciType 

 

  • countCIsByType.JPG

     

    Or to get a more granular inventory (this includes all CI Types in use): 

Mbean: UCMDB:service=Model Services. Method: countCIsPerType:

counsCIsPerType.JPG

 

Is that helpful?

Regards,

View solution in original post

Highlighted
Super Contributor.
Super Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

Thank you SKAZAL.

This is what I was looking for!

Best Regards,

Costas

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

Hi 

This is something different from the actual question.

I have composition link count in uCMDB UI different from the DB. 

ANd i don't know how to resolve this. Thinking of deleting the whole composition id object and again scan them.

Is this a good idea to do that ?

Please suggest

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

Not the weirdest thing I've heard. This might have something to do with what they call 'in-line links'.  I'd open a ticket and request an opinion from R&D before going through the delete and rediscover process.  

Regards,
0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

Hi,

COuld you please tell me what is this in line link means ?

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: ucmdb 10.33 count of relationships

Jump to solution

An in-line link is an optimization where the composition relationship for some CI types is stored as an attribute and not as a unique row in the database.

Regards,
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.