Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Automated Indicator for a Dot Walked Field

jacobsmith1
Tera Contributor

Hi everyone, I've been working on trying to create an Automated Indicator that shows a count of Discovery Model Products. The issue I've been having is that I need to dot walk over from the Software Installation table to the Discovery Model table to the Product field for this indicator (Software Installation > Discovery Model > Product). Now when I try to do this I only get a count of the installations and not the products. My scripts that I've tried to make for this have not worked as in I don't get any data when I try to do a collection job. I've been attempting to maybe do a Facts Table from a database view but I'm very inexperienced with it and am not sure if it will work anyway. Does anyone have any experience with this and can offer advice on how they accomplished this?

3 REPLIES 3

KB
Tera Contributor

Are you able to use the "Count Distinct" option thats found in graph type reports?

jacobsmith1
Tera Contributor

Yes I am, the main issue is that I can't group it by the Product. It only shows the installation count.

jacobsmith1
Tera Contributor

Yes I am, I can only see the count of Installations though and not the Product.