Cisco TMS Option Key Removal

[Steve Judd]

Is there a simple way to remove an option key entered into TMS? Licensing has provided us a 25 movi license when it should have been a 25 endpoint licens. We want to remove this movi licence from the clients TMS.

Sent from Cisco Technical Support iPad App

[Steve Kapinos · Accepted solution]

Only through direct modification of the SQL database.  If SQL server was installed locally on the server by the installer, open a command prompt and do

osql -S localhost\sqltms -E -d tmsng

You'll get a prompt like 1>

Enter the commands below... replacing string with your actual license key

delete from OptionKeys where OptionKey like 'string'

go

Type exit to quit the osql tool.

If your SQL server is installed somewhere else or under a different instance name, you will have to modify the osql command (-S specifies the server address... -E means using windows authentication) or use SQL Management Studio.  If you are using a external SQL Server, whomever set it up can help you.  If you are unsure, open TMS Tools on the TMS server, and look at the database connection properties.  They will tell you where the TMS database is located.

[Steve Judd]

Thanks Steve, it's local SQL so I'll give this a go.

Sent from Cisco Technical Support iPad App

[testmember]

I have the same question

[Steve Judd]

Just tested on my lab TMS and this works, thanks very much!

I would add (because it is case specific) and it may save someone head scratching

line should read

delete from OptionKeys where OptionKey like "string"

Note the "" double quotations.

[Steve Kapinos]

Hrmm... should work with single quotes too if you are actually in the osql command line.  The screenshot above is a live screenshot, not a mock-up.

Queries ran from the command line by using -Q  normally need to be in a double quotes around the entire query, but that's because you are dealing with the windows command line environment.  Once in osql, tsql syntax should rule.

[daleritc]

There is a new feature in the next coming release that will allow you do this from the UI :)

Sent from Cisco Technical Support iPad App