Subversion Repositories computer_asset_manager_v1

select 
   version,
   device.name
from 
   sysinfo_report 
   join device using (device_id)
where
   report_date > date_sub(now(),interval 1 day)
order by
   version