| 49 |
rodolico |
1 |
/* moving sysinfo summary from a report to a callable */
|
|
|
2 |
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'SysInfo', 'callable.php:sysinfoView', now() );
|
|
|
3 |
update report set screen_report = null where name = 'Sysinfo Reports';
|
|
|
4 |
/* this is a cleanup, and should be in the main function. It creates a view which shows only devices which are systems */
|
|
|
5 |
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');
|
|
|
6 |
/* add maintenance report */
|
|
|
7 |
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Maintenance', 'callable.php:maintenanceView', now() );
|
|
|
8 |
|