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
WRES_IS_ENABLED =1 AND
Wres_Last_Connect NOT like 'null' AND
Wres_Last_Connect > '2016-11-01 00:00:01.000' AND
Replace the syntax with your Project Server database name.