Interactive filter on dashboard - filter cmdb_rel_ci report by Asset Tag

nathanpalin
Tera Contributor

Exploring the possibility of having a dashboard for end-users that shows Parent/Child relationships (for all types of configuration item) as a List, that can be filtered by providing an Asset Tag string (eg. dashboard reports filter to show all Parent/Child relationships involving CI123456). So if a particular CI was attacked we could filter by Asset Tag to show hardware and software dependencies in report format, rather than as a map.

 

So I created an Interactive Filter first pointing at the cmdb_rel_ci table and then the cmdb_ci table, after an unsuccessful attempt. Reference type interactive filter doesn't support String, and I cannot get the Dynamic Content workaround (as seen here: Solved: Create interactive filter to search on string type... - ServiceNow Community, and elsewhere) to work, despite replacing mentions of Short Description to asset_tag, and Task to another table.

 

What are my options, please? Bare in mind, I have VERY limited knowledge on code. ðŸ˜…

 

First row of example report below, for context.

nathanpalin_0-1743414763511.png

 

Thanks!!

0 REPLIES 0