Business Application with Information Object Relationship - How it's calculated? - Support and Troubleshooting

Business Application with Information Object Relationship - How it's calculated? Issue .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } In the CSDM Data Foundation Dashboard, under the 'Fly' tab, the relationship between the Business Application and Information Object may display a lower percentage than anticipated. This article will clarify how this percentage is calculated.

Release .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Based on Zurich Patch 7

Resolution .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } To calculate the percentage, you can use the following formula:

Percentage = (Business Apps with an InfoObj relationship ÷ Total Business Apps) × 100.

Alternatively, this can also be expressed as:

Percentage = 100 - (Missing Business Apps ÷ Total Business Apps) × 100.

To verify that the percentage displayed is accurate, please use the links below in your instance.

Business Apps with an InfoObj relationship:

https://[instance_name].service-now.com/cmdb_rel_ci_list.do?sysparm_query=parent.sys_class_name%3Dcmdb_ci_business_app%5Echild.sys_class_name%3Dcmdb_ci_information_object%5EGROUPBYparent&sysparm_first_row=1&sysparm_view=

Total of Business Apps: https://[instance_name].service-now.com/cmdb_ci_business_app_list.do?sysparm_userpref_module=11133b75870003005f9f578c87cb0bfe&sysparm_view=business_application_readonly&sysparm_clear_stack=true

With this information, you can calculate the percentage yourself.

Use the following script to see which CIs don't have a relationship with cmdb_ci_information_object.

var parentIds = [];

var rel = new GlideAggregate('cmdb_rel_ci'); rel.addQuery('parent.sys_class_name', 'cmdb_ci_business_app'); rel.addQuery('child.sys_class_name', 'cmdb_ci_information_object'); rel.groupBy('parent'); rel.query();

for (; rel.next();) { parentIds.push(rel.getValue('parent')); }

var apps = new GlideRecord('cmdb_ci_business_app'); apps.query();

var count = 0; for (; apps.next();) { var sysId = apps.getValue('sys_id'); if (parentIds.indexOf(sysId) === -1) { gs.info(apps.getValue('name') + ' | ' + sysId); count++; } }

gs.info('Total WITHOUT Info Object relationship: ' + count); This script can be run in System Definition > Scripts - Background, and set the scope = global.