Stored Query - Open Tickets last 30 minutes

[thiagooliveira]

Hello Guys,

 

It is possible to create stored query to list the last 30 minutes open tickets?

I need to stored querys to last 30 minutes, last 45 minutes and last 1 hour.

 

I create this to list the tickets open in last hour.

 

active = 1

AND open_date > StartAtTime(\'LAST_HOUR\')

Thank you very much.

[Giedrius Bekintis]

You need to add new time span for 30 min under Administration->Service Desk->Application Data->codes->timespans

I think start time should be -30 min and trigger +30 min

[Zhijun He]

Hi,

Yes, you can create new timespan as Guitis suggested.

 

But I would like to remind you, don't over use the timespan stored queries.

As each timespan stored query will refresh itself regularly, (if my memory is right, it will be done for each logged in analyst), too many timespan stored queries could cause severe performance problem -- your database could be flooded with SQL of the timespan stored queries.

 

Regards,

Mark