Database View for Entities and Risk Identification

[SM6]

Hi, 

Can someone help me with a database view where I want to see the list of entities that do not have Risk Identification created.

Entities should not be empty.

Thank you!

[Vishal Jaswal]

Hello @SM6 

Here are few changes:

Database view:

View Table: sn_risk_advanced_risk_identification

View Table: sn_grc_profile

Database View > Related Links > Try it > Configure List Layout

Expand Entity fields to include Entity.Name

Hope it helps!

[SM6]

Hi Vishal,

The requirement is to show me entities which has been through a risk identification and also the once where a risk identification is never performed on an entity. The above solution only shows the one that has risk identification associated.

Looking for something like this https://www.servicenow.com/community/itsm-forum/database-view-to-show-all-groups-and-incidents/m-p/2... 

[Vishal Jaswal · Accepted solution]

@SM6 I believe it is not possible via Database view.