User guide

--host=<IP address or hostname> (p. 72)

--credentials=<user name>,<password>,encrypted (p. 115)

--address=<IP address or hostname> (p. 72)

Access to a specific service within a machine

--service={mms|ams} (p. 72)

2.3.5 Microsoft SQL

The commands listed in this section can be executed on a machine where Agent for SQL (single-pass)

is installed.

2.3.5.1 list mssql_instances

Lists Microsoft SQL Server instances.

Examples (p. 128)

Parameters

--filter_edition=<editions> (p. 111)

--filter_name=<names> (p. 112)

--filter_version=<versions> (p. 114)

General parameters

--log=<full path> (p. 117)

--log_format={structured|unstructured} (p. 117)

--output={formatted|raw} (p. 118)

{-f|--file_params}=<full local path> (p. 116)

Access to a remote machine (advanced editions only)

--host=<IP address or hostname> (p. 72)

--credentials=<user name>,<password>,encrypted (p. 115)

--address=<IP address or hostname> (p. 72)

Access to a specific service within a machine (advanced editions only)

--service={mms|ams} (p. 72)

2.3.5.2 list mssql_databases

Lists Microsoft SQL databases of the specified instance. Only the databases whose files are stored in

local folders of the SQL server are displayed.

Examples (p. 128)

Parameters

--filter_name=<names> (p. 112)

--instance=<instance name> (p. 75)

--credentials=<user name>,<password>,encrypted