Dohmosh Tech

In a previous blog post we have discussed how to retrieve Risks and Issues custom columns information (built in project properties) from Sharepoint through SQL query. But ... what If I have another custom list that is not a project property by default, lets say "Project Monthly Review" that contains these columns "Month" as text, "Year" as text, and "Review" as multiline text. for retrieving this information in Sharepoint 2010 through SQL below is the query that will just do the work: SELECT  P.ProjectUID, A.tp_ListId, A.tp_IsCurrent, A.nvarcahr3  as  [ Year ], A.nvarchar4  as  [ Month ], A.nText2  as  [Review] FROM  PWA_ContentDB.dbo.AllLists  as  L   INNER   JOIN  PWA_ContentDB.dbo.AllUserData  AS  A  ON  L.tp_ID = A.tp_ListId There the trick ... again ... the new custom Sharepoint list added to this certain site template (or project site) is not connec...

Working with Project Server 2010 Reporting database makes me realize how it can be painful to get information and properties that was customized on Risks or Issues sharepoint lists (or any sharepoint list). Risks, Issues, and Deliverables are lists in the project site, yet they are project's properties. those properties have their own Tables in the project server 2010 reporting database as: Risks : MSP_WssRisk Issues : MSP_WssIssue Deliverables: MSP_WssDeliverable And since they are sharepoint lists then they can be customized to add columns or update column's values. and there the trick is ... the new custom columns are added to the sharepoint content database as database columns that will be named by the data type of the property and a postfix number, in the [AllUserData] table like: datetime2, sql_variant1, nvarchar9 ...etc. After lots of googling the way to do it I have found a blog (unfortunately I can't find it again) that suggeste...