Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Exclude Path in Query
7 views
Skip to first unread message
tkutil
Mar 31, 2010, 3:13:01 PM3/31/10
to
My queries keep picking up patches as well as the actual program. How do I
exclude the path for the patches.
exclude the path for the patches.
This is the path I'm trying to exclude
C:\WINDOWS\Installer\$PatchCache$\Managed\00002109A30000000000000000F01FEC\12.0.4518\
This is my query statement
select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName,
SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion,
SMS_G_System_SoftwareFile.FilePath 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.FileName =
"winproj.exe" and SMS_G_System_SoftwareFile.FilePath not like
"C:\\WINDOWS\\Installer\\$PatchCache$\\Managed\\00002109A30000000000000000F01FEC\\12.0.4518\\" order by SMS_G_System_SoftwareFile.FilePath
0 new messages