Home > User Guide - UPLINX Report Tool > Generating Reports from the Command Line for Scripting and Scheduling > Example 2 - Generate CSV Output for One SQL Command

Example 2 - Generate CSV Output for One SQL Command

The following command creates a CUCM report to CUCM with IP address 10.5.1.110, use the AXL soap credentials of user “admin” with password “cisco,123” and executes the SQL command "select* from device" and writes the output to a file.

The /csvheader will add (optional) the column names in the header row of the CSV file. The CSV header names are the same as the originating column names of the SQL table.

ReportTool.exe /cucm_ip 10.5.1.110 /cucm_user admin /cucm_password "bla,123" /sql "select* from device" /csvfile c:\mytemp\sql.csv /csvheader

Uplinx(c) Report Tool for Cisco Unified Communications: <version>

<<-- Parameters -->>
-- Profile file = ReportTool.config
-- CUCM IP = 10.5.1.110
-- CUCM AXL user = admin
-- CUCM AXL password Length = 7
-- SQLcmd = select* from device
-- csvfile = c:\mytemp\sql.csv
-- csvheader = True
Loading config file: Default
Loaded config file: Default

<<-- Running tasks (Press CTRL-C to abort) -->>
Executing: Creating SQL to CSV file(s)
15:08:11 | Starting SQLtoCSV Report
15:08:15 | Licensed mode enabled for DEBUGGING.
15:08:15 | Report Tool running in licensed mode
15:08:15 | Starting SQL2CSV => Finished at 15:08:15
File created: c:\mytemp\sql.csv
Exiting...
Finished - no error