Hi!
I have a bunch of program information from the process table in a mysql db.
The data stored is for instance, creation date, process name, userid (owner of processes ) etc.
What I want to do is choose a specific record, i.e. 'firefox.exe'. Find the first date, get all the instances of this program for this day, and then do this in interval of 1 days...
Any pointers? I've tried this by using creationdate<Date_Add(creationdate, Interval 1 day) for testing, did not work. ANd still, I want process information from within a specific day.
Does anyone know if this is possible directly in SQL (MySQL) or using PHP etc.?
I need this data to calcuate averages and standard deviation on various process parameters.
I have a bunch of program information from the process table in a mysql db.
The data stored is for instance, creation date, process name, userid (owner of processes ) etc.
What I want to do is choose a specific record, i.e. 'firefox.exe'. Find the first date, get all the instances of this program for this day, and then do this in interval of 1 days...
Any pointers? I've tried this by using creationdate<Date_Add(creationdate, Interval 1 day) for testing, did not work. ANd still, I want process information from within a specific day.
Does anyone know if this is possible directly in SQL (MySQL) or using PHP etc.?
I need this data to calcuate averages and standard deviation on various process parameters.