SQL Query to Find Active Resources for Licensing

SQL Query to Find Active Resources for Licensing

V: 1.2, MD: 01/24/2017

Following SQL query will show the list of users that are active, that connected to Project Web App (PWA) since specified date (Oct 1st, 2015 or the date you specify) and should be counted towards the licensing.

* Contact Softvative for accurate licensing assessment of your SharePoint or Project Server PPM farms. We have done Software Asset Management (SAM) projects for customers where we worked with the software vendors to save the licensing costs. We have skills in Microsoft MAP, System Center and other custom tools for the SAM.

Click here to download the SQL query file.

Replace the syntax with your Project Server database name.



Leave a Reply

Enter the CAPTCHA * Time limit is exhausted. Please reload CAPTCHA.