2007 query for time entered but not yet submitted

[Robert Dibble]

In 2007, in the database, I can find:
1. Daily time entered on timesheets
2. Daily time entered via the My Tasks webpart as long as it has been
submitted and accepted into the project(s)

What I really need to find and report on is:
1. Time entered or imported into the My Task webpart, but that has not yet
been submitted for acceptance into projects

Do you know where this data is stored?

 

[James Fraser]

On Dec 7, 9:36 am, Robert Dibble

What I really need to find and report on is:
1. Time entered or imported into the My Task webpart, but that has not yet
been submitted for acceptance into projects

Do you know where this data is stored?

This data is stored in binary in the tables. If I recall correctly the
table is the MSP_ASSIGNMENT_TRANSACTIONS table, and the
ASSN_CHANGE_DATA holds the binary with the data you're looking for.

Yeah, I wasn't too happy about this either...


James Fraser

 

[Nelson Melo]

Hi James:

Any ideas on how to deserialize the data?
I tried a SQL convert and it said that it was an image?

Thanks a lot!

Nelson Melo

 

[Mike Mahoney]

Hi James:

Any ideas on how to deserialize the data?
I tried a SQL convert and it said that it was an image?

Thanks a lot!

Nelson Melo








- Show quoted text -

Nelson

An alternative approach is to compare msp actuals v timesheet actuals
within a cube and show a variance

regards

Mike

 

[James Fraser]

Hi James:

Any ideas on how to deserialize the data?
I tried a SQL convert and it said that it was an image?

My company has done some work on reverse engineering this, and we've
isolated the hour updates. This will be probably be incorporated in to
a commercial report. Contact me at (e-mail address removed) if you
are interested in purchasing some of this code or a report based on
it.


Sorry, not free like beer or speech...
James Fraser