I think this is what you are looking for. If not, it should get you started. I did not find a " time resolved" field, only the last time the alarm was changed. Which I am assuming, if it was resolved or terminated, that would be the last time it was changed. I added in the source object name, as I thought that would be useful. select object_properties.name as 'Node Name', alarms.alarm_id as 'Alarm ID', alarms.message as 'Message', DATEADD(S,alarms.creation_time, '1970-01-01') as 'Date Created',DATEADD(S,alarms.last_change_time, '1970-01-01') as 'Date Last Changed', CONVERT(varchar, (alarms.last_change_time-alarms.creation_time) / 86400) + ':' + CONVERT(varchar, DATEADD(s, (alarms.last_change_time-alarms.creation_time), 0), 108) as 'Age DD:HH:MM:SS' from alarms inner join object_properties on object_properties.object_id=alarms.source_object_id where alarms.alarm_state > 1 order by alarms.last_change_time desc

thank you very much for all the help.

I guess this thread is pretty much an "FYI" now, because I've sorted it. I renamed the index to .old and the upgrade has succeeded. I don't really know enough about databases to know what terrible consequences this will have, but I guess I'll find out. The reason it spent so long on that upgrade step is that the syslog table is 7GB.

Can somebody please run upgrade with -t option and post output? Also, content of failed table before upgrade could be helpful. Best regards, Victor

Hi, tdata tables holds table DCI values, so you should check your table DCIs. If you don't use them then everything should be fine. Best regards, Victor

After upgrade to 2.1 stable - all fine

Ok everything is fine today

I was about to create a thread about this LLDP does in fact work on most MikroTik devices but apparently not on CRS devices - and presumably others that utilize an onboard switch chip as opposed to software switching If you try and poll the MAC database on a CRS you won't get anything. However if you instead use a bridge interface and put the ports in it this will work. Obviously not the greatest as you lose the dedicated switching features and will take a big impact to performance. It may very well be that the information is located in a different OID somewhere. If this could be located and implemented when using mikrotik driver this would solve the issue.

I'm not sure what was done, but this seems to have been resolved in the latest release (Version 2.1). Happiness - Thank you!!! [image: NetXMS Dashboard Resolved.PNG]

Hi Victor, adding the permission solved he problem. thank you very much, Lindeamon

The filter box is bigger because of the new 'Clear' an 'Info' buttons. I was also made bigger and made to show by default in almost all views where it is available. This is because most people didn't know the filter box was available in DCI 'Last Values' views, or in EPP, or server configuration view, etc. So it was an UX change to make the search/filter box more available to people everywhere across the system. I personally think it's good it's being bigger, since it provides new as well as existing users with easier access to it. But that's of course just my opinion

OK what I have: I have data: in alarms Message.  62AEE34128F1F8413C5E6141 this data is in 32 bit float hex Basically I'm  using calc on https://www.h-schmidt.net/FloatConverter/IEEE754.html I have to transform this data split or so to 3 32 bits values 62AEE341 -> 41E3AE62 -> I need result  28.460148 28F1F841 -> 41F8F128 -> I need result  31.117752 3C5E6141 -> 41615E3C  ->I need result  14.085506 in netxms somewhere Is this possible to do in NETXMS?

Hi there, first of all, thanks for this awesome Software. I am trying to add some Icons to the ImageLibrary via Java-API but i am not sure how to do this. What I have already tried: Upload png to Server with uuid as Filename, this works, file is in /var/files/ Instantiate new LibraryImage(uuid, Name, category,...), works also, except for empty Image createImage adds Image to Library with desired Name, but then I get a NullPointerException because of the empty image So, can someone help me on how to get an png-File on the Server into the ImageLibrary? Thanks Andy Edit: Ok, got it working. String objectName = (String)object1.getObjectName(); String fileName = "C:/Users/xxx/Images/" + objectName + ".PNG"; UUID uuid = UUID.randomUUID(); ProgressListener listener = null; byte[] array = Files.readAllBytes(new File(fileName).toPath()); LibraryImage newImg = new LibraryImage(uuid, objectName, "Default", "image/png", false); newImg.setBinaryData(array); s.createImage(newImg, listener); Only Problem now, it takes some time until i can assign the new Image to a Node.

Hi, tables are cleaned by internal housekeeper process according to configured retention times. All tdata_* tables contains data for table DCI. You can reduce their size by reducing retention times on table DCis. Also, version 2.1 uses different format for table data storage, more efficient in terms of consumed space (but less efficient for random access). Best regards, Victor

@victor said in Create DCI Summray Table fails. Access denied [solved]: Hi, what NetXMS version you are using? If on 2.1, make sure administrator user and/or group has access right "Manage DCI summary tables" set. Best regards, Victor Hi, I'm on 2.0.8, but Your tip was right. I was missing access rights. Thank You Stefan

Thanks! This all answers what I needed perfectly!

Thanks!

Hello , I have a script which returns custom attribute to my devices. Now i made a script as external parameter which i am using as DCI. I set up everything and it seems to be working. I am passing two parameters to the DCI first one is from the custom attribute script and the second one is the node_primary_ip. I am applying this in a template, as follows: RStatus(%{script:CustomAttributeSetScript}, %{node_primary_ip}) This is returning the correct parameters in the DCI, but the DCI is not polling at all. If i want to get status for the DCI i must force poll it. If i give the Custom Attribute parameter value manually it is working with no issue and polling on the interval I set up. Best Regards, Adrian

Thanks for the heads up Stan.  That did the trick!!  Thanks again.

The following should work: Create a script called "MyScript" with the following code: node1 = FindNodeObject($node,"NODE1_NAME"); node2 = FindNodeObject($node,"NODE2_NAME"); dci1 = GetDCIValueByDescription(node1,"DCI1_DESCRIPTION"); dci2 = GetDCIValueByDescription(node2,"DCI2_DESCRIPTION"); return dci1 + dci2; Replace NODE1_NAME and NODE2_NAME with the object names of the nodes holding your data. Replace DCI1_DESCRIPTION and DCI2_DESCRIPTION with the DCI descriptions. Create a new DCI on a node, select type "Script" and select the "MyScript" you created earlier. You do not need to use a delta transform for this, as you already transformed the other two DCIs. If you do not get any result, there may be a typo in one of the node names or DCI descriptions or you may have the trusted node check enabled (that's the default) and NODE1_NAME and/or NODE2_NAME do not contain the node you're running the script on in the list of trusted nodes. You can confirm if that's the issue by setting the server configuration variable CheckTrustedNodes to 0 and restarting the NetXMS server. You can always just right-click on a node and "Execute Server Script" and select "MyScript" to see what's happening when you execute it. Documentation references: https://wiki.netxms.org/wiki/NXSL:FindNodeObject https://wiki.netxms.org/wiki/NXSL:GetDCIValueByDescription https://wiki.netxms.org/wiki/SG:Security_Issues Cheers