Listing the Microsoft SQL Server configuration with the values set by mssql-conf?

The utility mssql-conf in /opt/mssql/bin/mssql-conf has the setting list which tells you possible keys,

```
$ sudo ./mssql-conf list
control.alternatewritethrough Enable optimized write through flush for O_DSYNC requests
control.hestacksize Host extension stack size in KB
control.writethrough Use O_DSYNC for file flag write through requests
coredump.captureminiandfull Capture both mini and full core dumps
coredump.coredumptype Core dump type to capture: mini, miniplus, filtered, full
filelocation.defaultbackupdir Default directory for backup files
filelocation.defaultdatadir Default directory for data files
filelocation.defaultdumpdir Default directory for crash dump files
filelocation.defaultlogdir Default directory for log files
filelocation.errorlogfile Error log file location
filelocation.masterdatafile Master database data file location
filelocation.masterlogfile Master database log file location
hadr.hadrenabled Allow SQL Server to use availability groups for high availability and disaster recovery
language.lcid Locale identifier for SQL Server to use (e.g. 1033 for US - English)
memory.memorylimitmb SQL Server memory limit (megabytes)
network.forceencryption Force encryption of incoming client connections
network.forcesecureldap Force using LDAPS to contact domain controller
network.ipaddress IP address for incoming connections
network.kerberoskeytabfile Kerberos keytab file location
network.tcpport TCP port for incoming connections
network.tlscert Path to certificate file for encrypting incoming client connections
network.tlsciphers

There is no command line option to view what the values are actually set too, for now you'll have to check the file yourself

cat /var/opt/mssql/mssql.conf

However, it does not show the defaults. Stock, it has two options. One for sqlagent.enabled and one for EULA.accepteula. If you change one of those values as in the case of disabling CEIP,

$ sudo /opt/mssql/bin/mssql-conf set telemetry.customerfeedback false

Your conf file will look like this,

$ cat /var/opt/mssql/mssql.conf
[EULA]
accepteula = Y

[sqlagent]
enabled = false

[telemetry]
customerfeedback = false

StackExchange Database Administrators Q#216955, answer score: 6