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

Exporting, information, using, System, Information, Center, program, Importing, database

Get Lenovo ThinkPad T40p PDF manuals and user guides View all Lenovo ThinkPad T40p manuals
Add to My Manuals
Save this manual to your list of manuals

Page 49 highlights

Exporting information using the System Information Center program With the System Information Center program you can generate reports and export them so that they are compatible with any SQL-compliant database. This advanced function (which is typically performed by either a Super-User or an Administrator account is useful when you need to transfer asset information from one database to another. Because the exported information is a .CSV file (a comma-delimited file) you can easily import it into some spreadsheet programs if you need to generate a spreadsheet containing asset reports. This function is useful when giving an asset inventory presentation. Exporting reports is an advanced function. Note: For information about generating reports see "Generating a common report" on page 33. To export either a common or custom report as a .CSV file, 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, click Reports and then select All Reports. 3. Mark the check box next to the type of report you would like to export. 4. In the System Information Center menu bar, click Reports and then select Run. 5. In the System Information Center menu bar, click Output. 6. Click CSV File. 7. Save and download the file to the appropriate folder. Importing information into a database The System Information Center program provides a feature for exporting the results of a custom report into a comma separated value (CSV) file. For more information, see "Creating a task" on page 28 The CSV file can then be imported into another database such as IBM DB2. An example of how this would be done using DB2 is shown in the following procedure: 1. The database table in the target database will need to be defined with columns that have types that are compatible with the values taken from the System Information Center database. Refer to Appendix B, "Using database information," on page 79 for a definition of the tables and the values that are used in the System Information Center database. 2. If you do not already have a table in the target database, create one containing the fields that you will be exporting. The following is an example command: CREATE TABLE MY.USERS (USERID VARCHAR(70) NOT NULL, EMAIL VARCHAR(70) NOT NULL,TITLE VARCHAR(5),FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(30), LOCATION VARCHAR(60), PRIMARY KEY(USERID)) 3. Use the custom report features of the System Information Center program to create a report that displays the information that will be exported in the correct format. For instance, the report would show values for USERID, EMAIL, TITLE, FIRSTNAME, LASTNAME, LOCATION in that order. 4. Create a new task using the CSV_FILE task type. Specify the custom report in step 3 when creating the task. You can either run the task from the Tasks menu or set a schedule for it to run when you create it. Chapter 5. Performing System Information Center advanced functions 41

  • 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
Exporting
information
using
the
System
Information
Center
program
With
the
System
Information
Center
program
you
can
generate
reports
and
export
them
so
that
they
are
compatible
with
any
SQL-compliant
database.
This
advanced
function
(which
is
typically
performed
by
either
a
Super-User
or
an
Administrator
account
is
useful
when
you
need
to
transfer
asset
information
from
one
database
to
another.
Because
the
exported
information
is
a
.CSV
file
(a
comma-delimited
file)
you
can
easily
import
it
into
some
spreadsheet
programs
if
you
need
to
generate
a
spreadsheet
containing
asset
reports.
This
function
is
useful
when
giving
an
asset
inventory
presentation.
Exporting
reports
is
an
advanced
function.
Note:
For
information
about
generating
reports
see
“Generating
a
common
report”
on
page
33.
To
export
either
a
common
or
custom
report
as
a
.CSV
file,
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,
click
Reports
and
then
select
All
Reports
.
3.
Mark
the
check
box
next
to
the
type
of
report
you
would
like
to
export.
4.
In
the
System
Information
Center
menu
bar,
click
Reports
and
then
select
Run
.
5.
In
the
System
Information
Center
menu
bar,
click
Output
.
6.
Click
CSV
File
.
7.
Save
and
download
the
file
to
the
appropriate
folder.
Importing
information
into
a
database
The
System
Information
Center
program
provides
a
feature
for
exporting
the
results
of
a
custom
report
into
a
comma
separated
value
(CSV)
file.
For
more
information,
see
“Creating
a
task”
on
page
28
The
CSV
file
can
then
be
imported
into
another
database
such
as
IBM
DB2.
An
example
of
how
this
would
be
done
using
DB2
is
shown
in
the
following
procedure:
1.
The
database
table
in
the
target
database
will
need
to
be
defined
with
columns
that
have
types
that
are
compatible
with
the
values
taken
from
the
System
Information
Center
database.
Refer
to
Appendix
B,
“Using
database
information,”
on
page
79
for
a
definition
of
the
tables
and
the
values
that
are
used
in
the
System
Information
Center
database.
2.
If
you
do
not
already
have
a
table
in
the
target
database,
create
one
containing
the
fields
that
you
will
be
exporting.
The
following
is
an
example
command:
CREATE
TABLE
MY.USERS
(USERID
VARCHAR(70)
NOT
NULL,
EMAIL
VARCHAR(70)
NOT
NULL,TITLE
VARCHAR(5),FIRSTNAME
VARCHAR(30),
LASTNAME
VARCHAR(30),
LOCATION
VARCHAR(60),
PRIMARY
KEY(USERID))
3.
Use
the
custom
report
features
of
the
System
Information
Center
program
to
create
a
report
that
displays
the
information
that
will
be
exported
in
the
correct
format.
For
instance,
the
report
would
show
values
for
USERID,
EMAIL,
TITLE,
FIRSTNAME,
LASTNAME,
LOCATION
in
that
order.
4.
Create
a
new
task
using
the
CSV_FILE
task
type.
Specify
the
custom
report
in
step
3
when
creating
the
task.
You
can
either
run
the
task
from
the
Tasks
menu
or
set
a
schedule
for
it
to
run
when
you
create
it.
Chapter
5.
Performing
System
Information
Center
advanced
functions
41