We have an enviroment with Sitescope integrated with APM. I need to automate an SQL query which will check if the events in an external database are the most recent (dateTime) or if there is a connectivity issue.
I have done shell scripting in the past with OMU's schedule monitor/template to run custom scripts. But I'm new with Sitescope & Windows environment.
How should I go about addressing this?