NetXMS Support Forum

Hello,

I tested the button. You can provide feedback by adding little timeout
to ServiceCheck.Custom(<insert arguments here>) as additional parameter
so that check would give back value when TCP port is not reachable

And one more suggestion if I can (pushing my luck) evaluate feature
requests, create table put value preset pay pall button in each row in that
table.

thank you,

Ales

Thank you,

BTW I am still searching for pay pal donations button
For those of us that appreciate hard work but can not
afford professional support.

Ales

Hello,

Is there any option to collect windows performance counters with
"#" in path name. I tried enclosing # in single/double quotes,
prefixing with "/", "\", defining path in agent config *WinPerf section
vs using PDH parameter.

In trace mode it looks like parsing stops at "#" character.

Agent used was: 0.2.26.1 (0.2.26).

Thank you,

Ales

Sory, environment is:

- windows 2008 x64 server
- x64 v0.2.26.1 agent

Error was checked with Process Monitor v2.04
http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

Filtering was set to show nxagentd.exe Process Name and
all failed registry query requests begining with path
HKLM\System\CurrentControlSet\Services\Eventlog

Ales

Hello,

----------------------------
Current: .\src\agent\subagents\logwatch\eventlog.cpp is unable
to handle any other event log beside *System.

parser definition <file>*Security</file> for instance will try
to get EventMessageFile value from registry on path:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\System\Security
----------------------------

----------------------------
<file>*Application</file>

should handle:
HKLM\SYSTEM\CurrentControlSet\Services\Eventlog\Application\Application
HKLM\SYSTEM\CurrentControlSet\Services\Eventlog\Application\<XY Application>
----------------------------

----------------------------
Could someone pretty please fix that and attach compiled logwatch.nsm
for v0.2.26.1 until next release.

Curent fix (for impatient grateful users) is to copy:
HKLM\SYSTEM\CurrentControlSet\Services\Eventlog\Security\Security
to
HKLM\SYSTEM\CurrentControlSet\Services\Eventlog\System\Security

for *Application hover you must copy relavant subkey of
HKLM\SYSTEM\CurrentControlSet\Services\Eventlog\Application\<xyz>
to
HKLM\SYSTEM\CurrentControlSet\Services\Eventlog\System\<xyz>
----------------------------

thank you,

Ales

This is agent side configuration. You should copy/paste definitions
under *WinPerf section of agent configuration . After agent restart
and refresh of configuration you should be able to find defined
counters betwen NetXMS Agent Parameters list when trying to
create DCI.

A

Counter = ASP.NET.Requests.Rejected:"\ASP.NET\Requests Rejected":60:A:INT:ASP.NET Requests Rejected total
Counter = ASP.NET.Applications.Running:"\ASP.NET\Applications Running":60:A:INT:ASP.NET Applications Running over past minute
Counter = ASP.NET.Request.Execution.Time:"\ASP.NET\Request Execution Time":60:A:INT:ASP.NET Request Execution Time over past minute
Counter = ASP.NET.Error.Events.Raised:"\ASP.NET\Error Events Raised":60:A:INT:ASP.NET Error Events Raised total
Counter = ASP.NET.Application.Restarts:"\ASP.NET\Application Restarts":60:A:INT:ASP.NET Application Restarts total

Counter =  SQLServer.BufferManager.BufferCacheHitRatio:"\SQLServer:Buffer Manager\Buffer cache hit ratio":60:A:INT:"MSSQL: Percentage of pages that were found in the buffer pool without having to incur a read from disk."
Counter =  SQLServer.BufferManager.PageReads:"\SQLServer:Buffer Manager\Page Reads/sec":60:A:INT:"MSSQL: Number of physical database page reads issued."
Counter =  SQLServer.BufferManager.PageWrites:"\SQLServer:Buffer Manager\Page Writes/sec":60:A:INT:"MSSQL: Number of physical database page writes issued."
Counter =  SQLServer.Databases.ActiveTransactions:"\SQLServer:Databases(_Total)\Active Transactions":60:A:INT:"MSSQL: Number of active update transactions for the database."
Counter =  SQLServer.Databases.Transactions:"\SQLServer:Databases(_Total)\Transactions/sec":60:A:INT:"MSSQL: Number of transactions started for the database."
Counter =  SQLServer.GeneralStatistics.UserConnections:"\SQLServer:General Statistics\User Connections":60:A:INT:"MSSQL: Number of users connected to the system."
Counter =  SQLServer.GeneralStatistics.Logins:"\SQLServer:General Statistics\Logins/sec":60:A:INT:"MSSQL: Total number of logins started per second."
Counter =  SQLServer.GeneralStatistics.Logouts:"\SQLServer:General Statistics\Logouts/sec":60:A:INT:"MSSQL: Total number of logouts started per second."
Counter =  SQLServer.MemoryManager.TotalServerMemory:"\SQLServer:Memory Manager\Total Server Memory (KB)":60:A:INT:"MSSQL: Total amount of dynamic memory the server is currently consuming."
Counter =  SQLServer.MemoryManager.SQLCacheMemory:"\SQLServer:Memory Manager\SQL Cache Memory (KB)":60:A:INT:"MSSQL: Total amount of dynamic memory the server is using for the dynamic SQL cache."
Counter =  SQLServer.Locks.LockRequests:"\SQLServer:Locks(_Total)\Lock Requests/sec":60:A:INT:"MSSQL: Number of new locks and lock conversions requested from the lock manager."
Counter =  SQLServer.Locks.AverageWaitTime:"\SQLServer:Locks(_Total)\Average Wait Time (ms)":60:A:INT:"MSSQL: The average amount of wait time (milliseconds) for each lock request that resulted in a wait."
Counter =  SQLServer.SQLStatistics.BatchRequests:"\SQLServer:SQL Statistics\Batch Requests/sec":60:A:INT:"MSSQL: Number of SQL batch requests received by server."

