Ask the Community
Groups
SQL Server Data Collector Command Line options - Connect IT Community | Kaseya
<main> <article class="userContent"> <p>The following information is to be used with ssdc.exe<br><br>######################<br># COMMAND LINE BASICS<br>######################<br>Please note that when passing a command line option that conatins special <br>characters or SPACES, the option MUST BE DOUBLE QUOTED. <br>Example: <br>ssdc -outdir "c:\network detective"<br><br><br>######################<br># RECOMMENDED<br>######################<br>It is recommended that you use the SqlServerDataCollector.exe to produce the command<br>line switches. On the Verify and Run screen, click the "Save Settings to File"<br>link. Then from the command line you can run:<br>ssdc -file <your saved file><br><br><br>######################<br># SWITCH DETAILS<br>######################<br>Switch: -v<br>Details: Get the version of the program.<br><br>Switch: -encrypt <password> <br>Details: Encrypt a password. Used to produce the string to be used by options <br> that accept encrypted password.<br><br>Switch: -file <filename><br>Details: Gets other command line parameters from the specified file. <br>Note 1: Each paramter must be on a single line. Please note that a switch that<br> takes a value counts as two parameters. Using -outbase for example,<br> -outbase will be on a single line, then <basename> will on on its own line. <br>Note 2: Any other switches used with -file WILL TAKE PRECEDENCE over the switches<br> contained in filename.<br><br>Switch: -comment <comment text><br>Details: Set the working directory for the output. This directory will be used <br> for tmp storage and file generation.<br>Example: -comment "This is for MY COMPANY"<br><br>Switch: -outbase <basename><br>Details: The basename of the outfile. <br>Default: SqlServerDataCollection-<timestamp>.ddf<br><br>Switch: -outdir <directory><br>Details: The directory to produce the final DDF. Defaults to the current <br> directory.<br><br>Switch: -user <username><br>Details: User name to be used to connect to the SQL Server.<br>Default: sa<br>Note: If -user is NOT used, -auth will default to windows.<br><br>Switch: -epwd <password><br>Details: The ENCRYPED password for the SQL Server user.<br>Note: If both -epwd and -pwd are specified, only the encrypted one will <br> be used.<br><br>Switch: -pwd <password><br>Details: The NON_ENCRYPTED password for the SQL Server user.<br>Note: If both -epwd and -pwd are specified, only the encrypted one will <br> be used.<br> <br>Switch: -server <host or ip><br>Details: Hostname or IP Address of the SQL Server.<br>Default: localhost<br><br>Switch: -port <port><br>Details: The port number of the SQL Server.<br>Default: 1433<br><br>Switch: -test<br>Details: Tests a connection to the SQL Server. No data is collected.<br><br>Switch: -auth <sql | windows><br>Details: The authentication mode used to connect to the sql server.<br>Default: sql if the -user switch is used, otherwise windows<br>Note 1: If using windows authentication mode, the user name and <br> password switches will be ignored. <br>Note 2: This switch really does not need to be used. It can be controlled<br> by either using or not using the -user switch. </p> </article> </main>