AI OnAI Off
Useful SQL Queries
It's much faster, safer and simpler to perform such actions using the API:s, typically I use a console to get reports like the ones you suggest.
Here's a starter project I made a while ago https://www.herlitz.io/2024/02/22/optimizely-cms-in-a-terminal-console-app/
Dec 09, 2024 9:34
I'm trying to do a content audit on a CMS12 instance. I want a report of all pages with the name, url, created date, modified/changed date, contentTypeName, and which site it belongs to. If anyone has any useful resources they can share or if you've done this directly on the DB in the past, can you share? If you have any other queries that you've found useful, I'd love to see those as well.