WQL stuff to help make Query-Based SCCM collections or to guide you whilst developing Web Reports. You can substitute the appropriate version R numbering for other releases (e.g. R16.1 for AutoCAD 2005, and so on). Substitute the ProductName value with others to weed out Civil 3D, Map 3D, Mechanical, and so on, and so on, and so on, and … ok, I'll stop.
Select Distinct SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName,
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID
WHERE SP.ProductName = "AutoCAD" and
SP.ProductVersion like "R18.1.%"
Order by SYS.Netbios_Name0, SP.ProductName