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.

Historical Data from Indicator Source Best Practice

Mike Rae
Kilo Guru

‎08-29-2017 09:39 PM

Initially my Indicator Source only pull records created ON TODAY.   The problem I had was when I ran a historical job it only pulled records for the current day and 0 records or all historic days. As a solution I followed an OOB example I found here on the community to use ON TODAY and BEFORE TODAY shown below.

find_real_file.png

The new indicator source works great but every day it collects a lot of extra data. What I'm confused about is Isn't this going to collect all records everytime the job runs going forward?   So when my daily job runs overnight, will it pull all records from the source table?  

Is this the best way to do this, or am I missing something?

Thanks,

Mike

Labels:
Preview file
86 KB
0 Helpfuls
  • 3,632 Views
5 REPLIES 5

Mike Rae
Kilo Guru

‎09-01-2017 03:19 PM

I have been trying out the all of the suggestions I have seen.   No matter what I did the Job was fetching 0 records.   Following what Pieter Goris said, the blue link was showing 1000+ records for the source but the Job would return 0.  



That being said I got it working.   I set the Source to pull Created ON YESTERDAY and I fetched 0 records.   I decided to change the field I was pulling and tried Processed_on ON YESTERDAY and everything started to work.   So it is working but I'm not sure why,


0 Helpfuls