Our networking department uses Microsoft's System Center Operations Manager 2007 (formerly MOM) to monitor servers. We want to check if a particular SQL Server database is being updated (basically if there are any rows with the current date in a particular table). I can write the SQL query with no problems, but one of our networking guys wants a VBScript to use with an alert-generating rule.
I have an example of this, but was hoping that there's a cleaner way than VBScript.
- Is there an existing module for this?
- Can you write custom rules (or whatever's appropriate) in C#?
- Can you write them in PowerShell?
- Any examples/links on the above?