# Reporting and Queries

> Compose and generate detailed reports from inventory data across hardware, software, users, logins, updates, and packages, with export to SQL Server Reporting Services.

Source: https://docs.capaone.com/capainstaller/the-capainstaller-console/reporting-and-queries/  
Product: CapaInstaller — a separate CapaSystems product; do not apply this page to any other.

The following information is about the reporting tool, its functionality, and its purpose. 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, thereby allowing you to generate the precise output that you need. Reports can be saved and exported to SQL Server Reporting Services.

It is possible to create reports on the following areas: Hardware, Software Metering, User, Login, Updates, and Packages.

Each area has its own tree view, but the functionality is the same and will be described below. The different assets are collected by category.

**Right-clicking on a category on an item brings the following possibilities:**

|                       |                                                |
|:----------------------|:-----------------------------------------------|
| **Element**           | **Description**                                |
| Select sub item       | Select all elements under the selected node.   |
| Deselect all sub item | Deselect all elements under the selected node. |

**Right-clicking on an item brings the following possibilities:**

|                                                                                                              |                                                 |
|:-------------------------------------------------------------------------------------------------------------|:------------------------------------------------|
| **Element**                                                                                                  | **Description**                                 |
| Select item                                                                                                  | Select element.                                 |
| [Define report criteria](/capainstaller/the-capainstaller-console/reporting-and-queries/how-to-use-reporting/define-report-criteria/) | Here can specific criteria be set for a report. |
| Deselect item                                                                                                | Deselect element.                               |

|                       |                                                                                                              |
|:----------------------|:-------------------------------------------------------------------------------------------------------------|
| **If you want to...** | **You can...**                                                                                               |
| Create a report       | [Create a report](/capainstaller/the-capainstaller-console/reporting-and-queries/how-to-use-reporting/create-a-report/) to see how.   |
| Preview a report      | [Preview a report](/capainstaller/the-capainstaller-console/reporting-and-queries/how-to-use-reporting/preview-a-report/) to see how. |

## In this section

**Start here**

- [Getting started with Reporting and Queries](/capainstaller/the-capainstaller-console/reporting-and-queries/getting-started-with-reporting-and-queries/) - Create your first query and report, and the requirements to do so.
- [Prerequisites for Reporting and Queries](/capainstaller/the-capainstaller-console/reporting-and-queries/prerequisites-for-reporting-and-queries/) - What must be in place before you can use Reporting and Queries.
- [Benefits of Reporting](/capainstaller/the-capainstaller-console/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](/capainstaller/the-capainstaller-console/reporting-and-queries/what-is-reporting/) - A description of the individual elements in Reporting.
- [How to use Reporting](/capainstaller/the-capainstaller-console/reporting-and-queries/how-to-use-reporting/) - Step-by-step guides for using Reporting.

**Reference**

- [Reporting Tree view](/capainstaller/the-capainstaller-console/reporting-and-queries/reporting-tree-view/) - The tree views available for each report area.
- [Toolbar and menu description for Reporting](/capainstaller/the-capainstaller-console/reporting-and-queries/toolbar-and-menu-description-for-reporting/) - The toolbar buttons and menu commands in the Reporting plugin.
- [Best practice of using SQL Reporting Services](/capainstaller/the-capainstaller-console/reporting-and-queries/best-practice-of-using-sql-reporting-services/) - Recommendations for structuring and securing SQL Server Reporting Services.
- [Troubleshooting Reporting and Queries](/capainstaller/the-capainstaller-console/reporting-and-queries/troubleshooting-reporting-and-queries/) - Where to look when reporting does not work as expected.