I have to generate reports for the following :
1- cpu usage.
2- memory usage.
The generated reports must be looks like the following forms :
I've tried with more than one command to get system readings ... such as htop, atop and dstat -ta --top-cpu
The result for htop was :
The result for atop was:
The result for dstat was :
which is the correct command should I use to gather the correct system readings in which I can calculate the average value,min value,max value,median value and deviation for the cpu usage,memory usage,open files count and open ports count as in the first and second picture ?
If any one can help me to decide the appropriate command ...I hope if he can also tell me what the important numbers from the resulting system readings should I take to calculate the columns in the first two pictures ?
The data must be stored in a database that consists of a specific tables while the reports can be generated with the help of a java application which is responsible to deal with the database and use the retrieved data to make calculations and generate reports ... now I'm trying to make the database model so I need to know the necessary columns in the tables so I need your help to start the actual work for me which is the java application ... just I want to know what data should I take in my consideration !