Issues & Risks Database

[Turki Ben Sumih]

Dear Friends,
we are trying to develop an application that presents issues & risks in our
project server 2003 . what i have been trying is how can i find the tables
that contain issues & risks in SQL database ?
and is there way OR methed to query the databse of issues and risks ?
Thanks in Advance !

 

[Ed Morrison]

Issues, risks, and documents are stored in the SharePoint database. The
database name typically starts with STS_ then the name of the SharePoint
server then a 10 digit number.

Issues and risk data is in the UserData table. The name of the list is
found in the Lists table.

 

[akarim]

Hello Mr. Ed Morrison,

Thanks alot. your information was very usefull.

1-would explain to me how issues are stored in this table (nvarchar1,
nvarchar2,....),(ntext1,ntext2,...), .......etc.

2- and how can i link them to their projects? "i.e. issue X for which
project?"

Regards,
A.Karim

 

[Ed Morrison]

A. Karim,
1. I do not have the field mappings as these change when you customize a
site. I usually create a test issue and see how it maps.
2. In your project server database run the following query:
Select p.proj_name, 'http:\\' + s.wsts_server_name +'\'+ s.wsts_managed_path
+'\' + p.WPROJ_STS_SUBWEB_NAME
from msp_web_Projects p
inner join MSP_WEB_STS_SERVERS s on p.wsts_server_id=s.wsts_server_id

This returns a value equal to the full_url field in the WSS Sites table.
The sites.id field can be used to find the appropriate lists, documents,
etc.


--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com