Jump to content
FQCN

ShadowProtect Missed Backups

Recommended Posts

Posted (edited)

I am attempting to make a monitor for ShadowProtect backups to be alerted if there is no backup ran. The built in alerts for SP only trigger on a successful backup or a failed backup but if the job doesn't run there is no alert. I created the monitor below but I don't think its configured correctly, if someone could point me in the right direction it would be greatly appreciated!

Table to check: eventlogs

Field to Check: eventID

Check Condition: Equals

Result: 1120

Identity Field: Reverse.Query

Additional Condition: eventlogs.Source='ShadowProtectSvc' and timegen > DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)

 

I've tried altering the date when building the query to a shorter timeframe to ensure this is configured properly but return no results. 

 

Edited by FQCN
Spelling

Share this post


Link to post
Share on other sites

I ended up getting it to query properly by changing the additional condition to 

eventlogs.Source='ShadowProtectSvc' and timegen > DATE_SUB(NOW(), INTERVAL 1 DAY)

 

Share this post


Link to post
Share on other sites

Alternately we look at the SP plugin table, so this works for SPX with the plugin installed:

table: Software
field:Name
cond: Equals
Result: StorageCraft ShadowProtect SPX
Identity:Name

additional:

Computers.LastContact > DATE_ADD(NOW(),INTERVAL -1 DAY)

AND
Computers.ComputerID NOT IN
(
SELECT distinct H.computerid
FROM `plugin_sc_spx_h_jobevents` H

where
 H.`Finish` > DATE_ADD(NOW(), INTERVAL -7 DAY)

)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...