Chatta subito con l'assistenza
Chat con il supporto

Password Manager 5.13.2 - Administration Guide

About Password Manager Getting started Password Manager architecture
Password Manager components and third-party applications Typical deployment scenarios Password Manager in a perimeter network Management Policy overview Password policy overview Secure Password Extension overview reCAPTCHA overview User enrollment process overview Questions and Answers policy overview Password change and reset process overview Data replication Phone-based authentication service overview
Management policies
Checklist: Configuring Password Manager Understanding Management Policies Configuring access to the Administration Site Configuring access to the Legacy Self-Service Site or Password Manager Self-Service Site Configuring access to the Helpdesk Site Configuring Questions and Answers policy Workflow overview Custom workflows Custom activities Legacy Self-Service or Password Manager Self-Service Site workflows Helpdesk workflows Notification activities User enforcement rules
General Settings
General Settings overview Search and logon options Importing and exporting configuration settings Outgoing mail servers Diagnostic logging Scheduled tasks Web Interface customization Instance reinitialization Realm Instances Domain Connections Extensibility features RADIUS Two-Factor Authentication Internal Feedback Password Manager components and third-party applications Unregistering users from Password Manager Bulk Force Password Reset Fido2 key management Working with Redistributable Secret Management account Email templates
Upgrading Password Manager Administrative Templates Secure Password Extension Password Policies Enable 2FA for administrators and helpdesk users Reporting Password Manager integration Accounts used in Password Manager Open communication ports for Password Manager Customization options overview Feature imparities between the legacy and the new Self-Service Sites Third-party contributions Glossary

Using Reports

You can create and view reports interactively using the Administration Site, and save them to multiple file formats.

To use the reporting functionality, you have to specify the SQL Server to store the Password Manager database and connect to the Report Server that is capable of building reports using the data stored in the Password Manager database.

When specifying the SQL Server and the database to store the log data, ensure that the account under which Password Manager will access the server has the appropriate permissions to create and write to a database on the server.

When connecting to a report server for the first time, Password Manager publishes the reports included with the solution to the server, and populates the list of reports on the Administration Site. Before connecting to a report server, ensure that the account under which Password Manager will access the server has the appropriate permissions to publish the Password Manager reports. The administrative rights on the report server will be sufficient for this account to publish reports.

To configure Password Manager reports

  1. On the home page of the Password Manager Administration Site, click Reporting.

  2. On the Statistics page, click the Reports link under the Reporting and User Action History title.

  3. On the Reports page, click Configure SQL Server and Report Server.

  4. In the SQL Server Connection Settings dialog, specify the following settings and click Next:

    Table 24: SQL server connection settings

    Setting

    Description

    SQL Server

    Type the name of the SQL Server to be used for storing the Password Manager database.

    Database name

    Specify the name for the database where Password Manager will log information used for building reports.

    If the database you specified does not yet exist, you will be prompted to confirm creation of the database.

    When prompted, select the account for creating the database.

    NOTE: The account you select must have the db_owner permissions to the database.

    Select account for connecting to the SQL Server

    To have Password Manager access the SQL Server under the Password Manager Service account, select Password Manager Service account. Otherwise, select Specific SQL Server account, then enter user name and password of the user account you want Password Manager to use when accessing the SQL Server.

    NOTE: The account you select must have the db_owner permissions to the database.

  5. In the Report Server Connection Settings dialog, specify the following settings and click OK:

Table 25: Report server connection settings

Setting

Description

Report Server URL

Type in the URL address of the Report Server in the following format: http://<server_name>/<report_server>), where <server_name> is the name of the server where Report Server resides, <report_server> is the name of the report server instance.

Report Manager URL

Type in the URL address of the Report Manager in the following format: http://<server_name>/<report_server>), where <server_name> is the name of the server where Report Server resides, <report_server> is the name of the Report Manager instance.

This is an optional setting.

Specify the account for deploying SSRS reports

Enter the user name and password of the user account that you want Password Manager to use when accessing the Report Server.

This account must have the permissions to deploy reports.

Specify the account that the Report Server will use to connect to the data source

Enter user name and password of the user account you want the Report Server to use when accessing the data source. You can use either Windows credentials or SQL Server credentials. If you choose Windows credentials, select the Use as Windows credentials when connecting to the data source check box as well.

NOTE: The account you select must have the db_owner permissions to the database.

