Hi, I have a database where different servers from different projects store a timestamp on a 5 minute interval. The servers come and go, are up and down.
I want to calculate per day, per server, per project how many minutes/hours different serves were up. So i want to know the total minutes logged per server/hostname per project.
The table looks like this: hostname, projectname, timestamp
Can you make a query that calculates this on a daily basis, specified per project and then stores this in a new table?