Integrating bash with sql.
I m just curious to know whether it is possible to store the output of a shell command to a database .
My main aim is to use a full capacity of sql language to analyze the output generated by shell script.
by storing the 5 instances of of top at different interval we can simply predict lot of things like.
Which process has Maximum cpu utilization, Which user has maximum processes running.
I think writing a scripts for doing these tasks will require lot of overheads and file creation.
I hope i have clear my point .Please reply if any further clarification is required.
Last edited by pinga123; 08-12-2010 at 03:43 AM.