Data Certification Metric

[Jimmers]

Hi Team,

     We currently have Data Certification running on Servers on a 7 day cycle to collect desired attributes on newly deployed servers. I'm looking for a way to present these as Metrics on a dashboard but I'm not finding a really good way to separate the Tasks for each 7 day cycle, and show progress and completion.  Anyone have any ideas on what attributes to use for this?  Thanks in advance!

[Sankar N]

To present the data certification results as metrics on a dashboard, you could consider using the following attributes:

1. Server name: This attribute will allow you to identify each server and track its progress through the data certification process.
2. Date of certification: This attribute will allow you to track when each server was last certified and how long it has been since the last certification.
3. Certification status: This attribute will allow you to track the progress of each server through the data certification process, including whether it has been completed, is in progress, or has not yet been started.
4. Number of attributes certified: This attribute will allow you to track the progress of each server in terms of how many attributes have been certified out of the total number of desired attributes.
5. Certification completion percentage: This attribute will allow you to track the overall progress of the data certification process across all servers by calculating the percentage of servers that have been fully certified.

To separate the tasks for each 7 day cycle, you could add a filter to your dashboard that only shows data certification results for servers that were last certified within the past 7 days. You could also consider adding a chart or graph that shows the trend in data certification completion over time, which would allow you to identify any trends or patterns in the data.

Overall, by using these attributes and visualizations, you should be able to effectively track the progress and completion of your data certification process

[Syedmd08]

One possible solution to your problem could be to use ServiceNow Performance Analytics to create a dashboard that displays the progress and completion of your data certification tasks.

Here are some attributes that you could use to create your dashboard:

1. Task completion status - You can create a field on your data certification task record that indicates whether the task is complete or not. You can then use this field to track the completion status of each task.

2. Server deployment date - You can create a field on your server record that indicates when the server was deployed. You can then use this field to group your data certification tasks by the week of the server deployment.

3. Task due date - You can create a field on your data certification task record that indicates when the task is due. You can then use this field to track the progress of each task and to ensure that tasks are completed on time.

4. Task assignee - You can create a field on your data certification task record that indicates who is responsible for completing the task. You can then use this field to track the progress of each assignee and to ensure that tasks are assigned and completed in a timely manner.

Using these attributes, you can create a dashboard that shows the completion status of your data certification tasks for each week of server deployment. You can also track the progress of each task and assignee, and ensure that tasks are completed on time.

Please mark my reply as Helpful and/or Accept Solution, if applicable. Thanks!

[Jimmers]

Thanks Sankar, We'll take a look at this!

[Mercedes Pons 1]

Hi, I would like to follow up on this topic.  Is there any way to report on what CIs (specific classes) don't have any Certification Task associated?  I want to report what servers have a Cert Task and which ones don't have any.  I've tried Query Builder but I cannot do a Left join... not sure how to do this.

Thank you