Database View for Entities and Risk Identification

SM6
Giga Guru

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.

 

SM6_0-1742079273214.png

Entities should not be empty.

SM6_1-1742079302421.png

 

Thank you!

1 ACCEPTED SOLUTION

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


Hope that helps!

View solution in original post

3 REPLIES 3

Vishal Jaswal
Giga Sage

Hello @SM6 

Here are few changes:

Database view:

vishal_jaswal_0-1742150285248.png

View Table: sn_risk_advanced_risk_identification

vishal_jaswal_1-1742150353297.png
View Table: sn_grc_profile

vishal_jaswal_2-1742150399236.png

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

vishal_jaswal_4-1742150476072.png


Expand Entity fields to include Entity.Name

vishal_jaswal_5-1742150552834.png

vishal_jaswal_6-1742150620209.png


Hope it helps!


Hope that helps!

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... 

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


Hope that helps!