January 26, 2017 at 6:02 pm
Hello
Can you please tell is there any possibility to automate (from wmi or any scripts) to get all the installed SQL Server components (Generating Discovery Report)?
Thanks
Shuaib
January 26, 2017 at 6:56 pm
ShuaibV - Thursday, January 26, 2017 6:02 PMHello
Can you please tell is there any possibility to automate (from wmi or any scripts) to get all the installed SQL Server components (Generating Discovery Report)?Thanks
Shuaib
You can generate the Discovery Report from the command line by calling the SQL Server setup.exe. So if 2014 was on the C:\ it would be something like:
"C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\Setup.exe" /Action=RunDiscovery /q
The reports get generated to the most recent setup folder in the Setup Bootstrap\Log\ path for SQL Server. On 2014, it would be along the lines of:
C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\\<Folder name with the newest timestamp>\SqlDiscoveryReport.htm
So it seems like it would be possible to do something to automate that.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply