ADSM-L

[ADSM-L] SV: Exchange 2010 TDP Backups - SQL reporting queries

2011-11-27 13:57:58
Subject: [ADSM-L] SV: Exchange 2010 TDP Backups - SQL reporting queries
From: "Leonard, Matthew" <Matthew.Leonard AT ATLASAIR DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sun, 27 Nov 2011 18:48:55 +0000
Christian, that would be great. Please let me know details or send me the 
script. I guess anymore info I can get automatically would be great. Much 
appreciated.  Currently some scripts outputs I use are below. I would like them 
broken down to database names added. 

1. 
Exchange 2010 Status TSM 24 hour Report for SXDCTSM01 generated at 2011-11-27 
13:30:15 on SXDCTSMADMIN01 covering 2011-11-26 13:30:15 to 2011-11-27 13:30:14

Server name: SXDCTSM01, platform: Windows, version: 6.1.4.5, date/time: 
11/27/2011 13:30:15



Exchange 2010 Backup

Scheduled Start     Actual Start        Schedule Name Node Name Status    
---------------------------------------------------------------------------
11/26/2011 17:30:00 11/26/2011 17:30:06 EXCHANGE2010  EXCHDAG01 Completed 
11/26/2011 17:45:00 11/26/2011 17:45:07 EXCHANGE2010_2EXCHDAG02 Completed
11/26/2011 18:00:00 11/26/2011 18:00:13 EXCHANGE2010_3EXCHDAG03 Completed
11/26/2011 18:15:00 11/26/2011 18:15:36 EXCHANGE2010_4EXCHDAG04 Completed

2.
Exchange 2010 Status TSM 24 hour Report for SXDCTSM01 generated at 2011-11-27 
13:30:15 on SXDCTSMADMIN01 covering 2011-11-26 13:30:15 to 2011-11-27 13:30:14

Server name: SXDCTSM01, platform: Windows, version: 6.1.4.5, date/time: 
11/27/2011 13:30:15



Exchange 2010 Backup

Scheduled Start     Actual Start        Schedule Name Node Name Status    
---------------------------------------------------------------------------
11/26/2011 17:30:00 11/26/2011 17:30:06 EXCHANGE2010  EXCHDAG01 Completed 
11/26/2011 17:45:00 11/26/2011 17:45:07 EXCHANGE2010_2EXCHDAG02 Completed
11/26/2011 18:00:00 11/26/2011 18:00:13 EXCHANGE2010_3EXCHDAG03 Completed
11/26/2011 18:15:00 11/26/2011 18:15:36 EXCHANGE2010_4EXCHDAG04 Completed

Regards,
Matthew J. Leonard

On Nov 27, 2011, at 6:29 AM, "Christian Svensson" <Christian.Svensson AT 
CRISTIE DOT SE> wrote:

> Hi Matt,
> We have a small tool that can send any text string in to TSM Activity Log.
> In that way can you end of each batch job pull out the last couple of lines 
> and send it in to your Activity Log and make sure your backups works fine or 
> not.
> 
> Please let me know if you want to know more.
> 
> Best Regards
> Christian Svensson
> 
> Cell: +46-70-325 1577
> E-mail: Christian.Svensson AT cristie DOT se
> Supported Platform for CPU2TSM:: 
> http://www.cristie.se/cpu2tsm-supported-platforms
> 
> ________________________________________
> Från: Leonard, Matthew [Matthew.Leonard AT ATLASAIR DOT COM]
> Skickat: den 27 november 2011 08:09
> Till: ADSM-L AT VM.MARIST DOT EDU
> Ämne: Exchange 2010 TDP Backups - SQL reporting queries
> 
> Hello all,
> 
> I'm backing up exchange 2010 with four separate schedules - 4 separate 
> command files which each backup two databases. Works great however I would 
> like to be able to pull some reports via tivoli without looking through the 
> "EXCFULL.LOG" or "EXCHACHED.LOG" files. I can pull up the actual schedule 
> details within tivoli but can't figure out how to view the actual database 
> name/details. Does anyone have/know any SQL commands to retrieve detailed 
> reports via tivoli for database backup details? Anymore detail I can get that 
> I can automate would be great. Thanks much
> 
> Matthew J. Leonard
> Infrastructure Administrator
> AtlasAir Worldwide Holdings
> Network Operations Department
> Matthew.Leonard AT AtlasAir DOT com<mailto:Matthew.Leonard AT AtlasAir DOT 
> com>
>