nixCraft

In Short:
The basic jist with this post is to ask how to get the system information for a Linux Red Hat system into a CSV format. The end goal is to put the collected data together from other OS's into a MySQL DB.


Long Question:
The goal is to take the system information from a RHEL system using on standard bash commands such as “ps aux”, “cat /proc/cpuinfo”, “free -m”, “lspci and the like and have that information collected and input in a CSV file. While the end goal is to compile the data into a MySQL database the machines that the data will be collected from will not have access to the MySQL machine facilitating the need for an interim file format for transfer to the MySQL DB.


The output from some of the some of the bash commands that will need to run do not lend themselves to each conversion to a CSV format. Thank you in advance for any help.

So what actually is your question? I mean, like you would phrase it yourself...

Basically, I would like to get system information by running bash scripts and have that information be exported in csv format.

So which commands would you run?
What makes something a CSV file?