web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Sql query to find late...
Microsoft Dynamics CRM (Archived)

Sql query to find latest rollup applied to dynamics crm 2011.

(0) ShareShare
ReportReport
Posted on by Ridwan 3,065

Hello forum,

I had a crash server issue and i have the latest backup of dynamics crm 2011 data and log file.

I need help on sql query to find latest rollup applied on the system.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Royal King Profile Picture
    Royal King 27,686 on at

    Use below query to find the latest build version from the db (MSCRM_CONFIG) , once you have build number you can find which rollup it belongs to.

    SELECT [Id]
    ,[ConfigurationMetadataXml]
    ,[BuildVersion]
    ,[InstalledOn]
    ,[MaxReplBlobLengthBytes]
    FROM [MSCRM_CONFIG].[dbo].[ConfigurationMetadata] order by installedon desc

  • Community Member Profile Picture
    Community Member on at

    select your CRM db, then use the following query

    select revision, majorversion, minorversion from buildversion

  • Ridwan Profile Picture
    Ridwan 3,065 on at

    Thanks Chitrarasan, will get back to you.

  • Ridwan Profile Picture
    Ridwan 3,065 on at

    Thanks for you response jaimie.

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Hi Ridwan,

    Or you can use this query using your CRM Database

    SELECT UpgradeToVersionNumber

    FROM [Yourdatabase_MSCRM].[dbo].[UpgradeActionTracker] --change to your database name

    order by UpgradeToVersionNumber desc

    buildversionrollup.png

    Search in the Google '6.0.2.51'

    is

    Thank you.

     

     

  • Suggested answer
    Andi G Profile Picture
    Andi G 25 on at

    You can get this from the following SQL Query:

    SELECT TOP 1 [UpgradeToVersionNumber]

    FROM [MSCRM_CONFIG].[dbo].[UpgradeActionTracker] ORDER BY [UpgradeToVersionNumber] DESC

  • Ridwan Profile Picture
    Ridwan 3,065 on at

    Thanks chitra, i was able to get the version.

    Am very greatful.

  • Ridwan Profile Picture
    Ridwan 3,065 on at

    Thanks am very greatful for your response.

  • Ridwan Profile Picture
    Ridwan 3,065 on at

    Thanks for your response

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans