A quick and simple way to extract all of your Cobra Milestones for a Project using the SQL Command Utility.

On a recent project, we had to craft a way of rapidly extracting the key weighted milestones used in a Cobra project, to then validate that the data aligned to the schedule data integrated with the software.

Enter the SQL Command Utility!

For some users this feature may not be enabled because lets face it, we are dealing with direct access to the back-end database. But for those who have the ability and prior SQL language experience, data extraction can be a breeze.

Using the default sample data provided with Cobra, we can see a Work Package that uses Milestones as its method of measuring performance:

CobraMilestones

In a larger implementation, there may be numerous work packages and even more milestones that require integration.

We Constructed a simple SQL query that merges both the MILESTN and CAWP tables to create a data set with which we could then pivot on and review:

SQLQuery

By right clicking the Results pane, we are able to save this data to an Excel format.

Other recent articles

Full blog index
March 07, 2022

Find out how GBA Projects can help your project perform.

Contact us.

Clients

  • 01-santos-logo.jpg
  • 02-bhp-logo-new.jpg
  • 03-hansen-logo.jpg
  • 04-sydney-water.jpg
  • 05-beach-energy.jpg
  • 05-kbr-logo.jpg
  • 06-aurecon-logo.jpg
  • 08-riot-tinto-logo.jpg
  • 09-sa-govt-logo.jpg
  • 10-spotless-logo.jpg
  • 11-built-environs-logo.jpg
  • 12-dyno-logo.jpg
  • 13-sa-power-logo.jpg
  • 14-incitec-logo.jpg
  • 15-electranet-logo.jpg