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