Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Topics - bulwer

#1
Got a very strange one here. We have 2 Kiosk PCs used at one of our sites to allow customers entrance to the centre. We want to monitor that these are staying up during the day so I added them both to NetXMS with just the standard Status DCI. I then set a custom schedule so it only collects the data when the PC should be on and stops overnight when they are manually switched off. According to the history of the DCI, this works perfectly. However, we are getting Node down alarms and therefore emails outside of the custom schedule for just one of these PCs when it is being switched off. The other PC should be switched off around the same time but we don't get an alarm for that which is what we want.

Probably one of those annoying problems you won't be able to replicate but I thought I would mention it on the off chance I have done something stupid. I have attached screenshots of the setup of the DCI in question but, as I say, the History shows that it is collecting data at the correct time - it is just triggering the alarm when it shouldn't be and doesn't appear to be collecting data.
#2
Many thanks for the new addition in 1.2.9 - Text Gauges give me exactly what I was after.

However, it appears as if the Legend doesn't work correctly when choosing text. Whatever position you choose the legend to be in, it just displays the first label in completely the wrong position. If you change from Text to Dial, it works perfectly.

I have attached a screenshot to show the problem. Very minor issue but thought it worth mentioning.
#3
General Support / Unable to start core service
September 10, 2013, 12:10:34 PM
Hi,

Our NetXMS has been working fine for months and has just keeled over. The core service is refusing to start. I have run it from the command line and here is the last part of the output

