ADSM-L

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

2011-11-27 16:16:42
Subject: Re: [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 21:14:52 +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<mailto: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<mailto: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<mailto:Matthew.Leonard AT ATLASAIR DOT COM>]
Skickat: den 27 november 2011 08:09
Till: ADSM-L AT VM.MARIST DOT EDU<mailto: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><mailto:Matthew.Leonard AT AtlasAir DOT com>

<Prev in Thread] Current Thread [Next in Thread>