Jump to content

Shadow Protect Replication Monitoring


Recommended Posts

I have to put this on hold for a while. Didnt get any further with the ones I had sent it out too, probably my fault from always being busy. but hopefully in a month or so I can dedicate some labtech time. Sorry

 

5XjPEps.jpg

Edited by Guest
Link to post
Share on other sites

It checks what servers had SP jobs at the clients location, then pulls the data from image manager and give you the information on what that servers monitored folder has. I've been using it for IntelligentFTP monitoring so it should work for the cloud. Hopefully soon setting it up to monitor more replication jobs like shadowstream and local drive copies.

Link to post
Share on other sites

That sounds very good. Yes we are just using mainly IntelligentFTP and some Local Network Replication jobs.

 

One thing I would be keen on, but cant see a way that it would work, would be to get the file size of the file that was being replicated. Mainly so I can see if someone has generated a 10GB daily incremental and we are going to see some WAN issues/delays.

 

We haven't yet done much with local drive replication, as usually backup to NAS, then replicate off the NAS.

Link to post
Share on other sites
  • 2 weeks later...

I was pulling the image sizes over but never set it into labtech. After this post I got a little inspiration to continue work on it, also had storage craft come down last week for a meeting, I've added a ton more stuff, and have a meeting setup with the storagecraft engineering team. I also have the email addresses saved of the people who emailed me, so bear with me another week or two to get some things with them fixed and I'll send everything out. I'm no programmer so I had to note everything in the script since I'm not sure if it makes sense to others.

Link to post
Share on other sites
  • 4 weeks later...
  • 2 weeks later...
  • 2 weeks later...
  • 2 weeks later...

I'm guessing Joseph has left this?

 

I would like to get a plugin developed for LT to handle ImageManager as such I will open a topic in the plugins page and put forward the information I have gathered in the hope we may be able to crowd source a solution as I'm new to doing LT plugins.

 

One thing I haven't yet been able to find is that in Joseph's example above he has % complete of transfer, in my digging to date I've yet to find it recorded the other items I have found in the ImageManager.mdb database.

Link to post
Share on other sites
  • 2 months later...
  • 1 month later...

CREATE VIEW `v_imagemanagerfail` AS
   select 
       `h_eventloghistory`.`ComputerID` AS `computerid`,
       `h_eventloghistory`.`Message` AS `message`,
       `h_eventloghistory`.`TimeGen` AS `timegen`
   from
       `h_eventloghistory`
   where
       ((`h_eventloghistory`.`Source` like '%imagemanager%')
           and ((`h_eventloghistory`.`Message` like '%error%')
           or (`h_eventloghistory`.`Message` like '%fail%')
           or (`h_eventloghistory`.`Message` like '%does not connect%')
           or (`h_eventloghistory`.`Message` like '%chain missing%')
           or (`h_eventloghistory`.`Message` like '%unable to synchronize%')
           or (`h_eventloghistory`.`Message` like '%not find a part of the path%'))
           and (`h_eventloghistory`.`TimeGen` >= (now() + interval -(24) hour))) 
   union select 
       `eventlogs`.`ComputerID` AS `computerid`,
       `eventlogs`.`Message` AS `message`,
       `eventlogs`.`TimeGen` AS `timegen`
   from
       `eventlogs`
   where
       ((`eventlogs`.`Source` like '%imagemanager%')
           and ((`eventlogs`.`Message` like '%error%')
           or (`eventlogs`.`Message` like '%fail%')
           or (`eventlogs`.`Message` like '%does not connect%')
           or (`eventlogs`.`Message` like '%chain missing%')
           or (`eventlogs`.`Message` like '%unable to synchronize%')
           or (`eventlogs`.`Message` like '%not find a part of the path%'))
           and (`eventlogs`.`TimeGen` >= (now() + interval -(24) hour)))
   order by `timegen` desc

CREATE VIEW `v_imagemanagerfailgrouped` AS
   select 
       `v_imagemanagerfail`.`computerid` AS `computerid`,
       `v_imagemanagerfail`.`message` AS `message`,
       `v_imagemanagerfail`.`timegen` AS `timegen`
   from
       `v_imagemanagerfail`
   group by `v_imagemanagerfail`.`computerid`

 

Monitor Setup:-

Table to Check: v_imagemanagerfailgrouped

Field to Check: computerid

Check Condition: Greater Than

Result: 0

Identity Field: v_imagemanagerfailgrouped

 

Alert Mesage:

Errors have been detected in ImageManager on %computername%

Please Investigate

 

%FieldName%

Link to post
Share on other sites
  • 4 months later...
  • 1 month later...
  • 1 month later...
  • 11 months later...
CREATE VIEW `v_imagemanagerfail` AS
   select 
       `h_eventloghistory`.`ComputerID` AS `computerid`,
       `h_eventloghistory`.`Message` AS `message`,
       `h_eventloghistory`.`TimeGen` AS `timegen`
   from
       `h_eventloghistory`
   where
       ((`h_eventloghistory`.`Source` like '%imagemanager%')
           and ((`h_eventloghistory`.`Message` like '%error%')
           or (`h_eventloghistory`.`Message` like '%fail%')
           or (`h_eventloghistory`.`Message` like '%does not connect%')
           or (`h_eventloghistory`.`Message` like '%chain missing%')
           or (`h_eventloghistory`.`Message` like '%unable to synchronize%')
           or (`h_eventloghistory`.`Message` like '%not find a part of the path%'))
           and (`h_eventloghistory`.`TimeGen` >= (now() + interval -(24) hour))) 
   union select 
       `eventlogs`.`ComputerID` AS `computerid`,
       `eventlogs`.`Message` AS `message`,
       `eventlogs`.`TimeGen` AS `timegen`
   from
       `eventlogs`
   where
       ((`eventlogs`.`Source` like '%imagemanager%')
           and ((`eventlogs`.`Message` like '%error%')
           or (`eventlogs`.`Message` like '%fail%')
           or (`eventlogs`.`Message` like '%does not connect%')
           or (`eventlogs`.`Message` like '%chain missing%')
           or (`eventlogs`.`Message` like '%unable to synchronize%')
           or (`eventlogs`.`Message` like '%not find a part of the path%'))
           and (`eventlogs`.`TimeGen` >= (now() + interval -(24) hour)))
   order by `timegen` desc

CREATE VIEW `v_imagemanagerfailgrouped` AS
   select 
       `v_imagemanagerfail`.`computerid` AS `computerid`,
       `v_imagemanagerfail`.`message` AS `message`,
       `v_imagemanagerfail`.`timegen` AS `timegen`
   from
       `v_imagemanagerfail`
   group by `v_imagemanagerfail`.`computerid`

 

Monitor Setup:-

Table to Check: v_imagemanagerfailgrouped

Field to Check: computerid

Check Condition: Greater Than

Result: 0

Identity Field: v_imagemanagerfailgrouped

 

Alert Mesage:

Errors have been detected in ImageManager on %computername%

Please Investigate

 

%FieldName%

 

 

Sorry for necro'ing the thread but this actually works really well and wanted anyone looking for this solution to know it. We have it displaying on a dashboard as well as creating ticket alerts. Can't thank you enough for this!

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...