Project Server 2013

Query Task Hierarchy of a subtask using SQL In Project Server

In the previous article, I discussed How to display the Task Hierarchy within My Assignment view inside Tasks section in Project Server 2013, In this article, I will elaborate How to query this field from ProjectWebApp Database in Project Server 2013? My scenario I have a project schedule as shown below: I need to query …

Query Task Hierarchy of a subtask using SQL In Project Server Read More »

PWA Content Database Best Practices

PWA Content Database Consideration In Project Server

In this article, we will explain some recommendations and considerations for PWA Content Database that we are performing when provisioning a new PWA instance in Project Server 2019,2016, and 2013. PWA Instance Structure in Project Server First, you should be aware of the web application in SharePoint can hold multiple content databases and each content …

PWA Content Database Consideration In Project Server Read More »

% Complete and % Work Complete In Microsoft Project

In this post, we will show what’s the difference between % Complete and % Work Complete In Microsoft Project. You might also like to read You can’t inactivate a task that’s in progress in Microsoft Project What’s the difference between % Complete and % Work Complete? Briefly, Both fields refer to the percent of achievements. but …

% Complete and % Work Complete In Microsoft Project Read More »