Controll Cals

All replies

• 

  

  0

  Sign in to vote

  yes theres is - go to PWA>server Settings>"About Project Server"

  hope that is what you are looking for :)

  Nikki

  Tuesday, January 24, 2012 8:38 PM
• 

  

  0

  Sign in to vote

  Is this possible export this? get this info from a powershell or registry?

  Tuesday, January 24, 2012 9:38 PM
• 

  

  0

  Sign in to vote

  Kindly refer this blog

  http://blogs.msdn.com/b/wwepmcoe/archive/2010/01/19/how-to-determine-resource-licensing.aspx

   

  ---

  Hrushikesh Deshpande,Senior EPM Infrastructure Consultant @ DeltaBahn LLC

  • Proposed as answer by Alexander.Burton Thursday, January 26, 2012 12:17 PM
  • Marked as answer by Christophe FiessingerMicrosoft employee Saturday, January 28, 2012 5:15 PM

  Thursday, January 26, 2012 1:01 AM
• 

  

  0

  Sign in to vote

  I use the below query to find the resource data which is consuming the license:
  

  SELECT  [RES_NAME]
  ,[WRES_LAST_CONNECT_DATE]
        ,[WRES_ACCOUNT]
        ,[RES_IS_WINDOWS_USER]
        ,[WRES_EMAIL]
        ,[RES_AVAIL_FROM]
        ,[RES_AVAIL_TO]
        ,[RES_STD_RATE]
        ,[RES_OVT_RATE]
        ,[RES_MATERIAL_LABEL]      
        ,[RES_TYPE]
        ,[RES_BOOKING_TYPE]
        ,[RES_AVAILABILITY]
        ,[RES_IS_NULL]
        ,[RES_ASSN_START]
        ,[RES_ASSN_FINISH]
        ,[RES_HIRE_DATE]
        ,[RES_IS_TEAM]
        ,[RES_LAST_ACTIVITY]
        ,[CREATED_DATE]     
    FROM [ProjectServer_Published].[dbo].[MSP_RESOURCES]
    WHERE RES_IS_TEAM =0
    AND WRES_ACCOUNT IS NOT NULL

  Hope that helps.
  

  ---

  Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

  Thursday, January 26, 2012 7:34 AM