Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
Could share the sql query to get list of project name and numbers.
You can import this query builder report https://www.ptc.com/it/support/article/CS31882 in Windchill, modify it as you would and then get your SQL query following this article https://www.ptc.com/it/support/article/CS135285
