Compare Business applications and application services list

[Phanideepthi]

Hi,

We need to compare the Business and Application services name and get the mismatched name.

For example: If we have AD in Business application and Active Directory in Application services. Then how can we get the application that the name is not matching or how can we get the names that are matching.

Please help me

Thanks

[Brian Lancaster]

They don't need to necessary match Business Application is from the business perspective. So for example we rebrand ServiceNow and call it something else. So from a Business perspective it is one name but when it comes to Application Service which is the technical Service which is what should be used in thinks like incident, change, etc. it is called ServiceNow.

They way I have always done comparisons is export into. Then copy the name field from both file into a new one. Then you can use the conditional formatting > highlight > Duplicate values.

[Phanideepthi]

Actually we are having our own status page for business where we will be using Business applications and mapping them with change request for any maintenance of applications. Now in change we are using application services where we are facing issue with name match.

So we need to update all the missing applications in both the tables and match the naming convention. 

[ashishdevsingh]

you can check by querying the cmdb_rel_ci table. 

Build the logic to get the business application and for one BA there must be number of entries. 

Then you can find it out the sys_id of record. Save it into Array and use as your query. (I believe you just need one time)