locked
No SQL data in an external consult to WMI RRS feed

  • Question

  • WINDOWS SYSTEM, WINDOWS SERVER 2008 R2

    WINDOWS SQL 2005

    I'm trying to consult the SQL parameters from a monitoring platform (ScienceLogic EM7). I have checked the regular configuration to make it and looks OK. Also, I can make some consults with this command (using EM7 cli):

    wmic -U 'DOMAIN\USER%PASSWORD' //IPADDRESS-OF-SERVER "select * from Win32_PerfFormattedData"

    CLASS: Win32_PerfFormattedData_APPPOOLCountersProvider_APPPOOLWAS
    (null)|CurrentApplicationPoolState|CurrentApplicationPoolUptime|CurrentWorkerProcesses|Description|Frequency_Object|Frequency_PerfTime|Frequency_Sys100NS|MaximumWorkerProcesses|Name|RecentWorkerProcessFailures|TimeSinceLastWorkerProcessFailure|Timestamp_Object|Timestamp_PerfTime|Timestamp_Sys100NS|TotalApplicationPoolRecycles|TotalApplicationPoolUptime|TotalWorkerProcessesCreated|TotalWorkerProcessFailures|TotalWorkerProcessPingFailures|TotalWorkerProcessShutdownFailures|TotalWorkerProcessStartupFailures
    (null)|3|946|0|(null)|0|0|0|0|Classic .NET AppPool|0|946|0|0|0|0|946|0|0|0|0|0
    (null)|3|946|1|(null)|0|0|0|1|DefaultAppPool|0|946|0|0|0|0|946|1|0|0|0|0
    (null)|0|1892|1|(null)|0|0|0|1|_Total|0|1892|0|0|0|0|1892|1|0|0|0|0
    CLASS: Win32_PerfFormattedData_ASPNET2050727_ASPNETv2050727
    ApplicationRestarts|ApplicationsRunning|AuditFailureEventsRaised|AuditSuccessEventsRaised|(null)|Description|ErrorEventsRaised|Frequency_Object|Frequency_PerfTime|Frequency_Sys100NS|InfrastructureErrorEventsRaised|Name|RequestErrorEventsRaised|RequestExecutionTime|RequestsCurrent|RequestsDisconnected|RequestsQueued|RequestsRejected|RequestWaitTime|StateServerSessionsAbandoned|StateServerSessionsActive|StateServerSessionsTimedOut|StateServerSessionsTotal|Timestamp_Object|Timestamp_PerfTime|Timestamp_Sys100NS|WorkerProcessesRunning|WorkerProcessRestarts
    0|0|0|0|(null)|(null)|0|0|0|0|0|(null)|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0
    CLASS: Win32_PerfFormattedData_ASPNET642050727_ASPNETv2050727
    ApplicationRestarts|ApplicationsRunning|AuditFailureEventsRaised|AuditSuccessEventsRaised|(null)|Description|ErrorEventsRaised|Frequency_Object|Frequency_PerfTime|Frequency_Sys100NS|InfrastructureErrorEventsRaised|Name|RequestErrorEventsRaised|RequestExecutionTime|RequestsCurrent|RequestsDisconnected|RequestsQueued|RequestsRejected|RequestWaitTime|StateServerSessionsAbandoned|StateServerSessionsActive|StateServerSessionsTimedOut|StateServerSessionsTotal|Timestamp_Object|Timestamp_PerfTime|Timestamp_Sys100NS|WorkerProcessesRunning|WorkerProcessRestarts
    0|0|0|0|(null)|(null)|0|0|0|0|0|(null)|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0

    ************************************

    OUTPUT CUT, IT'S VERY LONG...

    ************************************

    I have checked the SQL instance in the server with the WMITools but, if I make a consult to the SQL instance, I receive the following answer:

    wmic -U 'DOMAIN\USER%PASSWORD' //IPADDRESS-OF-SERVER "select * from Win32_PerfFormattedData_MSSQLNAEMOFINSTANCE_MSSQLNAMEOFINSTANCEDatabases"

    ERROR: Retrieve result data.
    NTSTATUS: NT code 0x80041010 - NT code 0x80041010

    In the Windows Server Logs I can find this:

    ....................................................

    An account failed to log on.

    Subject:
    Security ID:  NULL SID
    Account Name:  -
    Account Domain: -
    Logon ID:  0x0

    Logon Type: 3

    Account For Which Logon Failed:
    Security ID:  NULL SID
    Account Name:  USER
    Account Domain: WORKGROUP

    Failure Information:
    Failure Reason: Unknown user name or bad password.
    Status:  0xc000006d
    Sub Status:  0xc0000064

    Process Information:
    Caller Process ID: 0x0
    Caller Process Name: -

    Network Information:
    Workstation Name: EM7_SS
    Source Network Address: IP-ADDRESS
    Source Port:  48778

    Detailed Authentication Information:
    Logon Process: NtLmSsp 
    Authentication Package: NTLM
    Transited Services: -
    Package Name (NTLM only): -
    Key Length:  0

    This event is generated when a logon request fails. It is generated on the computer where access was attempted.

    The Subject fields indicate the account on the local system which requested the logon. This is most commonly a service such as the Server service, or a local process such as Winlogon.exe or Services.exe.

    The Logon Type field indicates the kind of logon that was requested. The most common types are 2 (interactive) and 3 (network).

    The Process Information fields indicate which account and process on the system requested the logon.

    The Network Information fields indicate where a remote logon request originated. Workstation name is not always available and may be left blank in some cases.

    The authentication information fields provide detailed information about this specific logon request.
    - Transited services indicate which intermediate services have participated in this logon request.
    - Package name indicates which sub-protocol was used among the NTLM protocols.
    - Key length indicates the length of the generated session key. This will be 0 if no session key was requested.

    .............................................

    THINGS HAPPENING:

    1. I don't know why the server is changing the DOMAIN to WORKGROUP, as you can see in the log, when I consult the SQL, but it doesn't change if I made a general consult.

    2. Why data about SQL is not been included in the Win32_PerfFormattedData consult? I have made it many times in many places and it works, you can find the SQL data in that general consult.

    If someone has anything that can help me, I will really appreciate it. Thanks,

    Andres M.


    Andres M. IE Networks Solutions - El Salvador - Guatemala

    Friday, May 3, 2013 4:29 PM