Where the WMI service will be stored in MSDB Dtabases?

• Mani-584606

  SSChampion

  Points: 11788

  More actions

  March 28, 2011 at 12:52 pm

  #248793

  Hi,

  I want to use the WMI with Powershell to monitor SQL Server events.

  And came to know that the WMI creates a service in MSDB (SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 in the msdb database) and then translates the WMI query to Event notifications.

  Where this WMI service will be stored in MSDB database?

• pshaship

  SSCertifiable

  Points: 6125

  More actions

  March 28, 2011 at 12:59 pm

  #1304528

  Use the below queries:

  use msdb

  go

  select * from sys.services

  select * from sys.service_queues

  Thanks