TDPSQL failed backup in last 24 hours

[dudure]

hi to everybody

i write a little script that check SQL servers Failed Last 24 Hours
here is the command -
select MESSAGE from actlog where MSGNO=4993 and (cast((current_timestamp-date_time)hours as integer)<24)

i want to add filter by node or several nodes

Thx

David.

 

[moon-buddy]

For all nodes with MSGNO=4993:

select MESSAGE,nodename from actlog where MSGNO=4993 and (cast((current_timestamp-date_time)hours as integer)<24)