Help writing a query to find a File in a location

[a4r0]

Hi,

 

Can someone please help me with a query to find a file in a particular location.

 

thank you

[Jorgen Nilsson]

Hi,

check out this post: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/9a1fb650-b6c3-4858-98d0-ec06ebd83b69/

regards,

Jörgen

[a4r0]

Thank you, but that doesnt seem to work,

 

ive created the following but im not getting any results....

 

 

select * from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "custom11.prf" and SMS_G_System_INSTALLED_SOFTWARE.InstalledLocation = "c:\\program files\\microsoft office\\"

 

why do you think this may be.

 

thank you for your response.