Similar to what's been discussed in this post earlier - How to configure corrective action against alarm
I am trying to implement a corrective action triggered via Foglight to auto-remediate SQL server space alarms e.g. increase max size of file and so on
I read the answer that was added to the post cited above but it seems the answer is incomplete.
1) Does RemoteCommandAction (rule recovery action) require FGLAM to be installed on the host where the command needs to be executed i.e. should the SQL DB monitored host have FGLAM installed?
2) Scripting action pack - Can this be used to execute Powershell scripts on the SQL monitored host (no FGLAM installed)? If yes, are there any examples available ?
Any other suggestions on how I can go about implementing corrective action triggered via Foglight, keeping in mind action needs to be triggered on a remote monitored host (Windows) hosting a SQL instance and no FGLAM or FMS installed on the host?