KB: How do i gather inventory data that's to be used for an Oracle support ticket

Applies to: Opslogix Oracle Management Pack (all versions)
Last updated: November 2026 · Latest version: 26.11.4544.0

See also: Upgrade guide for 26.11.4544.0 · Version support · Release notes

Run the PowerShell script below on one SCOM management server, then copy the output and send it to the support engineer.

## ---------------------------------------------------------------
## Support script: gather information about the SCOM Oracle environment
## ---------------------------------------------------------------

$MPName = "OpsLogix.IMP.Oracle"

Import-Module OperationsManager
New-SCOMManagementGroupConnection

## management pack versions
Write-Output "------ Management pack versions -------"
Get-SCOMManagementPack | Where-Object { $_.Name -like "*$MPName*" -or $_.Name -like "OpsLogix.BaseLibrary*" -or $_.Name -like "*Licensing*" } | Format-Table Name, Version -AutoSize

## object count per class
Write-Output "------ Object count per class -------"
Get-SCOMClass -Name "$MPName.*" | Get-SCOMClassInstance | Group-Object -Property LeastDerivedNonAbstractMonitoringClassId |
  Select-Object @{Name = 'Class'; Expression = { (Get-SCOMClass -Id $_.Name).Name }}, Count | Format-Table -AutoSize

## Oracle instances and the resource pool that manages them
Write-Output "------ Oracle instances and resource pools -------"
$pools = @{}; Get-SCOMResourcePool | ForEach-Object { $pools[$_.Id.ToString()] = $_.DisplayName }
Get-SCOMClass -Name "$MPName.Instance" | Get-SCOMClassInstance | ForEach-Object {
  $poolId = $_."[$MPName.Instance].ManagedByPool".Value
  [pscustomobject]@{ Instance = $_.DisplayName; Version = $_."[$MPName.Instance].DatabaseVersion".Value; Role = $_."[$MPName.Instance].DatabaseRole".Value; ResourcePool = $pools[$poolId]; Health = $_.HealthState }
} | Format-Table -AutoSize

## Opslogix Oracle Collector service per pool member
Write-Output "------ Collector service -------"
Get-SCOMClass -Name "OpsLogix.IMP.Oracle.Collector.Class.CollectorService" | Get-SCOMClassInstance | Format-Table Path, DisplayName, HealthState, IsAvailable -AutoSize

## configured templates
Write-Output "------ Configured templates -------"
(Get-SCOMManagementGroup).Presentation.GetFolders() | Where-Object { $_.Name -like "*TemplateoutputOpsLogixIMP*" } | Format-Table DisplayName

## overrides
Write-Output "------ Monitor overrides -------"
Get-SCOMOverride -Monitor (Get-SCOMMonitor -Name "$MPName.*") | Format-Table Parameter, Value, Name -AutoSize
Write-Output "------ Rule overrides -------"
Get-SCOMOverride -Rule (Get-SCOMRule -Name "$MPName.*") | Format-Table Parameter, Value, Name -AutoSize
Write-Output "------ Discovery overrides -------"
Get-SCOMOverride -Discovery (Get-SCOMDiscovery -Name "$MPName.*") | Format-Table Parameter, Value, Name -AutoSize