Reporting and Queries
Use the CapaInstaller Reporting and Queries plugin to compose and generate detailed reports based on your inventory data. You can establish the content of each report using many different criteria and choose the precise set of units to include. Reports can be saved, used as dynamic groups, and deployed to SQL Server Reporting Services.
You can create reports on the following areas: Hardware, Software, User, Logon, Updates, and Packages.
Each area has its own tree view, but the functionality is the same. The inventory is grouped by category.
Right-click a category
Section titled “Right-click a category”| Menu item | Description |
|---|---|
| Select all subitems | Select all items under the selected node. |
| Deselect all subitems | Deselect all items under the selected node. |
Right-click an item
Section titled “Right-click an item”| Menu item | Description |
|---|---|
| Select item | Add the item to the report. |
| Select with criteria… | Add the item to the report and open the Define Report Criteria form. For more information, go to Define report criteria. |
| Define criteria… | Available for items that are already in the report. Open the Define Report Criteria form. |
| Deselect item | Remove the item from the report. |
| Deploy to Reporting Services… | Deploy the content of the selected node to Reporting Services. For more information, go to Deploy to reporting services. |
In the Software tree view, right-click Application groups to select Check license or Software Vendor Report. In the Updates tree view, right-click All updates to select Check updates.
In this section
Section titled “In this section”Start here
- Getting started with Reporting and Queries - Create your first query and report, and the requirements to do so.
- Prerequisites for Reporting and Queries - What must be in place before you can use Reporting and Queries.
- Benefits of Reporting - Why to use reporting and what it can tell you about your environment.
Concepts and tasks
- What is Reporting - A description of the individual elements in Reporting.
- How to use Reporting - Step-by-step guides for using Reporting.
Reference
- Reporting Tree view - The tree views available for each report area.
- Toolbar and menu description for Reporting - The toolbar buttons and menu commands in the Reporting plugin.
- Best practice of using SQL Reporting Services - Recommendations for structuring and securing SQL Server Reporting Services.
- Troubleshooting Reporting and Queries - Where to look when reporting does not work as expected.