Web Sites Table and the Common Service Data Model

Louis R Ronzitt
Tera Guru

Anyone know of another way to obtain greater value from the Websites table?

 

Specifically, 

 

1. The Horizontal Discovery Log pattern (below link) in Step 7 is capturing the website (e.g., cams.sdcounty.ca.gov).

 

https://yourinstance.service-now.com/$sw_horizontal_discovery_log.do?discoLogId=6fb12cc783106a50b766...

 

2. We could update this pattern in Step 7 to populate a new URL field (u_url) that we would create on the Websites table (cmdb_ci_web_sites).

 

3. Then, we would add a field called Business Applications (u_business_apps) that would reference the business application table (cmdb_ci_business_app) and automatically populate this field by looking at the server; Web Server field on this table where the server name is directly after the @ sign. 

 

For  example, if the Web server in that field is called 'Microsoft IIS Server@servername' then we only look at the 'servername' part of that string.

 

5. Once we have the servername, we can then see which Application Service or Dynamic CI Group is consumed by the business application and from there we can determine which business application consumes that Application Service or Dynamic CI Group.

 

5. We can then also dot walk in any other business application fields needed into the Web Sites table.

 

All of this would provide additional value for this table, since on its own it's disconnected from the Common Service Data Model (CSDM) and therefore of limited value.

 

Please also upvote this idea if you think that its useful.

 

Web Sites Table and the Common Service Data Model

0 REPLIES 0