Hi - version 2.24 has LOGWATCH, however, I am unable to find any information on it's usage.
It appears from the changelog that server Events in the Event log can be monitored. How do I access this feature? The agent has the option installed and 2.24 sever is also being used
many thanks in advance
Geoff
Below are working SQL commands to extract the latest value for a DCI. Note - the DCI as named for the node is queried not its ID
The following SQL will list all of the idata_value’s for the DCI named 'SQL Cache Memory KB' for node 201
SELECT TOP 1 items.item_id, items.node_id, idata_201.idata_timestamp, idata_201.idata_value
FROM items INNER JOIN
idata_201 ON items.item_id = idata_201.item_id
WHERE (items.description = 'SQL Cache Memory KB') AND (items.node_id = 201)
ORDER BY idata_201.idata_value DESC, idata_201.idata_timestamp ASC
The following SQL code will list the latest idata_value for the DCI named 'SQL Cache Memory KB' for node 201
select A.item_id,A.ts,D.idata_value,I.description from
(
select item_id,max(idata_timestamp) as ts from idata_201 group by item_id
) A
join idata_201 AS D on A.item_id=D.item_id and D.idata_timestamp = A.ts
join items AS I on I.item_id = A.item_id
where description = 'SQL Cache Memory KB'
Sorry but I am not aware of the syntax you have put this post in. Can you please explain how to use the items you have listed .... ie do we use the wmi agent or something else.
I suggest we use this topic to update it with useful WMI queries. My interest is in IIS and SQL. I am having luck with IIS but not SQL, ie a logsize for a particular database is becoming difficult. My set that I can offer, and more will follow are as follows.
iis anoymous users
WMI.Query(root\cimv2,select * from Win32_PerfFormattedData_W3SVC_WebService, TotalAnonymousUsers)
iis service
WMI.Query(root\microsoftiisv2,select * from iiswebservice,state)
nlb status - 1008 shows all is ok - more details here http://msdn.microsoft.com/en-us/library/cc307934(VS.85).aspx
WMI.Query(root\MicrosoftNLB,select * from MicrosoftNLB_Node, StatusCode)
SQL Cache Memory KB
WMI.Query(root\CIMV2,select * from Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryManager,SQLCacheMemoryKB)
SQL Transactions
WMI.Query(root\CIMV2,select * from Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions, Transactions)
iis bytes received
WMI.Query(root\cimv2,select * from Win32_PerfFormattedData_W3SVC_WebService, TotalBytesReceived)
iis bytes sent
WMI.Query(root\cimv2,select * from Win32_PerfFormattedData_W3SVC_WebService, TotalBytesSent)
iis current connections
WMI.Query(root\cimv2,select * from Win32_PerfFormattedData_W3SVC_WebService, CurrentConnections)
available memory
WMI.Query(root\cimv2,select * from Win32_perfRawData_PerfOS_Memory,AvailableMbytes)
Victor - the 2.23 version of wmi works well, however, the 64bit wmi needs the new version as well. Can you please provide me with the 2.23 version of wmi?
many thanks
Geoff
Victor - many thanks for the details on the database structure, however, I am in need to know how to structure an SQL command to fid the latest values. I see where ALL the collected data is but how do you display the latest values with differing timestamps for each item that exists in each nodes data?
Victor - you are BRILLIANT! The new wmi code WORKS .... ohhhh yeah ... sorry about that but now I can use the full functions of this fine product and get those WMI stats that I need
many thanks
I have uninstalled 2.22 server and agents and installed 2.21 server and agents. All WMI Queries on ALL servers, including the server where netxms server is installed, fail communications after the 1st WMI query has completed.
Victor - if your test server and now my 2.21 install are failing then it pints to a problem in my install. I used defaults to install on a Windows 2003 SP2 server using MS SQL for the database. Please advise me on where we can investigate from here.
Sorry for the confusion - WMI worked with the 2.21 version of server and agent. I have a new environment with 2.22 installed and it fails on all WMI queries other than the first. I have since installed the 2.21 agent on a server and the same error occurs, ie the first WMI query qorks, the others have communications failure.
Victor - do you have an eta on a fix for the WMI agent? I know that the older version has worked, however, I would like to continue with the latest version but have limited time to get a monitoring solution going here in the office.
regards
Geoff
Many thanks Victor .... all the info I need much appreciated
regards
Geoff
I have Netxms installed using a MS SQL 2005 database. The plan is to have Netxms gather all the relevant WMI and SNMP statistics and server status then have an intranet webpage developed to extract various information from the Netxms database and show the status, ie are certain servers up, SQL and IIS server transaction statistics.
To achieve this a better understanding of the database fields is needed. Is there any documentation available to show the database field structure, in particular the latest values for node data collection.
many thanks
Many thanks Victor ... it was "doing my head in" until I tracked down the sequence. Look forward to your reply
We have netxms 0.2.22 installed on a Windows 2003 server. An agent is installed on on Windows 2003 server with wmi subagent.
Running the wmi query WMI.Query(root\MicrosoftIISv2,select * from IISWebService,status) works if the agent has been restarted, however, a subsequest running of the same command fails with "Cannot get parameter: Communication failure". Restart the agent and the command works.
Running any other agent command, ie System.Hostname, works everytime. Any valid WMI Query works just once. Is there anything either I have missed or doing wrong?
Has anyone had any experience in monitoring Apache tomcat servers with netxms via SNMP? I have seen where some monitoring systems, like MRTG, use Mod-Apache-Snmp to interface with Apache servers but this looks old (2006).
I am looking for OID values that can be used to monitor via Netxms
many thanks
I am impressed with Netxms, especially the fact the data is stored in SQL which allows for a simple to use data collector.
A few days have been spent on getting SNMP queries to a MS-SQL 2005 system working when I found a webpage showing that Microsoft no longer support SNMP queries to SQL 2005 .... so that leaves WMI to perform the checks.
I see that Netxms has a "Generic WMI Query" option within the agent, but I do not see any information on how to use this feature.
Has anyone done WMI queries on SQL and/or other Windows performance settings? If so how is this done.
Many thanks for your assistance
Below are separate compiles of two mibs - both Microsoft - perfmib and mssql. The error line is also included. Does the netxms mib compiler need mibs in a different format? I am looking to monitor MSSQL, Apache Tomcat and IIS servers as well as Juniper Netscreens and HP equipment?
.\perfmib.txt
.\perfmib.txt: ERROR 003: Parser error - syntax error, unexpected LEFT_PAREN_SYM
, expecting OBJECT_TYPE_SYM in line 4354
Line 4354 is
ms-dhcp-MillisecondsPerPacket(Avg) OBJECT-TYPE
SYNTAX INTEGER
ACCESS read-only
STATUS mandatory
DESCRIPTION
"The average time per packet taken by the DHCP server to send a response."
::= { dHCP-Server 4 }
.\mssql.txt
.\mssql.txt: ERROR 003: Parser error - syntax error, unexpected OCTET_SYM, expec
ting IMPLIED_SYM or UCASEFIRST_IDENT_SYM or LCASEFIRST_IDENT_SYM in line 353
Line 353 is the 2nd last line below
mssqlSrvConfigParamEntry OBJECT-TYPE
SYNTAX MssqlSrvConfigParamEntry
ACCESS not-accessible
STATUS mandatory
DESCRIPTION
"mssqlSrvConfigParamTable entries. The SQL Server configuration
parameter name is used as the index value."
INDEX { OCTET STRING }
::= { mssqlSrvConfigParamTable 1 }
I have spent some time searching the forum and other places for this answer .... but ...
Adding MIBS .... I have tried to add the MS-SQL mib and others only to have them fail with various paser errors. Can someone please either point me in the direction of where to locate mibs that work with NETXMS or explain why these errors occur.
I like NETXMS as it allows you to poll devices and store the results in SQL where a purpose built web page can be created from the results but this requires additional mib information.
Any help on how to compile mibs and the location of mibs that work with Netxms would be very helpful
many thanks in advance ;D
