Post Tagged with: “SQL”

Seaching Cognos 10 Content Store for an XML string

Seaching Cognos 10 Content Store for an XML string

We recently migrated our knowledgebase from Collab to sharepoint, which meant all reports that had links to collab needed to be identified and edited. This query proved helpful – it searches the content store for occurrences of the old string, ‘collaboration.au’, and displays the report name and location. The query does take a while to run though – almost 40 minutes against our beast-mode content store…

read more