How to access files in network drive to search for a string in that file?

Question

0.00/5 (No votes)

See more:

I am using below code in windows powershell to search for a string and give filename as output if string is found.

$a=Get-ChildItem -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "err"}
Write-host " Files with error code ERROR : $a
but i want to search files in a shared location which is given below which is protected by username and password which can be supplied

shared location : \\d1dal723\prdload
username : abc\xxyyzz
password : asdfghj@123
Please help me to search and display file names in that shared path .

Thanks in Advance.

Posted 14-Feb-14 8:14am

Member 10597584

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

notjustme · Answer 1 · 2014-02-15T04:39:00

UNC paths seem to work just fine for me. What have you tried and what error messages do you get?

Anyway, Get-ChildItem is gonna need the path to begin with. Using the full local path could perhaps be an option. Like... "\\d1da1723\c$\This Directory\Stuff\prdload"

Or you could mount the share with "net use" before searching through the files.
"net use /?" for help on that.

PowerShell

$a=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath | select-string -pattern "err"}
Write-host "Files with error code ERROR : $a"

Member 10597584 · Answer 2 · 2014-02-15T06:01:00

Solution 2

Hi
After trying your code

SQL

a=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath | select-string -pattern "err"}
Write-host "Files with error code ERROR :

I got the below error:

e term 'a=Get-ChildItem' is not recognized as the name of a cmdlet, function, script f
ile, or operable program. Check the spelling of the name, or if a path was included, ver
ify that the path is correct and try again.
At line:1 char:16
+ a=Get-ChildItem <<<<  "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {g
c $_.pspath | select-string -pattern "err"}
    + CategoryInfo          : ObjectNotFound: (a=Get-ChildItem:String) [], CommandNotFo 
   undException
    + FullyQualifiedErrorId : CommandNotFoundException


:(

Posted 15-Feb-14 6:01am

Member 10597584

Comments

notjustme 16-Feb-14 0:47am

It was actually your code, I just added the path you mentioned. However, the $ in $a got cut out when I copied your code.

Member 10597584 20-Feb-14 8:38am

Hi,

Now i used the below code but got an error.Although i have mapped my network drives to Z and Y i am still getting error.PFB the code i used.

<blockquote class="FQ"><div class="FQA">Quote:</div>$net = new-object -ComObject WScript.Network
$net.MapNetworkDrive("Z:", "\\d1dal723\prdload", $false, "apl\smallak", "Smile@05")

$a=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "err"}
Write-host " Files with error code ERROR : $a"-foreground "magenta"-backgroundcolor "black"

$b=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "ora[0-9]"}
Write-host " Files with error code ORA : $b"-foreground "magenta"-backgroundcolor "black"

$c=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "odbc[0-9]"}
Write-host " Files with error code ODBC : $c"-foreground "magenta"-backgroundcolor "black"

$d=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "TNS"}
Write-host " Files with error code TNS : $d"-foreground "magenta"-backgroundcolor "black"

$e=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "inaccessible"}
Write-host " Files with error code INACCESSIBLE : $e"-foreground "magenta"-backgroundcolor "black"

$e=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "Holos not logged "}
Write-host " Files with error code Holos not logged : $e"-foreground "magenta"-backgroundcolor "black"

$e=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "\?"}
Write-host " Files with error code object no longer exists : $e"-foreground "magenta"-backgroundcolor "black"
</blockquote>

Member 10597584 20-Feb-14 8:39am

Hi,

Now i used the below code but got an error.Although i have mapped my network drives to Z and Y i am still getting error.PFB the code i used.

$net = new-object -ComObject WScript.Network
$net.MapNetworkDrive("Z:", "\\d1dal723\prdload", $false, "apl\smallak", "Smile@05")

$a=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "err"}
Write-host " Files with error code ERROR : $a"-foreground "magenta"-backgroundcolor "black"

$b=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "ora[0-9]"}
Write-host " Files with error code ORA : $b"-foreground "magenta"-backgroundcolor "black"

$c=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "odbc[0-9]"}
Write-host " Files with error code ODBC : $c"-foreground "magenta"-backgroundcolor "black"

$d=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "TNS"}
Write-host " Files with error code TNS : $d"-foreground "magenta"-backgroundcolor "black"

$e=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "inaccessible"}
Write-host " Files with error code INACCESSIBLE : $e"-foreground "magenta"-backgroundcolor "black"

$e=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "Holos not logged "}
Write-host " Files with error code Holos not logged : $e"-foreground "magenta"-backgroundcolor "black"

$e=Get-ChildItem "\\d1dal723\prdload" -r | ? {$_.psiscontainer -eq $false} | ? {gc $_.pspath |select-string -pattern "\?"}
Write-host " Files with error code object no longer exists : $e"-foreground "magenta"-backgroundcolor "black"

Please help

notjustme 24-Feb-14 21:51pm

You're gonna have to adjust your path to your mapping then (like $a=Get-ChildItem Z: instead of what you have now). What is the error you're getting?

On a sidenote, if that's your real user/pass you migth wanna edit that out before pasting your code here.