Archive | December, 2012

Your SCOM SDK Query cheat Sheet

12 Dec

So while  reading the title didn’t you had the feeling that you where back at the college banks… This time I will post a small cheat sheet that you can use in the SCOM excel Workbook is posted last time.

So let’s start.

Using the SDK you have the possibility to get SCOM related data using a sort of SQL query language. Defining a query can be tricky if you don’t know what all possibility’s are. And for sure remember that the key properties are case sensitive !

And please don’t think I found this out my self , all the credits go to the MS Product team at http://msdn.microsoft.com/en-us/library/hh328943.aspx I only wanted to make one page for all.

The query syntax can be found here : http://msdn.microsoft.com/en-us/library/bb437603.aspx (this a 2007 page but is also valid for 2012)

You will see more types of data you can get. I can already tell you that the vnext SCOmExcelWorkbook will be extended with most of the data types shown’ below.

Events

  • Id
  • OriginalId
  • MonitoringObjectId
  • MonitoringClassId
  • MonitoringObjectName
  • MonitoringObjectDisplayName
  • MonitoringObjectPath
  • MonitoringObjectFullName
  • MonitoringRuleId
  • PublisherName
  • Number
  • CategoryId
  • User
  • Channel
  • LevelId
  • LoggingComputer
  • TimeGenerated
  • TimeAdded
  • EventData
  • EventParameters

 

Alerts

  • Id
  • Name
  • Description
  • MonitoringObjectId
  • MonitoringClassId
  • MonitoringObjectName
  • MonitoringObjectDisplayName
  • MonitoringObjectPath
  • MonitoringObjectFullName
  • IsMonitorAlert
  • ProblemId
  • MonitoringRuleId
  • ResolutionState
  • Priority
  • Severity
  • Category
  • Owner
  • ResolvedBy
  • TimeRaised
  • TimeAdded
  • LastModified
  • LastModifiedBy
  • TimeResolved
  • TimeResolutionStateLastModified
  • CustomField1
  • CustomField2
  • CustomField3
  • CustomField4
  • CustomField5
  • CustomField6
  • CustomField7
  • CustomField8
  • CustomField9
  • CustomField10
  • TicketId
  • Context
  • ConnectorId
  • LastModifiedByNonConnector
  • MonitoringObjectInMaintenanceMode
  • MonitoringObjectHealthState
  • ConnectorStatus
  • NetbiosComputerName
  • NetbiosDomainName
  • PrincipalName
  • AlertParams
  • SiteName
  • MaintenanceModeLastModified
  • StateLastModified
  • Management Packs
  • Id
  • Sealed
  • Name
  • FriendlyName
  • Version
  • KeyToken
  • LastModified
  • TimeCreated
  • DisplayName
  • Description
  • VersionId

Performance

  • Id
  • MonitoringObjectId
  • MonitoringClassId
  • MonitoringObjectName
  • MonitoringObjectDisplayName
  • MonitoringObjectPath
  • MonitoringObjectFullName
  • MonitoringRuleId
  • InstanceName
  • ObjectName
  • CounterName
  • HasSignature
  • LearningMonitoringRuleId
  • LastSampledValue

Diagnostics

  • Id
  • Name
  • Accessibility
  • ManagementPackId
  • Enabled
  • TargetMonitoringClassId
  • MonitorId
  • ExecuteOnState
  • Remotable
  • Category
  • Timeout
  • TimeAdded
  • LastModified
  • DisplayName
  • Description
  • HasNonCategoryOverride

Discoveries

  • Id
  • Name
  • Accessibility
  • ManagementPackId
  • Enabled
  • TargetMonitoringClassId
  • ConfirmDelivery
  • Remotable
  • Category
  • Priority
  • TimeAdded
  • LastModified
  • DisplayName
  • Description
  • HasNonCategoryOverride

Rules

  • Id
  • Name
  • ManagementPackId
  • TargetMonitoringClassId
  • Enabled
  • Category
  • DisplayName
  • Description
  • ConfirmDelivery
  • TimeAdded
  • LastModified
  • Remotable
  • Priority
  • DiscardLevel
  • HasNonCategoryOverride

 

Monitors

  • Id
  • Name
  • ManagementPackId
  • Accessibility
  • DisplayName
  • Description
  • TargetMonitoringClassId
  • Algorithm
  • AlgorithmParameter
  • MonitoringRelationshipClassId
  • Category
  • MemberMonitorId
  • ParentMonitorId
  • IsUnitMonitor
  • IsInternalRollupMonitor
  • IsExternalRollupMonitor
  • AlertOnState
  • AlertAutoResolve
  • AlertPriority
  • AlertMessage
  • HasNonCategoryOverride

Recoveries

  • Id
  • Name
  • Accessibility
  • ManagementPackId
  • Enabled
  • TargetMonitoringClassId
  • MonitorId
  • ResetMonitor
  • ExecuteOnState
  • MonitoringDiagnosticId
  • Remotable
  • Category
  • Timeout
  • TimeAdded
  • LastModified
  • DisplayName
  • Description
  • HasNonCategoryOverride

Tasks

  • Id
  • Name
  • ManagementPackId
  • TargetMonitoringClassId
  • Enabled
  • Category
  • DisplayName
  • Description
  • Accessibility
  • Remotable
  • Timeout
  • TimeAdded
  • LastModified

TaskResults

BatchId
ErrorCode
ErrorMessage
Id
LastModified
LocationId
ManagementGroup
ManagementGroupId
Output
ProgressData
ProgressLastModified
ProgressMessage
ProgressValue
RunningAs
Status
StatusLastModified
SubmittedBy
TargetClassId
TargetObjectId
TaskId
TimeFinished
TimeScheduled
TimeStarted

Overrides

  • Id
  • Name
  • ManagementPackId
  • TargetId
  • ContextId
  • ContextObjectId
  • Value
  • Enforced
  • DisplayName
  • Description
  • TimeAdded
  • LastModified

 

Happy SCOMMING

Michel Kamp

Advertisements