Recently one of my client encountered some errors with his Project Server 2010 farm (EPM). First question from EPM’s experts, could you check if updates between SharePoint 2010 and Project Server 2010 are at same levels?
According to the following Technet article, running queries against SharePoint config DB and EPM DB is not a valid method to check if products are at same levels.
The right path to get this kind of information can be found directly from: central admin → « Upgrade and Migration » → « Check product and patch installation status »
Unfortunately, like many consultant, I don’t have direct access to central admin to get this information. I need to deal with SharePoint farm admins guys. After few discussions, I received the following information (see print screen below).
Pretty hard for me to work with this kind of information in my Excel:
- All data are located in the same cell.
- Random carriage return.
Probably the guy select information from central admin and pasted directly in Excel.
After some research, I found a better way to format them.
If you would like to use the following procedure, your PC where Excel is installed (tested with Excel 2010), must able to connect to central admin.
- Open Excel
- Go to « Data » tab
- Click on « From Web »
- In « New Web Query » window enter the following address: http://YourServerName:YourTCPPort/_admin/PatchStatus.aspx and enter farm admin credentials.
-
Central admin display now on your screen. Click on yellow box like mentioned in next print screen, and click on « Import » button.
-
Data are now arranged in more convenient way (see print screen), for working with excel (filters).
This kind of technique can be very useful if you have a multiple servers and or SharePoint product installed in your farm.
I hope this post will help someone.
DG Concepts 