1,126
edits
Difference between revisions of "Useful SQL Queries for Content Manager OnDemand"
Jump to navigation
Jump to search
Useful SQL Queries for Content Manager OnDemand (view source)
Revision as of 11:28, 13 February 2017
, 11:28, 13 February 2017→Which tables are available for us to query?
(Added section on exporting Content Manager OnDemand Application Group row counts to Comma Delimited Format.) |
|||
| Line 78: | Line 78: | ||
--snip-- | --snip-- | ||
The tables starting with ARS are internal configuration tables for CMOD. All of the data you see can be found in these tables. Although the contents of the tables are only briefly documented, there is plenty of interesting data to be found inside them to help you solve problems and troubleshoot Content Manager OnDemand. | The tables starting with ARS are internal configuration tables for CMOD. All of the data you see inside the IBM CMOD client can be found in these tables. Although the contents of the tables are only briefly documented in the IBM CMOD documentation, there is plenty of interesting data to be found inside them to help you solve problems and troubleshoot issues. Check out the [Content Manager OnDemand Database Tables] for more information about the tables, fields, and their contents. | ||
And what are those other table names? They contain the index data with the fields you define in Application Groups with the OnDemand Administrator Client. Keep reading! | And what are those other table names? They contain the index data with the fields you define in Application Groups with the OnDemand Administrator Client. Keep reading! | ||