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 · Accepted solution]

I got my indicator result:

From this policy:

This entity type:

This indicator template against a control objective:

(The main thing here is your target table is your entity table, so therefore the reference field must be sys id!)

It's simple but most people need a double take on that one so read it again 🙂 

Set to Passed:

ps. if you want to make your entity type filter condition readable, check out: https://community.servicenow.com/community?id=community_article&sys_id=4d30a1f4dbb15cd0d82ffb2439961... 

[alexrozov]

Now I manged to get it working

Strange since I think I did try the reference with sys ID yesterday.

Maybe something on my filter was not defined properly.

In nay case this is now working perfectly so a big thanks