Forum Discussion

Bharath_Achar's avatar
11 years ago

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.

  • 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

  • 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

     

  • 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