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

Monitor a csv status file

Hi guys,

I've got a linux server that is currently outputting statistical information about the performance of an application to a CSV file. I want solarwinds to monitor the content of this csv into a table that could be monitored with thresholds on the data that is being outputted, and email the service desk if one of the thresholds is met.

Is this possible?

A sample of the csv content is below:

Date,Time,Files,%MEM,%DISK_USED,PROC_Files_SLIMIT,PROC_Files_HLIMIT,SYS_Files,SYS_FMAX,FD_SOCKETS,ALT_CONNECTIONS,DBCP_COUNT,DC_MEM_USED,DC_MEM_ALLOC
05-10-20,00:00:09,1388,27,64,100000,100000,4256,2426888,202,46,60,4218,4996
05-10-20,00:05:02,1453,27,65,100000,100000,4128,2426888,261,69,88,4371,4996
05-10-20,00:10:03,1400,27,65,100000,100000,4160,2426888,203,46,61,3279,4996
05-10-20,00:15:09,1435,27,66,100000,100000,4224,2426888,228,57,78,3723,4996
05-10-20,00:20:02,1393,27,66,100000,100000,4128,2426888,185,43,58,3495,4996

As you can see, every 5 minutes a new line is added. I want this to be checked every minute and the new line to update the current figure in the solarwinds table.

Thanks

Find more posts tagged with

Accepted answers

All comments

Seashore

A script that parse that file, taking one of the values as output into the orion sam component. Then you can add thresholds to that.

Seems possible. But I don't have the skills to write the code but it seems possible.

Jfrazier

There are a number of ways to skin that cat. First it depends on what/how you are monitoring your linux server with. SNMP, Agent, etc.

Once we know what tools are involved we can help to suggest a solution.

If you have a log file monitor, you can use that to read the file directly and only process the last line as they come in. Then a little script work to insert a row into the DB table should do the trick. You might be able to do all that from the linux server itself pointing to the database where ever it may be.

gareth.armstrong

Hi jfrazier,

I'm monitoring the server with an agent, it's a managed node so I could put application monitors on it fairly easily. Solarwinds has pretty much full access to this server.

Is there a log file monitor in SAM?

Thanks,

Gareth

gareth.armstrong

Hi Seashore,

That's pretty much what I'm after, and yep you nor I have those skills, hopefully some nice person in the the Thwack community will come to the rescue!

Cheers,

Gareth