question How create a report or database view with downstream / upstream entities in GRC forum

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

cdiegobb — Sat, 18 Nov 2023 00:33:19 GMT

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 — Sat, 18 Nov 2023 05:48:36 GMT

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

AndersBGS — Sat, 18 Nov 2023 14:10:54 GMT

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 — Mon, 20 Nov 2023 12:42:42 GMT

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

cdiegobb — Mon, 20 Nov 2023 13:02:51 GMT