cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

 

 

how to ?

 

Please help me on this.

1 Solution

Accepted Solutions
Accepted Solution!

Hello   Take a look at this

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

View solution in original post

2 Replies
Accepted Solution!

Hello   Take a look at this

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

View solution in original post

Bharath, You cannot execute

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