Secret Timesheet URL Viewer

This one is short and sweet.

I noticed that when I view my timesheet in Project, it has an associated Unique ID. This made me wonder if an admin could view any timesheet for any user, as long as they had the UID number. The short answer is YES!

The second question was, is it possible to get this information from the database? The short answer is YES!

The third question was, could I use a report to mash the URL & UID together and generate a page that gives me the URLs for all the users timesheets so they were easily accessible? Would I be writing this post if the answer wasn’t YES!?

Keep in mind that unless you’re the timesheet manager, you can’t actually DO anything to the timesheet, but it’s very useful to be able to view them.

It’s as easy as:

SELECT DISTINCT
'https://YOURPROJECTSERVERURL/PWA/ReviewTSDetail.aspx?TSUID='+CONVERT(nvarchar(50), MSP_TimesheetLine_UserView.TimesheetUID) as TSLink,
MSP_TimesheetPeriod.StartDate,
MSP_EpmResource_UserView.ResourceName

FROM
MSP_TimesheetLine_UserView

LEFT OUTER JOIN
MSP_TimesheetPeriod ON
MSP_TimesheetPeriod.PeriodUID = MSP_TimesheetLine_UserView.PeriodUID

LEFT OUTER JOIN
MSP_EpmResource_UserView ON
MSP_EpmResource_UserView.ResourceUID = MSP_TimesheetLine_UserView.ResourceUID

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s