SQL Query to Find Active Resources for Licensing

Share on facebook
Share on twitter
Share on linkedin

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.

 

 

Leave a Reply

Sign up for Softvative Newsletter

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter

Get notified about new articles

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest