Live Report and Web Report Date of last execution/action ?

Hello,

Our user wants to know the last execution date of WebReports and LiveReports that we have.

We have found the way to do this for the WebReports by running an SQL request that query the WEBREPORTSTATS table.

We can't seem to find a table for the LiveReports. I saw that it is audited on the DAUDITNEW table, but it does not store the value when it is executed(it only store creation, rename etc).

Is there a table specifically for the LiveReports(like WEBREPORTSTATS for the WebReport)? Where can we find the last execution date of LiveReports(if it exists).

Thank you very much in advance!

Find more posts tagged with

Comments

Hi Gazelly,

Depending on the version of Livelink/Content Server you have installed, they should be an option to enable this.

Visit the Admin.Index page and scroll down to find System Administration and Administer Event Auditing.

Click that, then click on Set Auditing Interests.

The event audit you need to activate is “Live Report Executed”.

You may need to restart your services on all instances in your cluster.

Obviously this will not retrospectively give you data, but will record events going forwards.

Regards

Lindsay

Lindsay Davies
Information Systems Administrator
Renewable Energy Systems (RES)

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 12 May 2016 10:37
To: eLink Recipient
Subject: Live Report and Web Report Date of last execution/action ?

Live Report and Web Report Date of last execution/action ?

Posted by Aury, Gazelly On 05/12/2016 05:35 AM

Hello,

Our user wants to know the last execution date ofWebReports and LiveReports that we have.

We have found the way to do this for the WebReportsby running an SQL request that query the WEBREPORTSTATS table.

We can't seem to find a table for the LiveReports. I saw that it is audited on theDAUDITNEW table, but it does not store the value when it is executed(it only store creation, rename etc).

Is there a table specifically for the LiveReports(like WEBREPORTSTATS for the WebReport)? Where can we find the last execution date of LiveReports(if it exists).

Thank you very much in advance!

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

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.

Hello Lindsay,

Thank you so much for your response. That helped us.

Have a good day!

Regards,

Gazelly

To get the length of time, I wonder if the “timings” files will show this. An alternative is to go to the IIS logs. Use Log Parser 2.2, a free download from MS, and Log Parser Studio, also a free download (but not from MS), to query them looking for “runReport”. If you know the dataid, you can combine the search criteria. Download them to your desktop and process them offline from the server. Two very handy utilities. Also check your Log entries in IIS to make sure you are recording the parameter you need.

The CS-URI-STEM will have something like this: func=ll&objId=16186939&objAction=runReport&inputLabel1_ID=12282097

The TIME-TAKEN will have the amount of “time taken” in MS. It’ll even list the input parameters.

You can tell if phones or tablets are being used, what OS, the browser and it’s version, as well.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

Knowledgelink@capitalone.com

Cell: 918-904-9223

Don’t waste space with attachments – follow these steps to e-mail links to documents stored in Knowledgelink

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, May 12, 2016 6:13 AM
To: eLink Recipient
Subject: RE Live Report and Web Report Date of last execution/action ?

RE Live Report and Web Report Date of last execution/action ?

Posted by Davies, Lindsay On 05/12/2016 06:12 AM

Hi Gazelly,

Depending on the version of Livelink/Content Server you have installed, they should be an option to enable this.

Visit the Admin.Index page and scroll down to find System Administration and Administer Event Auditing.

Click that, then click on Set Auditing Interests.

The event audit you need to activate is “Live Report Executed”.

You may need to restart your services on all instances in your cluster.

Obviously this will not retrospectively give you data, but will record events going forwards.

Regards

Lindsay

Lindsay Davies
Information Systems Administrator
Renewable Energy Systems (RES)

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 12 May 2016 10:37
To: eLink Recipient
Subject: Live Report and Web Report Date of last execution/action ?

Live Report and Web Report Date of last execution/action ?

Posted by Aury, Gazelly On 05/12/2016 05:35 AM

Hello,

Our user wants to know the last execution date of WebReports and LiveReports that we have.

We have found the way to do this for the WebReports by running an SQL request that query the WEBREPORTSTATS table.

We can't seem to find a table for the LiveReports. I saw that it is audited on the DAUDITNEW table, but it does not store the value when it is executed(it only store creation, rename etc).

Is there a table specifically for the LiveReports(like WEBREPORTSTATS for the WebReport)? Where can we find the last execution date of LiveReports(if it exists).

