Query Mapped Network Drive

Question

This query runs fine on my local machine:

strComputer = "."
drive = "C:"
path = "\\path\\to\\local\\folder\\"

Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set colFiles = objWMIService.ExecQuery("Select * From CIM_DataFile Where Path = '"&path&"' and drive='"&drive&"'")

If colFiles.Count < 1 Then
    Wscript.Echo "Folder does not exist"
Else
    Wscript.Echo "Folder does exist"
End If

But when I try to query a mapped network drive, the program fails with 'Folders does not exist'. Yet I am sure it is the correct path to the file.

The only parts that change are:

drive = "Z:"
path = "\\path\\to\\mapped\\drive\\folder\\"

Any clues as to why this would not work?

Using double backslashes like that is not appropriate in vbscript. — Hans Passant
– Hans Passant, Commented Oct 18, 2012 at 13:05
Ok, but the program runs fine for a local file. And that uses double backslashes. So I don't think it would be the backslashes. — Chris M
– Chris M, Commented Oct 19, 2012 at 9:50
Avoid thinking about it. Actually remove the backslashes and try again. What happens? — Hans Passant
– Hans Passant, Commented Oct 19, 2012 at 12:08
When I remove the backslashes from the path name, I receive an error from windows script host reading 'Invalid query', source SWbemObjectSet, code 80041017. — Chris M
– Chris M, Commented Oct 22, 2012 at 9:04

Community · Accepted Answer · 2017-05-23 12:12:20Z

2

Trying to map drives on a remote computer via WMI will fail, though there is a workaround. Thanks to Frank White's inspirational code, a fully fleshed process now exists to map a drive on a remote computer via WMI using a command prompt and passing explicit credentials.

https://stackoverflow.com/a/11948096/1569434

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Nov 4, 2012 at 3:32

Lizz

1,4685 gold badges25 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris M · Accepted Answer · 2012-10-22 11:23:12Z

0

So to debug this I ran the following:

strComputer = "."
 Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
 Set colFiles = objWMIService.ExecQuery("Select * from CIM_Datafile Where Drive = 'Z:'")
 For Each objFile in colFiles
    Wscript.Echo objFile.Name
 Next

This resulted in the error 'remote procedure call failed', which I understand means that the mapped drive does not support WMI.

answered Oct 22, 2012 at 11:23

Chris M

757 bronze badges

Collectives™ on Stack Overflow

Query Mapped Network Drive

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related