Querying Client Property Data

When you run hardware inventory, software inventory, and Find Client operations, Vector AM also collects and stores Client-specific information, such as when hardware and software inventories were last performed and the details of the offline area used to collect information. This data, together with organization-specific information collected using the Get User Data operation, is stored in the NODEPROP table.

To create queries on this Client property data, you must specify the name of the property you want to use (such as $DEPARTMENT) and the value you want to search for (such as SALES) using the User Information choice in the Field Selector menu.

For example, to create a query that only includes Clients from the Engineering department, you can enter the following query:

Building a SQL Expression

Available Properties

The following properties are available for use in queries.

$DEPARTMENT

The Department which owns the PC. For example ENGINEERING.

$LOCATION

The PC's Location. For example, Upstairs Office.

$OWNER

The name of the PC user. For example, Ferris Bueller.

$TELNUMBER

The telephone number associated with the PC. For example, 110.

$USERNAME

The User ID of the PC user. For example, FB.

$SWDATE

The date on which the Software Inventory was last saved to the Site database

$HWDATE

The date on which hardware inventory data was last saved to the Site database.

$OfflineArea

The offline area path used by the PC.

$OfflineId

The Client-specific subdirectory of the offline area. Client data is located on path $OfflineArea\$OfflineID. For example: \\AWS\PUSH%Guest\LU0005.


Selecting DISTINCT Records

The SQL keyword DISTINCT eliminates duplicate results from query results. You cannot perform a "SELECT DISTINCT * ..." query on user-specified Client Property.

Use the Select Fields to Display dialog to show just the NODENAME and any other essential fields. Alternatively, edit the generated SQL code in the SQL Code tab.