Skip Navigation LinksALVAO 7.1ALVAO Asset ManagementIndex of WindowsCreate Query Wizard - Step 3 Skip Navigation Links.
Organizations Address Book
Numeric Series
Database - Edit
Date and Time
Define and Edit Properties
Hardware Detection Details
Software Detection Details
Hardware Detection vs. Tree
Vouchers
Kind of New Object
Installations Register
Installations Register vs. Software Detection
Licenses Register
History
HTML Document
Identifiable components
Icons
License - Vouchers
License - Media
License - Basic
Assets
Symbol CS1504 Barcode Reader Manager
Media
Moving Options
List of Properties
Load Objects from Active Directory
Loading Software Products Library - Step 1
Loading Software Products Library - Step 2
Loading Software Products Library - Step 3
Replace User-Defined Organizations
Replace User-Defined Products
Substitute Products
Settings - Automatic Loading
Settings - Detection
Settings - Passwords
Settings - General
Settings - Scheduling
Settings - Network Scan
Settings - SW library
Settings - Basic
Settings - View
New Numeric Series
New Detection - Basic
New Installation - Next
New Installation - Computers
New Installation - Products
New Installation - Shared License
New Installation - Trial License
New License - Vouchers and Media
New License - License
New License - License Items
New License - Product
New Organization
New Reminder
New Medium
New Computers
New Voucher
New Computer Name
New Object - Select a Master Object - Existing Objects
New Object - Select a Master Object - Object Templates
New Object - Select a Master Object - Object Samples
New Computer
New Product
Object - SW Profile
Object - Basic
Objects
Send for Recognition - Step 1 of 3
Send for Recognition - Step 2 of 3
Send for Recognition - Last Step
Reply
Permissions
Organization - Other
Other
Query Parameters
Computers
Detection Details
License Item
Items
License Items
Hardware Detections Comparison
Compare Detections to Asset Register
Uniqueness Violation
Use Function
Note
Product - Other
Products (software)
Handover Protocol (external)
Handover Protocol (internal)
Create Query Wizard - Step 1
Create Query Wizard - Step 2
Create Query Wizard - Step 3
Create Query Wizard - Step 4
Create Query Wizard - Step 5
Moving Computers to ["Recycle Bin","Discarded Assets"]
Move Licenses
License Allocation
Logon
Command
Commands
Reminder
Reminders
Extent
License Sharing
Stocktaking List
Unifying Objects
Column
Reader File
Manual Detection Files
Special Installation of the Product
Database Manager
SQL Query
Save Custom Software Products Library - Step 1
Save Custom Software Products Library - Step 2
Save Custom Software Products Library - Step 3
License Upgrade - License
Edit Rule for Recognition Based on System Registry - General
Edit Rule for Recognition Based on Files - General
Edit - Voucher
Edit - Vouchers
Edit - Stocktaking
Edit - Medium
Edit - Organization
Edit - Product
Edit Numeric Series
Edit Installation - Detected
Edit Installation - Basic
Edit Reminder
Users
Links
Property
Object Selection
Select Target Object
Select Asset
Please Select
Searching - Query
Search - Text
SW Profile Exceptions for This Computer
Search Results
Specify a Path
Indication Tab
Object Security Tab
Change Property Value
Change Quantity
License Voiding - Vouchers
License Voiding - Licenses
License Voiding - Other
Detection Method
Skip Navigation Links Skip Navigation Links.


Create Query Wizard – Step 3

Description

List

The list items represent the columns in the print report which will be the result of the query.

Select the column that you want to edit in the list and edit the item values in this window, or click on the Edit button. You can use the two arrows at the bottom edge of the list to move the selected item up and down in the list. The order of items specifies the order of columns in the final print report.

Edit

Select a column in the list and click on this button. A dialog box opens where you can edit the column header and width.

Only include rows where

If you want the values in the selected column to match a certain conditional expression, select an operator and enter a value to compare. For example, you can use "<64" for the RAM size.

Include in print report

Check this checkbox, if you want to include the selected column in the final print report.

Property type
Do not distinguish

The property can be the custom or the inherited type.

Custom

Only native properties will be used.

Inherited

Only inherited properties will be used.

Aggregate function
Number

The print report footer will include the number of property items.

Sum

The print report footer will include the sum of property values.

Average

The print report footer will include the average value of the property.

Minimum

The print report footer will include the minimum value of the property.

Maximum

The print report footer will include the maximum value of the property.

 

Did not find what you were looking for? Ask our technical support team.