yeah I have a few issues with this SQL overview package as well
a) I normally run this at the load server info level to get the machines domain name, but now the registry entry doesn't exist...anyone know how I can use SQL to get the domain of the machine?
SET NOCOUNT ON
DECLARE @chvDomainName NVARCHAR(100)
EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon',
N'CachePrimaryDomain',@chvDomainName OUTPUT
b) I run this to find all SQL server instances on the domain
Exec xp_cmdshell 'sqlcmd /Lc'
but none of my SQL 2008 machine are being picked up!