Livelink/Content Server LiveReport to Capture Client IP Address ?

Is there any way from the Livelink or Content Server tables to capture a client IP address and create a SQL LiveReport ?

For example a user that fetched or opened a document and their IP address ?

Thank you,

Chad

Find more posts tagged with

Comments

Colin_Schmidt

Yes and No.

If your site has a Load Balancer, I don't think there is. The IP that gets recorded is the LB(DAUDITNEW & IIS). However, somehow a particular action of Brava records IP address in the IIS logs.

Without an LB, you can get it from the Login DAUDITNEW records or the IIS logs, if enabled/selected.

I'd seen in a site using a Reverse Proxy for external Users, code that would forward or pass thru the IP address.

I haven't searched for away to do that with your normal LB.

Colin J.

On Fri, Jun 19, 2015 at 10:30 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Livelink/Content Server LiveReport to Capture Client IP Address ? Posted bychad.latka@hii-ingalls.com (Latka, Chad)On 06/19/2015 10:26 AM

Is there any way from the Livelink or Content Server tables to capture a client IP address and create a SQL LiveReport ?For example a user that fetched or opened a document and their IP address ?Thank you,Chad
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation (mwv.com) or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Chad Latka

Hi Colin.

No we are not using a LB (load balancer). Just plain jane Livelink with application/web server (Windows 2008 R2, IIS 7.x)

When I go to the Livelink admin.index pages under Administer Event Auditing --> Query Audit Log (...?func=admin.auditdsp )

Select Event Type <Log-in> and Performers <Specific User> and run I can see a report of the user logging in and when and their IP address.

Was wanting to find out what Table that IP address was coming from or stored in ?

Chad Latka

OK. I found the IP listed in the DAuditNew table under the Value1 column.

Chad

Colin_Schmidt

DAUDITNEW

AUDITID = 23

PERFORMERID = qualified User

Field: VALUE1 <--can be in plain, but typically within single quote marks.

If you use the IIS logs, there's a REVERSEDNS function in Microsoft's Log Parser that may come in handy.

Colin J.

On Fri, Jun 19, 2015 at 11:12 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Re Livelink/Content Server LiveReport to Capture Client IP Address ? Posted bychad.latka@hii-ingalls.com (Latka, Chad)On 06/19/2015 11:05 AM

Hi Colin.No we are not using a LB (load balancer). Just plain jane Livelink with application/web server (Windows 2008 R2, IIS 7.x)When I go to the Livelink admin.index pages under Administer Event Auditing --> Query Audit Log (...?func=admin.auditdsp )Select Event Type <Log-in> and Performers <Specific User> and run I can see a report of the user logging in and when and their IP address. Was wanting to find out what Table that IP address was coming from or stored in ?
[To post a comment, use the normal reply function]
Topic: Livelink/Content Server LiveReport to Capture Client IP Address ?
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center