LiveReports Webinar or documentation for beginner/intermediate

Hilary_Stamper

Anyone know of any good webinars or documentation for LiveReports that would be appropriate for an intermediate Content Server admin?

Colin_Schmidt

If you can write a SQL query to run in a DB tool like Aqua Data Studio or SQL Developer or TOAD, you can write one for a LiveReport.   Though there are two different types.  One that reports just data and one that will include icons and links as if you’re inside from CS folder.  The latter executes longer to create.  IF you have the LR extensions, there are some other options, but they may not make much difference in the writing of the LR.

 

Outside of writing or composing a query, you need to know the tables and their data relationships.  You can get that two ways: get the Schema manual by way of an NDA from OT Support or open a QA or Dev Schema and look down through the tables.  Attached is a PDF(I recently updated) with some of the CORE tables and some of the ways they’re tied to other tables or can be used from other tables.  Codes and their translated values are extremely important and a fair amount of them can be obtained from the next PDF attached.  It comes from the Champion Toolkit section within the KC.    Others can be obtained the hard way(trial and the KC Forums) or from the Excel spreadsheet that is attached.

 

Check the Admin pages for what is being recorded in the DAUDITNEW table.  You might see something that is not being recorded that could provide you with something useful.  The more you select, the more log entries, but it also depends on their frequency.  Items related to the system or SOV will log rarely, but may be something you want to check over a year.  If you have Records Management, some of them may log so frequently that you may not really want them logging.  Etc.

 

One of two exceptions is the logging of WF activity.  That can be obtained in the WWORKAUDIT, not in DAUDITNEW.  The other is the Search Stats.  Search stats can be obtained from a section in the Admin pages or you can write your own.  They occupy SEARCHSTATS_COMPONENTS, SEARCHSTATS_QUERY, SEARCHSTATS_SLICE, and SEARCHSTATS_TERMS.  You can determine easily that most searches are done from the default Search text box and fewer are done from the Advanced.  You won’t, more than likely, be able to determine WHO searched, since the ID is masked in some places(companies and/or countries).  You can also determine what areas or what values are searched for most often, if that is of a one-time concern.

 

You can see the SOV messages from the SOVMGMTMSGS table. 

 

Data mining can produce a wealth of information, but not all interesting except some nut bent on acquiring numbers and stats(similar to the odd job writing this email). 

 

Regards,

 

Colin J

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, January 04, 2018 6:42 PM
To: eLink Recipient
Subject: [EXT] LiveReports Webinar or documentation for beginner/intermediate

 

LiveReports Webinar or documentation for beginner/intermediate

Posted byhilary.stamper@albertainnovates.ca (Stamper, Hilary) On 01/04/2018 05:21 PM

 

Anyone know of any good webinars or documentation for LiveReports that would be appropriate for an intermediate Content Server admin?

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	My Support

 

The information contained in this message may be CONFIDENTIAL and is for the intended addressee only.  Any unauthorized use, dissemination of the information, or copying of this message is prohibited.  If you are not the intended addressee, please notify the sender immediately and delete this message.

Visio-TableRelationships.pdf

OTCS_Schema_Companion_Reference_Guide.pdf

LL-Table_codes.xlsx