View all Risk or all Issues associated with different-different pr

[Nitesh]

Hi I'm using Project Web Access 2003 and I want to view all Risk or all
Issues associated with different-different project plans, at a single place
in PWA and export them also in a single excel work sheet.
Is it possible? If yes then what is the method to do so.

Any possibilities.

Thanks in advance

 

[Chak]

Hi Nitesh,

It's not possible from PWA. You have to write SQL query to list all
the issues from all sites in your Project Server environment. You can
use MS Excel or SQL Reporting Services or similar tool to display the
query result.

You can use the query published on my website.

http://www.epmcentral.com/pjadmin/dbproj3-issuelist.php


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com

 

[Nitesh]

HI Chak

Thanks for your reply but when I run the query in SQL query Analysier its
shows following error message:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Lists'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserData'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Sites'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Webs'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserInfo'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserInfo'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserInfo'.

I did something wrong, I think so. Please tell me how do I identify my
Sharepoint database. My database file name is ProjectServer_8883_data.mdf.





--
------------------------------
Thanks
Nitesh
------------------------------

Hi Nitesh,

It's not possible from PWA. You have to write SQL query to list all
the issues from all sites in your Project Server environment. You can
use MS Excel or SQL Reporting Services or similar tool to display the
query result.

You can use the query published on my website.

http://www.epmcentral.com/pjadmin/dbproj3-issuelist.php


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com

 

[Nitesh]

Dear Chak

Please suggest any solution.
--
------------------------------
Thanks
Nitesh
------------------------------

Hi Nitesh,

It's not possible from PWA. You have to write SQL query to list all
the issues from all sites in your Project Server environment. You can
use MS Excel or SQL Reporting Services or similar tool to display the
query result.

You can use the query published on my website.

http://www.epmcentral.com/pjadmin/dbproj3-issuelist.php


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com

 

[Nitesh]

Any Body suggest what to do???
--
------------------------------
Thanks
Nitesh
------------------------------

HI Chak

Thanks for your reply but when I run the query in SQL query Analysier its
shows following error message:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Lists'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserData'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Sites'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Webs'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserInfo'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserInfo'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserInfo'.

I did something wrong, I think so. Please tell me how do I identify my
Sharepoint database. My database file name is ProjectServer_8883_data.mdf.

 

[Chak]

Hi Nitesh,

Which SQL Server version you have?

If you have SQL Server 2000, please use SQL Enterprise Manager/SQL
Query Analyzer to run the query

If you have SQL Server 2005, please use SQL Management Studio to run
the query.

Look for databases. Windows SharePoint database is generally named
something like Content DB. You have to run the query against Content
DB.

If you do not have access to all the databases, please contact your
DBA.

Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com
http://jobs.epmcentral.com