Report Assignment Transaction History Using PSI?

[Darrell]

All,

Can I use the PSI to access the assignment transaction tables in the
published database without impersonating each user or project manager? How do
I go about getting to this information so that I can report against it in
aggregate? I know I am not the only one wanting access to this information so
before I waste more time can anyone tell me if it is possible and provide
some basic direction for accomplishing the task?

Darrell

 

[Stephen Sanderlin]

Nope... you need to use impersonation to call ReadAssignmentHistory()
for anybody other than the currently logged-on resource.

To aggregate the data, you'd want to pull a list of resources and
iterate through them one by one, combining the results of their
ReadAssignmentHistory() calls into either a gigantic AssnHistoryDataSet
or a custom collection of some type (maybe use a dictionary keyed to the
resource name).

However, you should be aware that the data retrieved from
ReadAssignmentHistory() is of limited value if you want anything other
than dates and transaction types because the two CHANGE_DATA properties
are blob data which MS has provided no decoder for. You should also be
aware that even once you decode this data, it can take some work to
clean up and/or discard invalid data.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[Darrell]

Stephen,

Thx for the reply. I was being told that impersonation wouldn't work.

If I understand you correctly even once I get in I cannot read things like
the transaction history comments or other related fields? I could live with
just being able to report on who did not submit an update for an active task
if that is what I can get out. I currently use and Access database to show
where an update was not applied but it doesn't determine if the update was
not submitted or was not published. I could put this issue of who didn't do
their part to bed if I could just report on who did not submit an update.
Hate that MS took that ability out of the resource center....

Thx again,
Darrell

 

[Stephen Sanderlin]

Darrell,

You're welcome! I can't think of any reason that impersonation wouldn't
work, so long as it's done properly.

Check out
http://msdn.microsoft.com/en-us/library/websvcstatusing.assnhistorydataset.historyrow_members.aspx...
you will see that things such as comments, entry dates, and author are
readable but the timephased update data is not (it's encoded as a blob).

If all you want to do is report on people who have submitted task
updates, you may want to take a look at ReadStatusApprovalsSubmitted()
to see if that will work for you.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[Darrell]

Stephen,

Thx again for the input. I am actually interested in both so this is a good
start.

Darrell

 

[Stephen Sanderlin]

No problem -- glad to help!

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[MSPLearner]

I am not a developer, but can write SQL queries and understand DBs.

What info is contained in MSP_ASSIGNMENT_TRANSACTIONS and
MSP_ASSIGNMENT_SUBMITTED. I want to create an audit report to track (1) if a
resource has imported task updates (2) if PM has accepted (3) difference
between actuals hrs in plan and imported task update.

The reason for the report is that we now allow PMs to update actuals in the
plan directly and/or thru PWA Task Updates. Before it was restricted to
PWA/Timesheet/Task Updates only.

MSPLearner

 

[Stephen Sanderlin]

MSPLearner,

Take a look at
http://blogs.msdn.com/project_progr...using-transactions-partial-documentation.aspx
and
http://blogs.msdn.com/project_progr...tusing-transaction-partial-documentation.aspx.

HTH,
Steve

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com