[10-Sep-2013 10:06:21.591] Successful sync query: "SELECT id FROM containers WHE
RE object_class=28" [0 ms]
[10-Sep-2013 10:06:21.591] {0000000003A8F920} Successful prepare: "SELECT name,s
tatus,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop
_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,st
atus_thresholds,comments,is_system,location_type,latitude,longitude,location_acc
uracy,location_timestamp,guid,image,submap_id FROM object_properties WHERE objec
t_id=?" [0 ms]
[10-Sep-2013 10:06:21.591] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_171 WHERE item_id=1504 ORDER BY idata_timestamp DESC LIMIT 1"
[0 ms]
[10-Sep-2013 10:06:21.591] {0000000003A8F920} bind at pos 1: "886"
[10-Sep-2013 10:06:21.591] Successful prepared sync query: "SELECT name,status,i
s_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,st
atus_fixed_val,status_shift,status_translation,status_single_threshold,status_th
resholds,comments,is_system,location_type,latitude,longitude,location_accuracy,l
ocation_timestamp,guid,image,submap_id FROM object_properties WHERE object_id=?"
[0 ms]
[10-Sep-2013 10:06:21.607] {0000000003A8F920} Successful prepare: "SELECT attr_n
ame,attr_value FROM object_custom_attributes WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.607] {0000000003A8F920} bind at pos 1: "886"
[10-Sep-2013 10:06:21.607] Successful prepared sync query: "SELECT attr_name,att
r_value FROM object_custom_attributes WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.607] Successful sync query: "SELECT target_node_id FROM tr
usted_nodes WHERE source_object_id=886" [0 ms]
[10-Sep-2013 10:06:21.607] Successful sync query: "SELECT category,flags,auto_bi
nd_filter FROM containers WHERE id=886" [0 ms]
[10-Sep-2013 10:06:21.607] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_171 WHERE item_id=1507 ORDER BY idata_timestamp DESC LIMIT 1"
[0 ms]
[10-Sep-2013 10:06:21.607] {0000000003A8F920} Successful prepare: "SELECT user_i
d,access_rights FROM acl WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.607] {0000000003A8F920} bind at pos 1: "886"
[10-Sep-2013 10:06:21.607] Successful prepared sync query: "SELECT user_id,acces
s_rights FROM acl WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.622] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=886" [0 ms]
[10-Sep-2013 10:06:21.622] {0000000003A8F920} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.622] {0000000003A8F920} bind at pos 1: "886"
[10-Sep-2013 10:06:21.622] {0000000003A8F920} bind at pos 2: "1378767600"
[10-Sep-2013 10:06:21.622] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_171 WHERE item_id=1509 ORDER BY idata_timestamp DESC LIMIT 1"
[0 ms]
[10-Sep-2013 10:06:21.622] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.622] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.622] {0000000003A8F920} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.622] {0000000003A8F920} bind at pos 1: "886"
[10-Sep-2013 10:06:21.638] {0000000003A8F920} bind at pos 2: "1378681200"
[10-Sep-2013 10:06:21.638] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.638] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.638] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_171 WHERE item_id=1520 ORDER BY idata_timestamp DESC LIMIT 1"
[0 ms]
[10-Sep-2013 10:06:21.638] {0000000003A8F920} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.638] {0000000003A8F920} bind at pos 1: "886"
[10-Sep-2013 10:06:21.638] {0000000003A8F920} bind at pos 2: "1377990000"
[10-Sep-2013 10:06:21.638] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.638] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.638] ++++ ServiceContainer::initUptimeStats() id=886 100.0
00000 100.000000 100.000000
[10-Sep-2013 10:06:21.654] {0000000003A8F920} Successful prepare: "SELECT servic
e_id FROM business_services WHERE service_id=?" [16 ms]
[10-Sep-2013 10:06:21.654] {0000000003A8F920} bind at pos 1: "886"
[10-Sep-2013 10:06:21.654] Successful prepared sync query: "SELECT service_id FR
OM business_services WHERE service_id=?" [0 ms]
[10-Sep-2013 10:06:21.654] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_171 WHERE item_id=1521 ORDER BY idata_timestamp DESC LIMIT 1"
[0 ms]
[10-Sep-2013 10:06:21.654] Loading node links...
[10-Sep-2013 10:06:21.654] Successful sync query: "SELECT id FROM containers WHE
RE object_class=29" [0 ms]
[10-Sep-2013 10:06:21.654] {0000000003A8FA40} Successful prepare: "SELECT name,s
tatus,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop
_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,st
atus_thresholds,comments,is_system,location_type,latitude,longitude,location_acc
uracy,location_timestamp,guid,image,submap_id FROM object_properties WHERE objec
t_id=?" [0 ms]
[10-Sep-2013 10:06:21.654] {0000000003A8FA40} bind at pos 1: "887"
[10-Sep-2013 10:06:21.669] Successful prepared sync query: "SELECT name,status,i
s_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,st
atus_fixed_val,status_shift,status_translation,status_single_threshold,status_th
resholds,comments,is_system,location_type,latitude,longitude,location_accuracy,l
ocation_timestamp,guid,image,submap_id FROM object_properties WHERE object_id=?"
[0 ms]
[10-Sep-2013 10:06:21.669] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_171 WHERE item_id=1523 ORDER BY idata_timestamp DESC LIMIT 1"
[0 ms]
[10-Sep-2013 10:06:21.669] {0000000003A8FA40} Successful prepare: "SELECT attr_n
ame,attr_value FROM object_custom_attributes WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.669] {0000000003A8FA40} bind at pos 1: "887"
[10-Sep-2013 10:06:21.669] Successful prepared sync query: "SELECT attr_name,att
r_value FROM object_custom_attributes WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.669] Successful sync query: "SELECT target_node_id FROM tr
usted_nodes WHERE source_object_id=887" [0 ms]
[10-Sep-2013 10:06:21.669] Successful sync query: "SELECT category,flags,auto_bi
nd_filter FROM containers WHERE id=887" [0 ms]
[10-Sep-2013 10:06:21.669] {0000000003A8FA40} Successful prepare: "SELECT user_i
d,access_rights FROM acl WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.669] {0000000003A8FA40} bind at pos 1: "887"
[10-Sep-2013 10:06:21.685] Successful prepared sync query: "SELECT user_id,acces
s_rights FROM acl WHERE object_id=?" [16 ms]
[10-Sep-2013 10:06:21.685] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_182 WHERE item_id=46 ORDER BY idata_timestamp DESC LIMIT 1" [1
6 ms]
[10-Sep-2013 10:06:21.685] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=887" [0 ms]
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} bind at pos 1: "887"
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} bind at pos 2: "1378767600"
[10-Sep-2013 10:06:21.685] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.685] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} bind at pos 1: "887"
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} bind at pos 2: "1378681200"
[10-Sep-2013 10:06:21.685] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.685] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.685] {0000000003A8FA40} bind at pos 1: "887"
[10-Sep-2013 10:06:21.700] {0000000003A8FA40} bind at pos 2: "1377990000"
[10-Sep-2013 10:06:21.700] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.700] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.700] ++++ ServiceContainer::initUptimeStats() id=887 100.0
00000 100.000000 100.000000
[10-Sep-2013 10:06:21.700] {0000000003A8FA40} Successful prepare: "SELECT node_i
d FROM node_links WHERE nodelink_id=?" [0 ms]
[10-Sep-2013 10:06:21.700] {0000000003A8FA40} bind at pos 1: "887"
[10-Sep-2013 10:06:21.700] Successful prepared sync query: "SELECT node_id FROM
node_links WHERE nodelink_id=?" [0 ms]
[10-Sep-2013 10:06:21.700] {0000000003A8FB60} Successful prepare: "SELECT name,s
tatus,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop
_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,st
atus_thresholds,comments,is_system,location_type,latitude,longitude,location_acc
uracy,location_timestamp,guid,image,submap_id FROM object_properties WHERE objec
t_id=?" [0 ms]
[10-Sep-2013 10:06:21.700] {0000000003A8FB60} bind at pos 1: "888"
[10-Sep-2013 10:06:21.700] Successful prepared sync query: "SELECT name,status,i
s_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,st
atus_fixed_val,status_shift,status_translation,status_single_threshold,status_th
resholds,comments,is_system,location_type,latitude,longitude,location_accuracy,l
ocation_timestamp,guid,image,submap_id FROM object_properties WHERE object_id=?"
[0 ms]
[10-Sep-2013 10:06:21.700] {0000000003A8FB60} Successful prepare: "SELECT attr_n
ame,attr_value FROM object_custom_attributes WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.700] {0000000003A8FB60} bind at pos 1: "888"
[10-Sep-2013 10:06:21.700] Successful prepared sync query: "SELECT attr_name,att
r_value FROM object_custom_attributes WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.716] Successful sync query: "SELECT target_node_id FROM tr
usted_nodes WHERE source_object_id=888" [0 ms]
[10-Sep-2013 10:06:21.716] Successful sync query: "SELECT category,flags,auto_bi
nd_filter FROM containers WHERE id=888" [0 ms]
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} Successful prepare: "SELECT user_i
d,access_rights FROM acl WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} bind at pos 1: "888"
[10-Sep-2013 10:06:21.716] Successful prepared sync query: "SELECT user_id,acces
s_rights FROM acl WHERE object_id=?" [0 ms]
[10-Sep-2013 10:06:21.716] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=888" [0 ms]
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} bind at pos 1: "888"
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} bind at pos 2: "1378767600"
[10-Sep-2013 10:06:21.716] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.716] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} bind at pos 1: "888"
[10-Sep-2013 10:06:21.716] {0000000003A8FB60} bind at pos 2: "1378681200"
[10-Sep-2013 10:06:21.732] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [16 ms]
[10-Sep-2013 10:06:21.732] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.732] {0000000003A8FB60} Successful prepare: "SELECT change
_timestamp,new_status FROM slm_service_history WHERE service_id=? AND change_tim
estamp>?" [0 ms]
[10-Sep-2013 10:06:21.732] {0000000003A8FB60} bind at pos 1: "888"
[10-Sep-2013 10:06:21.732] {0000000003A8FB60} bind at pos 2: "1377990000"
[10-Sep-2013 10:06:21.732] Successful prepared sync query: "SELECT change_timest
amp,new_status FROM slm_service_history WHERE service_id=? AND change_timestamp>
?" [0 ms]
[10-Sep-2013 10:06:21.732] ++++ ServiceContainer::getUptimeFromDBFor(), downtime
0
[10-Sep-2013 10:06:21.732] ++++ ServiceContainer::initUptimeStats() id=888 100.0
00000 100.000000 100.000000
[10-Sep-2013 10:06:21.732] {0000000003A8FB60} Successful prepare: "SELECT node_i
d FROM node_links WHERE nodelink_id=?" [0 ms]
[10-Sep-2013 10:06:21.732] {0000000003A8FB60} bind at pos 1: "888"
[10-Sep-2013 10:06:21.732] Successful prepared sync query: "SELECT node_id FROM
node_links WHERE nodelink_id=?" [0 ms]
[10-Sep-2013 10:06:21.732] Loading service checks...
[10-Sep-2013 10:06:21.732] Successful sync query: "SELECT id FROM slm_checks" [0
ms]
[10-Sep-2013 10:06:21.732] Linking objects...
[10-Sep-2013 10:06:21.747] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=2" [15 ms]
[10-Sep-2013 10:06:21.747] Successful async query: "SELECT idata_value,idata_tim
estamp FROM idata_186 WHERE item_id=48 ORDER BY idata_timestamp DESC LIMIT 1" [1
5 ms]
[10-Sep-2013 10:06:21.747] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=3" [0 ms]
[10-Sep-2013 10:06:21.747] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=5" [0 ms]
[10-Sep-2013 10:06:21.747] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=6" [0 ms]
[10-Sep-2013 10:06:21.747] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=7" [0 ms]
[10-Sep-2013 10:06:21.747] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=8" [0 ms]
[10-Sep-2013 10:06:21.747] Successful sync query: "SELECT object_id FROM contain
er_members WHERE container_id=9" [0 ms]
[10-Sep-2013 10:06:21.747] #### CalculateCompoundStatus for id 9
[10-Sep-2013 10:06:21.747] ServiceContainer::calculateCompoundStatus(Business Se
rvices [9]): old_status=5 new_status=5
[10-Sep-2013 10:06:21.747] Objects loaded and initialized
[10-Sep-2013 10:06:21.747] Map update thread started
[10-Sep-2013 10:06:21.763] Successful sync query: "SELECT id,name,comments FROM
situations ORDER BY id" [16 ms]
[10-Sep-2013 10:06:21.763] Situations loaded and initialized
[10-Sep-2013 10:06:21.763] Successful sync query: "SELECT action_id,action_name,
action_type,is_disabled,rcpt_addr,email_subject,action_data FROM actions ORDER B
Y action_id" [0 ms]
[10-Sep-2013 10:06:21.763] Failed sync query: "SELECT event_code,severity,flags,
message,description,event_name FROM event_cfg ORDER BY event_code" [0 ms]
[10-Sep-2013 10:06:21.763] SQL query failed (Query = "SELECT event_code,severity
,flags,message,description,event_name FROM event_cfg ORDER BY event_code"): XX00
0 ERROR:  unexpected chunk number 0 (expected 1) for toast value 225167 in pg_to
ast_2619
[10-Sep-2013 10:06:21.763] Unable to load events from database
NetXMS Core initialization failed
[10-Sep-2013 10:06:21.763] {0000000003A8FC80} Successful prepare: "SELECT var_va
lue FROM config WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.763] {0000000003A8FC80} bind at pos 1: "DBLockStatus"
[10-Sep-2013 10:06:21.763] Successful prepared sync query: "SELECT var_value FRO
M config WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.763] {0000000003A8FC80} Successful prepare: "UPDATE config
SET var_value=? WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.763] {0000000003A8FC80} bind at pos 1: "UNLOCKED"
[10-Sep-2013 10:06:21.763] {0000000003A8FC80} bind at pos 2: "DBLockStatus"
[10-Sep-2013 10:06:21.778] Successful prepared sync query: "UPDATE config SET va
r_value=? WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.778] {0000000003A8FC80} Successful prepare: "SELECT var_va
lue FROM config WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.778] {0000000003A8FC80} bind at pos 1: "DBLockInfo"
[10-Sep-2013 10:06:21.778] Successful prepared sync query: "SELECT var_value FRO
M config WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.778] {0000000003A8FC80} Successful prepare: "UPDATE config
SET var_value=? WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.778] {0000000003A8FC80} bind at pos 1: ""
[10-Sep-2013 10:06:21.778] {0000000003A8FC80} bind at pos 2: "DBLockInfo"
[10-Sep-2013 10:06:21.810] Successful prepared sync query: "UPDATE config SET va
r_value=? WHERE var_name=?" [32 ms]
[10-Sep-2013 10:06:21.810] {0000000003A8FC80} Successful prepare: "SELECT var_va
lue FROM config WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.810] {0000000003A8FC80} bind at pos 1: "DBLockPID"
[10-Sep-2013 10:06:21.810] Successful prepared sync query: "SELECT var_value FRO
M config WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.810] {0000000003A8FC80} Successful prepare: "UPDATE config
SET var_value=? WHERE var_name=?" [0 ms]
[10-Sep-2013 10:06:21.810] {0000000003A8FC80} bind at pos 1: "0"
[10-Sep-2013 10:06:21.810] {0000000003A8FC80} bind at pos 2: "DBLockPID"
[10-Sep-2013 10:06:21.825] Successful prepared sync query: "UPDATE config SET va
r_value=? WHERE var_name=?" [15 ms]
[10-Sep-2013 10:06:21.825] DB connection 000000000089FF60 closed