Thank you very much in advance!

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

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.

[To post a comment, use the normal reply function]
Topic:	Live Report and Web Report Date of last execution/action ?
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

I will second Colin's answer as well many times user actions do come through the webserver and like IIS other webservers also has logging.Everything in livelink will end in a script(livelink.exe,cs.exe,llisapi.dll,livelink,cs,exe,cs.dll etc) and then a POST or even GET that is the ?func part

func=ll&objId=16186939&objAction=runReport&inputLabel1_ID=12282097

Like Colin I have used the log parsing tools many a time when something I am looking for is not readily available in livelink tables.

.....appu appnair appunair

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Thu, May 12, 2016 at 8:25 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

RE RE Live Report and Web Report Date of last execution/action ? Posted bySchmidt, ColinOn 05/12/2016 09:24 AM

To get the length of time, I wonder if the “timings” files will show this. An alternative is to go to the IIS logs. Use Log Parser 2.2, a free download from MS, and Log Parser Studio, also a free download (but not from MS), to query them looking for “runReport”. If you know the dataid, you can combine the search criteria. Download them to your desktop and process them offline from the server. Two very handy utilities. Also check your Log entries in IIS to make sure you are recording the parameter you need.The CS-URI-STEM will have something like this: func=ll&objId=16186939&objAction=runReport&inputLabel1_ID=12282097The TIME-TAKEN will have the amount of “time taken” in MS. It’ll even list the input parameters.You can tell if phones or tablets are being used, what OS, the browser and it’s version, as well. Colin J. SchmidtKnowledgelink Support CapitalOne | Collaboration TechnologyKnowledgelink@capitalone.comCell: 918-904-9223 Don’t waste space with attachments – follow these steps to e-mail links to documents stored in Knowledgelink

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, May 12, 2016 6:13 AM
To: eLink Recipient
Subject: RE Live Report and Web Report Date of last execution/action ?

RE Live Report and Web Report Date of last execution/action ?

Posted by Davies, Lindsay On 05/12/2016 06:12 AM

Hi Gazelly,
Depending on the version of Livelink/Content Server you have installed, they should be an option to enable this.

Visit the Admin.Index page and scroll down to find System Administration and Administer Event Auditing.
Click that, then click on Set Auditing Interests.
The event audit you need to activate is “Live Report Executed”.
You may need to restart your services on all instances in your cluster.

Obviously this will not retrospectively give you data, but will record events going forwards.

Regards
Lindsay

Lindsay Davies
Information Systems Administrator
Renewable Energy Systems (RES)

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 12 May 2016 10:37
To: eLink Recipient
Subject: Live Report and Web Report Date of last execution/action ?

Live Report and Web Report Date of last execution/action ?

Posted by Aury, Gazelly On 05/12/2016 05:35 AM

Hello,
Our user wants to know the last execution date of WebReports and LiveReports that we have.
We have found the way to do this for the WebReports by running an SQL request that query the WEBREPORTSTATS table.
We can't seem to find a table for the LiveReports. I saw that it is audited on the DAUDITNEW table, but it does not store the value when it is executed(it only store creation, rename etc).
Is there a table specifically for the LiveReports(like WEBREPORTSTATS for the WebReport)? Where can we find the last execution date of LiveReports(if it exists).
Thank you very much in advance!

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

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.
[To post a comment, use the normal reply function]
Topic:
Live Report and Web Report Date of last execution/action ?
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

[To post a comment, use the normal reply function]
Topic:	Live Report and Web Report Date of last execution/action ?
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

There is an audit event for Live Report execution.

The audit id is 234 and the auditstr is LiveReport.

As noted by Lindsay, the audit event 'LiveReportExecuted' will need to be turned on.

Ref.Usage Data of LiveReport

Simple query/s Who Runs LiveReports?

SELECT [columns] WHERE

DAUDITNEW.AUDITID = 234 AND

DAUDITNEW.SUBTYPE = 299 AND

DAUDITNEW.AUDITDATE >= DATETIME (2016, 05, 12, 00, 00, 00)

SELECT

DAUDITNEW.DATAID,

DAUDITNEW.AUDITSTR,

DAUDITNEW.PERFORMERID,

DAUDITNEW.AUDITDATE,

DAUDITNEW.SUBTYPE,

DAUDITNEW.AUDITID,

KUAF.MAILADDRESS

FROM

