Skip to main content

Import- Backup Exec - No successful backups in 3 days

Steps to Apply Remote Monitor​

1. Obtain Group ID(s)​

Obtain the group ID(s) of the group(s) that the remote monitor should be applied to.

2. Construct SQL Query​

Copy the following query and replace YOUR COMMA SEPARATED LIST OF GROUPID(S) with the group ID(s) of the relevant groups:
(The string to replace can be found at the very bottom of the query, right after WHERE)

INSERT INTO groupagents 
SELECT '' as `AgentID`,
`groupid` as `GroupID`,
'0' as `SearchID`,
'Backup Exec - No successful backups in 3 days' as `Name`,
'6' as `CheckAction`,
'1' as `AlertAction`,
'Backup Exec - No successful backups in 3 days - %ComputerName%~~~Successful backup job detected.!!!Backup Exec - No successful backups in 3 days - %ComputerName%~~~A successful backup job is not detected on %computername% in 3 days. Please investigate.' as `AlertMessage`,
'0' as `ContactID`,
'3600' as `interval`,
'127.0.0.1' as `Where`,
'7' as `What`,
'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe -ExecutionPolicy Bypass -Command "$ErroractionPreference = \'SilentlyContinue\'; $StartTime= (Get-Date).AddDays(-3); $EndTime= (Get-Date); if(Get-winevent -erroraction silentlycontinue -FilterHashtable @{logname=\'Application\'; id=34112; ProviderName = \'Backup Exec\'; StartTime = $StartTime; EndTime = $EndTime} ) { return \'Good\' } Else {return \'Problematic\'}"' as `DataOut`,
'9' as `Comparor`,
'Problematic' as `DataIn`,
'' as `IDField`,
'1' as `AlertStyle`,
'0' as `ScriptID`,
'' as `datacollector`,
'21' as `Category`,
'0' as `TicketCategory`,
'1' as `ScriptTarget`,
UUID() as `GUID`,
'root' as `UpdatedBy`,
(NOW()) as `UpdateDate`
FROM mastergroups m
WHERE m.groupid IN (YOUR COMMA SEPARATED LIST OF GROUPID(S))
AND m.groupid NOT IN (SELECT DISTINCT groupid FROM groupagents WHERE `Name` = 'Backup Exec - No successful backups in 3 days');

3. Example Query​

An example of a query with a group ID:

INSERT INTO groupagents 
SELECT '' as `AgentID`,
`groupid` as `GroupID`,
'0' as `SearchID`,
'Backup Exec - No successful backups in 3 days' as `Name`,
'6' as `CheckAction`,
'1' as `AlertAction`,
'Backup Exec - No successful backups in 3 days - %ComputerName%~~~Successful backup job detected.!!!Backup Exec - No successful backups in 3 days - %ComputerName%~~~A successful backup job is not detected on %computername% in 3 days. Please investigate.' as `AlertMessage`,
'0' as `ContactID`,
'3600' as `interval`,
'127.0.0.1' as `Where`,
'7' as `What`,
'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe -ExecutionPolicy Bypass -Command "$ErroractionPreference = \'SilentlyContinue\'; $StartTime= (Get-Date).AddDays(-3); $EndTime= (Get-Date); if(Get-winevent -erroraction silentlycontinue -FilterHashtable @{logname=\'Application\'; id=34112; ProviderName = \'Backup Exec\'; StartTime = $StartTime; EndTime = $EndTime} ) { return \'Good\' } Else {return \'Problematic\'}"' as `DataOut`,
'9' as `Comparor`,
'Problematic' as `DataIn`,
'' as `IDField`,
'1' as `AlertStyle`,
'0' as `ScriptID`,
'' as `datacollector`,
'21' as `Category`,
'0' as `TicketCategory`,
'1' as `ScriptTarget`,
UUID() as `GUID`,
'root' as `UpdatedBy`,
(NOW()) as `UpdateDate`
FROM mastergroups m
WHERE m.groupid IN (12)
AND m.groupid NOT IN (SELECT DISTINCT groupid FROM groupagents WHERE `Name` = 'Backup Exec - No successful backups in 3 days');

4. Execute Your Query​

Now execute your query from a RAWSQL monitor set.

5. Locate Your Remote Monitor​

Locate your remote monitor by opening the group(s) remote monitors tab, then apply the appropriate alert template.

Changelog​

2025-04-10​

  • Initial version of the document