# V7 Global Resource Change Log

**URL:** <https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [April 2, 2020, 11:39pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649 "2020-04-02T23:39:29Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**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:** [April 2, 2020, 11:39pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649/1 "2020-04-02T23:39:29Z")

</div>

v7.9.9

I’m looking to see what global resources have been edited in a log, similar to the project details log in the gateway webpage example below:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/da45d32f5f9a71e1a728ab219cec8db1a9b3c489.png)

Is something like this available for the global resources?

---

<div class="post-metadata">

**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:** [April 17, 2020, 4:21am UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649/2 "2020-04-17T04:21:51Z")

</div>

I’m guessing this isn’t captured anywhere?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [April 17, 2020, 12:48pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649/3 "2020-04-17T12:48:29Z")

</div>

No, it’s not, though the new auditing stuff may capture similar information. @paul-griffith?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 17, 2020, 3:03pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649/4 "2020-04-17T15:03:15Z")

</div>

All project changes are audited in 8.0, as of 8.0.5 or .6, yeah. For 7.9, I imagine you technically could enable auditing on the `global` project, but as there’s no way to open the UI for editing I’m not sure how you actually would.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [April 17, 2020, 3:04pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649/5 "2020-04-17T15:04:19Z")

</div>

Oops, I misread / misunderstood this post as being about getting similar information in Ignition 8.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 17, 2020, 3:08pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649/6 "2020-04-17T15:08:35Z")

</div>

> [@nminchin](#):
>
> I’m guessing this isn’t captured anywhere?

Do you know how to manually get to the internal database in the UI? I imagine you could `select * from project_changes where projectid=-1`; I have to assume that we're using the same mechanism to store all project changes and not specifically discarding the global project, although that may be a poor assumption.

---

<div class="post-metadata">

**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:** [April 19, 2020, 10:04pm UTC](https://forum.inductiveautomation.com/t/v7-global-resource-change-log/33649/7 "2020-04-19T22:04:27Z")

</div>

> [@paul-griffith](#):
>
> I image you could `select * from project_changes where projectid=-1`

Awesome, this works 🙂 Cheers!

I'm guessing I can use `SELECT * FROM SQLTAG ORDER BY SQLTag_ID DESC` for the tags, albeit it's not as convenient without the date added field.
