You can create new Application Compatibility Toolkit Connector (ACT Connector) reports in Configuration Manager 2007.
Use the following procedure to create a new report in Configuration Manager 2007.
To create a new report
-
In the Configuration Manager console, navigate to
System Center Configuration Manager / Site Database / Computer Management / Reporting / Reports. -
Right-click Reports, point to New, and then click Report to open the Report Properties dialog box.
-
Click the General tab, and then specify the following:
- Name. Specifies the name of the
report. The report name must be unique within the report category.
This is a required setting.
- Category. Specifies the category for
the report. Categories are case-sensitive, and, unless a new
category is being created for the report, we recommend to select
from the Category drop-down list the category Windows
Upgrade Assessment. This is a required setting.
- Comment. Specifies a description for
the report. This is an optional field that helps to describe the
purpose of the report.
- SQL statement. Specifies the SQL
Server statement used to retrieve the report data. Click Edit
SQL Statement to create the SQL Server statement that will
retrieve the desired data. For more information about creating SQL
Server statements for reports, see SQL Query Statement
Reference. This is a required setting.
- Prompts. Allows you to create a report
prompt. For more information about creating report prompts, see
How to Create or
Modify Report Prompts.
- Name. Specifies the name of the
report. The report name must be unique within the report category.
This is a required setting.
-
Click Next, on the Display page to configure whether the data in the report is automatically updated and whether to provide a chart for the report.
-
Click Next, and then on the Links tab, specify one of the following:
- No Link. Specifies that a link is not
configured.
- Link to another report. Specifies that
a link to another report is configured. Click Select to
specify the targeted report from the Select Report dialog
box. If the targeted report requires prompts, you must specify the
column from the source report that will be used to provide the data
for each prompt in the targeted report. To configure the column,
double-click a prompt, type the column number in the Column
text box, and then click OK.
- Link to Computer Details. Specifies
that a link to computer details is configured. The source report
must contain a column that contains the computer name. In the
Computer name column text box, specify the column that
contains the computer name, and then click OK.
- Link to Status Message Details.
Specifies that a link to status message details is configured. The
source report must contain a column that specifies a status message
record ID. In the Record ID column text box, specify the
column that contains the status record ID, and then click
OK.
- Link to URL. Specifies that a link to
a URL resource is configured. Specify the URL in the URL
text box, and then click OK.
- No Link. Specifies that a link is not
configured.
-
Click Next.
-
On the Security page, specify the security rights that must assigned to this report, and then click Next.
-
On the Wizard Completed page, click Close to exit the New Report Wizard.