| || |
License Type Query
I've had a look around the forum and can't seem to find a thread on this. I need to query the QC site admin db to get the current list of projects that have a license type of 13 (Business Components).
I've wrote one query but my joins are on session id, thus meaning that its a historical view of the data. It returns information or any project that had a license 13 used on it. I need to get the current view.
Can anybody help me with this?
See the query below..
(D.PROJECT_NAME(+) = C.PS_PROJECT_NAME) AND
(C.PS_ID(+) = B.SLH_SESSION_ID) AND
(B.SLH_SESSION_ID(+) = F.SESSION_ID) AND
(B.SLH_LICENSE_TYPE LIKE '13')
Any help would be greatly appreciated,