Unique ID - in master project for sub projects` tasks - & - Task Summary Name in SQL Database table RRS feed

  • Question

  • Hello Masters and All,

    I am looking SQL data tables that stores "Task Summary Name"  and master projects "Unique ID" for sub projects line items.

    Please help

    how can I get these to fields in SQL. I probably just need SQL table names or if anyone can provide me SQL query to get this data from SQL database of the MS Project Wep App.



    Thursday, January 23, 2020 7:04 AM

All replies

  • Hi All,

    I found the "Task Summary Name" but not yet lucky for "Unique ID" -  in master project

    Answer (for first in above)

    I used the "TaskParentUID" . I merged two task tables and "TaskParentUID" = "TaskUID" and took the "TaskName"

    For "Unique ID" in master project  -  anyone has ideas please let me know



    Thursday, January 23, 2020 7:48 AM