CA Service Management

Hello All,

I am looking to create time based stored queries which will be used for aging i.e. requests > 30 days old (from open date) , requests between 31 days and 60 days old, etc. I have attempted to create a few but am receiving errors. Please assist. Thanks in advance.

Here is what I have so far: type \'R\' AND open_date > StartAtTime (\'TODAY\') + 30

What specific errors are you receiving?

ADH05800: Bad where clause, invalid constraint. Could not recognize +

Hi Chavarousk  - Did jmayer 's response help answer your question? If so please mark as Correct Answer. Thanks!

well you need to create your timestamp with start and end date. for the evaluation not doing the math inside the query itself

look there for idea that I just responded this morning:

Stored Query based on mins

A quick search in community is always helpful

/j