--- title: Cognos Data Source Tables and Columns description: This query lists all the data sources and their tables and columns which are used in any published Framework Manager mode --- [![envisn](https://www.envisn.com/hs-fs/file-15282154-gif/images/logo.gif?width=120&name=logo.gif "envisn")](https://www.envisn.com) [![Request a Demo](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be) ![netvisn for cognos](https://www.envisn.com/hs-fs/hubfs/barfade.jpg?width=2150&name=barfade.jpg) # Cognos Data Source Tables and Columns This query lists all the data sources and their tables and columns which are used in any published Framework Manager model. This query may result in lengthy output on large content stores. ![Cognos Data Source Tables and Columns](https://www.envisn.com/Portals/70307/images/query-18.jpg) ******Use Case:*** ***See which database tables and columns are being used in Cognos. ***Setup:*** none ## *** [![download file](https://www.envisn.com/hs-fs/file-432592281-png/images/download-file.png)](http://cta-service-cms2.hubspot.com/cs/c/?&cta_guid=884ddfb8-627a-4a83-87cc-77bdb8234592&placement_guid=abe6a63a-3b0d-4a9e-b46d-d087b3185174&portal_id=70307&redirect_url=duifPvjeYwmAl%2BO82QVDL/QnYdI8MZnDjfCJcY%2BYl5G7vi/YJaq6WyDM9a/23SZ3CDLly73Vf7HtXzAY31QoLCiYClDhRknbFWcYuZLnxtF1QAHeLamJ9PMAJIlEjTaVXIIcZKG3ffw%3D&iv=G2vraJX%2Bp8Q%3D&hsutk=&canon=) ***   ***Category:*** Cognos Data Sources ### Browse Custom Queries by Category - [Cognos Model Dependency](https://www.envisn.com/custom-queries-cognos-model-dependency) - [Cognos Database Usage](https://www.envisn.com/custom-queries-cognos-database-usage) - [Cognos Report Info](https://www.envisn.com/custom-queries-cognos-report-info) - [Cognos License Compliance](https://www.envisn.com/custom-queries-cognos-license-compliance) - [Cognos Report Usage](https://www.envisn.com/custom-queries-cognos-report-usage) - [Cognos Data Sources](https://www.envisn.com/custom-queries-cognos-data-sources) - [Cognos Job Info](https://www.envisn.com/custom-queries-cognos-job-info) [![return to custom query library](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/5ad85082-a862-405e-ab6e-aff65b0b240d.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/5ad85082-a862-405e-ab6e-aff65b0b240d) *Share This:* [![Share on Facebook](https://static.hubspot.com/final/img/common/icons/social/facebook-24x24.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fwww.envisn.com%2Fcustom-queries%2Fcognos-data-source-tables-and-columns%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on LinkedIn](https://static.hubspot.com/final/img/common/icons/social/linkedin-24x24.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fwww.envisn.com%2Fcustom-queries%2Fcognos-data-source-tables-and-columns%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on Twitter](https://static.hubspot.com/final/img/common/icons/social/twitter-24x24.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fwww.envisn.com%2Fcustom-queries%2Fcognos-data-source-tables-and-columns%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fwww.envisn.com%2Fcustom-queries%2Fcognos-data-source-tables-and-columns%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Cognos%20Data%20Source%20Tables%20and%20Columns) [![Share on Email](https://static.hubspot.com/final/img/common/icons/social/email-24x24.png)](mailto:?subject=Check%20out%20https%3A%2F%2Fwww.envisn.com%2Fcustom-queries%2Fcognos-data-source-tables-and-columns%3Futm_medium%3Dsocial%26utm_source%3Demail%20&body=Check%20out%20https%3A%2F%2Fwww.envisn.com%2Fcustom-queries%2Fcognos-data-source-tables-and-columns%3Futm_medium%3Dsocial%26utm_source%3Demail) ### [Cognos Tools from Envisn](https://www.envisn.com/envisn-products) [NetVisn](https://www.envisn.com/netvisn) [AutoVisn](https://www.envisn.com/autovisn-cogos-scheduler) [UniVisn](https://www.envisn.com/univisn-cognos-performance-management) [DocuVisn](https://www.envisn.com/docuvisn-cognos-documentation) ### [Cognos Resources](https://www.envisn.com/resources) [Envisn’s IBM Cognos Blog](https://www.envisn.com/envisn-cognos-blog) [Custom Query Library](https://www.envisn.com/custom-query-library) [Tutorial Videos](https://www.envisn.com/cognos-demo-videos) [Mastering Cognos Security](https://www.envisn.com/mastering-ibm-cognos-security) [Content Store Survival Guide](https://www.envisn.com/content-store-survival-guide) [Expert Guide to Cognos Audit Data](https://www.envisn.com/cognos-audit-data-expert-guide) ### [Contact Envisn](https://www.envisn.com/contact) [Request a Demo](https://www.envisn.com/request-a-demo) [Support](https://www.envisn.com/support) 512-991-3999 [info@envisn.com](mailto:info@envisn.com) ### Latest Cognos Posts | [![youtube](https://www.envisn.com/hs-fs/hubfs/youtube.png?width=30&name=youtube.png)](https://www.youtube.com/user/envisn) | [![linkedin](https://www.envisn.com/hs-fs/hubfs/linkedin.png?width=30&name=linkedin.png)](https://www.linkedin.com/company/envisn-inc./) | [![twitter](https://www.envisn.com/hs-fs/hubfs/twitter.png?width=30&name=twitter.png)](https://twitter.com/Envisn) | [![facebook](https://www.envisn.com/hs-fs/hubfs/facebook.png?width=30&name=facebook.png)](https://www.facebook.com/envisn/) | | --- | --- | --- | --- | [![Real Time Analytics](https://static.getclicky.com/media/links/badge.gif)](http://clicky.com/101126274) ![Clicky](https://in.getclicky.com/101126274ns.gif) 3000 Polar Lane, Suite 901, Cedar Park, TX 78613 USA *Serving North America, Europe, and the UK with plans to expand to other areas in the near future. **[Privacy, Copyright & Liability](https://www.envisn.com/privacy-copyright-liability)*