Download Oracle Global License Advisory Services (GLAS) data

  • Release version: Washingtondc
  • Updated August 1, 2024
  • 3 minutes to read

    • Download Oracle GLAS data in CSV format to get detailed information on patterns and configuration items. You can also download reports for Oracle Database, Middleware, Oracle Java, VM, and vCenter hardware information.

    Before you begin

    To download Oracle GLAS Java report for versions earlier than Washington DC Patch 9 and Xanadu Patch 3, see KB1704359.

    Role required: admin or glas_admin

    Procedure

    1. Navigate to All > Oracle GLAS Data Collection > Download GLAS Data Collection.Oracle GLAS download page
    2. Download the following reports for Oracle GLAS data:
      • For downloading Oracle Database, Middleware, and Java reports, navigate to Step 1: Download GLAS Data Collection and select your data collection options.
      • For downloading vCenter hardware information based on your environment setup, navigate to Step 2: Download vCenter Hardware Information.
      • For downloading VM information, navigate to Step 3: Download VM Information.
    3. Select the download icon (Download icon).
    4. In the Enter email address dialog box, enter the email address where you want to receive a notification when the report is ready.
    5. Select OK.
      After the report creation status message appears, you can check the status of the download job by selecting the link provided in the message.

      Message for report creation status

      The Oracle GLAS Report Job Log [sn_itom_oracleglas_job_log] table opens in a new window. After your report is successfully created, the status of the report changes to Complete in the Oracle GLAS Report Job Logs table.

    6. Select a job log record to view its details including the unique number, name, status, description, and the date and time when the job log is created and updated.
    7. On the Oracle GLAS Report Job Log form that opens, download your report by navigating to Manage Attachments and selecting download.
      • If you select Oracle Database, the following CSV files are downloaded:
        • ORCL_V$SESSION.csv
        • ORCL_OPTIONS.csv
        • ORCL_DBA_USERS.csv
        • ORCL_DETAIL.csv
        • ORCL_V$LICENSE.csv
        • ORCL_OVERVIEW.csv
      • If you select Oracle Middleware, the following files are exported in the format as shown for the server name and the Oracle product installed:
        • ORCL_OVERVIEW.csv
        • Collection-<Server Name>_<Oracle Product>.tar.bz with the files and directories of the format FMW/u01/app/oracle/config/domains/soa_domain/config/config.xml in it.
      • If you select Oracle Java, the following folders are downloaded:
        • Java folder – contains Java installation information
        • CPUQ folder – contains CPUQ files, vCenter Hardware, and VM information
      Note:
      You can also download the CSV files for Oracle Database by navigating to Oracle GLAS Data Collection > Oracle GLAS Data. From the list that opens, select the table that you want to download and then select Download GLAS Report.

    Result

    The downloaded files appear in the location that you select.

    If the files are empty or contain an error message, check their sizes to verify that they haven't exceeded the limits set in the following properties. Navigate to All > System Properties > All Properties to find the following properties.

    Important:
    Consult with ServiceNow support before changing these properties.
    Property Description
    glide.discovery.file_tracking.max_file_size

    The maximum file size for tracked configuration file content.

    Type: integer

    Default value: 500000
    glide.discovery.file_tracking.max_files_per_ci

    The maximum number of tracked configuration files per CI.

    Type: integer

    Default value: 50
    glide.discovery.file_tracking.change_limit_count

    Number of changes permitted on a tracked configuration file in the defined time window.

    Type: integer

    Default value: 4
    glide.discovery.file_tracking.change_limit_days

    Time window (in days) that limits the number of changes on a tracked configuration file.

    Type: integer

    Default value: 7

    If you receive an error Error: Skipped sensor for Horizontal Pattern because of error in payload: Payload length 5056040 exceeded the limit of 300000, verify that the payload hasn't exceeded the system limit. Navigate to All > MID Server > Properties to find the following properties.

    Property Description
    mid.discovery.max_payload_size

    Defines the maximum overall payload size for the payload of results that come from patterns.

    Type: integer (bytes)

    Default value: 300000

    If you receive an SSH timeout error, you must create and set the following properties. See "Create a MID Server property" in MID Server Properties for details.

    Property Description
    mid.ssh.command_timeout_ms

    Number of milliseconds an SSH command is permitted to run before timing out (default is configurable per MID Server).

    Type: integer
    mid.sa.ssh.timeout

    The SSH timeout in milliseconds.

    Type: integer
    channel_timeout_ms

    The amount of time, in milliseconds, that a MID Server waits for activity when processing an SSH command. If the MID Server doesn’t detect activity within the specified window, the system terminates the command.

    Type: integer