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!
-
need help to make query
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 =...- epmpglck
- Post #4
- Forum: Microsoft: SMS (Systems Management Server)
-
need help to make query
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.- epmpglck
- Thread
- Replies: 4
- Forum: Microsoft: SMS (Systems Management Server)
-
SMS Query help
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...- epmpglck
- Post #2
- Forum: Microsoft: SMS (Systems Management Server)
-
SMS Query help
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...- epmpglck
- Thread
- Replies: 1
- Forum: Microsoft: SMS (Systems Management Server)
