Soldato
Hey,
So I have a sort of system I have been working on and running but I'm going to re-design it as it's fairly atrocious. I will describe the problem to you:
I have a data box which cycles through a number of other machines and creates a text file summary for all the working machines, this text file is placed in a folder hierarchy named after the computers and domains.
e.g. DOMAIN001/COMP0032/summary.txt
So my script goes through each domain folder and each computer folder and if the text file exists then copies what is in it to a number of fields in a MySQL database. I'm using Perl for that but am happy to change if anyone thinks there is a better language, more suited? Also, this script is running on the data box but I would like to not have any of my code on that box, I would rather do it remotely but not sure how to do that in code, is there a coded way to SSH in and then run stuff like this?
The second problem, the statistics are run every day or so. Some days new boxes are added and other they are taken away. So I need somehow to design the database so people can just see the latest stats and hide historical ones so the sort of core table has to be around the date and time the stats file is created or found? This would be easier to communicate if I could draw a diagram.
The purpose of all this is really just to be able to search the stats via a simple web interface which I can do easily enough on the dev box talking to the MySQL DB, I've used PHP for this so far.
I'm not sure what I'm looking for with this post, but if anyone has any good points or advice or insight, I would appreciate it.
So I have a sort of system I have been working on and running but I'm going to re-design it as it's fairly atrocious. I will describe the problem to you:
I have a data box which cycles through a number of other machines and creates a text file summary for all the working machines, this text file is placed in a folder hierarchy named after the computers and domains.
e.g. DOMAIN001/COMP0032/summary.txt
So my script goes through each domain folder and each computer folder and if the text file exists then copies what is in it to a number of fields in a MySQL database. I'm using Perl for that but am happy to change if anyone thinks there is a better language, more suited? Also, this script is running on the data box but I would like to not have any of my code on that box, I would rather do it remotely but not sure how to do that in code, is there a coded way to SSH in and then run stuff like this?
The second problem, the statistics are run every day or so. Some days new boxes are added and other they are taken away. So I need somehow to design the database so people can just see the latest stats and hide historical ones so the sort of core table has to be around the date and time the stats file is created or found? This would be easier to communicate if I could draw a diagram.
The purpose of all this is really just to be able to search the stats via a simple web interface which I can do easily enough on the dev box talking to the MySQL DB, I've used PHP for this so far.
I'm not sure what I'm looking for with this post, but if anyone has any good points or advice or insight, I would appreciate it.