ADSM-L

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

2011-11-27 14:00:45
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 18:51:51 +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>
>> 
> 

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