| |
Subscribe to RSS feed 
|
 |
|
Browse by categories | Browse by alphabetical list
| Server, Network & Device Management (Systems Management) Storage Management >> Tivoli Storage Manager
ITSM uses pre coded SQL statements to query the ITSM database to find any information you may need. Custom SQL statements can be created if
need be to create different reports or views.
To help you find what information is available in the database, Tivoli Storage Manager provides three system catalog tables:
SYSCAT.TABLES
Contains information about all tables that can be queried with the SELECT command.
SYSCAT.COLUMNS
Describes the columns in each table.
SYSCAT.ENUMTYPES
Defines the valid values for each enumerated type and the order of the values for each type.
You can issue the SELECT command to query these tables to determine the location of the information that you want. For example, to get a list of all tables available for querying in the database, enter the following command:
select * from syscat.tables
>> All or Other Storage Management Products
>> Tivoli Continuous Data Protection For Files
Security Management >> IBM Tivoli Security Compliance Manager
IBM Tivoli Security Compliance Manager (TSCM) uses 'collectors' to pull local machine settings dealing with security policy (i.e. patch level, AV signature level, password expiration setting, etc., etc.). These collectors are Java code and are used by an agent (the agent decides based on policy which collectors to download and run). The agent ultimately sends the data up to the server where the data is stored in a DB and reports may be run.
>> All Security Management Products
>> IBM Tivoli Netcool for Security Management
Business Application Management z/OS Systems Management Asset Management |
|
|
