cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
659
Views
10
Helpful
6
Replies
Steve Judd
Beginner

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
Steve Kapinos
Cisco Employee

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.

View solution in original post

6 REPLIES 6
Steve Kapinos
Cisco Employee

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.

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

Sent from Cisco Technical Support iPad App

testmember
Beginner

I have the same question

Steve Judd
Beginner

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.

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.

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

Create
Recognize Your Peers
Content for Community-Ad