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 specify the SQL Server, Password Manager database and Report Server 1. On the home page of the Password Manager Administration site, click Reports.
2. On the Reporting Settings page, click the Configure SQL Server and Report Server link.
3. In the SQL Server Connection Settings dialog box, specify the following settings and click Next.
4. In the Report Server Connection Settings dialog box, specify the following settings and click OK:
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.
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.
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.
Override the reports on the Report Server Select this option if you want Password Manager to overwrite any Password Manager reports which were previously installed on the Report Server.
By default this option is not selected and Password Manager installs on the Report Server only the reports which are not available on the Report Server.
To create and preview a report
1. On the home page of the Administration site, click Reports, and under Reporting Settings, click the report you want to preview. The following table lists the reports included with Password Manager.
Delete log record older than Select this checkbox to have SQL Server purge old records to prevent the logging database from growing indefinitely. Specify the age for the log records to be eligible for deletion.
Select account for connecting to the Report
Server To have Password Manager access the Report
Server under the Password Manager Service account, select Password Manager Service account. Otherwise, select Specified user name and password, and then enter user name and password of the user account you want Password Manager to use when accessing the Report Server.
REPORT NAME DESCRIPTION
Profile states (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 who of the users has registered with Password Manager and who has not, who of the users must re-create their profiles, and who is scheduled to update their profiles.
Profile states distribution (chart) This is a pie chart report 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 distribution (chart) This is a pie chart report 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 (chart) This is a column chart showing the monthly numbers of users registered with Password Manager. You can view this report for a specified month range.
Actions by month (chart) This is a line chart showing the monthly numbers of user actions performed in Password Manager.
You can view this report for a specified month range.
SETTING DESCRIPTION
2. Once the report is generated, it is displayed in the Report Viewer, in a new browser window.
3. Select the zoom ratio in the drop-down list on the toolbar.
4. 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.
5. 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.
6. 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:
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.
Helpdesk 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.
Actions by helpdesk 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.
Helpdesk activity by user (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.
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.
REPORT NAME DESCRIPTION
• 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.
You can modify properties of any of the Password Manager reports by using SQL Server Reporting Services Report Manager console. For example, you can edit report name and description, or the report parameters.
To modify report properties
1. On the home page of the Administration site, click Reports, and on the Reporting Settings page, click the rightmost icon next to the report whose properties you want to modify.
2. In the Report Manager window, modify the report properties as needed, and click the Apply button.
3. For information about how to use the Report Manager, see the Report Manager Online Help.
4. To preview the report with modified properties, click the View tab.
5. To close the Report Manager, simply close the Report Manager window.