AnsweredAssumed Answered

Insert Alarm Into non-local SQL Server  via nas script

Question asked by jgarew on Jul 4, 2013
Latest reply on Jul 4, 2013 by jgarew

I am having trouble getting alarm information into a SQL Server database that is located on the network. The information is being inserted somewhere, but not in the location that I am expecting. The alarm is being triggered from nas.

 Thanks in advance.

-- -- Insert Alarm data into table for use in the Evolver Alert Monitor system --  -- Get triggering alarm new_alarm = alarm.get()  -- This will open the default user database 'user.db' database.open("Data Source=myServer;Database=myDatabase;User ID=myId;Password=myPassword")  -- Add rows to table database.query("INSERT INTO ALARMS (source) VALUES ('%s')", new_alarm.source);  database.close()

Outcomes