Forum Discussion
- tom_sprouseLevel 6
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
- RiaanBadenhorstLevel 6
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
Related Content
- 10 years ago
- 11 years ago
- 12 years ago