Change Logs

Yahoo Archive
1
Take a look at the ChgLogTB and ChgLogGA tables.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Thursday, January 27, 2011 3:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Change Logs


Has anyone created a report that will pull out all the instances of
where
there are change logs turned on for a screen or field? Rather not
re-invent
the wheel if someone has already created one.

thanks



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
Good Morning:

Is there a way to create a report either in Report Builder or
Crystal, that will display all change log records for orders? I
can't seem to find a field in any of the order tables that store this
information, although I may have missed something as well.

Thanks,

Mark Smith
Director of Information Systems
Innerpac, Inc
3
The data is stored in the CHGLog table.
Thanks
Jeremy


-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Monday, March 01, 2004 10:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Change Logs


Good Morning:

Is there a way to create a report either in Report Builder or
Crystal, that will display all change log records for orders? I
can't seem to find a field in any of the order tables that store this
information, although I may have missed something as well.

Thanks,

Mark Smith
Director of Information Systems
Innerpac, Inc




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
Jeremy:



Thanks.



-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, March 01, 2004 9:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Change Logs



The data is stored in the CHGLog table.
Thanks
Jeremy


-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Monday, March 01, 2004 10:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Change Logs


Good Morning:

Is there a way to create a report either in Report Builder or
Crystal, that will display all change log records for orders? I
can't seem to find a field in any of the order tables that store this
information, although I may have missed something as well.

Thanks,

Mark Smith
Director of Information Systems
Innerpac, Inc




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.



[Non-text portions of this message have been removed]
5
Where in Vantage do you set up what fields you want to track on the change log?

Thanks,

Jasper



[Non-text portions of this message have been removed]
6
Joe,



This is found under System Management, Utilities and Business Activity
Manager.



There you can setup a new change log by picking the table and then the
fields you are looking to track. The actions tab is where you can
activate the log.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Tuesday, March 20, 2007 10:58 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Change Logs



Where in Vantage do you set up what fields you want to track on the
change log?

Thanks,

Jasper

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
7
On 5.2 its 'system management' -> 'utilities' -> 'change log
maintenance'

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Tuesday, March 20, 2007 11:58 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Change Logs

Where in Vantage do you set up what fields you want to track on the
change log?

Thanks,

Jasper



[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
8
We are currently using change logs and have been for quite some time. our problem is that we have noticed that these change logs have grown rather large in size over the years and we would like to delete out old information. Has anyone come up with a safe way of doing this? According to the help desk the ONLY way to remove data from the change logs is to get in touch with custom programming. I have been looking at the data and it appears that the only table the data resides in is the ChgLog table in the database.

In our test environment I have written a Progress query to look for older (based on field name DateStamp) records and remove them from the change log. This appears to have worked but I was hoping someone else has tried something like this already and could give me some more insight to this. Thank you


Robert Nupp
robert.nupp@...
Vantage 8.03.403C Progress Database
9
Go to System Management\Utilities\Database Purge and Summarize. You'll notice the Change Log is one of the items you can purge. We intend to start purging everything after two years once we're on Epicor 9. If anyone wants to see items that've been purged, we can always go to the month-end backups we keep for 7 years. (So we'll also keep the last 8.03.xx software for 7 years.)

--- In vantage@yahoogroups.com, "robert.nupp" <robert.nupp@...> wrote:
>
> We are currently using change logs and have been for quite some time. our problem is that we have noticed that these change logs have grown rather large in size over the years and we would like to delete out old information. Has anyone come up with a safe way of doing this? According to the help desk the ONLY way to remove data from the change logs is to get in touch with custom programming. I have been looking at the data and it appears that the only table the data resides in is the ChgLog table in the database.
>
> In our test environment I have written a Progress query to look for older (based on field name DateStamp) records and remove them from the change log. This appears to have worked but I was hoping someone else has tried something like this already and could give me some more insight to this. Thank you
>
>
> Robert Nupp
> robert.nupp@...
> Vantage 8.03.403C Progress Database
>
10
Hello,

I am looking for change logs within Vantage. There is a table called 'Chglog', however, I can't seem to find any changes to 'Vendor' master table.

Is there another table that keeps track of changes in master vendor file? If there is, is there a tracker for these changes?

Thanks,

Daniel
11
The chglog table receives changes based on Business Activity Manager
alert settings.

You need to create a BAM alert set to log changes on particular tables
and fields you're interested in. Those will wind up in chglog showing
who changed what and when.

Its not always obvious what really happened from the chglog messages,
but it's a start. But you do have to turn the logging on for each table
individually and pick which fields you're interested in (or you can
bring 'em all over in the maintenance program by clicking the
double-chevrons).

-brian

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dymilano@...
Sent: Thursday, September 02, 2010 1:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Change Logs

Hello,

I am looking for change logs within Vantage. There is a table called
'Chglog', however, I can't seem to find any changes to 'Vendor' master
table.

Is there another table that keeps track of changes in master vendor
file? If there is, is there a tracker for these changes?

Thanks,

Daniel



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
12
Has anyone created a report that will pull out all the instances of where
there are change logs turned on for a screen or field? Rather not re-invent
the wheel if someone has already created one.

thanks