ACM ships with pre-made reports covering many different data topics. Custom reports can be created that are specific to your organization’s needs. This page will show how to create a new custom report and where to save it for users to access.
| Note | ||
|---|---|---|
| ||
Custom reports interact with the ACM database directly, and misconfigured reports can modify or delete contents from the ACM database which may cause issues. See Reports Tab on how to configure the reporting account to a read-only SQL user/account. |
Instructions
- Create a new file with the .XML extension.
- Paste in the sample File Format shown on this page.
- Enter a Name and Description for the report. Assign a unique name. This is the display name that will appear in report listings. The description is supporting text to explain what the report provides.
- Enter the SQL for the report:
SQL Query method.
Info Example: <!-- SELECT * FROM TblObjects ORDER BY ObjectId -->
Stored Procedure method.
Info Example: <!–EXECUTE dbo.asi_spProcedureName '@Parameter' -->
- Create one or more parameters as needed. If no parameters are needed, leave the parameters node empty. See Parameters section for details and examples.
- Save the file to the File Location shown below. The Report Service will include the new report the next time the listing is loaded or refreshed. There is no need to restart the Report Service.
...