Resources for IT Professionals > 論壇首頁 > The Official Scripting Guys Forum! > VB Script: Delete multiple shares on a server with deleting the C$ and D$ share.
發問發問
 

已答覆VB Script: Delete multiple shares on a server with deleting the C$ and D$ share.

  • 2009年7月1日 下午 05:37b4sher 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    Hi, I have just recently been thrown into VB Scripting as a means to make me and my fellow admin's jobs a bit easier. Right now we are migrating about 1000 user shares off a server and onto a new CIF. I wrote a script for this that lists all user folders in a directory (all of them are shared folders) and then runs that list (a saved txt file) through a loop that first unshares their drive, then xcopy's their data to the new server. The script runs...but it is extremely slow. I'm pretty sure it is getting hung up on querying all of the shares via:
    Set
     objWMIService = GetObject("winmgmts:"
     _
        	& "{impersonationLevel=impersonate}!\\"
     & strServer & "\root\cimv2"
    )
    	Set
     colShares = objWMIService.ExecQuery _
        	("Select * from Win32_Share Where Name = '"
     & strUsrShare & "'"
    )
    	For
     Each
     objShare in
     colShares
        	objShare.Delete
    	Next
    
    
    As we have over 1000 shares on that server. So I figure it might be easier on the front end to delete all shares then migrate their data. However I can't delete the standard C$ and D$ share, as that is how I am xcopying their data over. But I am specifically noticing the "Select * from Win32_Share" in that snippet of code and was wondering if there is a way to select all the shares that start with "a" and so on and so forth (i.e. a*).

    If anyone has any ideas, thoughts, suggestions that would be awesome.

    Thanks a lot!

解答

  • 2009年7月1日 下午 05:54NickHunyady 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     已答覆
    Shouldn't be a problem. The WQL can handle that sort of query.

    ("Select * from Win32_Share Where Name Like 'a%'")
    • 已標示為解答b4sher 2009年7月1日 下午 06:02
    •  

所有回覆

  • 2009年7月1日 下午 05:54NickHunyady 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     已答覆
    Shouldn't be a problem. The WQL can handle that sort of query.

    ("Select * from Win32_Share Where Name Like 'a%'")
    • 已標示為解答b4sher 2009年7月1日 下午 06:02
    •  
  • 2009年7月1日 下午 05:55b4sher 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    Thanks for the reply! But would this cause reason for the script to run slowly? Querying that many shares?
  • 2009年7月1日 下午 06:01NickHunyady 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    Querying that many shares may take a while to begin with, although if your doing this locally it should run just fine. One thing to remember though, since you are using the operator and only looking for things that start wiht a* this will limit your results drastically.
  • 2009年7月1日 下午 06:30perhof 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     

    You can also query all shares and exclude certain shares.
    Select * from Win32_Share Where Not Name = 'C$' AND Not Name = 'D$'

    I would also recommend you to avoid deleting other administrative shares like admin$, ipc$, print$ etc.

  • 2009年7月1日 下午 06:42NickHunyady 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    Building on perhof's reply it could be easier to build your query to just exclude administrative shares all together.

    ("Select * from Win32_Share Where Name Like 'a%' AND Type = '0'")