To create and preview a report

  1. On the home page of the Administration Site, click Reporting, and under Reporting and User Action History, click Reports.

  2. On the Reports page, click the report you want to view. The following table lists the reports included with Password Manager:

    Table 26: Reports and user action history

    Report Name

    Description

    User status (table)

    This is a table report displaying a list of users in the managed domains, and the states of the users’ Questions and Answers profiles in Password Manager.

    You can see which users have registered with Password Manager and which users have not, which users must re-create their profiles, and which users are scheduled to update their profiles.

    User status (pie chart)

    This is a pie chart showing the percentage of the total number of users for each of the Q&A profiles states.

    Actions by user (table)

    This is a table report showing what actions each of the users performed in Password Manager, and whether the result of a user action was successful or not. You can view this report for a specified period of time.

    Actions by user (pie chart)

    This is a pie chart displaying the percentage of the total number of user actions for all types of user actions such as registration with Password Manager or password reset. You can view this report for a specified period of time.

    Registrations by month (bar chart)

    This is a bar chart showing the monthly numbers of users that are registered with Password Manager. You can view this report for a specified month range.

    Actions by month (bar chart)

    This is a bar chart displaying the monthly numbers of user actions that are performed in Password Manager. You can view this report for a specified month range.

    Actions by type (table)

    This is a table report showing a summary of user actions in Password Manager sorted by action type. You can view this report for a specified period of time.

    Help desk usage by actions (table)

    This is a table report showing a summary of actions on the Helpdesk Site. You can view this report for a specified period of time.

    Help desk usage by operators (table)

    This is a table report showing what actions each of the helpdesk operators performed in Password Manager, and whether the result of an operator action was successful or not. You can view this report for a specified period of time.

    Help desk usage by users (table)

    This table report shows what actions each helpdesk operator has performed for specific users. You can view this report for a specified period of time.

    E-mail notifications by user (table)

    This table report lists the e-mail notifications sent to specific users. You can view this report for a specified period of time.

    E-mail notifications by type (table)

    This is a table report showing a summary of e-mail notifications sent to users. The notifications are sorted by action type. You can view this report for a specified period of time.

    IMPORTANT: To view Password Manager reports, the account used to view reports must have permissions to read data from the report server database. By default, Windows integrated authentication is used to access the report server database. If you want to change access settings to the report server database, edit the appropriate settings on the Report Server.

  3. Once the report is generated, it is displayed in the Report Viewer, in a new browser window.

  4. Select the zoom ratio in the drop-down list on the toolbar.

  5. To go to a particular page, type in a page number in the leftmost text box on the toolbar and press ENTER, or use the navigation arrows beside this text box.

  6. To modify report parameters, set the new parameter values by using the group of controls in the upper area of the Report Viewer, and then click the View Report button.

  7. To close the Report Viewer and return to the List of Reports page, simply close the Report Viewer window.

When previewing a report, you can easily locate specific records, or find certain values within the report. The Report Viewer finds each occurrence of the item you are looking for.

To search a report

  1. Enter the text you are looking for in the Find Text text box on the menu bar.

  2. Click Find.

  3. Click Next to find the next occurrence.

In the Report Viewer, you can also save the report in a file, or print the report.

To save a report, select the target file format from the Select a format drop-down list on the menu bar, and then click Export. The Report Viewer supports the following file formats:

  • XML file (.xml)

  • Microsoft Excel Comma Separated Values file (.csv)

  • TIFF file (.tiff)

  • Portable Document Format (.pdf)

  • Web archive file (.mhtml)

  • Microsoft Excel Worksheet (.xls)

To print a report, click the printer icon on the menu bar, and in the Print window, click OK.

User Action History

User action history is a history of all actions performed by all users registered with Password Manager. This functionality is provided by the Enterprise Auditing Service. This service is installed during Password Manager installation and does not require any configuration.

To view user action history, you need to add a connection to SQL Server.

To connect to SQL Server

  1. On the home page of the Password Manager Administration Site, click Reporting.

  2. On the Statistics page, click the History link under the Reporting and User Action History title.

  3. On the History page, click Connect to SQL Server.

  4. In the SQL Server Connection Settings dialog, specify the following settings and click OK:

Table 27:  SQL server connection settings

Setting

Description

SQL Server

Type the name of the SQL Server to be used for storing the Password Manager database.

Database name

Specify the name for the database where Password Manager will log information used for building reports.

If the database you specified does not yet exist, you will be prompted to confirm creation of the database.

When prompted, select the account for creating the database. This account must have the permission to create a database.

Select account for connecting to the SQL Server

To have Password Manager access the SQL Server under the Password Manager Service account, select Password Manager Service account. Otherwise, select Specific SQL Server account, and then enter user name and password of the user account you want Password Manager to use when accessing the SQL Server.

Note, that the account you select must have the permissions to write to the database.

After you connect to SQL Server, you can perform full-text search for various user actions by user names, emails, activity names, domain, and so on.

On the History page of the Administration Site, enter a value you want to search for and click Search. You can sort the search results by relevance or date. To search for actions performed by User 1, for example, enter User 1.

Managing Connections to SQL Server and Report Server

On the Reporting page of the Administration Site, you can edit or remove existing connections to SQL and Report Servers.

To edit connections, under Reporting and User Action History, click the Edit Connections link and specify required values.

To remove connections, under Reporting and User Action History, click the Disconnect Servers link. Note, that all existing connections will be removed.

Setting up Reporting environment

To enable the reporting functionality of Password Manager, ensure that the following requirements are met:

  • A SQL Server is deployed in your environment and the Password Manager database is configured on that server.

  • A SQL Serverr Reporting Services report server is installed in your working environment.

  • You have configured a connection to the report server through the Administration Site.

The interactive Web-based reports are built on data that the report server retrieves from the Password Manager SQL database, and can be either viewed online or exported into multiple file formats.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione