Is it possible to generate Opscentre pubilc/private repsorts from command line in CSV/TSV foramt and how to ?

[Bharath_Achar]

Is it possible to generate Opscentre pubilc/private reprots from command line in CSV/TSV foramt.

how to ?

Please help me on this.

[RiaanBadenhorst · Accepted solution]

Hello

Take a look at this post. It show how to grab the sql queries from the logs, and then execute them from CLI.

https://www-secure.symantec.com/connect/blogs/custom-sql-query-asa-db-opscenter-generate-monthly-success-rate

[tom_sprouse]

Bharath,

You cannot execute private or public reports from command line...

You cannot add reports into OpsCenter from Command Line...

However, as Riaan mentioned, you can execute custom SQL via command line.

You can use the loadSql.bat command.  Add the custom SQL query to a text file in a temporary location and then use the loadSql.bat (orloadsql.sh) command to invoke the changes.

Windows:  \Program Files\Symantec\OpsCenter\server\bin\loadSql.bat \temp\filename.txt
UNIX:  /opt/SYMCOpsCenterServer/bin/loadsql.sh -sqlFile /tmp/filename.txt

If you have any questions, please let us know.

--Tom