We have our CMDB being updated by a multitude of data sources. We are using CMDB 360 to handle the majority of reports/queries but it doesn't let you get more specific. We are trying to query the [cmdb_multisource_data] table to check and see:
1.) How many CIs are being discovered by SG-SCCM?
2.) Of those CIs how many are also being discovered by SG-Crowdstrike?
3.) How many of the CIs from point 1 are being discovered by Rapid7?
Hopefully the end game would be some sort of chart depicting the number of SCCM CIs/SCCM CIs that aren't being discovered by Crowdstrike/SCCM CIs that aren't being discovered by Rapid7.
After playing around with CMDB360 smart queries and the report builder the only thing I can think to do is to write a script include for the query. With ServiceNow trying to move more towards low code I wanted to check and see if that was our only option? Any help would be appreciated, thank you.