Use this topic to post WinPerf counters.

Hello,

If I understand correctly currently it is not possible to run architecture
netxmsd (linux) -> mssql (windows) with netxms version higher than 0.2.19...
Somehow I can confirm this trying to use:

-   netxms-0.2.22
-   unixODBC-2.2.12
-   freetds-0.82

symptoms is:
- DEBUG: Successful sync query: "SELECT var_value FROM config WHERE var_name='DBFormatVersion'" [0 ms]
- Your database has format version 0, but server is compiled for version 83

I will check forum next time first

Btw:
-   Is fixing/suporting this planned
-   How much work does fix require (some, a lot)
-   Did someone try:  linux odbc – > linux jdbc -> mssql ?

Ales

Some problems noticed when using management pack function:

- "\" character in parameter names/description gets duplicated at import
- templates with "." or " " character in their names can not be imported
- "REPEAT_INTERVAL=-1;" parameter is not supported
- win32 console V0.2.22, when creating management pack you can not browse
  for File name destination. Full path with filename must be typed.

All issues are minor and can be avoided, adjusting template names prior
export or editing export file prior import.

Ales

Beside sensors readout from BCM agent could also provide:

- power on/off
- log collecting
- power state
- right click on node: Open Console (if KVM is provided)

Ales

hello,

- use management studio to connect to sql server on production
- browse to <server_name>\Databeses\<netxms_database\Tables

a) if tables have prefix dbo.<tables...> execute SQL in query window:
EXEC sp_changedbowner '<DBLogin from netxmsd.conf>';

b) if tables have prefix <DBLogin from netxmsd.conf>.<tables...> execute SQL in query window:
EXEC sp_change_users_login 'Update_One', '<DBLogin from netxmsd.conf>', '<DBLogin from netxmsd.conf>';

Ales

Useful for:
- monitoring number of connections to specific TCP port
- checking if service is listening on specific port
- statistics of TCP connections table
- checking load on specific service as number of connections
- detecting TCP connection state based attacks and abnormalities

Requirements:
- agent on *nix system with net-snmp tools
- bash,grep,cat,snmpnetstat

Links:
http://net-snmp.sourceforge.net/docs/man/snmpnetstat.html
snmp_stat.sh attached

How-to:
1.
configure agent on node that has snmp connection to nodes you want to monitor:
ExternalParameter = TCP.Connections(*):/opt/netxms/scripts/snmp_stat.sh $1 $2 $3 $4

2.
add nodes you want to monitor to trusted nodes on that node

3.
parameters:
# $1 = hostname, monitored node ip
# $2 = community, monitored node snmp community string
# $3 = TCP state {ESTABLISHED|LISTEN|TIMEWAIT|TIMECLOSE|FINWAIT1|FINWAIT2|SYNSENT|SYNRECV}
# $4 = TCP port for detailed {ESTABLISHED|LISTEN}

4.
configure DCI's on node you want to monitor and specify node from 1.
as proxy node when creating DCI

5. examples DCI's:

# all established connections
TCP.Connections(192.168.1.1,public,ESTABLISHED)

# all established connections to TCP port 80
TCP.Connections(192.168.1.1,public,ESTABLISHED,80)

# will return 1 if service is listening on TCP port 25
TCP.Connections(192.168.1.1,public,LISTEN,25)


Feel free to use. Suggestions, spelling and bug fixes welcome.

Ales

hello,

very nice thank you
I hope that at least this time my bugging will be useful for someone.

Ales