# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=674 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 675 --- ## [Ignition Edge Questions](https://forum.inductiveautomation.com/t/ignition-edge-questions/71815)
**Author:** [@neil2](https://forum.inductiveautomation.com/u/neil2)\ **Replies:** 4\ **Last updated:** [March 30, 2023, 3:44pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-questions/71815 "2023-03-30T15:44:24Z")
I have some questions about ignition edge I hope someone can help with: Can the built in historian storage location be changed from default? And where is default? How can I increase the gateway memory allocation? I ha… --- ## [sqlt\_data\_X\_X table is consuming GB of data monthly](https://forum.inductiveautomation.com/t/sqlt-data-x-x-table-is-consuming-gb-of-data-monthly/71785)
**Author:** [@Darren\_Allison](https://forum.inductiveautomation.com/u/Darren_Allison)\ **Replies:** 6\ **Last updated:** [March 30, 2023, 3:11pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-x-x-table-is-consuming-gb-of-data-monthly/71785 "2023-03-30T15:11:34Z")
we have one table that is consuming 140gb monthly and growing. I need to know why this type of table grows so large, and is there any way to have a Stored Procedure or something that will normalize the data to hourly ch… --- ## [How to dynamically path to image management from report?](https://forum.inductiveautomation.com/t/how-to-dynamically-path-to-image-management-from-report/71834)
**Author:** [@Pierce\_Thompson](https://forum.inductiveautomation.com/u/Pierce_Thompson)\ **Replies:** 3\ **Last updated:** [March 30, 2023, 3:03pm UTC](https://forum.inductiveautomation.com/t/how-to-dynamically-path-to-image-management-from-report/71834 "2023-03-30T15:03:09Z")
Hello everyone, How would I dynamically path to an image in the image management tool to be displayed on a report? The documentation seems to suggest that you can either drag images from the image manager (this isn't d… --- ## [Gateway Tag Import](https://forum.inductiveautomation.com/t/gateway-tag-import/71835)
**Author:** [@Mark\_McClure](https://forum.inductiveautomation.com/u/Mark_McClure)\ **Replies:** 1\ **Last updated:** [March 30, 2023, 3:01pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-import/71835 "2023-03-30T15:01:42Z")
We are setting up a new gateway and are wondering if there is a better approach of getting tags setup on the server. Currently we export tags to JSON and then once our new gateway is online we will connect to the gatewa… --- ## [Access user source LDAP instance for search](https://forum.inductiveautomation.com/t/access-user-source-ldap-instance-for-search/62669)
**Author:** [@guipinper](https://forum.inductiveautomation.com/u/guipinper)\ **Replies:** 2\ **Last updated:** [March 30, 2023, 2:37pm UTC](https://forum.inductiveautomation.com/t/access-user-source-ldap-instance-for-search/62669 "2023-03-30T14:37:44Z")
Hi all, I want to make LDAP queries using the LDAP Helper object. I wanted to use the, already configured, UserSource instance from the Gateway context. I was trying with something like: from com.inductiveautomation.i… --- ## [SQL server 2019 and Cumulative Update : what are best practices?](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824)
**Author:** [@Stephane\_Boneff](https://forum.inductiveautomation.com/u/Stephane_Boneff)\ **Replies:** 8\ **Last updated:** [March 30, 2023, 2:23pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824 "2023-03-30T14:23:50Z")
Hello, We use Ignition with SQL server 2019 standard Enterprise. SQLserver hadn't been updated since it was installed. Now there are 19 Cumulative Update https://support.microsoft.com/en-au/topic/kb5023049-cumulative… --- ## [Historical Deadband - Percent](https://forum.inductiveautomation.com/t/historical-deadband-percent/71793)
**Author:** [@ISEMAREN\_AAG](https://forum.inductiveautomation.com/u/ISEMAREN_AAG)\ **Replies:** 5\ **Last updated:** [March 30, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/historical-deadband-percent/71793 "2023-03-30T13:04:06Z")
Hello. How exactly does the historical deadband work when the deadband mode is percent? If historical deadband is 1, does it mean that the tag will register when there has been a 1% change from its previous value? B… --- ## [Open file in perspective](https://forum.inductiveautomation.com/t/open-file-in-perspective/71816)
**Author:** [@Inken\_Kestler](https://forum.inductiveautomation.com/u/Inken_Kestler)\ **Replies:** 1\ **Last updated:** [March 30, 2023, 12:07pm UTC](https://forum.inductiveautomation.com/t/open-file-in-perspective/71816 "2023-03-30T12:07:03Z")
Hi togehter, I try to open a htm file, which is located on a network drive. I can reach this network drive from my local pc, but also from the ignition gateway server. I know that it is not possible to reach files fro… --- ## [Create Complex layered graph](https://forum.inductiveautomation.com/t/create-complex-layered-graph/71804)
**Author:** [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\ **Replies:** 1\ **Last updated:** [March 30, 2023, 1:07am UTC](https://forum.inductiveautomation.com/t/create-complex-layered-graph/71804 "2023-03-30T01:07:36Z")
Can someone tell me what component I should use to implement this graph in Vision? --- ## [Change namespace on MQTT Topic using RabbitMQ](https://forum.inductiveautomation.com/t/change-namespace-on-mqtt-topic-using-rabbitmq/71802)
**Author:** [@Mariano\_Cepeda](https://forum.inductiveautomation.com/u/Mariano_Cepeda)\ **Replies:** 4\ **Last updated:** [March 29, 2023, 10:30pm UTC](https://forum.inductiveautomation.com/t/change-namespace-on-mqtt-topic-using-rabbitmq/71802 "2023-03-29T22:30:31Z")
Hi everyone. I'm currently making some tests publishing data from Ignition via MQTT, but when I view the message on the MQTT Explorer the topic has changed, and added the sparkplug version on the namespace. Do you know… --- ## [Storage Provider inside Edit Tag](https://forum.inductiveautomation.com/t/storage-provider-inside-edit-tag/71796)
**Author:** [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 9:10pm UTC](https://forum.inductiveautomation.com/t/storage-provider-inside-edit-tag/71796 "2023-03-29T21:10:52Z")
I am using a trial gateway license. I created a database connection in the gateway to MSSQL server. The connect status is valid. I then created a blank project in the designer. In the tag browser I added a tag from the s… --- ## [\[Perspective\] PowerShell Script + system.util.execute](https://forum.inductiveautomation.com/t/perspective-powershell-script-system-util-execute/53718)
**Author:** [@Davide3i](https://forum.inductiveautomation.com/u/Davide3i)\ **Replies:** 15\ **Last updated:** [March 29, 2023, 8:15pm UTC](https://forum.inductiveautomation.com/t/perspective-powershell-script-system-util-execute/53718 "2023-03-29T20:15:11Z")
Hello. I’d like to know if there are any ways to receive a feedback from system.util.execute after executing a PowerShell script. If not, I suppose my best option will be to write the output to a .log file and the read… --- ## [Perspective Pipes - Helpful Tools](https://forum.inductiveautomation.com/t/perspective-pipes-helpful-tools/71794)
**Author:** [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\ **Replies:** 0\ **Last updated:** [March 29, 2023, 7:51pm UTC](https://forum.inductiveautomation.com/t/perspective-pipes-helpful-tools/71794 "2023-03-29T19:51:42Z")
I've been searching forums and feature requests to see what others are recommending for working with pipes within Perspective designer sessions. Personally, I believe pipes have come a long-way, and I'm now a regular use… --- ## [Indication if SQL BRIDGE is the best option](https://forum.inductiveautomation.com/t/indication-if-sql-bridge-is-the-best-option/71772)
**Author:** [@Lucas\_Bevilaqua](https://forum.inductiveautomation.com/u/Lucas_Bevilaqua)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 7:27pm UTC](https://forum.inductiveautomation.com/t/indication-if-sql-bridge-is-the-best-option/71772 "2023-03-29T19:27:12Z")
A customer has several machines in his plant, with several PLC's. The initial idea was to insert production data for each machine into a database table respectively. For example: Machine 1: You will insert data in the… --- ## [Ignition Redundancy](https://forum.inductiveautomation.com/t/ignition-redundancy/71572)
**Author:** [@Ricardo\_javier\_reyes](https://forum.inductiveautomation.com/u/Ricardo_javier_reyes)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 7:25pm UTC](https://forum.inductiveautomation.com/t/ignition-redundancy/71572 "2023-03-29T19:25:09Z")
Could anyone help me to make a link between a master and a backup gateway? --- ## [Table color count?](https://forum.inductiveautomation.com/t/table-color-count/71791)
**Author:** [@Micky\_Vue](https://forum.inductiveautomation.com/u/Micky_Vue)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 7:18pm UTC](https://forum.inductiveautomation.com/t/table-color-count/71791 "2023-03-29T19:18:54Z")
Hi everyone, I was wondering if it's possible to do a sum count of a certain color on a table? For example: Is it possible to count the total number of cells in a column that is green? --- ## [MES/PLC Heartbeat Tags](https://forum.inductiveautomation.com/t/mes-plc-heartbeat-tags/71786)
**Author:** [@tgjonaj](https://forum.inductiveautomation.com/u/tgjonaj)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 6:39pm UTC](https://forum.inductiveautomation.com/t/mes-plc-heartbeat-tags/71786 "2023-03-29T18:39:52Z")
Hello, I have a production site that's mainly Beckhoff PLCs and one of the requirements they have is a heartbeat tag that both MES and the PLC will write to (PLC writes a 1, then I respond with a 0). However, every once… --- ## [Download files stored in database using ignition Perspective](https://forum.inductiveautomation.com/t/download-files-stored-in-database-using-ignition-perspective/71699)
**Author:** [@KEERTHANA\_HEMANTH](https://forum.inductiveautomation.com/u/KEERTHANA_HEMANTH)\ **Replies:** 10\ **Last updated:** [March 29, 2023, 5:33pm UTC](https://forum.inductiveautomation.com/t/download-files-stored-in-database-using-ignition-perspective/71699 "2023-03-29T17:33:51Z")
Hi, I have a table in my sql server database with filename, filedata and id. I need to give user the access to download the files stored in my database. Kindly help me resolve this issue --- ## [Trying to scale an OPC integer down to a float](https://forum.inductiveautomation.com/t/trying-to-scale-an-opc-integer-down-to-a-float/71778)
**Author:** [@Cole\_Townsend](https://forum.inductiveautomation.com/u/Cole_Townsend)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 4:30pm UTC](https://forum.inductiveautomation.com/t/trying-to-scale-an-opc-integer-down-to-a-float/71778 "2023-03-29T16:30:52Z")
So I am trying to scale an integer that is coming from an OPC source down to a float. For example, if the source gives me 578, I want the tag to have the value 5.78. The issue I am running into here is that if I pull th… --- ## [Generate table to database with PostgreSQL does not generate data](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750)
**Author:** [@Julio\_Cesar\_Aguilar](https://forum.inductiveautomation.com/u/Julio_Cesar_Aguilar)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 4:21pm UTC](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750 "2023-03-29T16:21:10Z")
Hello everyone, I have this problem, I am working with PostgresSQL, it is supposed that through the tranciscion group I generate data and create a table within the database but I stop generating data at a certain point, … --- ## [Subplot gap on standard chart](https://forum.inductiveautomation.com/t/subplot-gap-on-standard-chart/17306)
**Author:** [@JNelson](https://forum.inductiveautomation.com/u/JNelson)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/subplot-gap-on-standard-chart/17306 "2023-03-29T16:18:04Z")
I need a way to set the subplot gap on a standard chart. I can do it on the Easy Chart by going to getComponent('Easy Chart').setSubplotGap(x) Any ideas? --- ## [urllib2.HTTPError: HTTP Error 422: Unprocessable Entity](https://forum.inductiveautomation.com/t/urllib2-httperror-http-error-422-unprocessable-entity/71762)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 5\ **Last updated:** [March 29, 2023, 3:52pm UTC](https://forum.inductiveautomation.com/t/urllib2-httperror-http-error-422-unprocessable-entity/71762 "2023-03-29T15:52:29Z")
I am trying to read API. The following python code works: import requests import json url = '.....' headers = { 'accept': 'application/json', 'SY-API-KEY': '.....', … --- ## [Sneding SMS in language other than English](https://forum.inductiveautomation.com/t/sneding-sms-in-language-other-than-english/71758)
**Author:** [@Anna\_Goldberg](https://forum.inductiveautomation.com/u/Anna_Goldberg)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 3:43pm UTC](https://forum.inductiveautomation.com/t/sneding-sms-in-language-other-than-english/71758 "2023-03-29T15:43:41Z")
Hello, Maybe someone have encountered this issue: I'm trying to send an SMS message using the Airlink LX40 modem. The Messages sent in English work fine, but when I send a message in Hebrew, I receive just meaningless … --- ## [Maximum amount of device connections in Gateway](https://forum.inductiveautomation.com/t/maximum-amount-of-device-connections-in-gateway/71735)
**Author:** [@f.boz](https://forum.inductiveautomation.com/u/f.boz)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 2:31pm UTC](https://forum.inductiveautomation.com/t/maximum-amount-of-device-connections-in-gateway/71735 "2023-03-29T14:31:12Z")
Hi all. I'm designing a new Ignition system where I have a lot of different types of devices like Rockwell, Siemens, Opto22, even OPC Servers, etc. The plant has three areas with about 10 devices each one (30 devices t… --- ## [User interaction logging](https://forum.inductiveautomation.com/t/user-interaction-logging/71661)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 2:03pm UTC](https://forum.inductiveautomation.com/t/user-interaction-logging/71661 "2023-03-29T14:03:58Z")
I want to log what the operator is doing: def Log(self,Para): msg = str(self.session.props.host) + '/' msg += str(self.page.props.title) msg += str(self.page.props.path) + '/' try: msg += str(self.parent.parent.meta… --- ## [Gateway Tag Change Script help (probably syntax)](https://forum.inductiveautomation.com/t/gateway-tag-change-script-help-probably-syntax/71766)
**Author:** [@Cameronin](https://forum.inductiveautomation.com/u/Cameronin)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 1:47pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-change-script-help-probably-syntax/71766 "2023-03-29T13:47:13Z")
I'm trying to use a gateway tag change script to get a value change in a tank (with corresponding start and end times) so I can get flow in to the tank from two historicised flow meters (using tagHistoryQuery), and calcu… --- ## [Connecting Arduino communicating in OPC to Ignition SCADA](https://forum.inductiveautomation.com/t/connecting-arduino-communicating-in-opc-to-ignition-scada/71761)
**Author:** [@Mohamed\_AbdelGhaffar](https://forum.inductiveautomation.com/u/Mohamed_AbdelGhaffar)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 12:10pm UTC](https://forum.inductiveautomation.com/t/connecting-arduino-communicating-in-opc-to-ignition-scada/71761 "2023-03-29T12:10:57Z")
Has anyone tried to connect an Arduino to ignition scada through OPCDA ? Arduino is connected through a serial port and I have Arduino OPC server already installed and functioning as well as output parameters can be rea… --- ## [Transaction Group Execution Identifier](https://forum.inductiveautomation.com/t/transaction-group-execution-identifier/71749)
**Author:** [@Chris.Hawkey](https://forum.inductiveautomation.com/u/Chris.Hawkey)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 12:35pm UTC](https://forum.inductiveautomation.com/t/transaction-group-execution-identifier/71749 "2023-03-29T12:35:00Z")
Hello! I am struggling to come up with a solution to my problem. I was hoping to use transaction groups to continuously store process data when a boolean tag is high. That part is easy. I was also hoping to generate … --- ## [jyThon-Python-Other?](https://forum.inductiveautomation.com/t/jython-python-other/71720)
**Author:** [@Alan\_Cannon](https://forum.inductiveautomation.com/u/Alan_Cannon)\ **Replies:** 17\ **Last updated:** [March 29, 2023, 12:07pm UTC](https://forum.inductiveautomation.com/t/jython-python-other/71720 "2023-03-29T12:07:12Z")
i was creating my own style of logging and i found a strange issue i do not understand, so apologies if this is in the wrong forum\\channel i originally did not have the top 2 lines, so i added these during dev ( Fol… --- ## [Last Date of Project Use](https://forum.inductiveautomation.com/t/last-date-of-project-use/71748)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 1\ **Last updated:** [March 29, 2023, 9:05am UTC](https://forum.inductiveautomation.com/t/last-date-of-project-use/71748 "2023-03-29T09:05:28Z")
Hi everyone, Does anyone know if there is any built-in way to obtain the "last accessed" date of an Ignition project? Whether that would be located in the internal database (I only see "LASTMODIFIED" in the "PROJECTS" t… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=673) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=675)