The Enterprise Vault System Status information is very useful for giving you a heads-up of what sort of bad things might be happening in your environment. One of the common flags that System Status raises is around backups of the Enterprise Vault databases. The Enterprise Vault System Status page shows when the databases were last backed up, in fact it shows them all:
Directory
Fingerprint, or Vault Store Group database
Vault Store
Monitoring
The data relating to when the last good backup was performed is obtained by query a SQL Server system table, as shown below:
SELECT
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_start_date,
msdb.dbo.backupset.backup_finish_date,
msdb.dbo.backupset.expiration_date,
CASE msdb..backupset.type
WHEN 'D' THEN 'Database'
WHEN 'L' THEN 'Log'
END AS backup_type,...