How to get the datacollector date in automation scripting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2025 10:21 AM
Hi all,
I'm trying to create a daily snapshot of my backlog tickets and with pain and suffering I finally got this code to almost work:
(function(dataCollector) {
var count = 0;
// Test date
// var scoreDate = new GlideDateTime('2025-02-05 00:00:00');
// Get the collection date
var scoreDate = dataCollector.getScoreDate();
var scoreDay = new GlideDateTime(scoreDate.getDisplayValue().split(" ")[0] + " 00:00:00");
var endOfDay = new GlideDateTime(scoreDate.getDisplayValue().split(" ")[0] + " 23:59:59");
// --- Closed late on this day ---
var closed = new GlideRecord('incident');
closed.addQuery('active', false);
closed.addQuery('closed_at', '>=', scoreDay);
closed.addQuery('closed_at', '<=', endOfDay);
closed.query();
while (closed.next()) {
var slaDueStr = closed.sla_due.getValue();
if (!slaDueStr) continue;
var slaDueDT = new GlideDateTime(slaDueStr + ' 23:59:59');
if (closed.closed_at.getGlideObject().compareTo(slaDueDT.getGlideObject()) > 0) {
count++;
}
}
// --- Still open and overdue as of this day ---
var open = new GlideRecord('incident');
open.addQuery('active', true);
open.addQuery('sla_due', '<', scoreDay.getDate()); // Compare against date only
open.query();
while (open.next()) {
count++;
}
answewr = count;
})(dataCollector);
The issue is that I can't get the datacollector score date. Tryed so many ways without any luck.
This line is the issue:
Here are my questions:
- How to pass the datacollector scoredate in an Automation Script that is attached to an indicator.
- Am I adrressing this the right wway? Is there an easier way.
Let me know thanks.
#Yokohama
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2025 10:55 AM
Hi @Richard Moreau ,
There is a typo error in your last line:
answewr = count;
it should be answer = count.
Your approach is good. As far as I know dataCollector.getScoreDate() — only works inside PA indicator scripts.
Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P