Creating a Sample of Incidents.

[keefah]

Hi all, hopefully I'm posting this in the right place.

We've been asked by management to create a way of randomly generating a number closed incidents from that month.

They would like to check 10% of our closed tickets every month and we're hoping there's way of generating that amount of tickets automatically/randomly.

We're using Service Now Express and I'm aware that doesn't allow for scripting but I'm hoping that there's another way of getting this.

Thanks for any help.

[Ankush13]

What do you mean by randomly generating number closed incidents? Why not schedule a monthly report of all incidents that were closed in the last 30 days and picking incident numbers randomly out of it for inspection?

[keefah]

I think that's what the current plan is, but I believe management were hoping to automate the process of picking the 10% of tickets.

Thanks for your help though.

[Ankush13]

If you truly want to randomize, you can write a script that takes all the incidents resolved within a time frame, randomize those incidents, calculate 10% of the total incidents count, separate the incidents(10%) from original array of all the resolved incidents(from first step) and finally inject that script into a report which you can then schedule monthly. You would need to return array of sys_ids for this to work.

You see it can be messy but is doable of course. The question you need to ask is whether its worth the time and effort.