• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1379
  • Last Modified:

Selecting/listing failed backups from TSM backup server

I want to get all backups that have failed from a TSM server:

SELECT scheduled_start, (current_timestamp-24 hours) as 24h, (current_timestamp-24 hours) - scheduled_start, scheduled_start > (current_timestamp-24 hours) FROM events

This select statement only selects failed backups until midnight the same day.

* current_timestamp-24 hours shows a date and time that is 24 hours ago.
* HOUR(current_timestamp-24 hours) shows the amount of hours from current time until midnight, not 24 hours.

I want a select statement that does much the same as this:
q event * * begint=18:00 begind=today-1 endt=now endd=today ex=yes
0
itnifl
Asked:
itnifl
1 Solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now