Rev 50 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
/* moving sysinfo summary from a report to a callable */
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'SysInfo', 'callable.php:sysinfoView', now() );
update report set screen_report = null where name = 'Sysinfo Reports';
/* this is a cleanup, and should be in the main function. It creates a view which shows only devices which are systems */
create or replace view view_device_systems as select * from device where device_type_id in (select device_type_id from device_type where show_as_system = 'Y');
/* add maintenance report */
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Maintenance', 'callable.php:maintenanceView', now() );