Web Usage Report

Hi all,

Has anyone developed a Web Usage report? Essentially, I am trying to determine who has logged into my JPD7333 environment over the last month. This would be for an XE implementation with WAS 5.0.2.3 on Intel. I suspect I could join a few tables together (F98owsec, F0092x) in an SQL select, but I am not really sure what all the tables are. Also, because our environment is locked down so tight due to SOX, I can't experiement with the Audit reports to see if one has what I need, (perhaps someone knows which report needs to be run and I can get my SOX folks to run it).

As always, any help is greatly appreciated.

Thanks, Jay

Jay,
There are previous post on this subject. if you search in the list you should be able to find it.

Thanks,
Chan

Forgive me, but I was unable to find any topics that had anything of use. Perhaps you can shoot me a link to one.
Thanks, Jay

Try looking at post # 109928.

Actually, I posted a bunch of queries up on JDEList a couple of years ago. You want to look up my post regarding the F9312....

http://www.jdelist.com/ubb/showflat.php?Cat=0&Number=111844