How create a report or database view with downstream / upstream entities

[cdiegobb]

Hi all,

I need create a report that show all the hierarchy of entities for example:

* Company class has all my entities and have the trier 1

* Busines unit class has all my entities and have the trier 2

* Area  class has all my entities and have the trier 3

I wan to show all the entities that are inside this class in order like dices

Company | Business unit | Area

Also i create a hierarchy of downstream and upstream entities

I try to made a database view but it´s impossible to reuse the table sn_grc_profile to make many columns for each level, do know how can i made this?

[AnubhavRitolia]

Hi @cdiegobb 

Can you elaborate please with some example or screenshot and in which table you want to generate report for?

[cdiegobb]

[AndersBGS]

Hi @cdiegobb ,

are we talking CMDB upstream and downstream? If yes, then you can create a report based on the cmdb_rel_cu table.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[cdiegobb]

no are not part of the cmdb i create entities manually, with class and triers