AI and Project

Select
    GIS.ARPDisplayName0,
    GIS.ProductName0,
    GIS.ProductVersion0,
    SL.CommonName,
    SL.CommonVersion
from
    v_GS_INSTALLED_SOFTWARE GIS
    join LU_SoftwareCode SC on GIS.SoftwareCode0 = SC.SoftwareCode
    join LU_SoftwareList SL on SC.SoftwareID = SL.SoftwareID
Where
—    GIS.SoftwareCode0 = ‘{90120000-0014-0000-0000-0000000ff1ce}’
    SL.CommonName = ‘Microsoft Office Project 2007 Professional Edition’