Subversion Repositories computer_asset_manager_v1

Clean up the computer uptime with something like this

create temporary table test like computer_uptime;

insert into test select

   null,

   device_id,

   timestamp( date(last_reboot), sec_to_time(time_to_sec( last_reboot ) DIV 300 * 300) ),

   min(added_date),

   max(removed_date)

from

   computer_uptime

group by

   device_id,

   timestamp( date(last_reboot), sec_to_time(time_to_sec( last_reboot ) DIV 300 * 300) );

delete from computer_uptime;

insert into computer_uptime select * from test;

drop table test;