# Extracting Tag Values from the default database sqlt\_data in MySQL **URL:** \ **Category:** Ignition\ **Created:** [July 18, 2018, 6:05am UTC](https://forum.inductiveautomation.com/t/extracting-tag-values-from-the-default-database-sqlt-data-in-mysql/18872 "2018-07-18T06:05:11Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![AkikRanade](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@AkikRanade](https://forum.inductiveautomation.com/u/AkikRanade)\ **Post date:** [July 18, 2018, 6:05am UTC](https://forum.inductiveautomation.com/t/extracting-tag-values-from-the-default-database-sqlt-data-in-mysql/18872/1 "2018-07-18T06:05:11Z")
I intend to extract certain tag values which I have logged under Default Historical scan class in Ignition. I realized that those tags are being stored under a default database table “sqlt\_data\_…” with columns timestamp, intvalue and floatvalue. I have observed that 2 separate timestamps are being recorded for intvalue tag and floatvalue tag despite being recorded at same time. Is there a way to have a single timestamp record for both intvalue and floatvalue tags as they are recorded at the very same time. I have around 450-500 tags under “sqlt\_data” default database table which I want to extract in a CSV for reporting purposes, but the separate timestamp record is doubling my column size. A help would certainly be appreciated. ---
**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:** [July 18, 2018, 12:26pm UTC](https://forum.inductiveautomation.com/t/extracting-tag-values-from-the-default-database-sqlt-data-in-mysql/18872/2 "2018-07-18T12:26:40Z")
The tag historian treats every tag individually when saving to the DB. If you need multiple data points explicitly recorded together, use a transaction group. That will receive a single timestamp for the group event.