NetXMS Forum

Hello! Sorry for late response, but it's a lot of writing, and I'm not good in doc writing I have updated NetXMS User Manual with log monitoring section (chapter 7). Updated manual already available at https://www.netxms.org/documentation/netxms_user_manual.pdf. In theory, it should give you all information about log monitoring Feel free to ask any questions. Best regards, Victor

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'

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

I guess you'll need JVM MIB: http://java.sun.com/j2se/1.5.0/docs/guide/management/JVM-MANAGEMENT-MIB.mib

I know that the post is old, But I just want to report what I found in case it helps someone else when searching on this fórum. Please let me know if is there a better way to do this. I found that Dell Servers have a particular way to interact with ACPI on this fórum : http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1307729003111+28353475&threadId=940582 So I made the following query using NetXMS agent : WMI.Query(root\CIMV2\dell, SELECT * FROM CIM_TemperatureSensor where DeviceID=2, CurrentReading) It works perfectly to me as the DeviceID 2 is the "BMC Ambient Temp Sensor" wich gives me better values (only 2 degrees of difference) like if the room temperature is around 25 Celcius, this sensor gives me the value of 270. Also for those who want to explore WMI, I recommend 2 tools. One is Windows native called Wbemtest.exe (C:\windows\system32\wbem) and the other you have to download and is called "WMI Administrative Tools" http://www.microsoft.com/downloads/en/details.aspx?familyid=6430f853-1120-48db-8cc5-f2abdc3ed314 Thanks.

Hello! Second error is definitely a bug in MIB compiler, I'll fix it. I\m not sure about first error - it's quite strange ta have parenthesis as part of object name, I'll check if it's allowed by standard. As a workaround, for first error you can change object name from ms-dhcp-MillisecondsPerPacket(Avg) to ms-dhcp-MillisecondsPerPacket, and delete entire INDEX line for second error. Best regards, Victor