Remove a Netscaler that is no longer online from the Netscaler Console

[Sadako Hattori]

I have a Netscaler that is no longer online and has not been for a couple of years at this point. It was originally part of an HA pair, but the services on that changed and so the secondary node was removed and rebuilt and used elsewhere. Unfortunately, the secondary node was not removed from the console prior to it being deleted and now I cannot seem to be able to delete it from the console. It still shows up in the inventory and is taking a license. When I try to remove the license, I get an error saying it can't communicate with the Netscaler and it will not unassign the license. It will never be able to communicate with the Netscaler, as that instance is long gone and not recoverable. 

How can I remove the dead Netscaler from the inventory and release the license on the console? 

 

[Julian Jakob]

It's not listed in the list of your NetScaler in NSC - but in Inventory, correct? If so, you have to delete it from the Inventory via Database.

SSH to NSC (Primary if HA):

 

shell

/mps/db_pgsql/bin/psql -U mpspostgres -p 5454 mpsdb

set schema 'Owner';

select ip_address,instance_mode,id from managed_device where ip_address like '<NetScaler IP Address>';

 

the table should output Ip_address, instance_mode and id

 

delete from managed_device where ip_address='<NetScaler IP Address>';

\q 

 

Notes :

- No need to reboot NSC, it should directly work

- No need to run this command on Secondary ADM if HA is present

[Michael Morrison1709160082]

I'm having the same issue. I used PuTTy to connect to the Netscaler Console and ran the commands to connect to the database. When I ran the "select" statement, no data was returned.

Did I miss a step somewhere?

Thanks,

Mike

[Michael Adam]

Hello @Michael Morrison1709160082

 

it looks like you miss the --> ; <-- at the end of the line. If you use the command correctly everything works fine:

Best regards,

Michael 

[Michael Morrison1709160082]

Thanks, Michael--that was it. I knew it was something simple!