Export Microsoft CRM 2011 Cases

Posted on 2011-10-10
Last Modified: 2012-06-27
Hi ,

I'm needing to Export all service cases in CRM out to a file or another database. I've looked around in the SQL tables and can't find one relating to cases. What is the best way to export this data?

Ultimately I'd like to have the case data exported to a separate table in another database.

Question by:AlwaysAStudent
    LVL 29

    Accepted Solution

    cases are referred to as incidents in the database. try the view filteredincidents.
    LVL 1

    Author Closing Comment

    This is fantastic, thank you.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now