Is it possible to use data certification for non-cmdb tables?

gunnergraves · ‎01-16-2018

Hello,

Our organization uses Assignment Lookup tables to keep track of how CI's route to different support groups and what level of support they are currently with. We were interested in using the Data Certification tasks to ask our process owners to verify the data in these tables on a regular basis. Is it possible to use the data certification on non-cmdb tables?

Thanks,
Gunner

philmurray · ‎01-18-2018

Yes it is possible, you could theoretically use any table. We use Data Certification to validate ServiceNow groups and roles which we regard as having elevated privileges, the owners get sent a list of members of each group and the pass (keep access) or fail (remove access) them. You set it up in the same way but select the table you want - we use Group Member (sys_user_grmember) and we use the schedule function to send this out every 6 months.

View solution in original post

Jeff316 · ‎05-14-2019

Thanks Phil,

This is how I was thinking to do it.

LK11 · ‎05-27-2019

Hi Phil,

Have you implemented automation to remove the failed members? Currently I'm working on this and if you have already done this, please share the steps.

Thanks

Laya

Stuart Comstiv1 · ‎02-23-2023

Hi Laya, I am now looking to do the same and wondered if you managed to progress with this? Thanks

CCZMAX1 · ‎03-05-2025

Hi Phil, I am trying to set this up too from the sys_user_grmember table but I do not get the option to select 'group manager' as the 'assigned to'. I only get 'user' which means all the users within the group will be assigned the task to validate their own membership.

I only get to field 'group manager' if i use table sys_user_group.

How did you achieve this?

Many thanks

Max

Stuart Comstiv1 · ‎03-06-2025

I get to select either 'Group' or 'User' elements from the Group Member tree in the 'Assign to' field once I have set up a Filter against the sys_user_grmember table