N
Nigel
Hello,
I'm trying to find out whereabouts the non-working/non-
project time is stored within Server 2002 and am hoping
some kind soul would point me in the right direction.
I have created non-working/non-project categories. People
are able to report and record time against these
categories via their Server Tasks menu. When this time is
entered an 'Update' cannot be done, presumably because
there is no project to update back to, so a 'save' is done
instead. The save stores the non-working time so that it
can be viewed later by the user.
As an admin who wishes to collate/analyse these figures, I
can't find out where these time records are stored.
I can extract the categories of non-working time that I
have created from the database easily -> select * from
MSP_WEB_NONWORKING_CATEGORIES
However when I look at the stored non-working records
using -> select * from MSP_WEB_NONWORKING, I get nothing
returned, indicating that there isn't any data stored in
the DB.
Are the records stored in the DB but else where, or are
they stored somewhere else.
Thanks to anyone with useful advice.
Nigel
I'm trying to find out whereabouts the non-working/non-
project time is stored within Server 2002 and am hoping
some kind soul would point me in the right direction.
I have created non-working/non-project categories. People
are able to report and record time against these
categories via their Server Tasks menu. When this time is
entered an 'Update' cannot be done, presumably because
there is no project to update back to, so a 'save' is done
instead. The save stores the non-working time so that it
can be viewed later by the user.
As an admin who wishes to collate/analyse these figures, I
can't find out where these time records are stored.
I can extract the categories of non-working time that I
have created from the database easily -> select * from
MSP_WEB_NONWORKING_CATEGORIES
However when I look at the stored non-working records
using -> select * from MSP_WEB_NONWORKING, I get nothing
returned, indicating that there isn't any data stored in
the DB.
Are the records stored in the DB but else where, or are
they stored somewhere else.
Thanks to anyone with useful advice.
Nigel