Searching for versions across multiple projects

Products

• CA Harvest Software Change Manager

Issue/Introduction

Any way to search for all versions of an item across multiple projects?

Or do you have to search project by project.

Environment

Release : 14.0

Component : CA HARVEST SCM GUI/Harweb

Resolution

Attached to this article is a SQL query that should accomplish the requested task.  I set it up to be flexible about the search criteria, so read the instructions in order to customize the query to your needs.