question CMDB Query Builder Schedule creating more & more duplicate records each scheduled run in ServiceNow AI Platform forum

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

Sisyphus — Thu, 04 May 2023 23:47:18 GMT

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

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

Community Alums — Thu, 20 Jul 2023 12:17:07 GMT

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

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

KamranKhan — Mon, 12 Aug 2024 12:04:50 GMT

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.

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

Mercedes Pons 1 — Tue, 20 Aug 2024 20:28:11 GMT

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.