Solved

Selecting/listing failed backups from TSM backup server

Posted on 2013-06-05
1
1,133 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 500 total points
ID: 39221420
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now