Search notes:

sys.dm_server_registry

select distinct registry_key from sys.dm_server_registry;

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\CPE
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\CurrentVersion
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\Parameters
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\AdminConnection\Tcp
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Np
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Sm
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP1
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP10
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP11
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP12
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP13
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP14
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP2
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP3
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP4
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP5
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP6
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP7
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP8
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IP9
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Tcp\IPAll
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\MSSQLServer\SuperSocketNetLib\Via
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL14.TQ84INSTANCEID\SQLServerAgent
HKLM\SOFTWARE\Microsoft\SQMClient
HKLM\SYSTEM\CurrentControlSet\Services\MSSQL$TQ84INSTANCENAME
HKLM\SYSTEM\CurrentControlSet\Services\SQLAgent$TQ84INSTANCENAME

See also

The sys schema

Index