How To Find Version of Double-Take From Registry Using SQL Query

So today one more request we got during audit is find version of double take in all the servers and now being experience we know every version details are available in registry.

But unfortunately if you are trying to find using search option it's hard to find and same happen with me, But as always some one comes to my rescue, This time its from my team and he found this for me.

Download
Registry:  HKEY_LOCAL_MACHINE\SOFTWARE\NSI Software\Double-Take\CurrentVersion\VersionInfo




So now being SQL server DBA i created below query to find same

/********** SCRIPT *********************/
DECLARE 
@key varchar(100),
@CurrentBuildNumber varchar (100)  

set @key = 'SOFTWARE\NSI Software\Double-Take\CurrentVersion'
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key=@key,@value_name='VersionInfo',
@value=@CurrentBuildNumber 
OUTPUT

 SELECT @@ServerName AS [Server Name],
@CurrentBuildNumber as CurrentBuildNumber
/***************************************/

So here my version is 7.0 for Double take