Exchange 2010 TDP Backups - SQL reporting queries
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.SE<mailto:Christian.Svensson < at > CRISTIE.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.se<mailto:Christian.Svensson < at > cristie.se>
Supported Platform for CPU2TSM::
http://www.cristie.se/cpu2tsm-supported-platforms
________________________________________
Från: Leonard, Matthew [Matthew.Leonard < at > ATLASAIR.COM<mailto:Matthew.Leonard < at > ATLASAIR.COM>]
Skickat: den 27 november 2011 08:09
Till: ADSM-L < at > VM.MARIST.EDU<mailto:ADSM-L < at > VM.MARIST.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.com<mailto:Matthew.Leonard < at > AtlasAir.com><mailto:Matthew.Leonard < at > AtlasAir.com>
