NetXMS monitoring tool question

[kyleighterry]

Hey Guys

Firstly I want to say that I am not a developer or a coder or a scripter or anything like that. We use NetXMS as a monitoring tool that was set up by one of our senior colleagues. We monitor over 30 sites with some sites have 5 switches and some sites having almost a 100 switches.

The port of every switch is set to an expected state and a current state so the port must be up but it is currently down for example so that is an error, vita versa also being an error. Our call centre has to report on this every single morning and with so many switches you can only imagine how long it must take.

I was wonder if there is anyway that you can extract the information of all switches and their ports with their expected state and current state in one shot. If I can get that information on a spreadsheet then I can manipulate the data for easier reporting. I am not an expert with NetXMS but I am bloody good with excel.

Some follow up question in case they arise:
I do have the same amount of right on NetXMS that the my senior has. I did ask my senior but he is unable to assist with my request (to put it politely).

Thanks in advance!

[victor]

Hi!

You can use object queries. Go to Tools -> Find Object, and use the following query (I assume you are using NetXMS 5.x):

with
Device = { node.name },
ExpectedState = { ['UP','DOWN','IGNORE'][expectedState] },
CurrentState = { ['UNKNOWN','UP','DOWN','TESTING','DORMANT','NOT PRESENT'][operState] }
type == INTERFACE

You will get list of all interfaces with expected state and current state (with some extra default columns).

Then you can export resulting table to CSV by selecting "Export all to CSV" from view menu or toolbar (in top right corner).

Best regards,
Victor