List all projects that belong to specific category?

[Vaso Vukovic]

How do you list all projects that belong to specific category?? (excluding
edit cagegory view).. Ideally in a spreadsheet, PWA view or SSRS report
format (SQL query would do)... I've got category that has over three hundred
projects but every now and then I want to check that all projects that are in
it should be in it and that there are no missing ones..

 

[Barbara - Austria]

Hi Vaso,

if a SQL query would do (Published DB):

SELECT dbo.MSP_WEB_SECURITY_CATEGORIES.WSEC_CAT_NAME,
dbo.MSP_PROJECTS.PROJ_NAME
FROM dbo.MSP_WEB_SECURITY_CATEGORIES INNER JOIN
dbo.MSP_WEB_SECURITY_CATEGORY_OBJECTS ON
dbo.MSP_WEB_SECURITY_CATEGORIES.WSEC_CAT_UID =
dbo.MSP_WEB_SECURITY_CATEGORY_OBJECTS.WSEC_CAT_UID INNER JOIN
dbo.MSP_PROJECTS ON
dbo.MSP_WEB_SECURITY_CATEGORY_OBJECTS.WSEC_OBJ_UID =
dbo.MSP_PROJECTS.PROJ_UID

Hopefully this can give you an idea how to move on?
Note: Microsoft does not support any queries on other DBs than Reporting!

Regards
Barbara


Am 07.04.2010 08:01, schrieb Vaso Vukovic:

 

[Vaso Vukovic]

Hi Barbara,

Sorry my reply will have to be limited to "Thank You Thank You Thank You
SOOOO MUCH!" , it won't do it justice..

this is ridiculously usefull to me.. )

P.S. Maaaybe.. one day.. in Project Server 2030 or thereabout, we will have
comprehensive reporting on Security items in MS EPM tools... . I'm still
hoping.

 

[Barbara - Austria]

You are welcome!

Regards
Barbara

Hi Barbara,

Sorry my reply will have to be limited to "Thank You Thank You Thank You
SOOOO MUCH!" , it won't do it justice..

this is ridiculously usefull to me.. )

P.S. Maaaybe.. one day.. in Project Server 2030 or thereabout, we will
have
comprehensive reporting on Security items in MS EPM tools... . I'm still
hoping.