How to find notifications that belong to some user

Run this:


Get-NotificationSubscription | foreach {
 $ns = $_.DisplayName
 $_.ToRecipients | foreach {
  If ($_.Name -match "Anders Nil") {
   Write-Host $ns
  }
 }
}

How to use correct XPath for different data types

OLE DB Monitor, context:

<DataItem type="System.OleDbData" time="2013-11-06T16:21:55.2097358+01:00" sourceHealthServiceId="98CB9B44-239D-CB7C-F9AE-4B92F852C344">
<HRResult>-2147467259</HRResult>
<ResultLength>37</ResultLength>
<Result>Data Source could not be initialized</Result>
<InitializationTime>21198</InitializationTime>
<OpenTime>0</OpenTime>
<ExecutionTime>0</ExecutionTime>
<FetchTime>0</FetchTime>
<RowLength>0</RowLength>
<OriginalDataLength>0</OriginalDataLength>
<ErrorDescriptionLength>40</ErrorDescriptionLength>
<ErrorDescription>ORA-12170: TNS:Connect timeout occurred</ErrorDescription>
<ResultCode>1</ResultCode>
</DataItem>

Example xpath that should be used for the file:

Result: $Data/Context/DataItem/Context/DataItem/Result$ 
ErrorDescription: $Data/Context/DataItem/Context/DataItem/ErrorDescription$
HRResult: $Data/Context/DataItem/Context/DataItem/HRResult$

Windows Service monitor, context:

<DataItem type="System.PropertyBagData" time="2013-11-04T15:21:13.1497326+01:00" sourceHealthServiceId="83648EC9-E97F-E444-F446-2E8EABEA0894">

<Property Name="State" VariantType="3">4</Property>

<Property Name="ServiceType" VariantType="3">16</Property>

<Property Name="StartMode" VariantType="3">2</Property>

<Property Name="ErrorControl" VariantType="3">1</Property>

<Property Name="TagId" VariantType="3">0</Property>

<Property Name="ProcessId" VariantType="3">3416</Property>

<Property Name="Name" VariantType="8">PMSEPS_GOYADA_XXST_TEST</Property>

<Property Name="BinaryPathName" VariantType="8">c:\Program Files (x86)\test\EPS_SERVER_XXST_GOYADA\EXE\exefile.exe</Property>

<Property Name="LoadOrderGroup" VariantType="8"/>

<Property Name="Dependencies" VariantType="8"/>

<Property Name="ServiceStartName" VariantType="8">someuser</Property>

<Property Name="DisplayName" VariantType="8">e-Product Server (GOYADA) - XXST_TEST</Property>

<Property Name="Description" VariantType="8"/>

</DataItem>

Example xpath that should be used for the file:

Service Name: $Data/Context/DataItem/Context/DataItem/Property[@Name='DisplayName']$ ($Data/Context/DataItem/Context/DataItem/Property[@Name='Name']$)
State: $Data/Context/DataItem/Context/DataItem/Property[@Name='State']$
ServiceStartName: $Data/Context/DataItem/Context/DataItem/Property[@Name='ServiceStartName']$
BinaryPathName: $Data/Context/DataItem/Context/DataItem/Property[@Name='BinaryPathName']$ 

Troubleshoot DiscoverSQL2005DBEngineDiscovery.vbs

How to troubleshoot warning alert in SCOM 2007:

Command executed:

"C:\WINDOWS\system32\cscript.exe" /nologo "DiscoverSQL2005DBEngineDiscovery.vbs" {E71360F6-C12E-8326-4539-FBC9D78862F5} {E6607398-183B-5B70-A183-878016FCF334} sfrfidcprdb002p.domain.name sfrfidcprdb002p.domain.name sfrfidcprdb002p "Exclude:"


Alert Description:

The process started at 5:56:12 AM failed to create System.Discovery.Data, no errors detected in the output. The process exited with 0.


In event log:

DiscoverSQL2008DBEngineDiscovery.vbs : The Query 'select * from SqlService where SQLServiceType ='1'' did not return any valid instances.  Please check to see if this is a valid WMI Query.. Invalid class

Solution:

From a command prompt, browse to the folder “C:\Program Files (x86)\Microsoft SQL Server\100\Shared”
Run mofcomp sqlmgmproviderxpsp2up.mof