Milestone list

[Silvia Garcia]

I would like to make a list of milestones for all my projects from the
Microsoft Project Server.
Is it possible to do so?
Thank you

 

[Rod Gill]

Hi,

Simplest way is to read all tasks the MSP_VIEW_tasks table and filter for
Summary=1. I read this data directly into Excel where you can further format
the data.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz

 

[Silvia Garcia]

Hi,
Thank you for the tip, but I can see I need to be more specific.

I want to do a milestone list for ALL projects in the server. As project
manager, I want an overview of milestones in the different projects.

I have tried the Assignment Views, but I cannot manage to make the
milestones come up because they are not assigned to any ressource.

 

[Brian Stebbins]

Silvia,
I had to do this same thing for my boss. What I did was inserted all
projects in to a Master Project file so I had all projects and all tasks in
one place. Then I expanded all outline levels so I had all tasks for all
projects visible (by the way this is all in normal gantt chart view). Then
I auto filtered "Scheduled Work" for equals 0 hrs, and that gave me every
milestone in my projects. I then filtered out all other (non-milestone)
tasks using autofilters. At this point you can sort by anything you want...
I sorted by finish date so I had a nice paredoed out view of all milestones
in order. Hope this helps you, if not... sorry for taking up your time to
no avail.

-Brian Stebbins