Data collection jobs Performance Analytics

pvanderlecq
Giga Contributor

10 hours ago

Dear friends,

 

I run into a problem around data collection jobs for Performance Analytics. My goal is to have a daily job that runs every morning 2 AM UTC +2.  I collect all records of the table sn_vul_vulnerable_item with a closed date of Yesterday. However, what I see at the job of 15th of September, is the following:

pvanderlecq_1-1757921309282.png

It seems that it takes data from the day before Yesterday, instead of yesterday. I would like to have the data of the day before.

 

Moreover, I see that it takes records that are closed between 10 pm and 10 pm, instead of 00:00 - 23:59, is this correct due to my timezone of UTC +2 or do I have to adjust anything in my settings to get 00:00 - 23:59 for my instance?

 

These are my collection parameters.

 

pvanderlecq_0-1757921249912.png

 

I hope anyone could help!

0 Helpfuls
  • 199 Views
2 REPLIES 2

sizzleMcFace
Mega Guru

10 hours ago - last edited 10 hours ago

If you set up the job to run at 02:00 and collect the previous day's records, you have 2 options:

  • The Indicator source should have "Closed on Today" & the job should run for "Relative start = 1" & "Relative end = 1"
    • This means that when it runs today 09/15, it goes back 1 day relative to today, so "Today" means 09/14.
  • The Indicator source should have "Closed on Yesterday" the job should run for "Relative start = 0 & Relative end = 0"
    • This means that when it collects today, 09/15 it collects tickets closed on 09/14. This is not best practice because numbers for 09/14 would be recorded for 09/15.

The first option is the better practice. On the job, you can set the timezone for which to run. If that is set up correctly, you don't have to do anything else.

Bhuvan
Kilo Patron

9 hours ago - last edited 9 hours ago

@pvanderlecq 

 

Relative Start=1 and Relative End=1 would collect yesterday's score. Change the indicator data collection configuration  accordingly

 

Check your data collection configuration and schedule the timezone as per your requirement, by default system time zone is used

Bhuvan_1-1757924516730.png

Refer below documentation for more details

 

https://www.servicenow.com/docs/bundle/zurich-now-intelligence/page/use/performance-analytics/task/t...

 

If my response helped to answer your query, please mark it helpful & accept the solution. As per community guidelines, you can accept more than one answer as accepted solution. 

 

Thanks,

Bhuvan

0 Helpfuls