NetXMS Forum

Thanks, it works perfectly

Also I think that would be nice if we can have a standard repository/post where all can share their customized reports.

Hi everyone.

1. Is there a way to create thresholds if a event keeps for last n minutes.
   For example, alert if a node is down for more than 5 minutes or alert if bandwith is above xxx for more than 10 minutes?

2. I need to check for network interfaces error and create an alert if error on some interface increase, I suppose that I have tu use the option "diff with previous value" do you have any example?

Hi everyone,
I have implemented netxms server with sql server 2016 and I have enabled reporting module. At the moment I can execute predefined report "Alarms Resolution time"
Also I have downloaded JasperStudio to create reports and I can view the report properly (On Jasper Studio Console). However, I would like to generate .jar file to integrate it with netxms.
I have seen some recomendation regarding use "maven package" command to generate .jar files. I have installed maven on windows but I realize that need a pom.xml file to make it wok properly.
Anyone  has a quick guide that I can follow?. I have seen that file (pom.xml) on java projects. It does mean that I have to use a java IDE like eclipse and jasper complement?.
What do you think would be the best way to do it?

Hi,
Recently I have some issues migrating from postgresql to windows server 2012 + sqlserver 2016
I'm attaching my configurations samples.
I also remove "lib" folder (due size of file) but you can restore them if you download reporting server https://netxms.org/download/releases/2.2/2.2.12/netxms-reporting-server-2.2.12.zip
You can copy the folder, change path of logs, modify users and password and should work.
On my case, my instalation path is: C:\NetXMS\Reporting\

Also, here is updated link for sql scrips (you have to execute them before configure reporting server):
https://github.com/netxms/netxms/tree/master/src/java/nxreporting/sql

I had an issue after execute this script:
https://github.com/netxms/netxms/blob/master/src/java/nxreporting/sql/mssql/nxreporting.sql

it says that you should create the sequence:
CREATE SEQUENCE HIBERNATE_SEQUENCE
  INCREMENT BY 1
  MINVALUE 1
  CACHE 20;

it didn't work for me, so I had to execute the next script:
create table hibernate_sequence(
    next_val INTEGER NOT NULL,
 PRIMARY KEY(next_val)
);
insert into [dbo].[hibernate_sequence] (next_val) values (3);

that should be enough to make it works

sorry for my english, I speak spanish.
hope this could be helpful

---

Reporting.zip

I think that you can use this link: https://git.netxms.org/public/reporting-server.git/tree/refs/heads/master:/sql?js=1

Thanks Victor, it works perfectly.
¿Is there a way to automaticaly restart agent after a policy change?

Hi,

I'm using ActionShellExec option in the configuration file to execute a command on a remote host.
I have the following is my configuration file:

##############################################################config file
MasterServers = CPRG-MRED
ConfigIncludeDir = C:\NetXMS\etc\nxagentd.conf.d
LogFile = {syslog}
FileStore = C:\NetXMS\var
SubAgent = ecs.nsm
SubAgent = filemgr.nsm
SubAgent = ping.nsm
SubAgent = logwatch.nsm
SubAgent = portcheck.nsm
SubAgent = winperf.nsm
SubAgent = wmi.nsm
ActionShellExec=DisplayServices:wmic service get DisplayName,name,startname
##############################################################config file

It works fine , but the problem is when I configure that option in a policy :

<config>
    <agent>
        <!-- there can be added comment -->
        <MasterServers>X.X.X.X</MasterServers>
        <ConfigIncludeDir>C:\NetXMS\etc\nxagentd.conf.d</ConfigIncludeDir>
        <FileStore>C:\NetXMS\var</FileStore>
        <LogFile>{syslog}</LogFile>
        
        ###################################### INI SUBAGENTES
        <SubAgent>ecs.nsm</SubAgent>
        <SubAgent>filemgr.nsm</SubAgent>
        <SubAgent>ping.nsm</SubAgent>
        <SubAgent>logwatch.nsm</SubAgent>
        <SubAgent>portcheck.nsm</SubAgent>
        <SubAgent>winperf.nsm</SubAgent>
        <SubAgent>wmi.nsm</SubAgent>
        <SubAgent>ssh.nsm</SubAgent>
        <SubAgent>netsvc.nsm</SubAgent>
        <SubAgent>dbquery.nsm</SubAgent>
        ###################################### FIN SUBAGENTES

        <ActionShellExec>DisplayServices:wmic service get DisplayName,name,startname</ActionShellExec>
                
    </agent>
    
    <filemgr>
        <RootFolder>C:\</RootFolder> # read/write access
        <RootFolder>D:\</RootFolder> # read/write access
    </filemgr>

    <WinPerf>
        <EnableDefaultCounters>yes</EnableDefaultCounters>
    </WinPerf>
</config>

