Deleting Unused Access Points
How to delete unused access points (APs) from Sputnik Control Center 3.x. (Self-hosted Sputnik Control Center is legacy software, and is no longer supported without purchase of a professional support incident from the Sputnik online store.)
Deleting unused APs from Sputnik Control Center's database.
Deleting access points that have previous session records cannot be done from the web UI. But you can delete them directly from the database. In the example below, substitute the name of your own vsite for the first line. Note that if you perform this action, all historical client session records associated with those APs will be gone! (Also note that inactive APs can be left in your database indefinitely, without affecting your required number of SCC licenses.)
Substitute your own site name instead of sputnik in the first line below.
# /usr/share/kosmos/libexec/scc_dbmaint --psql sputnik
sputnik=> select * from nodes;
Select the nodes you want to delete.
Which nodes do you want to delete? Note the node numbers (node_id). For the example below, nodes 4 and 8 will be deleted from all relevant tables in the database. The number of deletions for each command will vary. Substitute your own list of node_id's.
sputnik=> delete from sessionusage where session_id in (select session_id from sessions where node_id in (4,8));
DELETE 9
sputnik=> delete from session_stats where node_id in (4, 8);
DELETE 10
sputnik=> delete from sessions where node_id in (4,8);
DELETE 5
sputnik=> delete from nodeif_wifi where nodeif_id in (select nodeif_id from nodeifs where node_id in (4,8));
DELETE 2
sputnik=> delete from nodeifs where node_id in (4,8);
DELETE 6
sputnik=> delete from nodecaps where node_id in (4,8);
DELETE 4
(the very next SQL query is necessary if there are any entries in node_authsys)
sputnik=> delete from node_authsys where node_id in (4,8);
DELETE 1
sputnik=> delete from nodes where node_id in (4,8);
DELETE 2