Create a query to find a specific folder name

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Create a query to find a specific folder name

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Create a query to find a specific folder name

Page: [1]

Message

<< Older Topic Newer Topic >>

Create a query to find a specific folder name - 7/31/2008 10:14:46 AM

ttower336

Posts: 3
Score: 0
Joined: 7/29/2008
Status: offline

I could use some help constructing a query to find a specific folder on a collection of computers.

Post #: 1

RE: Create a query to find a specific folder name - 7/31/2008 11:19:34 AM

jnelson993

Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

SQL (for web report) or WQL (for SMS query or Collection query) ?

SQL

SELECT
*
FROM
dbo.v_GS_softwareFile
WHERE
filePath LIKE 'c:\folder'

WQL

SELECT
*
FROM
SMS_G_SYSTEM_SoftwareFile
WHERE
FilePath LIKE "c:\\Folder"

(notice the \\ in the WQL)

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to ttower336)

Post #: 2