View all upcoming tasks for all projects in Project Server

How do you create a view in Project Server that shows all upcoming tasks (for example, from today to the end of next month) and their start/finish dates for all projects that are in Project Server? This way a Server user can see all upcoming tasks for the Enterprise, without having to go into each individual schedule? If it's not possible to create such a view, what are best practices for extracting this data into an excel Pivot Table?