Oracle LMS Data Collection by SQL Adapter

Input CIT

Oracle

Input TQL Query

Host with Oracle with LMS

Triggered CI Data

Name Value
core_number ${Cpu.core_number:NA}
cpu_clock_speed ${Cpu.cpu_clock_speed:NA}
cpu_name ${Cpu.name:}
cpu_specifier ${Cpu.cpu_specifier:NA}
credentialsId ${SOURCE.credentials_id}
discovered_host_name ${HOST.name:NA}
discovered_model ${HOST.discovered_model:NA}
discovered_os_name ${HOST.discovered_os_name:NA}
discovered_vendor ${HOST.discovered_vendor:NA}
document_content ${AuditDocument.document_content:NA}
host_isvirtual ${HOST.host_isvirtual:NA}
ip_address ${SOURCE.application_ip}
logical_cpu_count ${Cpu.logical_cpu_count:NA}
partitioning_amazon_ec2_config ${Amazon EC2 Config.name:NA}
partitioning_hp_npar_config ${HP nPar Config.name:NA}
partitioning_hp_vpar_config ${HP vPar Config.name:NA}
partitioning_hyper-v_partition_config ${HyperV Partition Config.name:NA}
partitioning_ibm_lpar_profile ${IBM LPar Profile.name:NA}
partitioning_solaris_zone_config ${Solaris Zone Config.name:NA}
partitioning_vmware_host_resource ${VMware Host Resource.name:NA}
partitioning_xen_domain_config ${Xen domain config.name:NA}
port ${SOURCE.application_port:NA}
sid ${SOURCE.name:NA}

Used Scripts

  • Oracle_LMS.py

  • OracleLMSDbaUsers.py

  • OracleLMSDetail.py

  • OracleLMSOptions.py

  • OracleLMSOverview.py

  • OracleLMSUtils.py

  • OracleLMSVLicense.py

  • OracleLMSVSession.py

Discovered CITs

  • AuditDocument
  • Composition
  • Oracle

Parameters

Name Description
aggregationLevel The relevant aggregation level. For example: database level, server level, or network level.
applicationName The name of the application running in conjunction with the Oracle product.
applicationStatus The status of the application. For example: development, production, test environment, or training.
group The relevant grouping as you define it. For example: region, or department.
measurementComment Additional comments you want to add to the data.
oracleCSI The Oracle Customer Support Identifier that you use when dealing with Oracle Support Services.
serverNameInTheCluster If the servers are clustered, the names of the servers in the cluster.
size Default size of the compressed LMS data in bytes.
userCountForApplication If the DBA_USERS table has generic usernames or schemas to connect to the application or database, this is the User Count at Application Level.