Why is this immediately marked Answered by CA?
In the referenced article, that variable: expire_time = 30d In my environment 8.4SP2, I have alive_time entries from 2016 still that are not removed automatically. So would not rely on this at all.
Issac08 what I do is this:
1. open SQL Studio and run this query. Modify the HUB_NAME with the hub/origin your looking to completely remove:
select origin,name,ip,mac,nimbus_type,cs_id,cs_key,cs_type,os_type
from CM_COMPUTER_SYSTEM
where origin like ('%HUB_NAME%') order by origin,name
2. Then I select the entire CS_KEY column and copy that out into Notepad++. I get rid of all the return characters and replace them with commas "," (Ctrl+H, Find What: \n Replace with: , Check off Extended Search) and then I copy this entire line.
3. Open the discovery_server probe utility and then choose the "remove_master_kevices_by_cskeys" and paste the huge line into the csKey's text box at the bottom. Hit Play.
4. For QoS Removal: Open UMP, go into the SLM portlet and modify the Portlet Preferences to (wrench icon, gear box) and then modify the Order By QoS group so it arranges everything by Origin, Robot, Probe, Target. Save go back and then I can delete specifically and easily specific Robots 1x1. Do it 1x1 b/c if its a large site then the delete will potentially cause a data_engine queue backup.
5. Then open the Primary Hub's hub configuration, Hubs tab and r-click on the old hub entry and Remove.
6. Hit F5 to refresh IM and its all gone.