Re: [ADSM-L] SV: Exchange 2010 TDP Backups - SQL reporting queries
2011-11-27 14:00:45
> 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>
>>
>
|
|
|