Web Sites Table and the Common Service Data Model

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2025 04:42 PM
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).
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.