Share via

Where is this value is stored in the database

Bonus12 1,116 Reputation points
2020-11-04T00:25:15.75+00:00

Hi ,

Where I can find MECM full version in the sql database , not just 2002 or 2006 but I'm looking for the full one ex. 5.00.8968.1042

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,912 questions
Microsoft Configuration Manager
0 comments
Accepted answer
  1. Eswar Koneti 2,201 Reputation points
    2020-11-04T01:20:57.487+00:00

    The site information along with the build version is stored in v_Site
    You can query using select * from v_Site

    Regards,
    Eswar
    www.eskonr.com
    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenLiu-MSFT 44,101 Reputation points Microsoft Vendor
    2020-11-04T01:50:00.047+00:00

    @Immer
    Thank you for posting in Microsoft Q&A forum.

    Apart from v_Site, the view v_SiteDetailSummarizer also contains the version of site server.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Bonus12 1,116 Reputation points
    2020-11-04T04:34:10.583+00:00

    Thanks but no , both views are not showing the full version as I see it in the "Updates and servicing " page

    ex. I'm running 2002 CB and hotfix are installed so full version is showing 5.00.8968.1042 in "updates and servicing " page

    In both of the views you recommended the version returned is 5.00.8968.1000 which is the one before installing hotfix

  3. Garth Jones 2,076 Reputation points
    2020-11-04T12:00:07.717+00:00
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.