Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - toad

#1
General Support / LogWatch
January 30, 2009, 07:29:05 AM
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
#2
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'
#3
General Support / Re: Useful WinPerf counters
November 17, 2008, 02:42:13 AM
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.
#4
General Support / Useful WMI Queries
November 14, 2008, 07:46:36 AM
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)
#5
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
#6
General Support / Re: Database Structure
November 10, 2008, 06:34:57 AM
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?
#7
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
#8
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.
#9
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.
#10
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
#11
General Support / Re: Database Structure
October 14, 2008, 06:32:58 AM
Many thanks Victor .... all the info I need much appreciated

regards

Geoff
#12
General Support / Database Structure
October 13, 2008, 06:34:20 AM
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
#13
Many thanks Victor ... it was "doing my head in" until I tracked down the sequence. Look forward to your reply
#14
General Support / Communications Failure on WMI Queries
October 06, 2008, 10:41:36 AM
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?
#15
General Support / SNMP and Apache Tomcat
June 16, 2008, 11:07:48 AM
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