NetXMS Support Forum

Hi!

Is it supported the "L" extension in the custom schedule (such as in the Quartz java scheduler)? I would like to use a schedule like this:

59 23 L * *

to run a DCI collection at 23:59 in the last day of each month.

Best regards,
Marco

Quote from: andrey--k on April 24, 2014, 08:57:06 PM
Can you try next example:

Code Select Expand

SELECT avg(coalesce(to_number(idata_value),0)) FROM idata_<node_id> WHERE item_id=<dci_id> and idata_timestamp between <time_from> and <time_to>

Hi!,

to_number isn't present in MSSQL, it can be substituted with CAST (as per Victor's suggestion), to have it working on int and float it could be casted always to float as in this example:

SELECT avg(coalesce(cast(idata_value as float),0)) FROM idata_<node_id> WHERE item_id=<dci_id> and idata_timestamp between <time_from> and <time_to>

I would like to suggest also a check for numeric in the where condition (and isnumeric(idata_value)=1), running the above query on my DB I've discovered some dirty unvalid values in my records that caused failing of the query.

The final query should be something like:

SELECT avg(coalesce(cast(idata_value as float),0)) FROM idata_<node_id> WHERE item_id=<dci_id> and isnumeric(idata_value)=1 and idata_timestamp between <time_from> and <time_to>

Is there a little hope to have a GetSumDCIValue implemented in the meanwhile you add this fix? 

Best regards,
Marco

As per subject, it could be useful to have a function to perform the sum of the DCIs for a specified time range (like the GetMin/Max/AvgDCIValue). In my scenario, it will be used to perform cumulative statistics for network traffic (monthly based, with a custom schedule).

Best regards,
Marco

Quote from: andrey--k on April 22, 2014, 09:08:25 PM
to take math functions you should convert data from varchar to digits.
I use transit table in separate shema for this purpose.

Hi andrey--k,

Maybe I didn't understand your reply but my concern was related to the original GetxxxDCIValue, I'm not interested in running the query "manually". I ran the query as per suggestion in the reported thread just as a "proof" for the result. So, I was interested in knowing if the GetAvgDCIValue (for example) fails on floating point numbers only using MSSQL as backend DB or if this is a behaviour common even to the other DB engines supported by NetXMS.

Best regards,
Marco

Hi,

on MSSQL (tried on 2012) the GetxxxDCIValue works only with integer values, not with floating points (the wiki states numeric type).