DAUDITNEW INNER JOIN KUAF ON DAUDITNEW.PERFORMERID=KUAF.ID

WHERE

DAUDITNEW.SUBTYPE=30303 AND DAUDITNEW.AUDITDATE>=DATETIME (2015, 04, 29, 00, 01, 37)

ORDER BY

DAUDITNEW.PERFORMERID, DAUDITNEW.AUDITSTR

EXTERNAL JOIN DAUDITNEW.DATAID=DTREECORE.DATAID

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, May 12, 2016 9:25 AM
To: eLink Recipient
Subject: RE RE Live Report and Web Report Date of last execution/action ?

RE RE Live Report and Web Report Date of last execution/action ?

Posted by Schmidt, Colin On 05/12/2016 09:24 AM

To get the length of time, I wonder if the “timings” files will show this. An alternative is to go to the IIS logs. Use Log Parser 2.2, a free download from MS, and Log Parser Studio, also a free download (but not from MS), to query them looking for “runReport”. If you know the dataid, you can combine the search criteria. Download them to your desktop and process them offline from the server. Two very handy utilities. Also check your Log entries in IIS to make sure you are recording the parameter you need.

The CS-URI-STEM will have something like this: func=ll&objId=16186939&objAction=runReport&inputLabel1_ID=12282097

The TIME-TAKEN will have the amount of “time taken” in MS. It’ll even list the input parameters.

You can tell if phones or tablets are being used, what OS, the browser and it’s version, as well.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

Knowledgelink@capitalone.com

Cell: 918-904-9223

Don’t waste space with attachments – follow thesestepsto e-mail links to documents stored in Knowledgelink

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, May 12, 2016 6:13 AM
To: eLink Recipient
Subject: RE Live Report and Web Report Date of last execution/action ?

RE Live Report and Web Report Date of last execution/action ?

Posted by Davies, Lindsay On 05/12/2016 06:12 AM

Hi Gazelly,

Depending on the version of Livelink/Content Server you have installed, they should be an option to enable this.

Visit the Admin.Index page and scroll down to find System Administration and Administer Event Auditing.

Click that, then click on Set Auditing Interests.

The event audit you need to activate is “Live Report Executed”.

You may need to restart your services on all instances in your cluster.

Obviously this will not retrospectively give you data, but will record events going forwards.

Regards

Lindsay

Lindsay Davies
Information Systems Administrator
Renewable Energy Systems (RES)

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 12 May 2016 10:37
To: eLink Recipient
Subject: Live Report and Web Report Date of last execution/action ?

Live Report and Web Report Date of last execution/action ?

Posted by Aury, Gazelly On 05/12/2016 05:35 AM

Hello,

Our user wants to know the last execution date ofWebReports and LiveReports that we have.

We have found the way to do this for theWebReports by running an SQL request that query theWEBREPORTSTATS table.

We can't seem to find a table for theLiveReports. I saw that it is audited on theDAUDITNEW table, but it does not store the value when it is executed(it only store creation, rename etc).

Is there a table specifically for the LiveReports(like WEBREPORTSTATS for the WebReport)? Where can we find the last execution date of LiveReports(if it exists).

Thank you very much in advance!

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

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.

[To post a comment, use the normal reply function]
Topic:	Live Report and Web Report Date of last execution/action ?
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

[To post a comment, use the normal reply function]
Topic:	Live Report and Web Report Date of last execution/action ?
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Log Parser uses a SQL Query structure. The Help file that comes with MS’ Log Parser shows the structure in a very easy manner and format. It also can be used to query a large number of other file formats, even the Windows Events. One very helpful function is to pull the values for a specified parameter or to pluck out the value of the parameter….and other functions.

Log Parser Studio can be configured to output to the screen or automatically create a CSV and be opened by Excel. You can select one or almost as many IIS log files for the query to go through.

Queries come with it, but they’re nothing more than a starting point. You can create your own and save them within the query selection list/screen. I’ve queried Brava logs at one time.

The DAuditNew logs will not show the length of execution time, only the time the LR was started….as other DAuditNew entries do not show length of execution.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

Knowledgelink@capitalone.com

Cell: 918-904-9223

Don’t waste space with attachments – follow these steps to e-mail links to documents stored in Knowledgelink

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, May 12, 2016 10:54 AM
To: eLink Recipient
Subject: RE RE RE Live Report and Web Report Date of last execution/action ?

