Subversion Repositories computer_asset_manager_v1

-- Uninstall all entries associated with the sysinfo module
drop table if exists unknown_entry;
DROP TABLE IF EXISTS device_alias;
DROP TABLE IF EXISTS client_alias;
DROP TABLE IF EXISTS computer_uptime;
DROP TABLE IF EXISTS device_operating_system;
DROP TABLE IF EXISTS disk_info;
DROP TABLE IF EXISTS disk_space;
DROP TABLE IF EXISTS installed_packages;
DROP TABLE IF EXISTS network;
DROP TABLE IF EXISTS operating_system;
DROP TABLE IF EXISTS software;
DROP TABLE IF EXISTS software_version;
DROP TABLE IF EXISTS sysinfo_report;

delete from _system where group_name='Modules' and key_name= 'Sysinfo';
delete from menu where parent_id = (select menu_id from menu where parent_id is null and caption = 'SysInfo');
delete from menu where parent_id is null and caption = 'SysInfo'
delete from report where name in ('Installed Packages','Software Install Counts','Software Revisions for System','Current Disk Usage',
                                  'Sysinfo Reports','Device Network','Device Disk Usage','Device PCI' );