Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Open Text Content Server for reporting

Open Text Content Server for reporting

Open Text Content Server for reporting

Hi all,

I'm new so apologies if I am breaking any rules. I am currently a reporting analyst that is trying to report off Open Text content server.

I have connected to the SQL Server db and have browsed in OTCS db. I've found some useful audit info but it still doesn't make much sense.

Does anyone have any ERD's or useful tables to use especially relationships etc?

For example I have a PerformerID but where do I go to find out who the actual person is that's logged in?

Thanks in advance!


RE: Open Text Content Server for reporting

Its not considered proper etiquette to discuss OT's Proprietary table info however a lot of people here do.If you have an account in knowledge.opentext.com you have the Live Reports Discussions area
where this info is found.Most maintenance paying customers have access to the site for free as well OT will give you what you asked for after executing an NDA.

Your question is very easy so I will give clues there's a <usertable> that has user & group info if you join that you will get what you want.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

RE: Open Text Content Server for reporting

Hi appnair,

Thank you. It's strange that I can't see that table. I'll speak to DBA's to check my permissions.

I'll also see if I can get access to the live reports discussion area


RE: Open Text Content Server for reporting

As posted above, the LiveReports forum can be found at https://knowledge.opentext.com/knowledge/cs.dll?fu..., also OpenText can provide a schema for you, once your firm has an NDA, and there is also a supporting doc for the schema that can be found at https://knowledge.opentext.com/knowledge/cs.dll/Ov.... OpenText also provide a training course on the schema as well, you can find details on their site.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close