tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/15263-custom-reporting-from-the-database-last-updated-and-last-updated-byCascade CMS: Discussion 2018-10-18T20:37:23Ztag:help-archives.hannonhill.com,2010-02-09:Comment/354432532014-12-03T00:37:13Z2014-12-03T00:37:13ZCustom reporting from the database - Last Updated and Last Updated By<div><p>Hi,</p>
<p>I've been asked to create a report similar to the Stale Content
report that would list all pages in the site, including the Path,
Last Updated and Last Updated By fields, like they appear in the
Stale Content report.</p>
<p>I know that the cxml_foldercontent table contains page content,
and I assume the Path is just the cachePath. However, I can't find
any fields that correspond to Last Updated or Last Updated By.
Where are those fields? Are they pulled from the most recent entry
in the cxml_audit table for an edit action and the entityId?</p>
<p>Thanks!</p></div>tomlinsontag:help-archives.hannonhill.com,2010-02-09:Comment/354432532014-12-03T13:04:44Z2014-12-03T13:04:44ZCustom reporting from the database - Last Updated and Last Updated By<div><p>Hi,</p>
<p>You need to look at cxml_entitymetadata. The id it contains is
the metadataId in cxml_foldercontent. A join with these tables will
give you what you want.</p>
<p>I have documented most of the tables (with column names) in
<a href=
"www.upstate.edu/cascade-admin/programming-formats/velocity/java-programming/database/tables.php">
Tables</a>.</p>
<p>Wing</p></div>Wing Ming Chantag:help-archives.hannonhill.com,2010-02-09:Comment/354432532014-12-03T13:07:03Z2014-12-03T13:07:03ZCustom reporting from the database - Last Updated and Last Updated By<div><p>The URL given above is not quite right. Here it is again:
<a href=
"http://www.upstate.edu/cascade-admin/programming-formats/velocity/java-programming/database/tables.php">
Tables</a>.</p>
<p>Wing</p></div>Wing Ming Chantag:help-archives.hannonhill.com,2010-02-09:Comment/354432532014-12-03T13:25:35Z2014-12-03T13:25:35ZCustom reporting from the database - Last Updated and Last Updated By<div><p>Hi,</p>
<p>Curious, but will the <a href=
"http://www.hannonhill.com/kb/Stale-Content/#available-actions-from-the-stale-content-tab">
CSV export of the Stale Content report</a> (see very bottom of
page) provide what you are looking for? The export contains the
following information for each asset within the Site:</p>
<ul>
<li>Path</li>
<li>Title</li>
<li>Display Name</li>
<li>Last Updated</li>
<li>Last Updated By</li>
<li>Link to open the asset in your Cascade Server instance</li>
</ul>
<p>Note: if your report does not contain all assets, you could use
the "Last Updated" report and enter a large value in the
<em>Content last updated more than</em> field.</p>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/354432532014-12-04T17:21:46Z2014-12-04T17:21:46ZCustom reporting from the database - Last Updated and Last Updated By<div><p>Thank you Wing, that's exactly what I needed!</p>
<p>Ryan, I'm trying to get some extra information in addition that
isn't included in the Stale Content Report, and I'm trying to only
get pages and PDFs, so unfortunately, the Stale Content Report
won't be enough, but thanks for the suggestion!</p></div>tomlinsontag:help-archives.hannonhill.com,2010-02-09:Comment/354432532014-12-05T17:24:51Z2014-12-05T17:24:51ZCustom reporting from the database - Last Updated and Last Updated By<div><p>After a second thought, I have remove the Tables page from my
site and reserve it for my own use only. But table information can
still be found <a href=
"http://s3.amazonaws.com/entp-tender-production/assets/077d34aef51dcf35338d2c8db1edcfb3e12da377/cascade.log?AWSAccessKeyId=AKIAISVUXXOK32ATONEQ&Expires=1417800326&Signature=kCyjbi77S5x6JgNFeAvRELxM%2FDE%3D">
here</a>.</p>
<p>Wing</p></div>Wing Ming Chan