CMDB Query Builder Schedule creating more & more duplicate records each scheduled run

[Sisyphus]

Hi All,

I've recently created a CMDB Query in the CMDB Query Builder that I have selected to run every day in the morning. It's function is to discover all the servers for each business application and on the first run it's working fantastic. However, everyday it the schedule runs it seems to duplicate the business applications it returned (i.e. Day 1 it returned 1 business application, day 2 2 duplicate business applications, etc.).

I'm new to ServiceNow and reporting and was just wondering whether there is a way to stop it duplicating these entries for every run or whether there was something I missed when configuring it in CMDB Query Builder? Thanks

[JenniferS777]

Did you get any answers on this? I have the same happening. 

[KamranKhan]

This is because every time the schedule is executed, it creates a new query id.  When looking at your results table, you should add a filter with the latest query id so that you're always looking at the latest results of the query expression.

[Mercedes Pons 1]

Hi, this happened to me and I found out that when I create the report directly from Query Builder interface, it creates a report that is updated, and it doesn't duplicate the results every time the schedule runs.

When I create the reports from "Create Report" and select the Table query, it's when i get duplicates, but if I create the report from the Query Builder interface, it works fine.  I hope it helps.