I tried to simulate "manually" the query using this statement (reported in this thread https://www.netxms.org/forum/configuration/getavgdcivalue-not-working/msg11517/#msg11517):

SELECT avg(coalesce(idata_value,0)) FROM idata_<node_id> WHERE item_id=<dci_id> and idata_timestamp between <time_from> and <time_to>

but with floating point values I get the following error message:

Conversion failed when converting the varchar value '14.2999710' to data type int

Is this a restriction that applies only on MSSQL?

Best regards,
Marco

Quote from: hkusulja on April 20, 2014, 08:28:46 PM
Hi,
Thank you for reply, I am aware of Agent proxy feature which is nice, however in some particular cases I do not have any option to forward / open any of ports, so this is reason why I am using this.
Is there a way to automate push that you mentioned ?

Or I should write this as new feature request ?

Thank you once more

Hi,

I've automated it just writing a batch file that I run as a scheduled task. I'm not aware of a smarter way to do it but, honestly, it works fine in my case and I didn't spend any other time to find a smarter way

Best regards,
Marco

Quote from: hkusulja on April 20, 2014, 12:16:12 PM
Hi,
as I understand, netxms server, connects to the netxms agent on both TCP and UDP 4700 (default.)

However, is there a way, that agent connects to the server (instead oposite) and delivers the desired data?

I have few situations, where my monitored nodes are behind NAT and I can not do port forwarding. Only option is that agent delivers periodicaly (pools) data to the server, and if for some times agent does not report data to the server, we can mark node as down.

Is this feature supported and if so, how to configure it ?

As far as I know the only option to send data to the server is using the command line tools "nxpush" and "nxapush". The problem is that they works only with the "Push" origin, this means that you cannot use the agent collected parameters directly.
If you have the possibility to NAT just one of the nodes you can then use it as proxy to allow the server to connect to the agents installed on the other nodes.

Best regards,
Marco

Quote from: Marco Incalcaterra on February 10, 2014, 03:39:19 PM
I have exactly the same problem (since ver. 1.2.11). I think that it could be a great improvement to have the "Min/Max/Avg" selectable, so that the user can chose when to show it or not (instead of removing the entire legend).

This option has been added in version 1.2.12: it is the "Extended legend" flag.

Quote from: David Hewison on February 10, 2014, 01:49:14 PM
I want the legend, what I don't want is the max and min

David

I have exactly the same problem (since ver. 1.2.11). I think that it could be a great improvement to have the "Min/Max/Avg" selectable, so that the user can chose when to show it or not (instead of removing the entire legend).

Best regards,
Marco

Quote from: Victor Kirhenshtein on February 04, 2014, 09:03:40 PM
It is implemented for quite a while To create a slide show, create new dashboard, add element of type "Dashboard", and in properties of this element, add dashboards you want to display and delay between switches.

Best regards,
Victor

This is a very nice feature, I'm glad you made me discovering
May I suggest the adding of a pause/play button (top right, near the edit, save, refresh) to temporary pause the loop? This could be very helpful to focus on a specific dashboard in case of problems.

Best regards,
Marco

Quote from: Marco Incalcaterra on January 26, 2014, 09:08:01 PM
Is there a way to remove the Max, Avg, and Min values in the line graphs of the dashboards? I like the new info but, in my opinion, there should be the possibility to select if activate or not. If you have a "complex" dashboard with a lot of graphs (like the one attached) the new info will increase the clutter (and doesn't show properly).

Best regards,
Marco

Is there any news on this? I'm not able to remove the clutter from my "complex" dashboard

Best regards,
Marco

Quote from: Percy on February 05, 2014, 12:05:08 PM
hi Marco,

i am not able to put this script
http://wiki.netxms.org/wiki/Script_Example:_Aggregation_of_DCI_values_and_applying_the_95%25_percentile_average

can you help me how to use this script. does it require the DCI if yes what will be the Parameter.

regards
percy

Hi Percy,

I don't know if I did properly understand the example. I don't think that it can be used as-is without specific adaptation to your case.

It has to be executed from a transformation script: it looks for the parent nodes (of the DCI where it is executed), iterates in search of a parent named "all voice" (I suppose that it is the container for the ICMP DCI "packet loss" collected) and if found then it iterates for all the DCIs that have "ICMP: Packet loss to NODE-NAME" (NODE-NAME is substituted into the iterations with the node name). On all the values collected it calculates the 95th percentile.

Best regards,
Marco

Same here on Windows 2003 R2 x64 with MSSQL 2008 R2

Best regards,
Marco

Quote from: Percy on February 05, 2014, 12:05:08 PM
hi Marco,

i am not able to put this script
http://wiki.netxms.org/wiki/Script_Example:_Aggregation_of_DCI_values_and_applying_the_95%25_percentile_average

can you help me how to use this script. does it require the DCI if yes what will be the Parameter.

regards
percy

Hi Percy,

I never used that script, just saw it in the wiki. BTW I added it to the script library but I got an error during execution, I'll try to give it a more deep check later and I'll let you know, I'm a bit in rush now.

Best regards,
Marco

Quote from: Victor Kirhenshtein on February 04, 2014, 09:03:40 PM
It is implemented for quite a while To create a slide show, create new dashboard, add element of type "Dashboard", and in properties of this element, add dashboards you want to display and delay between switches.

Best regards,
Victor

Ooops

Thank you for your support! I added empty dashboards as containers, even if is a bit strange, for the moment I solved my problem.

Best regards,
Marco