Wednesday, December 15, 2010

AutoCAD WQL Time

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.

AutoCAD 2011

Select Distinct SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName,
SP.ProductVersion
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

Post a Comment