Tuesday, June 10, 2008

Delete from database

6.3.3

 

select device_id from device where name='00-11-43-E7-35-4A'

select * from device_physical_attributes where device_id=165

delete from device_physical_attributes where device_id=165

 

or

 

select * from device_physical_attributes where mac_address='00-14-22-11-1C-28'

delete from device_physical_attributes where device_id=165

 

7.3.0

 

select * from pm_device where mac_address = '00-11-43-E7-8B-A3'

or

select * from device where name like '<server name>'

 

delete from device where device_id = 189 (or whatever the number is)

delete from pm_device where pm_device_id = 189

delete from pm_device_audit_trail where pm_device_id = 189

No comments: