I am trying to create a report to list Office X64 "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Outlook\Bitness\X64" and only for Windows 7.
I need to create this report in SQL only.
So far I have this:
Select Top 1000000 upgrade_tblComputers.ComputerUnique,
upgrade_tblComputers.Domain,
upgrade_tblRegistry.Valuename,
upgrade_tblRegistry.Value,
upgrade_tblRegistry.Regkey,
upgrade_tblComputers.Computername,
upgrade_tblRegistry.RegistryID
From upgrade_tblComputers
Inner Join upgrade_tblRegistry On upgrade_tblComputers.Computername =
upgrade_tblRegistry.Computername
Where
upgrade_tblRegistry.Regkey =
‘HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Outlook\Bitness’
But getting the following error:
Invalid SELECT statement. Unexpected token "\" at line 13, pos 20.: Unexpected token "\" at line 13, column 20
Thanks for the help.
