Solved

Selecting/listing failed backups from TSM backup server

Posted on 2013-06-05
1
1,196 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
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.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

830 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