Where is this value is stored in the database

Question

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

Answer 1

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.

Answer 2

@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.

Answer 3

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

Answer 4

The list of supported Sql views can be found here. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/create-custom-reports-using-sql-server-views