Symantec ALTIRIS DEPLOYMENT SOLUTION 6.9 SP4 - V1.0 - Page 442

Deployment Solution 442
Tokens: Dynamic Database Access
To return the names of the computers:
%#!computer@computer_name%
To return the color column from a custom database and table that has the computer_id
column in it:
%#DBAlias!table@color%
To return the color column from the first record from a custom database and table:
%#DBAlias^!table@color%
Syntax Two
%#Alias*”SQL query statement”%
Examples
To return the names of the computer with an SQL statement:
%#*”SELECT computer_name from computer where computer_id =
1234567”%
To return the color column from a custom database and table with a computer_id
column:
%#DBAlias*”SELECT color from table where computer_id = 1234567”%
To return the color from the first record from a custom database and table:
%#DBAlias*”SELECT color from table”%
* Indicates that the following text is an SQL statement.