How do you collect SQL Server instance configuration that SMO doesn't expose?
Hello I'm trying to update our tool that documents SQL configuration and found we have a gap in the documentation for on-premises SQL Server around the Encryption, CEIP, network protocols, startup parameters, error loggin etc. This information is in SQL Server Configuration Manager but a lot of this information isn't exposed through SQL queries or SMO (well sometimes it is, but then it uses WMI).
How do you gather this information in real life? The registry functionality in SQL queries looks either limited or risky.
I was going to do it using two methods - SMO for most information and then use PowerShell remoting with a WMI fallback to gather host information (manufacturer, model, etc) and also the SQL Server Configuration Manager information.
Or am I missing an easier way?
Thanks, Dave