Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
1 rodolico 1
-- Uninstall all entries associated with the sysinfo module
2
drop table if exists unknown_entry;
3
DROP TABLE IF EXISTS device_alias;
4
DROP TABLE IF EXISTS client_alias;
5
DROP TABLE IF EXISTS computer_uptime;
6
DROP TABLE IF EXISTS device_operating_system;
7
DROP TABLE IF EXISTS disk_info;
8
DROP TABLE IF EXISTS disk_space;
9
DROP TABLE IF EXISTS installed_packages;
10
DROP TABLE IF EXISTS network;
11
DROP TABLE IF EXISTS operating_system;
12
DROP TABLE IF EXISTS software;
13
DROP TABLE IF EXISTS software_version;
14
DROP TABLE IF EXISTS sysinfo_report;
15
 
16
delete from _system where group_name='Modules' and key_name= 'Sysinfo';
17
delete from menu where parent_id = (select menu_id from menu where parent_id is null and caption = 'SysInfo');
18
delete from menu where parent_id is null and caption = 'SysInfo'
19
delete from report where name in ('Installed Packages','Software Install Counts','Software Revisions for System','Current Disk Usage',
20
                                  'Sysinfo Reports','Device Network','Device Disk Usage','Device PCI' );