Asset Management Suite

It is important to know status of recent Symantec_CMDB database backups.That can be achieved directly in SMP Console.

That can be easily achieved via report in SMP Console.

• You should be aware of timing and duration of each backup, so that you can schedule other DB-intense jobs accordingly.
• You also need to be aware of successful backup completion, to be assured that restoration is possible whenever needed.

We have created following report, and placed it under Reports > Notification Server > Server > Database

CMDB backups can be full, differential or transaction log - that also depends on DB Recovery Mode you have selected.

Report contains accurate information about:

• Backup start, end, duration
• Backup size
• Backup type:
  • D = Full
  • I = Differential
  • L = Transaction Log

This report will display any backup taken - either via SQL Studio or 3rd party Backup Tool, both manual and scheduled.

You can visualise these data by few clicks - export data to Excel and create bar-graph:

That will give your managers easy-to-understand graphical view of all backup activities.

You can also visually observe any abnormal duration or size, and take corrective steps accordingly.

Another option you may consider is setting up email notifications - see instructions in this article:

• How to setup Notification Emails for 7.0?

===  HERE ARE STEPS  ===

You can create your own Last Database Backup report this way:

1. Go to Reports, navigate to location mentioned above, or any other you like.
2. From context menu select New > Reports > Computer Report
3. In SQL query window, paste following query:

SELECT TOP 100 database_name as [Database Name], backup_set_id as [Backup Set ID], type as [Type],
backup_start_date as [Backup Start Date], backup_finish_date as [Backup Finish Date],
  datediff (second,backup_start_date, backup_finish_date)as [Time To Complete (Seconds)]
  ,convert (bigint, backup_size / 1048576 ) as [Size In MB] 
FROM msdb..backupset
--where type = 'D' – for full backup
WHERE database_name like 'Symantec%'
order by backup_finish_date desc

Alternatively, you can import report I have attached for you below.