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