Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SAM Alert to SQL Table

Hi All,

We are trying to have SAM log some stats to a SQL table based on warning and critical thresholds. I figure this can be done with PowerShell but wanted to see if anyone else has already done this. Not dying to recreate the wheel here.

Thanks in advance SAM homies!

Find more posts tagged with

Accepted answers

All comments

mrxinu

Any reason you're wanting to siphon the information to somewhere else? If you're just looking to report on a subset of the data based on some filters you could do that in a report easy enough. Can you give some more detail?

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

elliottp

Steven,

Thanks a bunch for the assist. We are looking to report whenever CPU on a server goes above a threshold for more than a duration of time. I.E. CPU is running over 70% for more than 10 minutes.

mrxinu

You're very welcome. The easiest thing to do is probably to create an alert that watches for CPU load >= 70% for at least 2 samples. Since node statistics come in every 10 minutes by default so you'd want a delay of at least 20 minutes.

Then you can use the trigger action that runs an external program (PowerShell script?) that'll go off and throw a datetime stamp and the node particulars in a table somewhere.

If you want a sample of PowerShell talking to a MS SQL database let me know and I'll pull something out of my bag and post it.

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

elliottp

Thanks! Yes if you have an example handy that would be great!