Dot-walking from Storage Device table to Service Offering Name to be presented in a list Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2025 02:16 AM
Hi Community,
I'm currently building a maintenance plan report in ServiceNow, starting with the cmdb_ci_storage_device table. My goal is to add a column that displays the Service Offering Name associated with each storage device.
Here's the challenge: When I open a Configuration Item (CI) like a cmdb_ci_win_server (which I can dot-walk to from cmdb_ci_storage_device via the computer field), I can see the Service Offering Name in the Related Items section after applying specific view settings.
This is exactly the information I want to pull into my report (used by Offerings Name.
I'm looking for the best way to achieve this. Can you help me? I'm wondering if a Database View (Join View) might be the right approach.
Using a different source table for my report isn't really an option because I need to include details like the storage device's size and name, which are directly accessible from the cmdb_ci_storage_device table.
Any guidance or examples on how to link these tables and pull in the Service Offering Name would be greatly appreciated!
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2025 03:11 AM
Hi, can you explain the use case again. I mean whats the end goal for this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2025 08:02 AM
Hi, basically I would like to show the Service Offerings name field in my report list.
Here is a little update I made from the last post.
DATA source = CI Relationship [cmdb_rel_ci] and from here I dot walk to Parent and can get all the info I need except Service Offering Name.
so for example if my "Parent Ci" is a Windows Server found in [cmdb_ci_win_server] once open the record and I go to the related Items in the form you will see :
used by - Offerings --> ( i ) Hosting (NAME) I want this NAME which is basically the Service Offering : field Name
Please let me know is you need more info.
Thank you.