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

Gather information for the OpsLogix support team.

Use this powershell script to gather information about your SCOM Oracle environment. Run this script below on one SCOM MS server. After this copy the output and send it back to the support engineer.

## ---------------------------------------------------------------
## support script for getting information in the environment
## ---------------------------------------------------------------
## Michel Kamp
## ---------------------------------------------------------------

# MP to get
$MPName="OpsLogix.IMP.Oracle"

Import-Module operationsmanager
New-SCOMManagementGroupConnection

## get the MP versions
Write-Output "------ get Mp versions -------"
Get-SCOMManagementPack | where {$_.Name -like "*$MPName*"} | ft Name , version

## get instance count
Write-Output "------ get instance count -------"
Get-SCOMClass -Name "$MPName.*" | Get-SCOMMonitoringObject | group -Property LeastDerivedNonAbstractMonitoringClassId | Select @{Name = ‘Name’; expression ={ Get-SCOMClass -id $_.Name}},Count | ft Name , Count –AutoSize

# get resource pool info
Write-Output "------ get resource pool info -------"
$x = Get-SCOMClass -Name "OpsLogix.IMP.Oracle.Class.OpsMgrResourcePool" | Get-SCOMMonitoringObject
Get-SCOMRelationshipInstance -TargetInstance $x | ft Id, SourceObject , TargetObject


## get configured templates
Write-Output "------ get configured templates -------"
(Get-SCOMManagementGroup).Presentation.GetFolders() | where { $_.Name -like "*TemplateoutputOpsLogixIMP*" } | ft DisplayName

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