Here's a simple hack of a page that should do it for you. It's based on the delete_system.php so I didn't have to do any work!
It basically runs a query that looks for uuid's that look like mac addresses. For each one it finds it runs pretty much the same code that delete_system.php does.
1. Backup your database. Use mysqldump or something reliable.
2. Save the code below in to a file in the open audit web directory
3. open the page from a browser
4. Check it doesn't die removing anything (if one of the queries fails it won't carry on and try to remove the rest)
5. Don't blame me if it doesn't work or the code sets your cat on fire or whatever
[code]<?php
include "include_config.php";
$link = mysql_connect($mysql_server, $mysql_user, $mysql_password) or die("Could not connect");
mysql_select_db("$mysql_database") or die("Could not select database");
$newquery = "SELECT system_uuid from SYSTEM where system_uuid like '__:__:__:__:__:__'";
$result = mysql_query($newquery) or die("Query failed to retrieve uuids of systems with mac type uuid'.");
while ($myrow = mysql_fetch_row($result)){
echo "About do delete: " . $myrow[0] . "<br />";
delete_system($myrow[0]);
}
function delete_system($system_uuid) {
$query = "select system_name from system where system_uuid='$system_uuid'";
$result = mysql_query($query) or die("Query failed at retrieve system name stage.");
$myrow = mysql_fetch_array($result);
$name = $myrow['system_name'];
$query = "DELETE FROM battery WHERE battery_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. battery");
$query = "DELETE FROM bios WHERE bios_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. browser_helper_objects");
$query = "DELETE FROM browser_helper_objects WHERE bho_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. browser_helper_objects");
$query = "DELETE FROM firewall_auth_app WHERE firewall_app_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. firewall_auth_app");
$query = "DELETE FROM firewall_ports WHERE port_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. firewall_ports");
$query = "DELETE FROM firewire WHERE fw_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. firewire");
$query = "DELETE FROM floppy WHERE floppy_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. floppy");
$query = "DELETE FROM graphs_disk WHERE disk_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. graphs_disk");
$query = "DELETE FROM groups WHERE groups_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. groups");
$query = "DELETE FROM hard_drive WHERE hard_drive_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. hard_drive");
$query = "DELETE FROM iis WHERE iis_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. iis");
$query = "DELETE FROM iis_ip WHERE iis_ip_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. iis_ip");
$query = "DELETE FROM iis_vd WHERE iis_vd_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. iis_vd");
$query = "DELETE FROM invoice WHERE invoice_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. invoice");
$query = "DELETE FROM keyboard WHERE keyboard_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. keyboard");
$query = "DELETE FROM manual_software WHERE man_soft_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. manual_software");
$query = "DELETE FROM mapped WHERE mapped_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. mapped");
$query = "DELETE FROM media WHERE media_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. media");
$query = "DELETE FROM memory WHERE memory_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. memory");
$query = "DELETE FROM modem WHERE modem_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. modem");
$query = "DELETE FROM monitor WHERE monitor_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. modem");
$query = "DELETE FROM mouse WHERE mouse_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. modem");
$query = "DELETE FROM ms_keys WHERE ms_keys_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. ms_keys");
$query = "DELETE FROM network_card WHERE net_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. network_card");
$query = "DELETE FROM nmap_ports WHERE nmap_other_id = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. nmap_other_ports");
$query = "DELETE FROM notes WHERE notes_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. notes");
$query = "DELETE FROM optical_drive WHERE optical_drive_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. optical_drive");
$query = "DELETE FROM partition WHERE partition_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. partition");
$query = "DELETE FROM passwords WHERE passwords_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. passwords");
$query = "DELETE FROM processor WHERE processor_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. processor");
$query = "DELETE FROM scsi_controller WHERE scsi_controller_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. scsi_controller");
$query = "DELETE FROM scsi_device WHERE scsi_device_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. scsi_device");
$query = "DELETE FROM service WHERE service_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. services");
$query = "DELETE FROM shares WHERE shares_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. shares");
$query = "DELETE FROM software WHERE software_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. software");
$query = "DELETE FROM sound WHERE sound_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. sound");
$query = "DELETE FROM startup WHERE startup_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. startup");
$query = "DELETE FROM system WHERE system_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. system");
$query = "DELETE FROM system_audits WHERE system_audits_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. system_audits");
$query = "DELETE FROM system_man WHERE system_man_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. system_man");
$query = "DELETE FROM system_security WHERE ss_uuid = '" . $name . "'";
$result = mysql_query($query) or die("Query failed at insert stage. system_security");
$query = "DELETE FROM tape_drive WHERE tape_drive_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. tape_drive");
$query = "DELETE FROM usb WHERE usb_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. usb");
$query = "DELETE FROM users WHERE users_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. users");
$query = "DELETE FROM video WHERE video_uuid = '$system_uuid'";
$result = mysql_query($query) or die("Query failed at insert stage. video");
}
?>[/code]