It seems to be seeing the Database fine but not running. Any pointers would be gratefully received.
#4
Hi All,

Thanks to help from Victor, we have a dashboard that shows the status of our Helpdesk calls by reading the contents of a SQL query and reading them as DCIs. These DCIs are then displayed as dial charts which works well.

However, I would also like to be able to display these values as values in a Dashboard. Without using a graph or dial, I can't see a way of just displaying a DCI in a dashboard. Has anyone got any neat workarounds for this? Ideally, I would like a widget that can display a DCI as an LED 7 segment style number so I can display values such as total calls logged on the Helpdesk which won't work as a Dial Chart - we just want a number displayed.

A very minor request as we can cope without it but it would be nice to have a page on our dashboard slideshow that shows open calls, unassigned calls, total calls etc as large, easy to read numbers.

Many thanks,
#5
General Support / Colour of Status Indicator
June 03, 2013, 06:55:14 PM
Hi,

I've been slowly adding all kinds of DCIs with various levels of alarms but have noticed that the Status Indicators used on our Dashboard only go Green or Red. Is there any way to make the dot the same colour as the alarms as a blue warning is still making the site go Red? I know you can change the status calculation for a Subnet but that is working fine already - it goes blue, yellow or red. The status indicator only goes red.

Many thanks,

Dave
#6
General Support / Reading in values from a file
April 26, 2013, 06:12:54 PM
I'm trying to convert what someone else has done for PRTG. We use Spiceworks as our Helpdesk system and I want to get a display of open and unassigned calls into our dashboard. Using this link http://community.spiceworks.com/how_to/show/733-how-to-monitor-spiceworks-tickets-using-prtg

