# Log data from multiple connected device every minute **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [June 24, 2024, 8:12pm UTC](https://forum.inductiveautomation.com/t/log-data-from-multiple-connected-device-every-minute/92300 "2024-06-24T20:12:16Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Pat\_Cunningham](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pat_cunningham/32/57710_2.png) [@Pat\_Cunningham](https://forum.inductiveautomation.com/u/Pat_Cunningham)\ **Post date:** [June 24, 2024, 8:12pm UTC](https://forum.inductiveautomation.com/t/log-data-from-multiple-connected-device-every-minute/92300/1 "2024-06-24T20:12:16Z")
I have multiple (+100) connected devices that each are an instance of the same UDT. I would like to log data from each to a datatable every minute. What would be the best way to do this? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [June 24, 2024, 8:35pm UTC](https://forum.inductiveautomation.com/t/log-data-from-multiple-connected-device-every-minute/92300/2 "2024-06-24T20:35:19Z")
I would probably go the SQL Bridge route and use a Transaction Group so you can have a Wide Table format, as opposed to the Tall format the Historian uses. The same can be achieved with a bit of time up front if you use a Gateway Scheduled Event Script (or a trigger with a Gateway Tag Change Script if you need to insure all of the data is synchronized). ---
**Author:** ![Pat\_Cunningham](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pat_cunningham/32/57710_2.png) [@Pat\_Cunningham](https://forum.inductiveautomation.com/u/Pat_Cunningham)\ **Post date:** [June 24, 2024, 8:58pm UTC](https://forum.inductiveautomation.com/t/log-data-from-multiple-connected-device-every-minute/92300/3 "2024-06-24T20:58:21Z")
I am actually using a Gateway event currently but I only have a couple of tools online. I am worried that as more come on that it not be able to do it a minute. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 24, 2024, 10:14pm UTC](https://forum.inductiveautomation.com/t/log-data-from-multiple-connected-device-every-minute/92300/4 "2024-06-24T22:14:11Z")
How urgent is your need? I am working on a "wide type historian" that is tailored for the purpose you describe. It will be an enhancement to my Time Series Database Cache module, so that the history retrieval part can use the same wide table infrastructure. It will likely be ready as a beta before August. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [June 25, 2024, 5:38am UTC](https://forum.inductiveautomation.com/t/log-data-from-multiple-connected-device-every-minute/92300/5 "2024-06-25T05:38:23Z")
Reading tag values via tag.read is super quick since it just reads the cached values. You won't have any issues reading and inserting the values in time. You could use the store and forward system to run the insert statement as well (system.db.runSFPrepUpdate) ---
**Author:** ![Pat\_Cunningham](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pat_cunningham/32/57710_2.png) [@Pat\_Cunningham](https://forum.inductiveautomation.com/u/Pat_Cunningham)\ **Post date:** [June 28, 2024, 12:32pm UTC](https://forum.inductiveautomation.com/t/log-data-from-multiple-connected-device-every-minute/92300/6 "2024-06-28T12:32:41Z")
Let me know when it is done. I would like to try it out.