Forum Discussion
Report upon N° of logins by users + N° of edits by users of MS Projects over a custom timepriod?
Hello, I am wondering if I can track how frequent users login to/use MS Projects & how many times they have edited/published a Project over a custom timeperiod (e.g. 1 year)? I understood that yo...
For Project Server 2019 Subscriber Edition this can help with a participation audit
CREATE VIEW [dbo].[pwa_last_login]
AS
SELECT
REPLACE(REPLACE(A.tp_Login,'Formsbasedmembershipprovider','') , 'domainmembersipprovider', '') as nname
-- above to clean up username
,DATEADD(hh,-5,A.[tp_ExternalTokenLastUpdated]) as lastl
,datediff(dd,DATEADD(hh,-5,A.[tp_ExternalTokenLastUpdated]),GETDATE()) as daysago
,B.[Resource Departments]
FROM [WSS_Content_PWA].[dbo].[UserInfo] A
left join
[WSS_Content_PWA].[pjrep].[MSP_EpmResource_UserView] B
ON
A.tp_Login = B.ResourceNTAccount
where A.tp_Login NOt IN ('sharepointaccount', 'other acount to filter out')
-- above to exclude service accounts