, I have got the following info out of Spiceworks and into a txt file:

tickets_new_total:0:Total new tickets - 0
tickets_open_AlistairMann:3:Open tickets for Alistair Mann - 3
tickets_open_DavidBulwer:3:Open tickets for David Bulwer - 3
tickets_open_SteveChapman:13:Open tickets for Steve Chapman - 13
tickets_open_total:45:Total open tickets - 45
tickets_overdue_total:12:Total overdue tickets - 12
tickets_unassigned_total:26:Total unassigned tickets - 26

I am struggling to figure out how to get these figures into NetXMS as DCI - It appears to me that ExternalParameters could be the way to go but I'm struggling to get my head around it - can anyone please give me any pointers?

Many thanks,

Dave
#7
General Support / Dashboards in Windows
April 22, 2013, 12:29:26 PM
Hi,

Had a good search on the site and couldn't find the answer. Is there a limited feature set in the Windows clients Dashboard than other systems? For example, there is no Dial Chart or custom widget option. If it is a limitation of Windows, do you need the server to be a different OS or just the client?

Another feature we would like is the ability to add a network map into a Dashboard. We had been using a Network map on our wall PC that shows all 34 of our sites along with their current status. This looks great but is a bit limited. I have now created a Dashboard with the status of each of the sites and an alarm browser. This is much more practical and useful but not as "pretty"! It would be nice to have the network map added in a slideshow of Dashboards but I can't see a way of doing this at present.
#8
General Support / Custom Schedule disappearing
January 17, 2013, 12:05:21 PM
Hi,

