ServiceNow

Export installed software from ServiceNow and upload it with the SIM template, or export Oracle GLAS data from ServiceNow (below).

ServiceNow stores hardware and software discovery data within its CMDB and SAM modules. The relevant data sources include:

• CMDB CI (Configuration Items): Stores device and system data.
• Software Installations [cmdb_sam_sw_install]: Records installed software linked to devices.
• Software Model [cmdb_sam_sw_model]: Defines normalized application data, publisher, and license details.
• ServiceNow REST API: Provides programmatic access to the same tables.

• Role: asset_admin, sam_admin, or equivalent with read/export permissions.
• Access to CMDB or Software Asset Management modules.
• Ensure that Discovery or IntegrationHub scans have populated software installation data.
• Permissions to export list views or reports as CSV.

• A ServiceNow account with API access and read permissions for:
  • cmdb_ci_computer
  • cmdb_sam_sw_install
  • cmdb_sam_sw_model
• Instance URL (e.g. https://yourcompany.service-now.com/api/now/table/).
• A working PowerShell or curl environment for REST API queries.

This is the most straightforward method for most users.

1. Log in to your ServiceNow instance.
2. Navigate to Software Asset → Software Installations. (Alternatively: open the table cmdb_sam_sw_install.list directly.)
3. Use the List View Configuration to display the following fields:

• Installed On → Name (Device Name)
• Software → Name (Software Name)
• Software → Version
• Software → Publisher

4. Apply filters as needed (e.g., Active = true, Discovery Source = ServiceNow).
5. Once the list is displayed, click the List Menu () → Export → CSV.
6. Save the file as ServiceNow_SIM_Export.csv.

Tip: You can save this as a personalized view for recurring exports.

For larger environments or automated reporting, use ServiceNow’s REST Table API.

# ServiceNow SIM Template Export Script
# Requires ServiceNow API credentials with read access to SAM tables

$Instance = "https://yourcompany.service-now.com"
$Username = "api_user"
$Password = "api_password"
$ExportPath = "C:\Exports\ServiceNow_SIM_Export.csv"

# Encode credentials
$EncodedAuth = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$Username`:$Password"))
$Headers = @{
    "Authorization" = "Basic $EncodedAuth"
    "Accept"        = "application/json"
}

# Query Software Installations table
$Url = "$Instance/api/now/table/cmdb_sam_sw_install?sysparm_fields=installed_on.name,software.name,software.version,software.publisher&sysparm_limit=10000"

$Response = Invoke-RestMethod -Uri $Url -Headers $Headers -Method Get

# Process data
$ExportData = @()
foreach ($Record in $Response.result) {
    $ExportData += [PSCustomObject]@{
        "Device Name"        = $Record.'installed_on.name'
        "Software Name"      = $Record.'software.name'
        "Software Version"   = $Record.'software.version'
        "Software Publisher" = $Record.'software.publisher'
    }
}

# Export to CSV
$ExportData | Export-Csv -Path $ExportPath -NoTypeInformation -Encoding UTF8
Write-Host "Export complete: $ExportPath"

For environments with more than 10,000 records, use pagination parameters such as sysparm_offset and sysparm_limit.

The CSV header row must be exactly Device Name,Software Name,Software Version,Software Publisher.

1. Open the Licenseware SIM Template. See SIM template.
2. Copy and paste the CSV content directly into the template, or use the Import from CSV function if available.
3. Verify that the columns align correctly:

• Column A → Device Name
• Column B → Software Name
• Column C → Software Version
• Column D → Software Vendor or Publisher

Ensure there are no blank header rows or extra delimiters before proceeding with upload to Licenseware.

Clean any duplicates or empty rows before saving.

Device Name,Software Name,Software Version,Software Publisher
WS-001,Google Chrome,129.0.6668.90,Google LLC
WS-002,Microsoft Teams,1.7.00.12345,Microsoft Corporation
SRV-03,Oracle Java SE Runtime Environment,8.0.411,Oracle Corporation
LAPTOP-15,Adobe Acrobat DC,24.002.20933,Adobe Inc.

ServiceNow’s Oracle GLAS (Global Licensing and Advisory Services) Data Collection exports Oracle Database, Middleware, Java, VM and vCenter data for upload to the Oracle GLAS data source.

Ensure you have one of the following roles assigned in ServiceNow:

• admin
• glas_admin

1. Navigate to: All > Oracle GLAS Data Collection > Download GLAS Data Collection
2. On the Oracle GLAS download page, you can retrieve the following reports:

• Step 1: Download GLAS Data Collection Select Oracle Database, Middleware, or Java data collection options.
• Step 2: Download vCenter Hardware Information Download hardware data relevant to your vCenter environment.
• Step 3: Download VM Information Download virtual machine configuration details.

3. Select the download icon.
4. Enter your email address when prompted to receive a notification once the report is ready.
5. After the report creation message appears, click the provided link to monitor the download job status.
6. The Oracle GLAS Report Job Log (sn_itom_oracleglas_job_log) opens in a new window. Once the report status changes to Complete, proceed to download.
7. Open the job log record and go to Manage Attachments, then download your report.

Depending on the selected data type, you’ll receive one or more of the following files:

• Oracle Database CSV files including:
  • ORCL_V$SESSION.csv
  • ORCL_OPTIONS.csv
  • ORCL_DBA_USERS.csv
  • ORCL_DETAIL.csv
  • ORCL_V$LICENSE.csv
  • ORCL_OVERVIEW.csv
• Oracle Middleware
  • ORCL_OVERVIEW.csv
  • Collection-_.tar.bz with config file structures
• Oracle Java
  • A folder containing Java installation details and CPUQ files
  • VM and vCenter hardware information in structured format

Note: You can also navigate to Oracle GLAS Data Collection > Oracle GLAS Data, select the table you wish to download, and choose Download GLAS Report directly.

Licenseware supports ingestion of both:

• The ZIP archive downloaded from ServiceNow
• The individual CSV files extracted from the report, specifically those for Oracle Database

Upload the files on the Oracle GLAS data source in Datasources.

If downloaded files are empty or contain errors, check file sizes to ensure they haven’t exceeded ServiceNow’s set limits. You can review or adjust these by navigating to: All > System Properties > All Properties