Video Screencast Help

Anybody Know How to rename BackupSelection List ?

Created: 09 Jul 2013 • Updated: 21 Aug 2013 | 6 comments
This issue has been solved. See solution.

System :

  • Windows 2008 R2
  • Running BackupExec 2012 (with all hotfixes installed).
  • IBM 3650 with IBM 2xDiskBay 3512 SAS Connected (SATA Drives)(4 Virtual Tape Labraries on 1 storage pool called "backup-to-disk")
  • IBM TS3100 LTO5 Tape Library SAS connected.

 

Here is my question :

 

   BackupExec was unable to provide me daily report of my backups results, so i maded a SQL query to extract it directly from BEDB.

Here it is (sorry comments are in French - cause i'm actually French !!):

SELECT DISTINCT [ScriptName] "Server", [JobName]
--        Je convertir les format date/heure pour une meilleur lisibilité
      ,CONVERT(varchar,[ActualStartTime],103) "DateDebut"
      ,CONVERT(varchar,DATEADD(hour,2,ActualStartTime),108) "HeureDebut"
      ,CONVERT(varchar,[EndTime],103) "DateFin"
      ,CONVERT(varchar,DATEADD(hour,2,[EndTime]),108) "HeureFin"
      ,CONVERT(varchar,DATEADD(s,[ElapsedTimeSeconds],0),108) "ElapsedTime"
--        Traduction du code de retour d'etat de sauvegarde
      ,Result =
      CASE FinalJobStatus
        WHEN '19' THEN 'Successfull'
        WHEN '6' THEN 'Failed'
        WHEN '3' THEN 'Success With Exceptions'
        END
      ,[DeviceName]
--      ,[TargetName]
      ,[MediaSetName]
 --        Conversion du volume sauvegardé pour que se soit plus lisible
       ,TotalDataSize =
      CONVERT(varchar,[TotalDataSizeBytes]/1024000) + ' Mo'
      ,[TotalRateMBMin] "Vitesse MB/min"
      ,[TotalNumberOfFiles] "Nb Fichiers"
      ,[TotalNumberOfDirectories] "Nb Dossiers"
      ,[TotalSkippedFiles] "Fichiers Ignorés"
      ,[TotalCorruptFiles] "Fichiers Corrompus"
      ,[FinalErrorDescription] "Description de l'erreur"
FROM [BEDB].[dbo].[JobHistorySummary]
--        Selection des sauvegardes de la veille J-1
WHERE ActualStartTime > GETDATE()-1
--        Je ne selectionne que les 'Backup' et pas les duplications
AND TaskTypeID='200'

 

 So the result is good but "ScriptName" field return a value like "Backup Selection List 0651" that i can't modify or even find out in any job configuration windows on BACKUPEXEC 2012. (On other jobs which were migrated from 2010 R3 version Scriptname Display the server Name)

 

 SO WHERE CAN WE MODIFY BACKUP SELECTION LIST NAME ?

 

Operating Systems:

Comments 6 CommentsJump to latest comment

Jaydeep S's picture

You cant modify this in BE 2012. Also, running SQL querries against the BEDB is not really recommended. Having said that, this is a nice work around.

SOLUTION
pkh's picture

You don't have to go true all this trouble if you want a report of your backup results.  You can either use one of the reports or use the BEMCLI cmdlet, Get-BEJobHistory.

CraigV's picture

...put it in as an Idea. Something else left off BE from previous versions!

https://www-secure.symantec.com/connect/backup-and...

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

Colin Weaver's picture

I agree nice script and whilst we do not approve of manually manipulating our BEDB, if you are only running queries and not editing, it should not be a major issue, so I will add some perhaps useful info. Based on you trying to get the Server Name from your Script Name. Try the following JOIN Statement modifications (3 lines changed or added) to your script (which may not work for duplicate jobs): NOTE: we do from time to time change the schema and table design within the BEDB so just because a script works for one version of BE is no guarantee it will work for another.

 

SELECT DISTINCT [DeviceSelectionName] "Server", [JobName]

-- Je convertir les format date/heure pour une meilleur lisibilit

,CONVERT(varchar,[ActualStartTime],103) "DateDebut"

,CONVERT(varchar,DATEADD(hour,2,ActualStartTime),108) "HeureDebut"

,CONVERT(varchar,[EndTime],103) "DateFin"

,CONVERT(varchar,DATEADD(hour,2,[EndTime]),108) "HeureFin"

,CONVERT(varchar,DATEADD(s,[ElapsedTimeSeconds],0),108) "ElapsedTime"

-- Traduction du code de retour d'etat de sauvegarde

,Result =

CASE FinalJobStatus

WHEN '19' THEN 'Successfull'

WHEN '6' THEN 'Failed'

WHEN '3' THEN 'Success With Exceptions'

END

,[DeviceName]

-- ,[TargetName]

,[MediaSetName]

-- Conversion du volume sauvegard pour que se soit plus lisible

,TotalDataSize =

CONVERT(varchar,[TotalDataSizeBytes]/1024000) + ' Mo'

,[TotalRateMBMin] "Vitesse MB/min"

,[TotalNumberOfFiles] "Nb Fichiers"

,[TotalNumberOfDirectories] "Nb Dossiers"

,[TotalSkippedFiles] "Fichiers Ignors"

,[TotalCorruptFiles] "Fichiers Corrompus"

,[FinalErrorDescription] "Description de l'erreur"

FROM [BEDB].[dbo].[JobHistorySummary]

JOIN [BEDB].[dbo].[BackupScriptEntries] ON (JobHistorySummary.ScriptID = BackupScriptEntries.ScriptID )

-- Selection des sauvegardes de la veille J-1

WHERE ActualStartTime > GETDATE()-1 AND Sequence = 0

-- Je ne selectionne que les 'Backup' et pas les duplications

AND TaskTypeID='200'

mirion's picture

Thanks so much for your help, And yes i only run queries reading informations from your DB.

the result is not really what i was expected but we're close.

 

THanks to all of you.

 

 

Colin Weaver's picture

Unfortunately because a "selection list" is no longer a visible object in the BE 2012 console, then being able to rename it is not considered as something that customers need to be able to do, as if you cannot see it then whatever name it is given is unimportant.  As we do not officially support customer SQL queries direct from the database then there is no justification to put this feature back into the product.

Putting in a new default report to do what you have asked for however is a different thing and would make a good enhancement request.

It is however possible that we might bring back some form of selection list to handle bringing back multiple servers in one backup job - if we do then renaming this may well become an option again. This will not be in this version of Backup Exec and exact details of any changes cannot be confirmed at this point.