I mentioned this happening in a different thread but it is happening again for a different, simpler DCI so I thought it time for a dedicated topic.

For a couple of our DCIs, I want to set a custom schedule. For the latest one I have tried, it is just to run once a day at 8:00 am as I want to check the modify date of a file to see if a backup has worked.

I add a custom schedule of 0 8 * * * and then apply. However, the DCI will still collect every minute and when I go back to look at the Custom Schedule, it is empty. If I check before the next collection happens, the schedule is still there but a minute or two later, it is gone.

Can you please let me know if there is something I need to change? Attached is a screenshot of how it looks when I add the schedule.
#9
General Support / Critical Paths
January 09, 2013, 02:35:48 PM
Sorry, me again! I have got our system set up to monitor our 35 remote sites and send an email if the node is down for more than 5 minutes which works perfectly thanks to your earlier help. However, when the connection to our head office went down the other night, we come in to around 200 emails telling us that every node was down and then back up again.

Can you suggest an easy way of changing the setup so we don't get emails if the main line goes down? Before settling on NetXMS, I tried OpenNMS and they had a critical path feature whereby you specify the Node connections it relies on so you don't get notifications if the critical path is down. I'm sure this can be done using individual rules but with a router and at least one, if not several servers at each site, I don't really want to have to create a separate rule for each node.

