For now I just want the previous day. Yesterday. midnight to midnight. I eventually want to go back and do each of the last 10 days individually for historical reasons, but for automated reporting I want the previous day.
After that I want to doa weekly usage agregated total and a monthly total report. These will be generated from a Powershell script - that bit works fine. Matt On Thu, Aug 24, 2017 at 11:07 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Matthew Halliday wrote: > > select servername, drive, strftime(date_time, -2) as iDATE, > SUM(diff_used) AS DailyUsed > > from tmp_dspace_import > > group by servername, drive; > > When there are multiple table rows in a group, which date should be > returned? > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
