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.
-- MSPS 2013 SQL Query to Find Active Resources for PWA Licensing --by: Faisal Masood (www.softvative.com) PMP, CCNA, ITIL, MCSE, MCITP, MCTS, MCSA, MOS, MS select Res_name, WRES_NT_ACCOUNT, WRES_ACCOUNT, WRES_EMAIL, WRES_LAST_CONNECT, WRES_IS_ENABLED, WRES_CAN_LOGIN, WRES_COUNT_LICENSE from pub.MSP_WEB_RESOURCES where WRES_IS_ENABLED =1 AND Wres_Last_Connect NOT like 'null' AND Wres_Last_Connect > '2016-11-01 00:00:01.000' AND WRES_COUNT_LICENSE =1
Click here to download the SQL query file.
Replace the syntax with your Project Server database name.