I have also set a check for our website which is hosted elsewhere. I am wondering if a check in the rule that if the website is down as well then don't email but that would stop monitoring working properly if the website is down for any length of time.

Any advice would be welcome.
#10
General Support / Custom Schedule query
January 04, 2013, 12:09:29 PM
I have setup an average ping time DCI for one of our sites that has a poor network connection and set it to email if the Average pings for the last 5 collections is over 1 second. This works perfectly but keeps emailing us in the early hours when the backup runs across the network. I tried to set up a custom schedule to just collect data in the day using rows like the following:

*/1 9 * * *
*/1 10 * * *
*/1 11 * * *
..
..
..
*/1 17 * * *

This doesn't work however and the schedule disappears after a few minutes. Is there a way I can just collect every minute between say 9 and 5 or 9 and 6?
#11
General Support / PhysicalDisk.smartstatus
December 11, 2012, 01:03:20 PM
Hi,

Apologies for what may be a basic question but we are a small IT department with limited knowledge of NMS systems. We have the basics we wanted working perfectly which is ping servers and emailing if they go down for longer than 5 minutes - our World map showing all of our sites and their status is drawing a lot of attention from other departments!

I am now looking to try and add jam to the cake by adding small things that would help us out which basically means collecting more attributes than we have been doing. I have managed to get Free Disk space working but I am struggling with others. The main one that would be useful is PhysicalDisk.smartstatus so we can get warnings when one of our disks is predicted to fail. We have the NetXMS agent installed on all of our servers and I have added the attribute PhysicalDisk.SmartStatus(0) which as I understand it should work. All that happens when I run a status check is the last value shows error.

Am I missing something obvious? I found the other question about this attribute in the forum which explained how to find the disk number and our server has disk 0 and 1 but neither seem to work. Should this work through the agent or does it need SNMP installed to work?

When I was having a play when I first installed the system, I was getting this error when I tried a few attributes. Any pointers to help me understand would be much appreciated!



#12
General Support / Checking file access
November 29, 2012, 12:07:34 PM
Hi,

We have an old Windows 2000 Server which hosts a lot of shared files but it is currently slowly dieing. Once a week or so, it stops serving access to these files until we reboot it.

Whilst we try and work out a way of moving all the files elsewhere, is there anything I can do with NetXMS to check whether it can access a file on this server and create an alert if it can't?
#13
Hi,

I installed NetXMS a couple of days ago and like what I see so far. I will play with advanced stuff later but for now I just want to add all of our routers and servers across 35 sites and have it tell us when they are down. However, because a lot of our sites are linked with ADSL lines which go down quite often, I only want an email after 5 minutes of being down.

I have got this working by using the Alarm Timeout so when the Alarm Timeout kicks in after 5 minutes, we get an email and this works great. However, I am struggling to come up with a way to get it to email us when the node is back up but only if the Alarm Timeout alarm was raised. I have set it to resolve the alarm timeout when the node comes up but if I add the email at that point, it will email me every time a node comes back up so we will get emails saying a node is up when we didn't get one to say it was down as it was only down for less than 5 minutes.

Is there a way I can add an Event Policy to run when an Alarm Timeout is resolved?

Many thanks