Chat now with support
Chat mit Support

Change Auditor 7.2 - User Guide

Change Auditor Overview Agent Deployment Change Auditor Client Overview Overview Page Searches Search Results and Event Details Custom Searches and Search Properties Enable Alert Notifications Administration Tasks Agent Configurations Coordinator Configuration Purging and Archiving your Change Auditor Database Disable Private Alerts and Reports Generate and Schedule Reports SQL Reporting Services Configuration Change Auditor User Interface Authorization Client Authentication Certificate authentication for client coordinator communication Integrating with On Demand Audit Enable/Disable Event Auditing Account Exclusion Registry Auditing Service Auditing Agent Statistics and Logs Coordinator Statistics and Logs Change Auditor Commands Change Auditor Email Tags

Launch Report Designer

The report designer in Change Auditor uses StimulReport.Net components for designing reports. For a detailed description and functionality of each component available, click F1 to view the Stimulsoft online help (www.stimulsoft.com).

NOTE: Once the report designer is launched, the Layout and Columns settings on the Report tab for the selected search are disabled. To re-enable these settings, click Reset at the bottom of the Report tab.

Publish reports

ChangeAuditor supports Microsoft's Microsoft SQL Server Reporting Services (SRS), providing a comprehensive, server-based solution that enables the creation, management and delivery of both traditional, paper and interactive web-based reports. In this implementation, administrators no longer need to traverse the various auditing solutions to create the desired reports. Instead they can interact with a web-based reporting portal and simply subscribe to the reports they want to see.

You can also publish reports to the Quest Knowledge Portal which extends Microsoft SQL Server Reporting Services to provide easy report management and delivery.

Prerequisites

Download the Quest Knowledge Portal from here: https://www.quest.com/products/knowledge-portal/.
IMPORTANT: This URL (Http://SQLServerName/Reports) will be used to create the required directories.
You can now browse open the knowledge portal site (Http://servername/QuestKnowledgePortal). The page will be empty until you publish a report.
2
Expand the Private and Shared folders and select a folder in the explorer view to display the list of search/report definitions stored in the selected folder.
From the right-hand pane, right-click a search/report definition and select Publish to Quest Knowledge Portal. The Knowledge Portal Setup dialog appears allowing you to configure the SQL Server Reporting services to be used and specify the report details. (To publish a series of reports (folder), select a folder in the explorer view.)
NOTE: Instead of entering the report server URL, you can click the Browse Knowledge Portal Servers button to select a Change Auditor agent that has Quest Knowledge Portal installed. Selecting an agent from the Eligible Change Auditor Agents dialog populates the report server URL.
Click Test to verify the credentials entered above.
2
Expand the Private and Shared folders and select a folder in the explorer view to display the list of search/report definitions stored in the selected folder.
3
From the right-hand pane, right-click a search/report definition and select Publish reports using SQL Reporting Services. This displays the Create Report dialog allowing you to configure the SQL Server Reporting services to be used and to specify the report details. (To publish a series of reports (folder), select a folder in the explorer view.)
NOTE: You can use the Import SRS Settings button on the Reporting Services Setup dialog to import a SQL Reporting Services template that was previously created to define the necessary SRS settings or enter the SRS settings as defined below.
Click Test to verify the credentials entered above.

Print or save a page's contents

From the client you can print or save the contents of the currently displayed page using the File | Print menu commands or the Print tool bar options. For each Change Auditor page, the data grid as it is displayed on the page is printed, except for the following pages:

NOTE: You may want to use the Print | Page Setup option in the client or Preferences button on the Print dialog to change the page orientation to Landscape and decrease the page margins prior to printing the pages that contain grids.
3
Click Print to close the dialog and send the displayed page to the designated printer.
1
Open the page to be printed, expand Print and select Print Preview.
1
Open the page to be saved to a file, expand Print and select one of the following commands:
2
The Save As dialog appears allowing you to specify the file name and location. Also if you clicked the Print to File command, you can specify the type of file to be saved (.xls, .xlsx or .csv).

SQL Reporting Services Configuration

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen