tag:help-archives.hannonhill.com,2010-02-09:/discussions/general/396-cascade-server-schema-diagramCascade CMS: Discussion 2014-03-25T20:56:38Ztag:help-archives.hannonhill.com,2010-02-09:Comment/111062932012-03-15T00:25:37Z2012-03-15T00:25:37ZCascade Server Schema Diagram<div><p>I've been visiting some older posts and saw this one. I do
apologize that it was overlooked.</p>
<p>You're looking for the database schema correct? Not a <a href=
"http://www.hannonhill.com/news/blog/2011/spotlight-on-cascade-entity-relationship-diagrams.html">
Cascade Entity Relationship diagram</a> of some kind? There are
some example reports in the Default Database. In the example.com
Site there is a folder called <code>_reports</code> that does some
generic reporting for stale content and pages without certain
fields filled in. Does that help at all?</p>
<blockquote>
<p>1) Are there plans to provide reporting for Cascade Server?</p>
</blockquote>
<p>Integrating reports into Cascade Server is on our radar.</p>
<blockquote>
<p>2) can you provide us with a copy of the Cascade Server
schema?</p>
</blockquote>
<p>I will certainly ask.</p></div>Charlie Holdertag:help-archives.hannonhill.com,2010-02-09:Comment/111062932012-03-15T15:55:54Z2012-03-15T15:55:54ZCascade Server Schema Diagram<div><p>Update:</p>
<p>We don't provide the schema or an explanation of it
publicly.</p>
<p>I would always encourage you to use the Web Services API to
programmatically access/manipulate data in Cascade. However, in
this case, if you let me know what information you're interested
in, it might be a few relatively simple SQL queries. It will
probably easier to assist with that if possible then spend time
spinning wheels.</p></div>Charlie Holdertag:help-archives.hannonhill.com,2010-02-09:Comment/111062932012-04-03T19:42:46Z2012-04-03T19:42:46ZCascade Server Schema Diagram<div><p>Hi rvaldez --</p>
<p>Just wanted to check-in to see if you found my comments
helpful.</p>
<p>Let me know!<br>
Thanks.</p></div>Charlie Holder