Changes between Version 1 and Version 2 of Internal/cProcedures/aGeneratingReports

Timestamp:

Apr 7, 2016, 12:22:41 PM (8 years ago)

Author:

Olivera Tosic

Comment:

—

Internal/cProcedures/aGeneratingReports

@@ -1 +1 @@
 = Generating Usage Reports =
+To get total reservations on all machines in minutes for certain period:
+{{{
+SELECT 
+sum((reservations.end_date   + (reservations.endTime * 60))-(reservations.start_date + (reservations.startTime * 60)))/60 duration
+FROM reservations
+WHERE unix_timestamp('2000-01-01') <=(reservations.start_date + (reservations.startTime * 60))  AND
+unix_timestamp('2016-03-31') >= (reservations.end_date   + (reservations.endTime * 60))
+AND is_pending = 0;
+
+
+}}}