[BCM] How can we create reports that display full information on dependencies captured in the BIA?

[Mickey Goldstei]

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.

[Connor Levien · Accepted solution]

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!

[Mickey Goldstei]

Hey Connor,

I've tried this solution out and it seems to have worked. I am able to see the values in a database view.

Thank you!

PS. I have a similar question, but related to the BIA PDF form. Should I open a new thread for this?

[Connor Levien]

Glad to hear it worked!

Its best to open a new thread so its easier for others to find the question in the future if they run into the same question! Just feel free to tag me in your new thread and I will look at it when I can