Everything works fine when i want to query a %.mpg% file, I can find the Filename, but i do not know the string or how to find the Filepath. I am running SMS 2.0 and any help on this would be greatly appreciated. I am currently looking to find %.mp3% and other extensions in seperate collection searches, but i also want the Filepath included in the report.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SMS Query help
- Thread starter epmpglck
- Start date
- Thread starter
- #2
This is currently the string that i am using to search for the .mpg or .mp3 files. I also need the Filepath included in the report.
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question