question

ruancra avatar image
ruancra asked

Query to retrieve RedGate backup license

Hi guys We have about 40 different SQL servers in our enviroment, most of the servers have Redgate sql backup installed. I am new here and need to find out what license was used for what server, is it possible to get this info by quering the registry from SQL? using SQL 2008R2 and SQL 2012 Thanks
red-gatetsqlt
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
I would assume that it's stored somewhere, possibly in the registry. You might want to reach out to Red-Gate directly and see if they can tell you an easy way to do this. In a quick search for documentation, I found this: http://documentation.red-gate.com/display/SBU7/The+Registered+SQL+Servers+pane which shows a dialog box that contains the information. Hope this helps!
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ruancra avatar image ruancra commented ·
Thanks John, I want to create a ssrs report detailing all the Database servers with their SQL backup serial key. Wanted to know if its possible to get it via SQL Server.
0 Likes 0 ·
JohnM avatar image JohnM ruancra commented ·
You can read the registry from SQL Server, however I might suggest looking at Powershell. You could create a script that would populate a table in a database that would be able to feed your report. Just a thought.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.