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