Extracting Milestone data from Project 2003 Server

[Nock]

I need to extract a list of all milestone entries for each project published
on our project 2003 server. These then need to be dumped into a weekly
report (excel format) with the highest level of automation possible.

1. How can I extract just the milestone tasks from each project?

2. What is the best way of going about this?

I'm open to any suggestions as I'm a newb when it comes to SQL analysis, SQL
queries, SQL view creation, Cube creation etc and have attempted each with
little success.

Many, many thanks.

Nock (Australia)

 

[Rod Gill]

Firstly you need to have rights to see the MSP_View tables. Then create a
view to look at all Projects linked to all Tasks with Milestone flag = 1.

The tables and fields are all in pjsvrdb.htm

For help in creating views, ask your database administrator.

 

[Nock]

Thanks Rod, I've done just that. ie. Downloaded the database schema and
printed it out on an A3 page. Looks rather like a suburb schematic to a newb
like myself.

I have created a couple of rather useless views in SQL but I'm getting there
- I think and I'll attempt to create a view with 'all Projects linked to all
Tasks with Milestone flag = 1' as you suggest.

Thanks again for your help, I think for most (in here) it's not necessarily
the explicit instruction that's really required, moreso someone with
experience pointing out where to look or begin.

Cheers,

Nock