Tracking Utilities -> Remove All Scan Results ...mods

[lavermil]

Hello,

I love this tool I am comparing it to a tool I have been developing a little with someone else (switchmap). Currently switchmap does everything I need and more. I really like the interface of MAC Track and it allows me to write my own custom reports. I am really happy so far. I have to see if it finds as many IP-MAC pairs as the (switchmap) install I have running.

None the less I have realized when Doing a Remove All Scan Results, you don't end up with the following columns being zeroed out if you are under the "Device Report". So I have added in a few statements to do that. I have also done the same for the "Site Report"

I believe the following columns under "Device Report" should be zeroed out when you "Remove All Scan Results".
"Total IP's", "User Ports", "User Ports Up", "Trunk Ports", "Active Macs", "Last Duration"

I believe the following columns under "Site Report" should be zeroed out as well when you "Remove All Scan Results". I do think Device Errors should remain. No reason to zero that column out.
"Total IPs", "User Ports", User Ports Up", "MACs Found"

**Assuming a unmodifed "mactack_utilities.php" which should contain 434 lines. I inserted the following code after line 319**

$mactrackdevicerows = db_fetch_cell("SELECT COUNT(*) FROM mac_track_devices");
for ( $counter = 1; $counter <= $mactrackdevicerows; $counter += 1) {
db_execute("UPDATE mac_track_devices SET ips_total='0' WHERE device_id='" . $counter . "'");
db_execute("UPDATE mac_track_devices SET ports_total='0' WHERE device_id='" . $counter . "'");
db_execute("UPDATE mac_track_devices SET ports_active='0' WHERE device_id='" . $counter . "'");
db_execute("UPDATE mac_track_devices SET ports_trunk='0' WHERE device_id='" . $counter . "'");
db_execute("UPDATE mac_track_devices SET macs_active='0' WHERE device_id='" . $counter . "'");
db_execute("UPDATE mac_track_devices SET vlans_total='0' WHERE device_id='" . $counter . "'");
db_execute("UPDATE mac_track_devices SET last_runduration='0.00000' WHERE device_id='" . $counter . "'");
}
$mactracksiterows = db_fetch_cell("SELECT COUNT(*) FROM mac_track_sites");
for ( $counter = 1; $counter <= $mactracksiterows; $counter += 1) {
db_execute("UPDATE mac_track_sites SET total_devices='0' WHERE site_id='" . $counter . "'");
db_execute("UPDATE mac_track_sites SET total_macs='0' WHERE site_id='" . $counter . "'");
db_execute("UPDATE mac_track_sites SET total_ips='0' WHERE site_id='" . $counter . "'");
db_execute("UPDATE mac_track_sites SET total_user_ports='0' WHERE site_id='" . $counter . "'");
db_execute("UPDATE mac_track_sites SET total_oper_ports='0' WHERE site_id='" . $counter . "'");
db_execute("UPDATE mac_track_sites SET total_trunk_ports='0' WHERE site_id='" . $counter . "'");
}

Thx again for this wonderful tool Witness.

-Lance

[TheWitness]

Can you link this post to the features section. I will be working on this on Monday.

TheWitness

[lavermil]

[lavermil]

[lavermil]

Witness,

Here is the best code I could come up with. It gets the job done. You might be able to come up with something more elegant. This catches everything even if you delete sites or devices.

$mactrackdevicerows = db_fetch_assoc("SELECT device_id FROM mac_track_devices");
foreach ($mactrackdevicerows as $device_row) {
db_execute("UPDATE mac_track_devices SET ips_total='0' WHERE device_id='" . $device_row['device_id'] . "'");
db_execute("UPDATE mac_track_devices SET ports_total='0' WHERE device_id='" . $device_row['device_id'] . "'");
db_execute("UPDATE mac_track_devices SET ports_active='0' WHERE device_id='" . $device_row['device_id'] . "'");
db_execute("UPDATE mac_track_devices SET ports_trunk='0' WHERE device_id='" . $device_row['device_id'] . "'");
db_execute("UPDATE mac_track_devices SET macs_active='0' WHERE device_id='" . $device_row['device_id'] . "'");
db_execute("UPDATE mac_track_devices SET vlans_total='0' WHERE device_id='" . $device_row['device_id'] . "'");
db_execute("UPDATE mac_track_devices SET last_runduration='0.00000' WHERE device_id='" . $device_row['device_id'] . "'");
}
$mactracksiterows = db_fetch_assoc("SELECT site_id FROM mac_track_sites");
print_r($mactracksiterows);
foreach ($mactracksiterows as $site_row) {
db_execute("UPDATE mac_track_sites SET total_devices='0' WHERE site_id='" . $site_row['site_id'] . "'");
db_execute("UPDATE mac_track_sites SET total_macs='0' WHERE site_id='" . $site_row['site_id'] . "'");
db_execute("UPDATE mac_track_sites SET total_ips='0' WHERE site_id='" . $site_row['site_id'] . "'");
db_execute("UPDATE mac_track_sites SET total_user_ports='0' WHERE site_id='" . $site_row['site_id'] . "'");
db_execute("UPDATE mac_track_sites SET total_oper_ports='0' WHERE site_id='" . $site_row['site_id'] . "'");
db_execute("UPDATE mac_track_sites SET total_trunk_ports='0' WHERE site_id='" . $site_row['site_id'] . "'");
}

[lavermil]

[TheWitness]

Instead of developing your own package, why don't you sign up with me. I could use the help...

Oh,

Here is the final version of your two suggestions. They are in SVN at the moment. Why don't you test?

[lavermil]