Lenovo ThinkPad T40p IBM System Information Center Administrator's Guide - Page 43

Generating, custom, report

Page 43 highlights

Note: There are two primary considerations when selecting a report from which to create a custom report. v You might want to use a comprehensive common report to serve as a basis for your custom report. One option is to click Reports from the System Information Center menu bar, select All Assets then click All Assets. This will provide a common report that will be a good foundation on which to create your custom report. v If you select All Reports from the Reports menu item located in the System Information Center menu bar, you are provided with a list of all reports contained within the program. Two types of reports are displayed: primary reports and sub-reports. Primary reports are identified by a 1 placed in the Display column. Sub-reports are identified by a 0 placed in the Display column. Primary reports can be run independently. Some sub-reports work in conjunction with primary reports, and therefore are dependent on a primary report. As a result, some sub-reports cannot be run separately. 5. In the System Information Center menu bar click Options and select Add Query Table. Then click on the table that contains the column you want to add. 6. In the System Information Center menu bar, click Options and select Add Query Column. Then click on the column that contains the specific user or asset information you want to add to the common report. Note: The columns that are displayed after you select Add Query Column are only those that are available from the table you selected in Step 5 or from tables included in the base report you chose to customize. For information about the tables that are provided with the System Information program and the columns associated with each table, see Appendix B, "Using database information," on page 79. 7. To save the report, complete the following procedure: a. In the System Information Center menu bar, select Reports. b. Click Edit Report SQL. c. In the Name field, type the name you would like to assign to the custom report you just created. d. In the Description field, type a phrase or sentence that uniquely describes the function of the custom report you just created. e. In the Menu name field, type the name of the custom report you just created as you would like it to appear in the menu bar located under the Reports menu item. f. Click Submit. Generating a custom report Unless you schedule a task that runs a report automatically, custom reports are run manually after they are created. To generate a custom report, complete the following procedure: 1. At the Logon window, type your User ID and Password. Click Submit. The System Information Center program is displayed. 2. In the System Information Center menu bar, select Reports. 3. Click All Custom Reports or My Custom Reports or Custom Reports. A list of available custom reports is displayed. 4. Mark the check box to the left of the appropriate custom report you want to run. 5. In the System Information Center menu bar, click Reports. Chapter 5. Performing System Information Center advanced functions 35

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108

Note:
There
are
two
primary
considerations
when
selecting
a
report
from
which
to
create
a
custom
report.
v
You
might
want
to
use
a
comprehensive
common
report
to
serve
as
a
basis
for
your
custom
report.
One
option
is
to
click
Reports
from
the
System
Information
Center
menu
bar,
select
All
Assets
then
click
All
Assets
.
This
will
provide
a
common
report
that
will
be
a
good
foundation
on
which
to
create
your
custom
report.
v
If
you
select
All
Reports
from
the
Reports
menu
item
located
in
the
System
Information
Center
menu
bar,
you
are
provided
with
a
list
of
all
reports
contained
within
the
program.
Two
types
of
reports
are
displayed:
primary
reports
and
sub-reports.
Primary
reports
are
identified
by
a
1
placed
in
the
Display
column.
Sub-reports
are
identified
by
a
0
placed
in
the
Display
column.
Primary
reports
can
be
run
independently.
Some
sub-reports
work
in
conjunction
with
primary
reports,
and
therefore
are
dependent
on
a
primary
report.
As
a
result,
some
sub-reports
cannot
be
run
separately.
5.
In
the
System
Information
Center
menu
bar
click
Options
and
select
Add
Query
Table
.
Then
click
on
the
table
that
contains
the
column
you
want
to
add.
6.
In
the
System
Information
Center
menu
bar,
click
Options
and
select
Add
Query
Column
.
Then
click
on
the
column
that
contains
the
specific
user
or
asset
information
you
want
to
add
to
the
common
report.
Note:
The
columns
that
are
displayed
after
you
select
Add
Query
Column
are
only
those
that
are
available
from
the
table
you
selected
in
Step
5
or
from
tables
included
in
the
base
report
you
chose
to
customize.
For
information
about
the
tables
that
are
provided
with
the
System
Information
program
and
the
columns
associated
with
each
table,
see
Appendix
B,
“Using
database
information,”
on
page
79.
7.
To
save
the
report,
complete
the
following
procedure:
a.
In
the
System
Information
Center
menu
bar,
select
Reports
.
b.
Click
Edit
Report
SQL
.
c.
In
the
Name
field,
type
the
name
you
would
like
to
assign
to
the
custom
report
you
just
created.
d.
In
the
Description
field,
type
a
phrase
or
sentence
that
uniquely
describes
the
function
of
the
custom
report
you
just
created.
e.
In
the
Menu
name
field,
type
the
name
of
the
custom
report
you
just
created
as
you
would
like
it
to
appear
in
the
menu
bar
located
under
the
Reports
menu
item.
f.
Click
Submit
.
Generating
a
custom
report
Unless
you
schedule
a
task
that
runs
a
report
automatically,
custom
reports
are
run
manually
after
they
are
created.
To
generate
a
custom
report,
complete
the
following
procedure:
1.
At
the
Logon
window,
type
your
User
ID
and
Password.
Click
Submit
.
The
System
Information
Center
program
is
displayed.
2.
In
the
System
Information
Center
menu
bar,
select
Reports
.
3.
Click
All
Custom
Reports
or
My
Custom
Reports
or
Custom
Reports
.
A
list
of
available
custom
reports
is
displayed.
4.
Mark
the
check
box
to
the
left
of
the
appropriate
custom
report
you
want
to
run.
5.
In
the
System
Information
Center
menu
bar,
click
Reports
.
Chapter
5.
Performing
System
Information
Center
advanced
functions
35