It doesnt works anymore and I get an error: Cannot execute action on node CPRG-MCFE: Communication failure

I'm using 2.2.10 version. What suppose that show threshol option should do?

Thanks. As you said. It worked in version 2.2.4.

Yes, that option is useful to find a device connected to a switch. But if you try to find the switch "Bridge Base Address"  it doens't work.

Hi

Some time ago, you created a functionality that allowed you to search for an object created in netxms by its IP address. This functionality is great.
It would be nice if they could search for a device by its MAC address. For example, although the switches have many MAC addresses, they have one that serves to identify the device. This serves for example; when the STP topology is calculated.
Being able to search for a device of this type by its MAC address, would help in cases of problem solving.

Hello,

Please, help me with this topic. I defined the ThresholdRepeatInterval in 600 seconds. All alarms are issued again after 10 minutes in case they have not been resolved.
However, after updating to netxms 2.2.3, I realized that it is not taking into account the time defined in ThresholdRepeatInterval for the DCI that have a script as a threshold.
Probe configuring the "Repeat Interval" directly in a DCI but it does not work. I do not know if it is an error of this version?

my script is the next:

ifName = $dci->name;
indexArray = SplitString(ifName,".");
ifIndex = indexArray[indexArray->size - 1];
interface = GetInterfaceObject($node, ifIndex);
ifSpeed = interface->speed;
actualSpeed = $1;
if (actualSpeed > 0 && ifSpeed > 0)
{
    usedBandwidthPerc = format((int64 (actualSpeed) * 100) / int64(ifSpeed),1,2);
// trace(0,$node->name);
// trace(0,"ifIndex-> " . ifIndex);
// trace(0,"ifSpeed-> " . ifSpeed);
// trace(0,"ActualSpeed-> " . actualSpeed);
// trace(0,"usedPercentage-> " . usedBandwidthPerc);
}
else
{
    usedBandwidthPerc = 0;
}
if (usedBandwidthPerc >= 80)
{
    return true;
}
else{
    return false;
}

---

I did what you told me.
with debugging I could realize that "$dci->instance" was returning the name of the iface instead index(returned in instance discovery)
I have to create another function that return iface index by providing ifname.
Thanks for your help

Any Help?

Yes your point is valid but I know that is possible, if I change the script and return any value, It appears on dci description.
I would like to know how to do it.

Hi everyone, I have an issue.
I don't know if I'm doing something wrong.
I have following script that I'm going to use to avoid collection of wrong values (hundred of TB)  obtained from snmp "iftable"
I dont get any error (of sintaxis) but the script is not performing any action.
In adition, there is a way to debug this scripts used on transformation tab?. I'm using Windows Server 2012R2 as Netxms Server and PostgreSQL

[script]
interface = GetInterfaceObject($node, ((int)$dci->instance));
speed = interface->speed;
if ($1 > speed){
    return 0;
}
else{
    return $1 * 8;
}

Hello everyone, do you know how can I call a script from a dci description?
for example, this is the description of a dci: TrafficIN %{script:getIfNameByName({instance-name})}
this is my script:
scriptName:getIfNameByName
sub getIfName(netString)
{
    if (length(netString) > 0)
    array a;
    a [length(netString)];
    a = SplitString(netString, " ");
    return (a [
                      (a->size)-1
                  ]
              );
}
return getIfName($1);
how can I call that script and send "instance-name" as parameter?

Hi everyone,
I was looking for a way to create a dci for network traffic on all interface address.
I'm using a template and instance discovery for the process. Now I know that I can use the agent list "Net.InterfaceList" to get interface index and then with Net.Interface.BytesIn64({instance}) get the data I need.
I use following Instance discovery filter script that Alex Kirhenshtein created:
if ($1 ~= "^([0-9]+) .*")
{
      return %(true, $1); // at this point $1 contains first matching group
}
return false;

I was trying to modify regex string to "^[0-9](?!.*127\.0\.0\.1)" to avoid loopback interface.
But I get error "execution error: Error 18 in line 3: Invalid regular expression"
As I couldn't find a way to do it, I use following script
if ((index($1,"127.0.0.1/8")==0)&&(index($1,"::1/128")==0)&&(index($1,"fe80:")==0))
{
    if ($1 ~= "^([0-9]+) .*")
    {
          return %(true, $1); // at this point $1 contains first matching group
    }
}
return false;

Now it works but I tested my regex string on others apps and it worked fine.
Also I was reading that with regex you can "split" the agent list string into multiple values, for example $1:iface Index, $2:IP Address, etc.
although now is working, I'm a bit confuse about regex expressions on netxms. how could I do it the same I do but with regex?
also, when you use regex to get multiple values from a string, how could you asign to multiple variables ($1,$2,etc)

Thanks for your help 

As you said, I have to install that on my Client PC and It works.