Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How to create a Class breakdown from cmdb ci table?

gitarani
Kilo Contributor

We are trying to get the class type as a breakdown in computer table but all the different class types are further extensions.   Is there any way to create a breakdown source to get "Class" to get all the types in computer table?

2 REPLIES 2

Vincent Loffel1
Kilo Guru

Hi Gita,



You can not create a regular breakdown on this type of field, because it is a reference to other table names. But don't worry there is another way to create a breakdown that does this. It is called a breakdown sandwich.



Please see this post i created earlier on how to build this: Re: How can I create a breakdown by task type on the Time Card table?


Instead of the task table use the cmdb_ci_computer table.



Cheers,


Vincent


mitzaka
Mega Guru

Here, I had to do this also, so I wrote it down in details (same approach as mentioned, only with the exact tables and fields): How to create a Performance Analytics breakdown by CI Class