Fantastic work as always Darren. You are a god. This helps us catch things that have changed post configuration of the plugin without having to manually check.
Another fantastic script. I had a couple of team members start to worry about script modifications and began to make their own archives within script folders.
Implemented this, does exactly as it says it would, now they don't need to worry.
Thanks again Darren.
Hey Matt,
I can assist here, as I had a similar issue.
I had to create an alert template that was able to run scripts only (called it 'Run Script' as per Darren's suggestion).
This alert template then allows the script defined in the monitor to run, which fixed up our issues.
There were also some slight modifications made to the original monitor to make it more 'live' rather than waiting on a table to rebuild.
Right now my monitor's configuration is this in the event you want to change it and test results. This is working well for us.
Identity Field: computers.name,(SELECT v_extradatacomputers.`Notify When Online` FROM v_extradatacomputers WHERE v_extradatacomputers.ComputerID=Computers.ComputerID) AS `Notify`
Additional Condition: Computers.ComputerID IN (SELECT extrafielddata.ID FROM extrafielddata WHERE ExtraFieldID IN (SELECT ID FROM extrafield WHERE `Name`='Notify When Online' AND Form=1) AND Value LIKE '%@%')