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