Dot-walking from Storage Device table to Service Offering Name to be presented in a list Report

Faycal
Tera Contributor

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.

Faycal_0-1749201102578.pngFaycal_1-1749201145532.png

 

 

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!

2 REPLIES 2

Pratiksha
Mega Sage
Mega Sage

Hi, can you explain the use case again. I mean whats the end goal for this. 

Faycal
Tera Contributor

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.