User`s guide

To create the $USVCS format:
1. Make the SAS PROGRAM EDITOR window the active window.
2. Issue this command
include !sasroot/misc/cpe/csgfmt2
SAS displays the program in the body of the PROGRAM EDITOR window.
The program has a comment that describes the PDB table and level on which it runs to create the format. In this case, the
program is designed to run on SNMP MIB-II data in the DETAIL.HN2NIX table.
3. To modify the program so that the format is saved in SITELIB.CPFMTS and, thus, is available to any IT Service Vision
user at your site, in the program portion of csgfmt2, edit this line:
if _n_=1 then put "PROC FORMAT;" /
to be
if _n_=1 then put "PROC FORMAT library=sitelib.cpfmts;" /
Note: If you do not save the format in SITELIB, the format lasts only as long as your current SAS session. To be able to
save the format in SITELIB, prior to submitting this program you must invoke the IT Service Vision server with
SITEACC=WRITE.
Note: You may want to keep the FORMAT procedure code as part of your daily job so that it is easy to remember how
to update the
$USVCS format.
4. To build the format, select Locals -> Submit.
5. To use this format, in the Local Where expression or Global Where expression (see above), you can construct a WHERE
expression like this:
put(machine,$USVCS.) ? ’IPGATEWAY’
Note: You may find it helpful to look at other IT Service Vision supplied examples for building formats in other ways. For
instance, the csgfmt1 example program builds a format $UMACHTY that contains a user-supplied list of key machines. To use
this format, you can construct a WHERE expression like this:
put(machine,$UMACHTY.) = ’SERVER’;
Because this format uses a user-supplied list rather than an automatic list, you need to edit the program and rebuild the format if
the list of key machines in your network changes.
Note:
You may want to keep the FORMAT procedure code as part of your daily job so that it is easy to remember how to
update the $USVCS format.
Note: For more information on the example programs and their formats, see the comments in the programs. For more
information on user-written formats in general, see "The FORMAT Procedure" in the SAS Procedures Guide in the
documentation for your current version of SAS.
Using One or More Formula Variables
Formula variables are variables whose values are calculated (from the values of other variables) when you access the data. The
values of the formula variables do not occupy disk space in the PDB.
You can add formula variables to PDB tables by using the the IT Service Vision server’s interactive interface or by using the IT
Service Vision %CPDDUTL macro. It is generally preferable to use the %CPDDUTL macro for your production PDB because
the macro documents what you did exactly and enables you to add the variables to many tables easily and accurately.
For information on adding a formula variable using %CPDDUTL, see the Macro Reference documentation for IT Service