Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Cisco TMS Option Key Removal

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Cisco TMS Option Key Removal

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.

key.jpg

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.

6 REPLIES
Cisco Employee

Re: Cisco TMS Option Key Removal

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.

key.jpg

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.

New Member

Re: Cisco TMS Option Key Removal

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

Sent from Cisco Technical Support iPad App

New Member

I have the same question

I have the same question

New Member

Re: Cisco TMS Option Key Removal

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.

Cisco Employee

Re: Cisco TMS Option Key Removal

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.

Cisco Employee

Re: Cisco TMS Option Key Removal

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

343
Views
10
Helpful
6
Replies
CreatePlease to create content