Core LiveReports - Which ones are they?

Knowledge_Administration_(paclif02kmadmin_-_(delet

Hello. We're currently trying to put together an index of the LiveReports that we have installed on our LiveLink server and we're really not sure where to begin. We have a slough of reports that may have been created after we implemented LiveLink server and reports that most likely shipped with Livelink server. Is there any easy way to differentiate between the two types - core vs custom? Does Open Text have a published list anywhere here in the Knowledge Center that documents which LiveReports ship with which version of their LiveLink Enterprise Server product?Thanks in advance!

Find more posts tagged with

Comments

Alex_Kowalenko_(x-eu0016039_-_(deleted))

Message from Alex Kowalenko via eLinkThe core LiveReports are installed in the Livelink LiveReports volume. If noother LiveReports were added to the LiveReports volume then an Oracle SQLquery like the following may work:select decode( ParentID, 2002, 'Core', 'Custom' ) "Source", Name from DTree where subtype = 299 order by 1, 2This assumes the LiveReport volume has a DataID of 2002.If custom LiveReports were added to this volume but the core LiveReportswere not modified or moved then a query by DTree.CreatedDate could be usedseparate the two types.The core LiveReports in a Livelink 9.5 SP1 instance that I have seen are thefollowing:25 Largest DocumentsAll Explorer Usage Since [Date] All Late WorkflowsAll Outstanding Tasks All Reserved ItemsAll Tasks Due Next Week All Workflows and ManagersAll Workflows with Comments Deleted Documents Deleted Documents By [User] Documents With The Most VersionsExplorer Professional Usage Count Since Explorer Professional Users Since [Date]Explorer Unique Usage Count Since [Date]Explorer Unique Users Since [Date]Item Count By CategoryItems Reserved By [User]Largest Projects (Physical Space) Least Active Projects In The Last WeekMost Active Projects In The Last Week My Bad Aliases and GenerationsMy Late Tasks My Outstanding TasksMy Recently Viewed DocumentsMy Tasks Due Next WeekNumber of Active Steps By [Performer] Number of Active UsersNumber of Active WorkflowsNumber of Active Workflows By [Map ID]Number of Late WorkflowsNumber of Late Workflows By [Map ID]Number of Steps LateNumber of Steps Late By [Performer] Outstanding Tasks For [User]Show All [Type] Items Status For All WorkflowsThis Week's NewsToday's NewsWhat Happened Last Month? What Happened Last Week?What Happened Yesterday?What's Hot This Week? What's Hot Today? What's New This Month?What's New This Week? What's New Today? Workflow Comments By [ID] Workflow Status By [ID] Workflow Steps and Status By [ID]-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, October 12, 2005 10:28 AMTo: eLink RecipientSubject: Core LiveReports - Which ones are they?Core LiveReports - Which ones are they?Posted by Nagatoshi, Mike on 10/12/2005 11:24 AMHello. We're currently trying to put together an index of the LiveReportsthat we have installed on our LiveLink server and we're really not surewhere to begin. We have a slough of reports that may have been created after we implementedLiveLink server and reports that most likely shipped with Livelink server.Is there any easy way to differentiate between the two types - core vscustom? Does Open Text have a published list anywhere here in the Knowledge Centerthat documents which LiveReports ship with which version of their LiveLinkEnterprise Server product?Thanks in advance![To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

I.S._Support_(bupauser3_-_(deleted))

Dear Alex/eLinkAs you know there is a report called All Outstanding Tasks. I want to get a list of these tasks with a switch for inactive users, any ideas of the best way of extracting this info using LiveReports?Many thanks for your input.

Krishnankutty_Nair

I do not know if this is oracle specific but there are two keys in kuaf which may give you what you are looking.Also I do not know in your oragnization what an active user is.I think of an active user as a user who can login and not in a deleted stateso we can write the orignal query asselect DTree.*, KUAF.Name "kuafname" from DTree, KUAF where (KUAF.ID=DTree.AssignedTo) and (DTree.DateCompleted IS NULL) and kuaf.deleted=0 and BitAnd(kuaf.userprivileges, 15) = 15%1 and %2 order by DTree.DateDue*****************Please see if this suits your purpose orif it works with sqlserver

I.S._Support_(bupauser3_-_(deleted))

Thanks for this. You have two switches (Param %1 and Param%2) but I cannot see whether you specified in your reply what you are using %1 and %2 for? Many thanks,Edward Dudetsky

Krishnankutty_Nair

The sql %1 and %2 is given to you by opentext not by me I added the two ands in that.Please take a look at the SQL statement the live report is executing.If you do not know sql please ask your dba or get some help.%1 is equivalent to dtrees.subtype "tasksubtype" a number, and %2 is the filter permissions.Your qn was How would I use this LR to report only active users or the reverse of that.

Alex_Kowalenko_(aka_-_(deleted))

Message from Alex Kowalenko via eLinkSorry I didn't get back to you earlier. I trust that you received goodanswers from the experts already.-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, January 20, 2006 2:00 AMTo: eLink RecipientSubject: ALL OUTSTANDING TASKS - INACTIVE USERSALL OUTSTANDING TASKS - INACTIVE USERSPosted by Support, I.S. on 01/19/2006 12:55 PMDear Alex/eLinkAs you know there is a report called All Outstanding Tasks. I want to get a list of these tasks with a switch for inactive users, anyideas of the best way of extracting this info using LiveReports?Many thanks for your input.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Core LiveReports - Which ones are they?https://knowledge.opentext.com/knowledge/livelink.exe/open/4236536Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.