"Hours per day" value: can I find it in the Reporting database ?

[bartorrent]

Hello,

I'm quite unknown with the Reporting database and I seem not to be
able to find the value for the "Hours per day" setting. I would use
that to to some calculations e.g. remaining work in days instead of
hours, so if you think there's a better way, please tell me ;-)

Thank you !

 

[Rod Gill]

Hi,

Download the Project SDK from:
http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&displaylang=en

This has a full description of the Project schema for the reporting db. I
recommend using the Views, especially those ending with _Userview as they
have most data and all custom fields appended as well. I can't see the
hoursperday values which is a hole in functionality.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[MOPS]

Hi,

thanks for the quick reply. I am 'familiar' with the sdk
documentation, but I can't find directly any table/views that give
access to the "hours per day" field (unless the field named totally
different?). I presume this value is saved in the enterprise global,
so if there would be a table/view that gives access to the enterprise
global I should be able to find it there...
Maybe I should look in one of the other Project Server databases, but
I know that's kind of blasphemy ;-)

 

[Dale Howard [MVP]]

MOPS --

Allow me to jump into this thread, but you have made a totally incorrect
assumption about the Hours Per Day value. This value is NOT stored in the
Enterprise Global, and thus, CANNOT be specified for the enterprise by the
Project Server administrator. Instead, this value is stored in each
enterprise project. So, perhaps this information will help you to locate it
in the Reporting Database, if it is even stored in that database. My
suspicion is that you will find it in the Draft database instead. Hope this
helps.

 

[Gary L. Chefetz]

If memory serves me correctly, you need to use the PSI to get this value for
the server. You should redirect this discussion to the developer's group
where you'll get more traction on this type of question.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[MOPS]

Allow me to jump into this thread, but you have made a totally incorrect
assumption about the Hours Per Day value. This value is NOT stored in the
Enterprise Global, and thus, CANNOT be specified for the enterprise by the
Project Server administrator. Instead, this value is stored in each
enterprise project. So, perhaps this information will help you to locate it
in the Reporting Database, if it is even stored in that database. My
suspicion is that you will find it in the Draft database instead. Hope this
helps.

thx for pointing me to my mistake indeed. So far I found nothing in
the Reporting db indeed, only the following in the Draft db as you
said:
table / column name:
MSP_WEB_ADMIN WADMIN_MAX_HOUR_PER_DAY
MSP_WEB_ADMIN WADMIN_STAT_MAX_HR_PER_DAY
MSP_WEB_ADMIN WADMIN_TS_HOURS_PER_DAY
MSP_WEB_ADMIN WADMIN_TS_MAX_HR_PER_DAY


@Gary, so far I have never used PSI, but I'm eager to learn it (the
basics) and we just hired a developer who's experienced with PSI, so
I'm gonna ask him, and meanwhile take a look at the deverloper's
group, thx.

 

[MOPS]

Allow me to jump into this thread, but you have made a totally incorrect
assumption about the Hours Per Day value. This value is NOT stored in the
Enterprise Global, and thus, CANNOT be specified for the enterprise by the
Project Server administrator. Instead, this value is stored in each
enterprise project. So, perhaps this information will help you to locate it
in the Reporting Database, if it is even stored in that database. My
suspicion is that you will find it in the Draft database instead. Hope this
helps.

thx for pointing me to my mistake indeed. So far I found nothing in
the Reporting db indeed, only the following in the Draft db as you
said:
table / column name:
MSP_WEB_ADMIN WADMIN_MAX_HOUR_PER_DAY
MSP_WEB_ADMIN WADMIN_STAT_MAX_HR_PER_DAY
MSP_WEB_ADMIN WADMIN_TS_HOURS_PER_DAY
MSP_WEB_ADMIN WADMIN_TS_MAX_HR_PER_DAY


@Gary, so far I have never used PSI, but I'm eager to learn it (the
basics) and we just hired a developer who's experienced with PSI, so
I'm gonna ask him, and meanwhile take a look at the deverloper's
group, thx.

 

[Gary L. Chefetz]

I do believe that this is stored in the Published database, but the
preferred (and supported) method of access would be through the PSI

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com