CA Service Management

  • 1.  Stored Query - Open Tickets last 30 minutes

    Posted 04-20-2015 02:22 PM

    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.



  • 2.  Re: Stored Query - Open Tickets last 30 minutes

    Posted 04-20-2015 03:55 PM

    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



  • 3.  Re: Stored Query - Open Tickets last 30 minutes

    Broadcom Employee
    Posted 04-20-2015 08:31 PM

    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