nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Audit Info on LiveReports

Greg_Kellogg_(EDWAFB01User1_(Delete)_2877426)

We are in the process of upgrading from version 9.1 to 9.5 and one of our tasks is to clean up our LiveReports. To do this it would be advantageous if we could see an execution history of the LiveReports on the system. When executing a LiveReport a RunReport command is issued for the objid of the LiveReport in question. I have the SQL needed to list all of our LiveReports but don't know where to find the audit information (it does not appear to be stored in the daudit table.Also, I would like to be able to review the native SQL for each LiveReport to identify which reports will need to be modified to work with the new schema 9.5 employs.

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh via eLinkUnfortunately, execution of LiveReports is not an audited event. Thishas been entered under the following bug number in our bugs database:Bug Description (#1982445) would like audit event logged when a Livereport is run by a user. The bug has been marked as a suggestion for a future release.To review the native SQL for each LiveReport requires you to click the"Edit" function for each LiveReport and look in the SQL box on the Editpage. I am not aware of a way to extract the SQL for all LiveReports inone go from the database.- Bhupinder------------------------------------------------------ Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------ -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, November 18, 2005 11:28 AMTo: eLink RecipientSubject: Audit Info on LiveReportsAudit Info on LiveReportsPosted by Kellogg, Greg on 11/18/2005 11:26 AMWe are in the process of upgrading from version 9.1 to 9.5 and one ofour tasks is to clean up our LiveReports. To do this it would beadvantageous if we could see an execution history of the LiveReports onthe system. When executing a LiveReport a RunReport command is issued for the objidof the LiveReport in question. I have the SQL needed to list all of ourLiveReports but don't know where to find the audit information (it doesnot appear to be stored in the daudit table.Also, I would like to be able to review the native SQL for eachLiveReport to identify which reports will need to be modified to workwith the new schema 9.5 employs.[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.

Matthew_Eidson

Message from Matthew Eidson <meidson@opentext.com> via eLink

eLink

One potential workaround to this issue would be to utilize the web server logs and search for URLs that contained 'RunReport' for the objAction in a Livelink URL.

This might be a tedious process but might be a viable workaround to the shortcoming of LiveReport execution auditing.

Thanks,

Matt Eidson
ECM Technical Consultant
OpenText - Global Services (West Coast)

Phone: 661.810.6091

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Fri 11/18/2005 10:46 AM
To: eLink Recipient
Subject: RE Audit Info on LiveReports

RE Audit Info on LiveReports		Posted by bsingh (Singh, Bhupinder) on 11/18/2005 01:46 PM
In reply to: Audit Info on LiveReports		Posted by EDWAFB01User1 (Kellogg, Greg) on 11/18/2005 11:26 AM

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

Unfortunately, execution of LiveReports is not an audited event. This
has been entered under the following bug number in our bugs database:

Bug Description (#1982445)
would like audit event logged when a Livereport is run by a user.

The bug has been marked as a suggestion for a future release.

To review the native SQL for each LiveReport requires you to click the
"Edit" function for each LiveReport and look in the SQL box on the Edit
page. I am not aware of a way to extract the SQL for all LiveReports in
one go from the database.

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, November 18, 2005 11:28 AM
To: eLink Recipient
Subject: Audit Info on LiveReports

Audit Info on LiveReports
Posted by Kellogg, Greg on 11/18/2005 11:26 AM

We are in the process of upgrading from version 9.1 to 9.5 and one of
our tasks is to clean up our LiveReports. To do this it would be
advantageous if we could see an execution history of the LiveReports on
the system.

When executing a LiveReport a RunReport command is issued for the objid
of the LiveReport in question. I have the SQL needed to list all of our
LiveReports but don't know where to find the audit information (it does
not appear to be stored in the daudit table.

Also, I would like to be able to review the native SQL for each
LiveReport to identify which reports will need to be modified to work
with the new schema 9.5 employs.

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/livelink.exe

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

[To reply to this thread, use your normal E-mail reply function.]
Topic:	Audit Info on LiveReports
Discussion:	Livelink LiveReports Discussion
Livelink Server:	Knowledge Center

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

eLink User

Message from Nair, Krishnankutty N. <Krishnankutty.N.Nair@conocophillips.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: RE Audit Info on LiveReports

Perhaps you can filter on subtype 299 and look at the extended data
Here's an example
select extendeddata from dtree where subtype=299 and dataid=36329735
It could prove nasty if there are sub reports etc
A<1,?,'conf_names'='','conf_values'='','displaytype'='autoreport','fields'={},'headers'={},'inputs'={A<1,?,'inputType'='Number','label'='inputLabel1','prompt'='Enter a ObjID?'>},'params'={'USERINPUT1',?,?,?,?,?,?,?,?,?},'promptIf'='CHECKED','recordlimit'=100,'sql'='SELECT a.docid ,a.versionid,a.version,a.vermdate,a.providerid ,b.PROVIDERTYPE,b.providerdata from dversdata a,providerdata b WHERE a.docid = %1 and a.providerid=b.providerid order by version desc','subreport_id'=?,'subreport_parms'={},'subreport_path'='','title'='Better All Versions of [Object] and Path '>

An then you have the LONG field in oracle to battle with.Also if you are like us we have WantSummaryTimings=true
in our livelink instance so we have .csv files burnt for each thread.So potentially I could write something for the func=RunReport and see which ObjID is being called.

Gee good nobody is asking us to do this.I did repair/redo most of the daudit/dauditenew imbroglio's earlier.

        Thanks Much
        Krishnankutty N Nair

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, November 18, 2005 12:47 PM
To: eLink Recipient
Subject: RE Audit Info on LiveReports

RE Audit Info on LiveReports
Posted by Singh, Bhupinder on 11/18/2005 01:46 PM

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

Unfortunately, execution of LiveReports is not an audited event. This
has been entered under the following bug number in our bugs database:

Bug Description (#1982445)
would like audit event logged when a Livereport is run by a user.

The bug has been marked as a suggestion for a future release.

To review the native SQL for each LiveReport requires you to click the
"Edit" function for each LiveReport and look in the SQL box on the Edit
page. I am not aware of a way to extract the SQL for all LiveReports in
one go from the database.

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion
[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, November 18, 2005 11:28 AM
To: eLink Recipient
Subject: Audit Info on LiveReports

Audit Info on LiveReports
Posted by Kellogg, Greg on 11/18/2005 11:26 AM

When executing a LiveReport a RunReport command is issued for the objid
of the LiveReport in question. I have the SQL needed to list all of our
LiveReports but don't know where to find the audit information (it does
not appear to be stored in the daudit table.

Also, I would like to be able to review the native SQL for each
LiveReport to identify which reports will need to be modified to work
with the new schema 9.5 employs.

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/livelink.exe

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Topic: Audit Info on LiveReports
https://knowledge.opentext.com/knowledge/livelink.exe/open/4336694

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/livelink.exe

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Lindsay_Davies

Message from Lindsay Davies via eLinkGreg,A suggestion for getting all the SQL is to fo to Admin.Index -LiveReports AdministrationThere is an Export LiveReports function (?func=report.batchexport) whereyou can export all the LiveReports of your choice into a text file.While this is not easy to read, (one report definition per line) youwould be able to see the SQL from each report.Or, write a "Livereport" format livereport to list all livereports - select %1 [=report fields] from dtree where subtype=299Then they are all on one page with the function menu so you can at leastbring them all up in the gui.Enjoy!- Lindsay-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 18 November 2005 18:47To: eLink RecipientSubject: RE Audit Info on LiveReportsRE Audit Info on LiveReportsPosted by Singh, Bhupinder on 11/18/2005 01:46 PMMessage from Bhupinder Singh via eLinkUnfortunately, execution of LiveReports is not an audited event. Thishas been entered under the following bug number in our bugs database:Bug Description (#1982445)would like audit event logged when a Livereport is run by a user. The bug has been marked as a suggestion for a future release.To review the native SQL for each LiveReport requires you to click the"Edit" function for each LiveReport and look in the SQL box on the Editpage. I am not aware of a way to extract the SQL for all LiveReports inone go from the database.- Bhupinder

Greg_Kellogg_(EDWAFB01User1_(Delete)_2877426)

I ran into the Longtext datatype error when I tried to extract the SQL using the extendeddata field. I use Brio to hit the backend and it chokes on the longtext datatypes. Gave me the following ODBC error:SQLExecDirect1: rc = -1, SQLSTATE: 37000, Error Msg: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00997: illegal use of LONG datatypeNot much help there so I guess I will try extracting the SQL one report at a time.As for the audit info - Matt's suggestion probably won't work because I don't know how far back the logs go and am not sure old ones are archived. Some of our reports may only be run quarterly or annually and I was hopeful Livelink tracked executions so I could see patterns over the past several years. Perhaps OpenText will add that functionality soon. Won't help us but I have to believe other sites would like to monitor the usage of reports so they can do some cleanup of outdated entries. We have 273 LiveReports on our system and I am willing to bet half of them could be deleted today. But unless I can prove it, they will all end up being migrated to the new setup.

eLink User

Message from Nair, Krishnankutty N. via eLinkIf you are oracle savvy it shouldn't take you long to convert the longinto a varchar and put into a temp table using some pl/sql.I have donesimilar stuff before.I use TOAD or SQLplus so the ODBC does not comeinto the picture.Lot of examples can be got in google for that.I got myideas from there . -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, November 18, 2005 2:58 PMTo: eLink RecipientSubject: Long DataTypeLong DataTypePosted by Kellogg, Greg on 11/18/2005 03:55 PMI ran into the Longtext datatype error when I tried to extract the SQLusing the extendeddata field. I use Brio to hit the backend and itchokes on the longtext datatypes. Gave me the following ODBC error:SQLExecDirect1: rc = -1, SQLSTATE: 37000, Error Msg: [Microsoft][ODBCdriver for Oracle][Oracle]ORA-00997: illegal use of LONG datatypeNot much help there so I guess I will try extracting the SQL one reportat a time.As for the audit info - Matt's suggestion probably won't work because Idon't know how far back the logs go and am not sure old ones arearchived. Some of our reports may only be run quarterly or annually andI was hopeful Livelink tracked executions so I could see patterns overthe past several years. Perhaps OpenText will add that functionality soon. Won't help us but Ihave to believe other sites would like to monitor the usage of reportsso they can do some cleanup of outdated entries. We have 273LiveReports on our system and I am willing to bet half of them could bedeleted today. But unless I can prove it, they will all end up beingmigrated to the new setup.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Audit Info on LiveReportshttps://knowledge.opentext.com/knowledge/livelink.exe/open/4336694Discussion: 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.

Greg_Petti_(gpetti_(Delete)_2694690)

For anyone who has WebReports, a couple of points here. 1. If you are running Livereports using a WebReport, there is an audit event which can be enabled to produce an audit log for each RUN or EXPORT event. This can be enabled/disabled on a per report basis. Not much help to Greg obviously but for customers who want to track this type of thing in the future it might be worth running the report via a WebReport even if you don't need any of the other features2. WebReports support decoding of Extended Data. We have an example reportview which shows the SQL and parameters for every LiveReport along with a button that allows the report to be run in a window. If anyone is interested in this let me know. Greg Petti