Create Collection - Computers without .Net 3.5

[kaiserclaw]

Hello,

I tried to make a collection with computers that has .Net 3.5 enabled and then make a collection checking witch one is missing.

I can't use check add remove programs due its not listed (.net 4.5 is listed).
Tried to check if C:\Windows\Microsoft.NET\Framework\v3.5 -folder is present but it seems like its partily function:

This is the query:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath like "C:\\Windows\\Microsoft.NET\\Framework\\v3.5\\%" and SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 10.0"

I also tried without % in the end. 

Some machines is correct but some does not have the folder but shows up in the collection.

 

Thank you.

[GarthMJ]

Use this method to inventory .Net then you can create collections based on the results.