Business Application Owner Stakeholders List

[Louis R Ronzitt]

Anyone have an idea on how to create a database view that would show us a list of business owners of business applications that only have the role: business_stakeholder?

In other words, we don't want anyone in the list that also have 'itil'.

Example, this was a great post/solution for another database view that @RichieP provided assistance.

Looking for a similar example but with I think the maybe the below tables, so the business_stakeholder role can be joined to the business owner (owned_by) of the business application. 

cmdb_ci_business_app

sys_user_has_role

Use Case: We have Business Owners of business appliations that only have the business_stakeholder role.

[Louis R Ronzitt]

Much closer and appreciate (so much) the time / effort in proving this assistance.  I got the same result.  But there are a few sticking issues.  The list should only show a business owner that only has a business_stakeholder role.  Currently, its also showing business owners with the 'itil' role.  It would be helpful to also be able to see the business application in the list view along side the business owner.   Goal is to of course see the list of all business stakeholders who are business owners and then which business applications they own.  The list is still showing users more than once but suppose we can live with that since there is value is this list of all business owners even if they own more than one business application.  Albeit, need to get the business application in the list.  I thought the cmdb_ci_business_app would be the left join and tried that but it didn't work.

[Louis R Ronzitt]

Oh, just figured it out with the business application.  Field is 'Name(bap_name)'.  Just need to now see how we can configure the list to only show users with business stakeholder role and not 'itil'.

[Louis R Ronzitt]

I think I figured out the last part. 

Adding the 'Business Owner.Roles' is not 'itil' to a report created based on the database view would then filter out the list to remove all business owners who also have the itil role.

Thumbs up!

[Ankur Bawiskar · Accepted solution]

@Louis R Ronzitt 

Glad to help.

If my response helped please mark it correct and close the thread so that it benefits future readers.