Goal to report Server, CI, Assignment Group, Policies

[JaneneU]

Server, CI, Assignment Group, Policies
From my findings these are from several different tables.  Any way to readily combine these to one view?
Business users are curious for what artifacts they are responsible for. 

[Dr Atul G- LNG]

Hi @JaneneU 

Technically, yes, there is a way to combine all these, and that is through a Database View. However, to do that, you need to identify the common fields in all these tables, or at least between the two tables you want to join.

For example:

• Server & CI

• CI & Assignment Group

• Group & Policies

In a database view, the WHERE clause is important, and for that, we need a common factor between the two tables.