SQL Server Performance

how to find wmi event types in namespace

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256b, Sep 4, 2011.

  1. Trev256b Member

    hi - how can i find a list of the wmi event types in a namespace? i know DATABASE_MIRRORING_STATE_CHANGE exists in \\.\root\microsoft\sqlserver\serverevents\<instance_name> but not sure how to find others to see what useful info i can extract...
    Trev256b, Sep 4, 2011
    #1

  2. preethi Member

    I use powershell for this:
    get-wmiobject -namespace "root/default" -list

    Note: Powershell is not installed with SQL Server 2005. You need to install it separately.
    preethi, Sep 4, 2011
    #2

  3. satya Moderator

    ...true POWERSHELL is next gen power to the DBAs .. who loves scripting ;)
    satya, Sep 8, 2011
    #3

Share This Page