Search:

But I don't really understand why this works :D

This one works!
Thank you!

Hi,

My problem is that I want to use the current_timestamp, so I don't have to rewrite the date every time I want to use the script.

TSM version 5.5

Hi all,

These 2 scripts give back different results:

With timestamp:


select distinct events.node_name, events.status, nodes.platform_name from events, nodes where...

Many thanks all for the help.
Hope this will get corrected in the new patches.

Hi,

With this variation the script works, but it only displays the jobs from today (as of midnight) not from yesterday :D
(gives the same result if I use -2 day).

This thing is really...

Tried on:
Version 5, Release 5, Level 1.0
Version 5, Release 4, Level 2.0

This is what I tried and it's not working:

With your modification:
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.


With the original:
NODE_NAME ...

Hi,

I use a really simple script to show me the failed & missed jobs from yesterday, but I have to rewrite the date every time I use it, is there a way to replace the actual date with a variable?...