KB 540107

KB 540107: How to load reports manually on a remote report server

In some cases automated Report Installations fail or need to be run from a remote location. Secure Vantage provides a command line script to assist in loading all reports to a Report Server. This script must be run from a system with SQL Server installed.

Report Load Utility

{Install Path}\Forensic Analyzer\ReportScripter.cmd “{scriptlocation}” “{ReportServer}” “{ReportServerInstanceName}” “{ACS Databaseserver}” “”

  • {Install Path} Path to the installation folder(Default: c:\Program Files\Secure Vantage Technologies)
  • {Scriptlocation} Name of the Script file to run. Forensic Analyzer Default: c:\Program Files\Secure Vantage Technologies\Forensic Analyzer IT Auditors Pack Default: c:\Program Files\Secure Vantage Technologies\IT Auditors Pack
  • {ReportServer} Name of the server with SSRS installed.
  • {ReportServerInstanceName} Instance name of the Report server, if necessary. This is preceded by a ‘$’ character. If there is no Instance Name, leave it blank.
  • {ACS Databaseserver} Name of the Database Server where the Audit Collection Database resides. Include the instance name if not a default instance. Format: Servername\Instancename
  • {ACS Databasename} Name of the Audit Collection Database.

Examples

  1. Report Server and ACS Database on Same Server - No Instance
    c:\Program Files\Secure Vantage Technologies\Forensic Analyzer\Reportscripter.cmd " c:\Program Files\Secure Vantage Technologies\Forensic Analyzer" " SQL001" "" "SQL001" "OperationsManagerAC"
  2. Report Server and ACS Database on Same Server - Report Server Instance
    c:\Program Files\Secure Vantage Technologies\Forensic Analyzer\Reportscripter.cmd " c:\Program Files\Secure Vantage Technologies\Forensic Analyzer" "SQL001" "DailyReporter" "SQL001" " OperationsManagerAC"
  3. Report Server and ACS Database on Same Server – Database on Instance
    c:\Program Files\Secure Vantage Technologies\Forensic Analyzer\Reportscripter.cmd " c:\Program Files\Secure Vantage Technologies\Forensic Analyzer" "SQL001" "" "SQL001\SecurityReporting" " OperationsManagerAC"
  4. Report Server and ACS Database on Different Servers
    c:\Program Files\Secure Vantage Technologies\Forensic Analyzer\Reportscripter.cmd " c:\Program Files\Secure Vantage Technologies\Forensic Analyzer" "RS001" "" "SQL001" "OperationsManagerAC"

News & Events

Press Release 08/04/2009: Secure Vantage Releases Security Auditing SP2 for the Audit Collection Services (ACS)

Online Webcasts 06/08/2009: Download the ACS Master Class Series for free real world expert training on the Audit Collection Services.

Read more