need help to make query

[epmpglck]

I am running SMS 2.0, i need to find the file path and filename of %.mpg%, can any suggest a string to use to include both the file name and filepath of this.
Thank you.

 

[00905364388461]

slm

 

[tbrennans]

http://www.smsexpert.com/smsexpert/Products/ESI.asp

will do this $99

 

[epmpglck]

Thank you that is very helpful, but is there a way to find the filepath without using the Plug-In.

The current string that i use to locate the files is
select mp3.FileName, SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SoftwareFile as mp3 on mp3.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where mp3.FileName like "%mpg%" order by mp3.FileName DESC

however this string only finds the mp3 or mpg files it does not report the filepath.

Thank you

 

[tbrennans]

No file paths that I've ever heard of with 2.0 unforunately....unless if you can figure out how sms expert does it ;-)