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:
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.