Not much found on this subject anywhere.
All I could find is how to reduce the data that is in the change log...on a WW
case.
I'm not versed in this stuff.....but this is the location referenced ...maybe
someone can figure it out.
dbo.GOBJECT_CHANGE_LOG
Below is what I found:
The size of the table in the MSSQL Galaxy Database called
dbo.GOBJECT_CHANGE_LOG can become very large over time when there
is a large amount of development. This table can be cleaned up by executing the
following script on the database:
USE {Galaxy_Name - eg KH_G}
DELETE FROM gobject_change_log
WHERE change_date <= DATEADD(dd,-15,GetDate())
This query deletes all the entries in the change log more than 15 days old.
-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Richard Peck
Sent: Saturday, April 22, 2017 3:23 PM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] FCS Strategy Change Log Export...Is it possible!!?
Hi Hexham,
I recently asked GCS about this and got told we could not access that data... a
very disappointing answer
Richard
On Fri, 21 Apr 2017 at 7:15 am, Hesham Mohamed <hesham.groups@xxxxxxxxx>
wrote:
Hi Gents,
I've been a little bit away from Infusion and FCS family products. I
can check strategies *change log* from properties window in the FCS
IDE. I believe these data reside somewhere in the Galaxy SQL, but
could not find a way to access it..
SQL views did not mention this part of information, neither did the
Direct Access..
Appreciate your guidance..
--
Best Regards*,*
*Hesham Mohamed*
Automation Consultant
______________________________________________________________________
___ This mailing list is neither sponsored nor endorsed by Schneider
Electric (formerly The Foxboro Company). Use the info you obtain here
at your own risks. See the disclaimer at
www.thecassandraproject.org/disclaimer.html
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
