Relate indicator supporting data to the entity

[alexrozov]

Hi All,

I'm trying to create a control objective, controls and indicators to verify my policies are not passed their valid to dates.

so I have done the following:

1. Created a control objective

2. created an entity type that is pointing at the policy table with an entity filter to look at all published policies

3. related the entity type to my control objective and this has created controls for all my published policies

4. I create an indicator template which I defined as basic.

5. In the supporting data I have defined the policiy table again with a filter looking for policies where the "valid to" field is in the next month - ?I want to make sure every policy that has only 1 month of validity left get's the relevant control out of compliance

The issue is that I can't figure out how to relate the supporting data to the entity. I want the supporting data to only look for the policy that is related to the entity of the specific control.

My understanding is I need to use the reference field to achieve this and I have tried doing so and referencing number and sys_id but none of these work correctly.

I'm sure I'm doing something really simple wrong but just can't figure it out.

Would be happy for any ideas on how to link filter the supporting data correctly

Thanks

[Phil Swann]

Hi, did you review this video?

https://community.servicenow.com/community?id=community_article&sys_id=cd6df784dbbd18905ed4a851ca961... 

[alexrozov]

Hi

I did see this video. this what made me realize I should probably use the reference field.

But I'm still doing something wrong.

My scenario is that I have a control related to an entity and I'm trying to create a basic indicator that will return 0 or one records on the supporting data and based on this I will decide on pass/fail.

so my entity and my supporting data are both records in the same table (policy)

I just can't get the reference field to point correctly at the entity

[sachin_namjoshi]

This is because policy and entity types has one to many relationships.

1 policy can have multiple entity types related and you know entity types are tied to entity.

You will have to create database view between policy, sn_grc_profile ( entity table) and sn_grc_profile_type table.

This will allow you to dot talk between reference fields available in this database view.

You can use same database view in indicator as well.

Regards,

Sachin

[Phil Swann]

I've got the answer for you...