SCCM Asset Intelligence - List manufacturer friendly names
This Query will list all possible manufacturer listings of an application and the friendly names (grouped)
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
No comments:
Post a Comment