Using Client Properties in Filter Expressions
Client Properties can be used in SQL Filter Expressions to create dynamic groups. The following field names can be used to extract Client Properties data:
Field Name |
Description |
Example Filter Expression |
PROPNAME |
Property Name |
WHERE PROPNAME='$DEPARTMENT' |
PROPVALUE |
Property Value |
AND PROPVALUE LIKE 'Engineering' |
For example, these two field names can be used in a Filter Expression:
SELECT * FROM NODES INNER JOIN NODEPROP ON NODEPROP.NODENAME = NODES.NODENAME WHERE NODEPROP.PROPNAME = '$DEPARTMENT' AND NODEPROP.PROPVALUE LIKE 'engineering'
SELECT * FROM NODES INNER JOIN NODEPROP ON NODEPROP.NODENAME = NODES.NODENAME WHERE NODEPROP.PROPNAME = '$LOCATION' AND NODEPROP.PROPVALUE LIKE 'upstairs%'
The following table lists the standard Client properties:
Property Name |
Description |
Example |
$DEPARTMENT |
The Client's Department |
Engineering |
$HWDATE |
The date on which a hardware inventory was last saved to the Site database |
20060421 |
$LOCATION |
The Location of the Client PC |
Server Room |
$OWNER |
The PC owner's name |
Ferris Bueller |
$SWDATE |
The date on which a software inventory was last saved to the Site database |
20060421 |
$TELNUMBER |
The user's telephone number |
3684 |
$USERNAME |
The username of the PC user |
NH |
$OfflineArea |
Offline area Directory Path |
|
$OfflineId |
Client-specific subdirectory - the PC's data upload area is located on path $OfflineArea\$OfflineID |
\\AWS\PUSH%Guest\LU0005 |