I am trying to find a solution to monitor the backup of an SQL database. The database is being backup up by SQL itself. And the maintenance plan can send out an email as well when the backups fails but I would like to age of the backup to be monitored by PRTG. Preferable by checking the value and comparing it to determine if the backup was done more then 60 minutes ago.
The below SQL file works and gives me the output when doing so in the Management Studio.
select max(backup_finish_date) as backup_finish_date from msdb..backupset where database_name='blablablabla'
The result is a single cell with the last time the backup was made
Running the SQL file in a Microsoft SQL V2 sensor returns a long number that I can't use.
Is it possible to get the date and time into PRTG and compare it?