solarback

Comments

  • ${SQL:select cs.status from CustomPollers cp, CustomPollerAssignment ca, CustomPollerStatus cs where cp.UniqueName='upsBasicBatteryStatus' and cp.custompollerid=ca.custompollerid and ca.custompollerassignmentid=cs.custompollerassignmentid and ca.NodeID=${Node.NodeID}} It works perfectly!! Thank you very much for very fast…
    in Problem with SQL query Comment by solarback July 2013
  • Main goal is to receive alerts from all UPS. But in the letters i want see data pertinent to specific devices, and i dont wont to make many advanced alerts to many devices. I want onle one advanced alert for all UPS, not only for node number 7. Can you help with this?
    in Problem with SQL query Comment by solarback July 2013
  • And can you please help to use this query for many nodes not only for Node number 7. In sql query i cant use NodeID=${NodeID}... after using query with NodeID=${NodeID} i receive error with NodeID=$@NodeID@
    in Problem with SQL query Comment by solarback July 2013
  • Thank you! It works!! Can you please explain why my first query doesn't work?
    in Problem with SQL query Comment by solarback July 2013
  • im get the value from different poller when test alert triggered. I dont understand why i receive sql query like text in e-mail? At screenshot i m using this query in sql database and all works perfect, but in test alert i have only the text of this query.
    in Problem with SQL query Comment by solarback July 2013
  • I have many custom pollers on one node. macro ${CustomPollerStatus.Status} for custom node poller returning data from another poller. I dont know why. The result is single value. But im receiving text, not the value of sql query....
    in Problem with SQL query Comment by solarback July 2013
  • I resolved it. My SQL Express exceeded the size of 4 GB. Im migrated this base to a new SQL Standard and all works.
    in Missing data in chart Average Response Time Comment by solarback February 2013
Avatar