troubleshooting Question

ASSOCIATORS OF Statement with SELECT query to select files with a certain extension in vbscript

Avatar of ChoobsTech
ChoobsTechFlag for Switzerland asked on
ProgrammingASPVB Script
7 Comments2 Solutions1873 ViewsLast Modified:
Dear experts,

I would like to combine two following queries in WQL & vbscript. Reference is on but quite poor in my opinion.

I want to locate all files with a "BRT" extension and using the CIM_Datafile. I can run the 2 queries separatly but cannot combine them.

Any ideas? My code is below:

trComputer = "."
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}\\" & strComputer & "\root\cimv2")

'Set colFiles = objWMIService.ExecQuery("Select * from CIM_DataFile where FileName Like '%.BRT'")
Set colFileList = objWMIService.ExecQuery("ASSOCIATORS OF {Win32_Directory.Name='C:\Scripts'} Where  ResultClass = CIM_DataFile")

For Each objFile in colFileList
    Wscript.Echo objFile.Name

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros