Creating custom reports – HP Integrity NonStop H-Series User Manual
Page 333
Generating DSM/SCM Reports
DSM/SCM User’s Guide — 529846-014
18 - 12
Creating Custom Reports
f.
Update the parameter type and description in DSM/SCM if you changed the
type or usage of a parameter when customizing a report.
1. Click Parameter list.... (You can also click this button from the Modify
Report dialog box.)
2. Select the parameter to modify.
3. Click Modify param....
DSM/SCM displays the Modify Parameter Definition dialog box, which
contains a scrollable list of parameter types:
To change the parameter type, scroll through the list of types and
select the new type.
To change the parameter description, enter up to three lines of text in
the Description field. You can overwrite existing text.
4. Click OK.
g. Click OK.
Creating Custom Reports
To create customized reports, use the SQL/MP report writer. To create a custom report,
create an IN_file outside of DSM/SCM that defines the report. The IN_file contains
appropriate Report Writer formatting commands and a SELECT statement that extracts
values from the DSM/SCM host database. DSM/SCM provides a set of shorthand
views of its database that provide quick access to the database. (See
When creating custom reports, use parameters to generalize your reports. For
example, this SELECT statement in a report’s IN_file selects the product names and
numbers for a given software input:
SELECT P.PRODUCT_NAME, P.PRODUCT_NUMBER
WHERE P.INPUT_NAME=?SW_INPUT_NAME
When you request the report whose definition contains this SELECT statement, specify
a value for the parameter SW_INPUT_NAME. The SELECT statement selects the
product name and number for a specific input name based on the value you specify. To
later generate the same report for a different input name, pass the input name as a
parameter.
Note. Avoid using INPUT_NAME, CONFIGURATION_REVISION, CONFIGURATION
REVISION1, or CONFIGURATION_REVISION2 as parameter names. Some views used by
standard reports use the SQL LIKE clause, which appends a % character to these parameter
names before submission to SQLCI.