RE RE RE Live Report and Web Report Date of last execution/action ?

Posted by Picard, Al On 05/12/2016 10:53 AM

There is an audit event for Live Report execution.

The audit id is 234 and the auditstr is LiveReport.

As noted by Lindsay, the audit event 'LiveReportExecuted' will need to be turned on.

Ref. Usage Data of LiveReport

Simple query/s Who Runs LiveReports?

SELECT [columns] WHERE

DAUDITNEW.AUDITID = 234 AND

DAUDITNEW.SUBTYPE = 299 AND

DAUDITNEW.AUDITDATE >= DATETIME (2016, 05, 12, 00, 00, 00)

SELECT

DAUDITNEW.DATAID,

DAUDITNEW.AUDITSTR,

DAUDITNEW.PERFORMERID,

DAUDITNEW.AUDITDATE,

DAUDITNEW.SUBTYPE,

DAUDITNEW.AUDITID,

KUAF.MAILADDRESS

FROM

DAUDITNEW INNER JOIN KUAF ON DAUDITNEW.PERFORMERID=KUAF.ID

WHERE

DAUDITNEW.SUBTYPE=30303 AND DAUDITNEW.AUDITDATE>=DATETIME (2015, 04, 29, 00, 01, 37)

ORDER BY

DAUDITNEW.PERFORMERID, DAUDITNEW.AUDITSTR

EXTERNAL JOIN DAUDITNEW.DATAID=DTREECORE.DATAID

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, May 12, 2016 9:25 AM
To: eLink Recipient
Subject: RE RE Live Report and Web Report Date of last execution/action ?

RE RE Live Report and Web Report Date of last execution/action ?

Posted by Schmidt, Colin On 05/12/2016 09:24 AM

To get the length of time, I wonder if the “timings” files will show this. An alternative is to go to the IIS logs. Use Log Parser 2.2, a free download from MS, and Log Parser Studio, also a free download (but not from MS), to query them looking for “runReport”. If you know the dataid, you can combine the search criteria. Download them to your desktop and process them offline from the server. Two very handy utilities. Also check your Log entries in IIS to make sure you are recording the parameter you need.

The CS-URI-STEM will have something like this: func=ll&objId=16186939&objAction=runReport&inputLabel1_ID=12282097

The TIME-TAKEN will have the amount of “time taken” in MS. It’ll even list the input parameters.

You can tell if phones or tablets are being used, what OS, the browser and it’s version, as well.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

Knowledgelink@capitalone.com

Cell: 918-904-9223

Don’t waste space with attachments – follow these steps to e-mail links to documents stored in Knowledgelink

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, May 12, 2016 6:13 AM
To: eLink Recipient
Subject: RE Live Report and Web Report Date of last execution/action ?

RE Live Report and Web Report Date of last execution/action ?

Posted by Davies, Lindsay On 05/12/2016 06:12 AM

Hi Gazelly,

Depending on the version of Livelink/Content Server you have installed, they should be an option to enable this.

Visit the Admin.Index page and scroll down to find System Administration and Administer Event Auditing.

Click that, then click on Set Auditing Interests.

The event audit you need to activate is “Live Report Executed”.

You may need to restart your services on all instances in your cluster.

Obviously this will not retrospectively give you data, but will record events going forwards.

Regards

Lindsay

Lindsay Davies
Information Systems Administrator
Renewable Energy Systems (RES)

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 12 May 2016 10:37
To: eLink Recipient
Subject: Live Report and Web Report Date of last execution/action ?

Live Report and Web Report Date of last execution/action ?

Posted by Aury, Gazelly On 05/12/2016 05:35 AM

Hello,

Our user wants to know the last execution date of WebReports and LiveReports that we have.

We have found the way to do this for the WebReports by running an SQL request that query the WEBREPORTSTATS table.

We can't seem to find a table for the LiveReports. I saw that it is audited on the DAUDITNEW table, but it does not store the value when it is executed(it only store creation, rename etc).

Is there a table specifically for the LiveReports(like WEBREPORTSTATS for the WebReport)? Where can we find the last execution date of LiveReports(if it exists).

Thank you very much in advance!

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

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.

[To post a comment, use the normal reply function]
Topic:	Live Report and Web Report Date of last execution/action ?
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

[To post a comment, use the normal reply function]
Topic:	Live Report and Web Report Date of last execution/action ?
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Live Report and Web Report Date of last execution/action ?
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.