SELECT Distinct CommonPublisher,Publisher
FROM v_LU_SoftwareList
INNER JOIN V_LU_Softwarehash ON V_LU_Softwarehash.SoftwareID = v_LU_SoftwareList.SoftwareID
ORDER BY CommonPublisher
6/27/2011
SCCM Asset Intelligence - List manufacturer friendly names
This Query will list all possible manufacturer listings of an application and the friendly names (grouped)
Subscribe to:
Posts (Atom)