- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2023 10:47 AM
Hello team,
In the BIA form, we've created additional columns that apply to our dependencies (Software, Locations, etc.) using the Grid Categories/Grid Configurations tables.
My question is:
How can we create a report that displays this information? For example, I want a report that shows all software dependencies across my organization and values for the custom columns that we've added in the BIA form.
There does not seem to be an easy way to find the data table that contains this data.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2023 04:42 PM
Hey @Mickey Goldstei, sorry for the delay responding! So I checked and the element variables values actually get stored in the sys_variable_value table. One way to report on this is to create a database view which joins the dependencies table and the variables table.
The below support KB article details how to do that with another table. You would just have to change wf_context to sn_bia_dependency and change the variable name if you want.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0864252
I will raise this with the product team to get this better documented!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2023 08:04 PM
Hey @Mickey Goldstei,
You would want to run a report on the sn_bia_dependency table which actually stores the dependencies. Depending on what fields you want to report on you can dotwalk to the BIA form from the dependency table via the "Dependency group field". This should allow you to make a report across all BIAs and all your dependencies.
Hopefully that help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2023 10:33 AM
Hey Connor, thank you for the reply.
I have followed this documentation and created a few distinct custom columns for various dependency group types. In the BCM Workspace, these columns appear under the 'Additional Details' section of a dependency record (first 2 images). This is the data that I am not able to display within a table/report. I also do not see a way to dot-walk to it.
In the sn_bia_dependency table, the 'Additional Details' column shows "(empty)" values (third image). So aside from navigating to the individual BIA, I cannot view this additional dependency data.
Any help here would be appreciated.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2023 06:25 PM
@Mickey Goldstei based on what you have shared you will have to add the fields to the list view. The grid configuration doesn't update the list layout in the classic view.
To do this you need to right-click on the table header and then add the fields. See the below screenshot of where to click to configure the list layout. You could also do this via personalising the list but that will only be visible to you.
You will then be presented with the list layout view, you will have to change to the right scope to make the changes but once you do you will be given the view below. Yours will look different but your custom fields should be in the Available section and you can bring them over to the selected section and they will appear.
The "Additional Details" column is a custom column to you have added to the form and is different to the section in your first screenshot. You need to add the fields "Transactions", "Contingency Strategy", "Original Data Source", and "Description of Contingency Strategy" as they are the actual fields where the values are stored.
Let me know if that helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2023 07:23 AM
Hey Connor,
Unfortunately, I cannot find the fields that I added in the grid configuration in the List Layout for the 'Dependencies' table. There does not seem to be a way to dot walk to them. It is interesting to note that I cannot select the 'Additional Details' column from this view, but it is available for selection when I personalize my columns.
The fields that I've added as part of my grid configurations are stored in the 'Element Variables' table:
However, I cannot look for them nor add them to the above 'Dependencies' list layout.
Do you think you can try creating grid configurations and additional fields on your end? Maybe I am missing something...
Thanks!