Get Service account & SQL Service Agent details using TSQL

Get Service account details using TSQL:

DECLARE @sn NVARCHAR(128);

EXEC master.dbo.xp_regread...
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\services\MSSQLSERVEr',
'ObjectName',
@sn OUTPUT;

SELECT @sn;

 

Get SQL Service Agent account details using TSQL:

DECLARE @sn NVARCHAR(128);

EXEC master.dbo.xp_regread...
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\services\SQLSERVERAGENT',
'ObjectName',
@sn OUTPUT;

SELECT @sn;