Getting started with Reporting and Queries

Owned by Martin Gudme Søndergaard
Nov 14, 2023
2 min read

Introduction

CapaInstaller collects large amounts of Hardware, Software, and User information from enrolled devices. 

 The Reporting and Queries plugin lets you compose queries for dynamic groups and generate detailed reports based on this 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. Results can be previewed and Reports can be saved and exported to Microsoft Reporting Services. 

Requirements

Benefits

An automatically-collected comprehensive inventory saves many man-hours and keeps operating costs down. Before deciding upon strategies or changes in your organization invest some time to investigate your inventory data with Reporting & Queries to get an idea of what state your Hardware and Software are in. Queries can be across platforms and device types or specific down to a single OS setting. If a criteria is collected by CapaInstallers inventory functions it is available for a query.


Example queries:

 Click here to expand...
  • Disk Space - A query for remaining disk space will reveal workstations in need of a disk upgrade before a major application or OS deployment.
  • OS versions - Get a quick preview of what Operating Systems are running and their versions and patch levels. This will help in planning OS upgrades.
  • Platform - For software deployment, a simple query can help you determine how many 32 and 64 bit workstations are running and in what departments.
  • Memory slots free - How many workstations can be upgraded without discarding memory modules? 
  • Mobile Security - How many devices are running without a passcode for unlock?
  • Android Security - Is there any devices with installation from unknown sources enabled?

Creating your first query

Here are the 5 simple steps you need to run through to create your first query.

  1. Go to the File menu and select "New"
  2. Decide what data type you want to query in the Report Type dropdown.
  3. Select the relevant data fields in the treeview on the left and choose select with criteria
  4. Design your query
  5. Preview data and save the query to a Report or a Dynamic group.


Read more about Dynamic Groups and How to use Reporting

Read more about Microsoft Reporting Services



Further reading about Reporting & Queries >