Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Selecting/listing failed backups from TSM backup server

Posted on 2013-06-05
1
Medium Priority
?
1,318 Views
Last Modified: 2013-06-06
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
Comment
Question by:itnifl
1 Comment
 
LVL 6

Accepted Solution

by:
Kiran Ch earned 2000 total points
ID: 39221420
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question