Here's a tool I wrote to help me figure out why my discoveries canceled.
It takes the number of a discovery as an argument and searches through all the ecc_queue records looking for output records that have no corresponding inputs.
You can then get a list of the sys_ids of the orphaned outputs, or you can get a CSV with selected fields.
There is also a UI action for the Discovery Status form to collect the list and display them on the ecc_queue.
Now, when a discovery cancels, I just go to the status page, run the orphan finder, and I can quickly find a list of the problematic probes.
// Search through the ecc_queue records for a discovery.
// Usage to get sys_id's:
var finder = new FindDiscoveryOrphans('DIS0010005');
var sysIDs = finder.find();
gs.print('' + sysIDs);
// Simple CSV:
var finder = new FindDiscoveryOrphans('DIS0010005');
var csvOut = finder.findCSV();
gs.print('' + csvOut);
// CSV with custom separator, field list:
var finder = new FindDiscoveryOrphans('DIS0010005', '/', ['sys_id', 'sys_created_on', 'agent', 'topic', 'name']);
var csvOut = finder.findCSV();
gs.print('' + csvOut);
