I try to monitor the local installed MS SQL Server. What I want is to see if the Server state is 0 (unknown state), 1 (started), 2 (paused) or 3 (stopped)?
Browsing the SNMP with the WUP Net Tools I get back: For 1.3.6.1.4.1.311.1.4.1.1.1.1.5: mssqlSrvState (not really what I want - should be 0,1, ...) When I browse all Sub items for 1.3.6.1.4.1.311.1.4.1.1.1.1 I get: mssqlSrvVendorName.21.77.105.99.114.111.115.111.102.116.32.67.111.114.11 2.111.114.97.116.105.111.110 "Microsoft Corporation" mssqlSrvProductName.21.77.105.99.114.111.115.111.102.116.32.67.111.114.1 12.111.114.97.116.105.111.110 "MS SQL Server" mssqlSrvVersion.21.77.105.99.114.111.115.111.102.116.32.67.111.114.112.1 11.114.97.116.105.111.110 8.00.194 mssqlSrvContact.21.77.105.99.114.111.115.111.102.116.32.67.111.114.112.1 11.114.97.116.105.111.110 is4o mssqlSrvState.21.77.105.99.114.111.115.111.102.116.32.67.111.114.112.111 .114.97.116.105.111.110 1 When I try the same for 1.3.6.1.4.1.311.1.4.1.1.1.1.5 with a different MIB Browser (AdventNet MibBrowser 3.2) I get the right value back. How can I do in wup to see if the state is up or down, what can do to see which state the server has? After I compiled the MSSQL MIB successfully to WUP, I started to add a custom monitor/service with: object id: 1.3.6.1.4.1.311.1.4.1.1.1.1.5 check it for: constant value value: 1 if value matches, the host is: up No chance. The "host" is down. (but I know the host is UP) Then I tried different things like: object id: 1.3.6.1.4.1.311.1.4.1.1.1.1.mssqlSrvState.21.77.105.99.114.111.115.111.1 02.116.32.67.111.114.112.111.114.97.116.105.111.110 check it for: constant value value: 1 if value matches, the host is: up or object id: 1.3.6.1.4.1.311.1.4.1.1.1.1 check it for: constant value value: mssqlSrvState.21.77.105.99.114.111.115.111.102.116.32.67.111.114.112.111 .114.97.116.105.111.110=1 if value matches, the host is: up Still no chance. The "host" is down. (but I know the host is UP) So where is the error? Is it me? What do I have do to? thanks Greg Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
