User`s guide

WHICHAID=attrid in (65134 65980 64900)
selects only the variables with the indicated values of attrid
.
WHICHMTH=
This parameter is used to subset the data so that the resulting table definitions reflect only the model types
that you select.
The value of this parameter is a list of the model types that should be used for creating tables. For
example:
WHICHMTH=mth in (65134 65132)
selects only those device types for table creation. Records for models of other types will not be used to
determine which attributes are included in the table.
WHICHTAB=NEW
This parameter is used to subset the data so that the resulting definitions reflect only the tables that are not
already known to IT Service Vision. Setting this parameter to ALL will cause the macro to create
CPDDUTL control statements for all the different tables (model types) encountered in the data sets.
Leaving the value of this parameter equal to
NEW
will cause the macro to generate CPDDUTL statements
only for model types that do not already have matching table definitions in IT Service Vision.
WHICHVAR=ALL
This parameter is used to subset the data so that the resulting table definitions reflect only the variables
that you select.
Leaving the value of this parameter equal to ALL will cause the macro to generate CPDDUTL control
statements for all attributes encountered in the data sets.
Setting this parameter to NEW will cause the macro to generate CPDDUTL control statements only for
attributes that were not previously defined in IT Service Vision.
For example, this program (which you can type in and submit from the SAS PROGRAM EDITOR window) generates an IT
Service Vision table definition that contains all the attributes exported into specgway.stat and lists the table definition in
the SAS LOG window:
* Define the specgway libref;
libname specgway ’/usr/spectrum/export.output’ ;
* Generate table definition statements;
%csatr2dd(modtyp=specgway.modtyp,
attr=specgway.attr,
model=specgway.model,
stat=specgway.stat,
outfile=/tmp/table.ddutl,
whichtab=ALL,
whichvar=ALL) ;
* Read table definition statements into %CPDDUTL;
%cpddutl (filename=/tmp/table.ddutl, list=y) ;
If you want to write the SAS log to an external file, see Prerequisite 1: You have a printed copy of the table definition(s)
in
Section 2, Task 1: Customize and Verify your Test PDB
for the steps.