1. I found out in Vantage (8.03.305h) that even if there is
unsuccessfull try to login into the system the Vantage is changing the
last logged time to that TRY. So if someone will put your username and
just click ok on login screen - it will be logged as last logging time.
2. What version of Vantage you are using? If you have anything in
changelog related to OrderRel than it seems that your chnge log is
working. If you have selected ALL fields and if Vantage is not logging
changes in Date01 it sounds for me like a bug in Vantage.
I am not using Date01 in OrderRel so I can't tell you if it is logged
on my system. However I can tell you that other fields for table
OrderRel all logged OK in ChgLog.
*********************
PLEASE USE 'Reply to ALL' functionality - so I don't need to search
through all new posts in Vantage group to be able to answer your
question
*********************
regards
Grzegorz Szczepański
Dnia Tue, 26 May 2009 13:50:49 -0400
"Brian W. Spolarich " <bspolarich@...> napisał(a):
unsuccessfull try to login into the system the Vantage is changing the
last logged time to that TRY. So if someone will put your username and
just click ok on login screen - it will be logged as last logging time.
2. What version of Vantage you are using? If you have anything in
changelog related to OrderRel than it seems that your chnge log is
working. If you have selected ALL fields and if Vantage is not logging
changes in Date01 it sounds for me like a bug in Vantage.
I am not using Date01 in OrderRel so I can't tell you if it is logged
on my system. However I can tell you that other fields for table
OrderRel all logged OK in ChgLog.
*********************
PLEASE USE 'Reply to ALL' functionality - so I don't need to search
through all new posts in Vantage group to be able to answer your
question
*********************
regards
Grzegorz Szczepański
Dnia Tue, 26 May 2009 13:50:49 -0400
"Brian W. Spolarich " <bspolarich@...> napisał(a):
> I don't think I was very clear.
>
> 1. What I'm saying is I see ChgLog entries that would lead me to
> think that another user is modifying *MY* last logged on time. I
> *know* for a fact they're not logging in as me.
>
> 2. I have *all* fields selected for OrderRel. I only get Date01
> logged if I change *other* dates on the release. If I change *just*
> Date01 nothing happens.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix / Picometrix bspolarich@... ~ 734-864-5618
> ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: phoenix [mailto:phoenix_@...]
> Sent: Tuesday, May 26, 2009 12:40 PM
> To: vantage@yahoogroups.com
> Cc: Brian W. Spolarich
> Subject: Re: [Vantage] Two ChangeLog Questions
>
> 1. Those ARE the foolks actually changing the UserFile records. Each
> time when particular user is logging it fires up a trigger which
> wrotes to database the date of the login in UserFile table. So, this
> change is made by THIS particular user (of course they are not aware
> of that :) )
>
> 2. Do you have your BAM configured to track OrderRel.Date01 ?
> In BAM you can SELECT the TABLE and then the FIELDS which will be
> logged. On Detail/Event tab you can see the table name and 'Available'
> and 'Selected' fields. To make your 'Selected' fields hits the log, on
> the 'Action' tab you need to select 'Create Log' checkbox.
>
> regards
>
> Grzegorz Szczepański
>
> Dnia Tue, 26 May 2009 10:13:12 -0400
> "Brian W. Spolarich " <bspolarich@...> napisał(a):
>
> > 1. I'm logging all changes to user accounts (UserFile table)
> > via BAM logging.
> >
> >
> >
> > I notice a bunch of ChgLog entries for UserFile. For example, on
> > my account ("user1") I see this from this morning:
> >
> >
> >
> > user2 09:45:24 Last Used Date: 05/21/09 -> 05/26/09 Last Used
> > Time: 53822 -> 35124
> >
> >
> >
> > And I see lots of others. But these aren't folks actually
> > changing the UserFile records (they don't have access, of that I am
> > sure).
> >
> >
> >
> > Where are these BAM logs coming from?
> >
> >
> >
> > 2. I have BAM logging on OrderHed/OrderDtl/OrderRel for all
> > fields. We use OrderRel.Date01 to track the customer requested date
> > for a release.
> >
> >
> >
> > However changes to that field aren't hitting ChgLog. I tried myself
> > just now and double-checked by directly querying the ChgLog table.
> > Nothing. If I change some of the other fields (e.g. NeedBy) at the
> > same time, then I will see the Date01 change in the ChgLog, but not
> > if I change just Date01. Is this a "feature"?
> >
> >
> >
> > -bws
> >
> >
> >
> > --
> >
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> > Photonix / Picometrix
> >
> > bspolarich@...
> > <mailto:bspolarich@...> ~ 734-864-5618 ~
> > www.advancedphotonix.com <http://www.advancedphotonix.com>
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >