Alterian CMC SQL Toolkit
Tags: Alterian, Web Content Management
Posted by: Adam Jenkin
Over the many years Auros has worked with Alterian CMC, we have gathered together a number of useful SQL files we use for querying, re-setting, and reporting against the Alterian CMC databases. Time and time again developers, installers and the support team at Auros find a use for some of these scripts so It would seem silly not to share these with the wider Alterian community!
Download Alterian CMC SQL Toolkit
The file names of the scripts within give a good overview of what's contained:
- LogoffAdmin.sql
- ShowAuthenticatedPages.sql
- ShowDeletedPages.sql
- ShowNewAndUpdatedPagesByYearMonth.sql
- ShowPageEdits.sql
- ShowPagesByTemplate.sql
- ShowPagesSubmittedForApproval.sql
- TruncateAuditTrail.sql
Please let us know if you find this useful, and whether you have any others you think would be worth adding.
Please note - absolutely no warranties are provided with these scripts and you use them completely at your own risk.