We have to do a lot of queries every (late) evening. So I would like to speed it up with favourites.
The first query is to ask for all incidents which came up over the day.
When I save it and move it to the menue "Favourites and Dasboards", the query looked at 17:49:22 like:
Query: security.id#"MD000069" and open.time>='16/10/15 00:00:00'
Normalized query: security.id#"MD000069" and open.time>=tod() - '17:49:22'
But it is NOT the same like:
security.id#"MD000069" and open.time>=date(tod())
I do not understand this, because date(tod()) should be the beginning of today.
How will I have to change the query so that I can use it every day?
We would like to find out how much/ which incidents were resolved between yesterday 19:00 and today 19:00 (=07:00 PM)
SM9 generates at 06:02PM:
query: security.id#"MD000069" and (resolved.time>='15/10/15 19:00:00' and resolved.time<='16/10/15 19:00:00') Normalized query: security.id#"MD000069" and (resolved.time>=tod() - '23:02:23' and resolved.time<=tod() '00:57:37')
I tried to convert it for everydays use
security.id#"MD000069" and (resolved.date>=date(tod() - '05:00:00') and resolved.date<=date(tod() '19:00:00')
but this is totally wrong (Invalid syntax for query.Failed parsing (display.show.rio).
How would it be correct?
Where can I find some informations about the parameters of tod() or date(tod())?
HP Service Manager-Client Version 7.11.655 P21
HP Service Manager-Server Release 9.34.4014 Build P4HF6