Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

B

bulwer

@bulwer
Unfollow Follow
About
Posts
32
Topics
13
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Node down alarm outside of polling time
    B bulwer
    Support

    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.


    kiosk1.png

    Kiosk2.png


  • Legend not working correctly using Text Gauges
    B bulwer
    Support

    Actually - the label that appears is the second one, not the first one. The first value has a legend of Open and the second one has a legend of Unassigned.


  • Legend not working correctly using Text Gauges
    B bulwer
    Support

    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.


    helpdesk.png


  • Unable to start core service
    B bulwer
    Support

    Don't worry - a vacuum of the Database seemed to fix it so must have been a corruption somewhere.


  • Unable to start core service
    B bulwer
    Support

    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.


  • Widget to display values from DCI in Dashboard
    B bulwer
    Support

    That would be perfect - many thanks Victor. It will look much nicer than my basic HTML page!


  • Widget to display values from DCI in Dashboard
    B bulwer
    Support

    As an example, here is something I have knocked up in HTML. I have the figures as values in DCIs - I would just like to have something similar but prettier and using NetXMS rather than pointing the Dashboard at a Webpage. I'm sure I could fine other uses for displaying DCI values in a Dashboard as well.


    helpdesk.jpg


  • Widget to display values from DCI in Dashboard
    B bulwer
    Support

    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,


  • Colour of Status Indicator
    B bulwer
    Support

    Thanks Victor - it would be useful if it could be changed but not if it is any great trouble to you or other users.


  • Colour of Status Indicator
    B bulwer
    Support

    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


  • NetXMS 1.2.7 released
    B bulwer
    Announcements

    Is there any info anywhere on how the basic software inventory works?


  • Reading in values from a file
    B bulwer
    Support

    After lots of hair pulling over what turned out to be a path issue for the cmd file, that worked perfectly - thanks Victor!


  • Reading in values from a file
    B bulwer
    Support

    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


  • Dashboards in Windows
    B bulwer
    Support

    Perfect - many thanks Victor


  • Dashboards in Windows
    B bulwer
    Support

    Here we go. Don't think I'm missing anything obvious - I've created two dashboards and a slideshow dashboard successfully but the ability to add dials and the network map would add the finishing touches.


    dashboard.jpg


  • Dashboards in Windows
    B bulwer
    Support

    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.


  • Action Configuration : Multiple Email Address
    B bulwer
    Support

    We use a distribution list so we email [email protected] to get it to come to all of us


  • Custom Schedule disappearing
    B bulwer
    Support

    Perfect - many thanks Victor


  • Custom Schedule disappearing
    B bulwer
    Support

    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.


    custom1.png


  • Critical Paths
    B bulwer
    Support

    @victor said in Critical Paths:

    Hi!

    It's not possible to specify such relation manually. Anyway, it is layer 2 connectivity issue, not layer 3, as both nodes (physical host and VM) are in same subnet, so 192.168.1.10 is not involved in the routing process, but acting as Ethernet bridge. I will add a feature request for including layer 2 topology into event correlation process.

    As a workaround, you can check status of the host node in the script in event processing policy, but this may not work as expected if VM polled first (so server don't know that host is already down).

    Best regards,
    Victor

    Thanks - I might give that a go as the event I am using waits for 5 minutes before emailing so the server must be down at the same time as the VM.

  • Login

  • Don't have an account? Register

  • Login or register to search.
Powered by NodeBB Contributors
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups