January 5, 2011

SQL query to get all workstations having .NET Framework version less than 2.0

Below is SCCM query to get all workstations having .NET Framework version less than 2.0-

select distinct (a.name0), a.user_name0, a.operating_system_name_and0, b.productname, b.productversion from v_R_System a, v_GS_SoftwareProduct b
where a.ResourceID = b.ResourceID
and a.Operating_System_Name_and0 like '%workstation%'

and b.ProductName like '%NET Framework%'
and b.ProductVersion< '2.0%'

Thanks!

0 comments:

Post a Comment