Need to add users from a CSV file to a security group

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ VBscripts
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - My vbScript answer to the Google Question. {the first 10 digit prime in e}.com Rember the google question {the first 10 digit prime in e}.com ? Here is my vbscript answer which finds the first 10 digit prime in e in half a second or so (depending upon your hardware). Note, this code is built for speed rather than readability (or 'write only code' as we call it here!). s=Timer() Dim a(100000) r=Round(Sqr(100000)) For p=2 To r While a(p)=True p=p + 1 Wend x=p * 2 While x<=100000 a(x)=True x=x+p Wend Next e="2718281828459045235360287471352662497757247093699959574966967627724076630353547594571382178525166427427466391932003059921817413596629043572900334295260595630738132328627943490763233829880753195251019011573834187930702154089149934884167509244761460668082264800168477411853742345442437107539077744992069551702761838606261331384583000752044933826560297606737113200709328709127443747047230696977209310141692836819025515108657463772111252389784425056953696770785449969967946864454905987931636889230098793" For p=1 To Len(e)-9 c=Mid(e,p,10) b=True For x=2 To 100000 If a(x)=False Then r=CDbl(c)/CDbl(x) If r=Round(r) Then b=False Exit For End If End If Next If b=True Then MsgBox c & " is the first 10 digit prime in e at p:" & p & vbCrLf & "done in : " & Timer() - s & " seconds" WScript.Quit End If Next Tag: Need to add users from a CSV file to a security group Tag: 209995
  - 2
    - Creating an exe from a .vbs script Hi I have a .vbs script for enabling Auto Logon into a Windows box which runs as c:\>wscript.exe AutoLogo.vbs I need to create an exe file of the same AutoLogon.vbs file. Is that possible? If yes, how? _linuxplorer Tag: Need to add users from a CSV file to a security group Tag: 209985
  - 3
    - re: 'Save As' routine I have used the command workbook.SaveAs = intReturn1, where intReturn1 is the value returned from an input box allowing a user to save an Excel workbook under the name they wish. Does anyone know of the instructions necessary to inform a user that a file already exists in that location, and that they need to save it under a different name? -- Charles Dean Tag: Need to add users from a CSV file to a security group Tag: 209984
  - 4
    - .vbs script for IIS 6.0 and ISAPI Filter I am trying to write a .vbs script to create an ISAPI filter within the default website. From what I can tell, setting an ISAPI filter via .vbs requires knowledge of using arrays. Can anybody help on how to accomplish this type of task with either same code or links to MSDN/Technet, etc? I also need to set an application mapping within the default website as well if anybody has any feedback for this. I tried to use the built-in iisconf.vbs script to copy the metabase from source computer to target computer but it seems like I cannot get rid of machine specific settings when using the iisconf.vbs script Thanks - Tag: Need to add users from a CSV file to a security group Tag: 209977
  - 5
    - vbscript & database access I am a newbie when comes to trying vbscript & database access (via ODBC or ADO). So where does one start? Does this require HTA scripting, or can this be done directly with vbs? I am a developer who is profficient with vbs and understanding code. Where is a good place to start? Thanks Tag: Need to add users from a CSV file to a security group Tag: 209974
  - 6
    - VBS like a Service Hi, I don't know how can explain... Can I start a vbs like a service? I have a vbs that generate a txt and I have to run it every 10min. Can I put it in "Windows Services"? I don't want to schedule this execution. How can I do this -- Rodrigo Ferreira Regards from Brazil Sorry for my poor english Tag: Need to add users from a CSV file to a security group Tag: 209966
  - 7
    - Need a filtered select box In Outlook Express, you can get to a list of all available newsgroups for any of your newsgroup accounts by hitting Control-W or clicking the newsgroups item from the tools menu. At the top of that Newsgroup Subscriptions window is a box in which to type some text; when you do, the main window immediaely displays newsgroups with that text anywhere in their name, thus giving you a more focused list to choose from. Does anyone have code to share which can do something similar in a web page or HTA? I'm thinking it could be implimented by having a 'filter' input box, an array of all potential items to be shown, and a select box. Each time the user changes the filter, a regular expression extracts a matches collection from the join of an array of potential items, and and those matches are put in the select box. Maybe there is an object with this kind of filtering built into WXP. I hate to start these little vast projects with half vast plans. Any ideas or links to sample script? -Paul Randall Tag: Need to add users from a CSV file to a security group Tag: 209959
  - 8
    - Help needed: Very odd VB Script behavior I have a web page with a vbscript section that looks like Sub Window_Onload() msgbox("Here") call getprojmonths(intProjNum,0) End Sub getprojmonths is a javascript function being called from a vbscript sub to provide ajax functionality and yes, it works. Here's the odd part: if I take out the msgbox the call does not get made. Furthermore, if I put another vbscript statement between the msgbox and js call it won't work; the js call must immediately follow the msgbox. I'm working on rewriting the js as vbscript but I am still curious why I have to execute a msgbox to get the js call to work. I'd love to hear why it behaves this way if anyone knows. Tag: Need to add users from a CSV file to a security group Tag: 209957
  - 9
    - re: Path Location dialogue box & ammendment to 'Save As' instruction This post consists of two questions: 1) I have used the command workbook.SaveAs = intReturn1, where intReturn1 is the value returned from an input box allowing a user to save an Excel workbook under the name they wish. Could somebody post the instructions necessary to inform a user that a file already exists in that location, and that they need to save it under a different name. 2) The default save location is My Documents. What instructions do I need to create a dialogue box which allows a user to choose another save location? Thanks -- Charles Dean Tag: Need to add users from a CSV file to a security group Tag: 209944
  - 10
    - Who Has Permission on shared folders? I would like to have a list with the following information: foldername; username; rights I tried powershell and cacls, but they both don't repeat the username on each line, so I have to reprocess the output. I'm a newbie to scripting, but I would appriciate any help that can generate this kind of information. Tag: Need to add users from a CSV file to a security group Tag: 209942
  - 11
    - Command line in vbs script Hi looking for a bit of help, tried a few things but cant get it to work, i am trying to run the following DOS command line from a VBS script. printmig -b "\\servername\file.cab" \\server1 Tried various ways but no luck can anyone help ? Thanks Tag: Need to add users from a CSV file to a security group Tag: 209939
  - 12
    - Cannot call ActiveX component function from VBScript I am trying to call ActiveX function which resides on a client computer from vbscript or javascript. I developed a simple Visual C++ 2005 ActiveX component (ocx file) with one exported method which returns int value. When I try to call this method from VB, everything works fine and I get the value that method should return. The ActiveX component was registered on the client computer with regsvr32. I tried in two ways to call the ocx method from javascript: - with new ActiveXObject("progID"), where the progID was found in the registry, - with <object classid="clsid:xxxxxxx" id="xx">, and classid was also found in the registry. VBscript makes the object, but cannot call the ocx method. An error "Object doesn't support this property or method" appears on the web page. At Internet Explorer options I enabled all activex objects both in Internet and intranet zone. I looked for some kind of solution everywhere, but didn't succeed. I am blocked at two lines of code for a week. The code of html page with vbscript follows. Thanks for any kind of help. <HTML> <HEAD> <TITLE></TITLE> <SCRIPT language="vbscript"> Sub callTest document.write(a.test()) End Sub </SCRIPT> </HEAD> <BODY> <OBJECT id="a" classid="CLSID:A2733628-A334-4207-83F1-F00198758EFF" name="a" ></OBJECT> <INPUT TYPE=button value="Test" onClick="callTest"> </BODY> </HTML> Tag: Need to add users from a CSV file to a security group Tag: 209936
  - 13
    - owner propety on files I have a script that works. I am sure there is a better way to do it. I am outputing the file properties for all files in a specified directory to an excel file. I can not figure out a way to include the owner property. I found something that does pull owner information - it also pulls alot of information i don't want and i have no idea how to integrate it into my existing script. Below i pasted both the script that pulls owner property and my existing script. Any help getting getting the "existing script" to pull the ower property is appreciated. *********************** ' pulls info on owners and extras Dim arrHeaders(34) Set objShell = CreateObject("Shell.Application") Set objFolder = objShell.Namespace("C:\Scripts") For i = 0 to 33 arrHeaders(i) = objFolder.GetDetailsOf(objFolder.Items, i) Next For Each strFileName in objFolder.Items For i = 0 to 33 Wscript.Echo i & vbtab & arrHeaders(i) _ & ": " & objFolder.GetDetailsOf(strFileName, i) Next Next *************************** 'Existing script Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colFileList = objWMIService.ExecQuery _ ("ASSOCIATORS OF {Win32_Directory.Name='H:\scripts'} Where " _ & "ResultClass = CIM_DataFile") i = 2 Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True 'open spreadsheet Set objWorkbook = objExcel.Workbooks.Open("h:\spreadsheet.xls") Set objWorksheet = objWorkbook.Worksheets(1) objExcel.Cells(1, 1).Value = "File Name" objExcel.Cells(1, 2).Value = "File Path" objExcel.Cells(1, 3).Value = "File Size in Bytes" objExcel.Cells(1, 4).Value = "Date Created" objExcel.Cells(1, 5).Value = "Last Accessed" objExcel.Cells(1, 6).Value = "Last Modified" objExcel.Cells(1, 1).Font.Bold = TRUE objExcel.Cells(1, 2).Font.Bold = TRUE objExcel.Cells(1, 3).Font.Bold = TRUE objExcel.Cells(1, 4).Font.Bold = TRUE objExcel.Cells(1, 5).Font.Bold = TRUE objExcel.Cells(1, 6).Font.Bold = TRUE For Each objItem In colFileList objworksheet.cells(i, 1).Value = objItem.FileName objWorksheet.cells(i, 2).value = objItem.Description objWorksheet.cells(i, 3).value = objItem.FileSize objWorksheet.cells(i, 4).value = WMIDateStringToDate(objItem.CreationDate) objWorksheet.cells(i, 5).value = WMIDateStringToDate(objItem.LastAccessed) objWorksheet.cells(i, 6).value = WMIDateStringToDate(objItem.LastModified) i = i + 1 Next Function WMIDateStringToDate(dtmDate) WScript.Echo dtm: WMIDateStringToDate = CDate(Mid(dtmDate,5,2) & "/" & _ Mid(dtmDate,7,2) & "/" & Left(dtmDate, 4) _ & " " & Mid (dtmDate,9,2) & ":" & Mid(dtmDate,11,2) & ":" & Mid(dtmDate,13,2)) End Function Dim arrHeaders(34) Set objShell = CreateObject("Shell.Application") Set objFolder = objShell.Namespace("H:\DoubleTake\scripts") For j = 0 to 33 arrHeaders(i) = objFolder.GetDetailsOf(objFolder.Items, j) Next For Each strFileName in objFolder.Items For j = 0 to 33 Wscript.Echo i & vbtab & arrHeaders(j) _ & ": " & objFolder.GetDetailsOf(strFileName, j) Next Next Tag: Need to add users from a CSV file to a security group Tag: 209922
  - 14
    - Get Error Description from Number Am I correct that VBScript does not support Error()? And that if you don't capture the value of Err.Description that your SOL when it come to needing a get the description of an error when you only have the code. Tag: Need to add users from a CSV file to a security group Tag: 209918
  - 15
    - vista indexing progress? Hey all. Anyone know how to read vista's indexing progress via vbscript? I want something that I can show our techs after a pc build so they dont give the machine to a user before indexing is %100. Tag: Need to add users from a CSV file to a security group Tag: 209911
  - 16
    - Naked windows Hi gang! It's been a while - hope everyone has been well. So my interest today is um, ahem, well let's just say I want a window without all its dressings. Specifically, I would like to make use of IE's window.setTimeout functionality. And I have no problem with that, it works fantastically well. However, it occurred to me that I can perhaps avoid several lines of initialization code. So instead of doing: Set ie = CreateObject("InternetExplorer.Application") ie.Navigate2 "about:blank" While ie.ReadyState<>4: Wscript.Sleep 10: Wend Set Win = ie.document.parentWindow 'Now I can use Win.setTimeout perhaps I could go directly to: Set Win = CreateObject("WhatGoesHere") Any tips? Csaba Gabor from Vienna Tag: Need to add users from a CSV file to a security group Tag: 209905
  - 17
    - Powershell NewsGroup Is there a Powershell specific newsgroup ? Tag: Need to add users from a CSV file to a security group Tag: 209898
  - 18
    - Adding IP printer with VBScript problem This is the code I'm using to add my IP printer through a script but only seems to add the port and not the printer to the machine. Can anyone tell what would keep the printer from getting added to the computer? strComputer = "." '= strComputer can be an array of netbios computer names or = '= ip addresses put into a for loop = Public Error Dim Count:Count=0 Set WshShell = WScript.CreateObject("WScript.Shell") Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root \cimv2") Dim IPArray '= here is where your editing skills happen! = IPArray = Array( "172.17.20.136") Dim PrintersArray '= here is where your editing skills happen again ! = PrintersArray=Array("c:\hpc2800d.inf") '= here is where you edit the printer names = Dim PrinterNames PrinterNames=Array("HP Color LaserJet 2800 (Remote Office)") For n = LBound(IPArray) To UBound(IPArray) 'Install the IP printer ports Install_IP_Ports IPArray(n) Next For n = LBound(IPArray) To UBound(IPArray) Count = Count + 1 'just increments the counter for the message at the end! '= Add the printers (Arguments: ip port, path to the .inf files, printer name) = '= get the name from the inf files or make one up! = Add_local_ip_printer IPArray(n), PrintersArray(n), PrinterNames(n) Next Make_Default_printer PrinterNames(0) '= if only one printer in array set to zero e.g. PrinterNames(0) or comment out!= 'Install the TCP/IP Port(s): Function Install_IP_Ports(strIPAddress) Set objNewPort = objWMIService.Get("Win32_TCPIPPrinterPort").SpawnInstance_ objNewPort.Name = strIPAddress objNewPort.Protocol = 1 objNewPort.HostAddress = strIPAddress objNewPort.PortNumber = "9100" 'objNewPort.Queue = "LPT1_PASSTHRU" objNewPort.SNMPCommunity = "public" objNewPort.SNMPEnabled = False objNewPort.Put_ 'stop the spooler Set colServiceList = objWMIService.ExecQuery _ ("Select * from Win32_Service where Name='Spooler'") For Each objService In colServiceList errReturn = objService.StopService() WScript.Sleep 100 Next 'start the spooler For Each objService In colServiceList errReturn = objService.StartService() WScript.Sleep 100 Next End Function Function Add_local_ip_printer(strIP,strPath_To_Inf_Files,strPrintername) WSHShell.run ("CMD.EXE /C RUNDLL32 PRINTUI.DLL,PrintUIEntry /if /b "_ & chr(34) & strPrinterName & chr(34) &" /f " & chr(34) _ & strPath_To_Inf_Files & chr(34) & " /r " & chr(34) _ & strIP & chr(34) & " /m " & chr(34) & strPrinterName & chr(34) _ & " /q /u"),0,true End Function Function Make_Default_printer(strPrinterName) Set colInstalledPrinters = objWMIService.ExecQuery _ ("Select * from Win32_Printer") For Each objPrinter in colInstalledPrinters If objPrinter.Name = strPrinterName Then objPrinter.SetDefaultPrinter() End If Next End Function Wscript.echo "Script Completed " & count & " Printers Added" 'End Script Tag: Need to add users from a CSV file to a security group Tag: 209897
  - 19
    - EFS, Active Setup and Desktop Folder I have a requirement to Encrypt the Desktop Folder. Since it is Locked Open I cannot do so via normal mechanisms. I have written a VB script that I run during Active Setup to mark the Folder for encryption and to Encrypt its files and sub-Folders. The script works about 70% of the time. The result is that the Files under Desktop get encrypted at the time the script runs, but the Desktop Folder itslef does not have the attribute set. So new Files added to the Desktop Folder are not encrypted. Is there some sample code out there to help me on my way? I need to prevent the Desktop Folder from getting locked, then Mark it for Encryption, then continue on with the user login process. I thought Active Sertup would do this, but apparently, it doesn't seem to work every time. I am hoping there is something explicit I can do in my code to handle this. Thanks for your help. Tag: Need to add users from a CSV file to a security group Tag: 209894
  - 20
    - Regular Expression Help Required I have downloaded the below code from Microsoft site and modified as per my requirment. The problem here is the script after matching the first pattern (837139231DDA)it will write data of that line to an excel file then immedielty it starts searching for the next pattern without writing the subsequent line before the next match. I have another 4 lines between the first match & the second match which is not getting written to the excel file. Could any one tell me where i am wrong.. Any help would be great appreciated. Input file ---------------------------- 837139231DDA 3 01 ADD DATE PLACED-- 240807 DATE TO EXPIRE 230809 CIX0044 08/24 13.17 A04NM540 LO SERIAL# HI SERIAL# LO AMT HI AMT CHARGE CODE Y PAYEE HUY NGUYEN SPECIAL COMMENTS SPECIAL COMMENTS PH: (07) 837139231DDA 3 01 CHG DATE PLACED-- 240807 DATE TO EXPIRE 230809 CIX0044 08/24 13.17 A04NM540 LO SERIAL# HI SERIAL# LO AMT HI AMT RESTRAINT REASON DATE NOT PROVIDED ---------------------------- Cod ------------------------------------------------------------------------------------ Const ForReading = 1 Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.Workbooks.Add x = 1 Set objRegEx = CreateObject("VBScript.RegExp") objRegEx.Global = True objRegEx.Pattern = "^[1-9]........DDA" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:\Script\Test.txt", ForReading) 'Do while objFile.AtEndOfStream Do Until objFile.AtEndOfStream strSearchString = objFile.ReadLine Set colMatches = objRegEx.Execute(strSearchString) If colMatches.Count > 0 Then For Each strMatch in colMatches objExcel.Cells(x, 1) =strSearchString x = x + 1 Next End If Loop objFile.Clos ----------------------------------------------------------------------------------- Tag: Need to add users from a CSV file to a security group Tag: 209890
  - 21
    - Accessing the contents of HTA dataarea after update. I'm trying to access the values of checkboxes that I've passed through to an HTML page in a script. A simple example that displays filenames but does not return the values is: <html><head> <title>HTA Test</title> <HTA:APPLICATION APPLICATIONNAME="HTA Test" SCROLL="yes" SINGLEINSTANCE="yes"> <script language="VBScript"> Set fso = CreateObject("Scripting.FileSystemObject") Sub GetFiles onlinepath = "T:\Testing" topline = "<Table cellpadding=0 cellspacing=0><TR><TD>File Name</ TD><TD align=center width=240>File OK??</TD></TR>" Set objFolder = fso.GetFolder(onlinepath) linenum=1 For each objFile in objFolder.Files fileis = onlinepath & "/" & objFile.name filelist = filelist & "<TR><TD>" & fileis & "</TD><TD align=center><input type=""checkbox""" & checked & " name=""TickBox" & linenum & """></TD></TR>" Next filelist = topline & filelist DataArea.InnerHTML = filelist End Sub Sub TestSub Set TickBox1 = window.event.srcelement MsgBox TickBox1.Value End Sub </script> </head> <body onload="GetFiles"> <Form> <span id = "DataArea"></span> <input type="button" value=button value="run" name="run_button" onClick="TestSub"><p> </TABLE> </FORM> </body></html> How do I access the values of the checkboxes in TestSub? Regards, Richard Tag: Need to add users from a CSV file to a security group Tag: 209885
  - 22
    - Path not found error using FSO GetFolder Hi I'm using a script to get a list of folders (and subfolders) for a UNC path but I noticed that if the script tries to get hold of a subfolder path that is too long to display then it ends with 'Path Not Found' - so the script is : Set objFSO = CreateObject("Scripting.FileSystemObject") objStartFolder = "\\server4\files" Set objFolder = objFSO.GetFolder(objStartFolder) Wscript.Echo objFolder.Path Wscript.Echo ShowSubfolders objFSO.GetFolder(objStartFolder) Sub ShowSubFolders(Folder) For Each Subfolder in Folder.SubFolders Wscript.Echo Subfolder.Path Set objFolder = objFSO.GetFolder(Subfolder.Path) Wscript.Echo ShowSubFolders Subfolder Next End Sub If I add 'On Error Resume Nex't at the top, then it doesn't display the error but the script just exits on the problem path again and won't go any further. I unfortunately don't have the means to change the path structure and make them smaller or use mapped drive etc. What I effectively need is the script to ignore any paths that cause a problem and just carry on with the next. Is there any other way of getting round this? Thanks John Tag: Need to add users from a CSV file to a security group Tag: 209879
  - 23
    - Unlocking locked local accounts Hi there, hope someone can help me I know there are other issues, but short-term this is the problem!! I have a number of users locking accounts by incorrectly passing credentials to a server. I need to be able to periodically sweep for these locked accounts and unlock them - these are all local accounts. I have found a number of ways to identify them, but cannot find a way to unlock them! For example ComputerName = localhost winmgmt1 = "winmgmts:{impersonationLevel=impersonate}!//"& ComputerName &"" Set UserSet = GetObject( winmgmt1 ).InstancesOf ("Win32_UserAccount") for each User in UserSet if user.lockout = "True" then ---what should go here??? end if next Finds me the locked accounts, though seems to add some domain accounts too.... Code below finds only local accounts and gives me details, but how do I check and fix locked this way? strComputer = "bob" Set colAccounts = GetObject("WinNT://" & strComputer & "") colAccounts.Filter = Array("user") For Each objUser In colAccounts Set objUser = GetObject("WinNT://" & strComputer & "/" & objuser.name) Wscript.Echo objUser.Name Next If it is easier, I do have powershell on this machine as welll Regards and thanks Ross Carr Tag: Need to add users from a CSV file to a security group Tag: 209876
  - 24
    - Avoid loading images - Avoid sounds Hello, I'm writing automation scripts in VBA and VBS to use IE6 to retrieve data from web sites. I create an instance of IE (or sometimes connect to one instance already open) and send it commands to navigate to URLs, and retrieve the data contained in tables etc. My questions (so far) are: 1) How do I avoid the loading of images? (Ideally the user should be able to browse normally while my script runs, this means: if the solutions involves the "display images" option, can it be set to OFF in one instance without affecting other IE instances?) 2) How to disable the clicking that happens when IE starts navigation? (again, disabling it in Control Panel shouldn't affect other instances, ideally) Thanks in advance Chris Tag: Need to add users from a CSV file to a security group Tag: 209865
  - 25
    - & and + hi all what's the difference between the ampersand and the plus charcters as cocatenators? ex "hello " & "world" "hello " + "world" Tag: Need to add users from a CSV file to a security group Tag: 209864
- Next
  - 1
    - Windows 2000 bsod script to prevent or detect bad hard drive At work we have several pc's that use windows 2000 professional for vision systems, and for some reason when we have to shut down our sub-stations invertently one of our pc's gets the bsod and upon restarting the pc's say that the system file is corrupt. We have about 100 pc's and it wouldn't be very possible to physically go around and shut off all the pc's as this would require too much manpower and it would be less expensive to just replace the pc and replace the hard drive and ghost the new one for later use. Is it possible to write a script to scan the hard drives while the pc still runs normally so we could first prevent the problem and hopefully mark the bad sectors as bad as to possibly prolong the life of the drives, and also to let us know that we need to put it on a schedule to change out the drive. Also if shutting down the pc's in this manner, (Shutting Power Off) maybe make a script that would automatically shut down all the pc's. I have never used vbscript but I've heard that such scripting is possible using it. Dave Marden Tag: Need to add users from a CSV file to a security group Tag: 209840
  - 2
    - Trouble with xcacls in usercreation Hi - I have made a user-creation script (by taking bits and pieces from various sources, which works nicely, except for one thing - this code creates the homefolders nicely, but doesn't apply the right security settings: objFSO.CreateFolder "\\SERVER\data$\" & strUserName strFolder = "\\SERVER\data$\" & strUserName strXcacls = "Xcacls " & strFolder & " /C /P system:f ""Domain Admins"":f " & strUserName & ":M /Y" WshShell.Run strXcacls, 0 It doesn't give any errormessages when run. Can anybody see what I have missed? Additionally, I forgot to assign logon-script to some of the groups of accounts I created - anybody know of a way to assign a logon-script for accounts that doesn't have one? Kind regards Tag: Need to add users from a CSV file to a security group Tag: 209837
  - 3
    - Declaring Arrays for use with Split() I'm very much in the habit of Dim-ing all of my variables and would like be able to explicitly Dim an array for use with Split(), however its giving me a 'Type Mismatch' error when I try to Dim it. Dim prefArray(2) prefArray = split(objFile.ReadLine, chr(9)) The line being read will only, ever have one tab return and thus the line will only be broken into two values. Tag: Need to add users from a CSV file to a security group Tag: 209833
  - 4
    - Help with RegExp I need help with the following 3 regular expressions: 1. Using the regexp pattern "^(?:[AUT]\d{5}(?:,|$))+$" the following string is valid: A12345,A23456,U45678,U12375,T12345,U87456. How would I have to modify the pattern to allow for a maximum of 5 values e.g. A12345,A23456,U45678,U12375,T12345? 2. Which pattern do I have to use to validate the following string, e.g.: 1001,5458,3112 Valid numbers are between 1000 and 9999. Each number needs to be separated with a comma. The string can only contain a maximum of 10 numbers. 3. Which pattern do I have to use to validate the following string, e.g.: 2007 Valid numbers are between 2000 and 2020. Only 1 number is allowed. TIA Pete Tag: Need to add users from a CSV file to a security group Tag: 209830
  - 5
    - VBScript - String - first letters to Uppercase Hello, Can anyone please help me with a function that takes a string, a name, and makes all the first letters Uppercase? Actually I can already kinda do the above but I'm stuck on initials eg if I get... "j.earl jones a.watson" I would like to make that "J.Earl Jones A.Watson" and of course if I get just "a.watson" turn that into "A.Watson" or simply change "james" to "James" and "james watson" to James Watson. Basically all the 1st letters unless there is a "." in which case the first letter also after the "." It would also be nice to put some kind of a check in case I get "j.earl." and there is nothing after the "." then leave it. Thank you in advance :-) Yas Tag: Need to add users from a CSV file to a security group Tag: 209829
  - 6
    - re: VBScript and Internet Explorer Could somebody give me a hand with writing a script whereby an Internet Explorer window can be used to browse a series of pictures, as if browsing them on a website? I have the code for creating an IE window, but don't know how to put images on different pages within that window. It would be great to use the backwards and forwards arrow buttons to browse these images, if that is possible. -- Charles Dean Tag: Need to add users from a CSV file to a security group Tag: 209823
  - 7
    - Mapped disk list We have a script which executes at users logon which should write to a file the list of user's mapped disks. If the user has administrative rights on the client it works , for normal users it doesn't . The problem is that it seems that the line Set colItems = objWMIService.ExecQuery("Select * from Win32_MappedLogicalDisk") reports no results How can we have the script running correctly even with normal users ? Thanks Below the portion of the script : Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_MappedLogicalDisk") For Each objItem in colItems objOutFile.writeline "Device ID|" & "Percorso di rete|" & "Volume Name|" & "Description|" & "Free Space|" & "Size" objOutFile.writeline objItem.DeviceID & "|" & objItem.ProviderName & "|" & objItem.VolumeName & "|" & objItem.Description & "|" & objItem.FreeSpace & "|" & bjItem.Size objOutFile.writeline Next Tag: Need to add users from a CSV file to a security group Tag: 209822
  - 8
    - Use VBS to set registry values.. Hi, How do I set the following fields in registry from a vbs script: 1. Auto arrange desktop icons 2. Display the My Computer, Network Neighbourhood, My Documents and IE shortcuts on the desktop. Thanks a lot for help on this regards jake Tag: Need to add users from a CSV file to a security group Tag: 209816
  - 9
    - ldap security in a script I have script from the Microsoft site that reads info from AD to create an OWA distibution list. The script contains the line Set objGroup = GetObject("LDAP://CN=Finance Users,OU=Finance,,DC=fabrikam,DC=com") Authenticated users should have enough access to read this info from AD shouldn't they? Thanks, Jeremy Tag: Need to add users from a CSV file to a security group Tag: 209815
  - 10
    - Select Case Limitations Does VBScript allow expressions such as "1 to 5" and "IS > 89"? The following code works fine in VBA, however VBScript doesn't appear to 'TO' and 'IS >' parts fo the case statement. For i = 1 To Len(strFileName) Select Case Asc(Mid(strFileName, i, 1)) Case 1 To 39, 42, 43, 44, 46, 47, 58 To 64, 91 To 96, Is > 122 validateFileName = 0 Case Else End Select Next i Tag: Need to add users from a CSV file to a security group Tag: 209804
  - 11
    - string match with regular expressions Hi All, i'm trying to use regular expressions to filter lines from an input text file and write to an output I am looking for lines containing the "Y" character here is the code part: ... If myString = "*Y*" Then OutputFile.WriteLine myString End if ... But it looks like this is loking for a match where the star "*" character is considered as a charcater and not as a wildcard? Tag: Need to add users from a CSV file to a security group Tag: 209801
  - 12
    - change mouse buttons Hi I have an injury that means that I can only use my mouse for limited periods of time. I also use voice activated software - but I often find the need to move the mouse. I can use the mouse in either hand, but just not for more than a few minutes on each. I would like to create a script that would run from an icon on my desktop that would switch left and right mouse buttons. This way I can simply activate that script and change hands for the mouse. I know that the mouse button settings are in the control panel, mouse settings in XP pro. How can I change these using a script - given I am using a standard mouse - the basic optical one that comes with a Dell system. Any assistance would be appreciated. Doug Tag: Need to add users from a CSV file to a security group Tag: 209785
  - 13
    - Help with vbscript please - delete files I know a little about VBscript but am struggling with trying to figure out how to do the following. I need to delete all .xml files from a certain directory, however, I need to delete only certain ones based off of client names. Can anyone provide me with a script that will do this? I have 30 clients that generate .xml files in this one directory, yet there are other .xml files we need to leave alone. All client ID's are based on a 3 character name, for example, AMB, KRT, MLI, TXI, etc I am trying to write the script to where it will (1) if files exissts then delete amb*.xml, krt*.xml, etc If possible, please send a reply to ken@txgeekman.com as well... Thank you K_Smith Tag: Need to add users from a CSV file to a security group Tag: 209780
  - 14
    - printer mapping hi all i ma trying to find a way to map a network printer via a script, the printer is not shared by a server, it is reachable via its share name or its ip address . all references i found use something like \\servername\sharename to reach a printer , bu in my case i only have the sharename or the printer ip tnx Tag: Need to add users from a CSV file to a security group Tag: 209769
  - 15
    - dating agency , japanese dating , meet swedish women , teen dating emotional http://great-singles-freeweb.com/index547.html http://great-singles-freeweb.com/index548.html http://great-singles-freeweb.com/index549.html http://great-singles-freeweb.com/index552.html http://great-singles-freeweb.com/index551.html http://great-singles-freeweb.com/index550.html http://great-singles-freeweb.com/index652.html http://great-singles-freeweb.com/index653.html http://great-singles-freeweb.com/index654.html http://great-singles-freeweb.com/index655.html http://great-singles-freeweb.com/index656.html http://great-singles-freeweb.com/index657.html http://great-singles-freeweb.com/index658.html http://great-singles-freeweb.com/index659.html http://great-singles-freeweb.com/index660.html http://great-singles-freeweb.com/index661.html http://great-singles-freeweb.com/index662.html http://great-singles-freeweb.com/index663.html http://great-singles-freeweb.com/index664.html http://great-singles-freeweb.com/index665.html http://great-singles-freeweb.com/index666.html http://great-singles-freeweb.com/index667.html http://great-singles-freeweb.com/index668.html http://great-singles-freeweb.com/index669.html http://great-singles-freeweb.com/index670.html http://great-singles-freeweb.com/index671.html http://great-singles-freeweb.com/index672.html http://great-singles-freeweb.com/index673.html http://great-singles-freeweb.com/index674.html http://great-singles-freeweb.com/index675.html http://great-singles-freeweb.com/index676.html http://great-singles-freeweb.com/index677.html http://great-singles-freeweb.com/index678.html http://great-singles-freeweb.com/index679.html http://great-singles-freeweb.com/index680.html http://great-singles-freeweb.com/index681.html http://great-singles-freeweb.com/index682.html http://great-singles-freeweb.com/index683.html http://great-singles-freeweb.com/index684.html http://great-singles-freeweb.com/index685.html http://great-singles-freeweb.com/index686.html teenage dating website , top 20 singles , datelines , win a date with porn , teenage dating age , friend finder , hot sexy date , dating in ireland , dating tips for teen guys , meet russian woman , singles online , teen dating sites , porn trailers , sexy women , teen statistics , women with women , where to meet older women , dating nl , mature date , tgp porn , new york bar exam dates , american matchmaking , naked sex , date sex porn , african women seeking men , comics porn , dating nu , dating service in new york , best place to meet women , find dates , sex teens , women with dildos , teen advise , teen personals , single man , women with strap on , women with dog , date married women , teen online dating sites , mature women , single men , online dating agency , photo personals , women seeking older men , dating , asian women seeking men , date agency , porn links , amerikanische single , interracial singles , women having sex with other women , mature women with big tits , adult dating personals , couples seeking woman , singles in the usa , women seeking love , irish dating agencies , dating website for teens , teen dating advise , single mothers in usa , usa hits , adult sex , speeddating , xxx date , singles net , marriage agency scams , dating ireland , married woman seeking , american dating services , new york magazine personals , introduction agencies , usa erotik , porn 08 , romantic dates in new york , dating ru , older women looking for younger men , married women seeking , sex numbers , sexy kitten sim date , christian teen dating , friendship , teen dating problems , porn pictures , porn thumbs , ohio dating services , sex date , porn movies , american singles , mature women seeking younger men , dating girls , nude porn , new york swingers , mature women with young girls , date porn games , woman with you , single dating , usa dating singles , women with small tits , women with eating disorders , adult cams , married women seeking men , dating dk , uk teen dating , sex chaten , dating de , porn dating , asian dating , marriage agency odessa , woman with big boobs , american dateing , dating uk , dating game , dating brides , teen adult dating , horny married women , top 10 usa singles , date marathon de new york , sex with pregnant women , teen dating fun , us dating , conversation with women , kostenlose singles , aussie matchmaker , amerikan singles , dating for teen , matchmaker dating , blinddate porn , billboard top usa singles , violence in teen dating , talk dirty , woman with pearl , cupid dating , american cupids , ohio single , russian dating agencies , sex logs , usa match , uk singles chart , dating rules , women with beards , adult sex chats , dating rules for teens , american singles sites , south american singles , porn video , women with short hair , porno date , billboard singles , singles personals , men meet women , american sites , teen dating questions , singles women , sex dates , teens dating older , great expectations , chinese dating , meet married women , prom date porn , love dating , usa single chart , woman with horse , 8 simple rules for dating my teenage daughters , beast dating , now singles , seeking a woman , teen dating and violence , sex with mature women , dating agency ireland , meet christian women , teens online dating , singles kontakte , american speed , new york match maker , catholic dating , women seeking american men , partnersuche singles , women with big butts , matchmaking , cd cover singles , beautiful women , married women sex , 8 simple rules for dating my teenage daughter episode , up to date porn , amerika single , women with hairy armpits , dating sex personals , date of new york , woman having sex with a horse , dating agency , teenage dating statistics , matchdoctor dating , women seeking husbands , cleveland personals , clips date , chatsex , old women with big tits , merced craigslist women seeking men , singles in new york , meet women online , speed dating new york city , matchmaking agency , hiv dating , singles agency , meet beautiful women , chats prono , miami dating , wedding agency , 8 rules to dating my teenage daughter , women with facial hair , sex bots , christian dating agencies , sex with black women , nude women , teen dating rules , woman seeking younger man , top 40 usa singles , seeking a women , women seeking sex , women with hair , new york concert dates , american single personals , amerikanische singles , dating and new york , flirt with women , matchmaking personals , connecting singles , shemale porn , erotic date , speed dating in new york , latin women seeking men , new york date , usa billboard singles , sex cam chats , teen dating quizzes , book of matches , online dating matchmaking , woman with animal , safe teen dating , sex dating , asian matchmaking , carbon dating , match personals , dating service new york , american personals , chats sexi , chatting females , wedding agencies , meet single girls , teen advice , dating web sites , woman looking for man , american sex , meet single women , guide to teenage dating , in love with a married woman , simple rules for dating my teenage daughters , married women seeking married men , jewish singles , women with huge breasts , sex uk , single usa , cheap phone sex , new york matchmaker , sim dating games , porn mpg , woman seeking man for sex , sex lines , porn stories , porn preview , usa singels , dates in new york , married women for sex , meet sexy women , ohio personals , older woman seeking younger man , live web cam , interracial matchmaking , women with dicks , russian dating agency , speed dating new york , hot married women , marriage agency romania , women fun , usa greatest hits , easy date porn , women seeking men in delhi , akron ohio dating , bbw dating , gay speed dating new york , matchmaking horoscopes , ohio dating laws , professional abuse , teen dating forums , american date , hitsville usa the motown singles collection , meet foreign women , asian date , wealthy women seeking men , great expectations dating agency , livesex , asian sex , teenage girl dating , tour dates new york , xxx webcams , eight simple rules for dating my teenage daughter , young porn , singles amerika , single women in usa , craigslist personals new york , games with naked women , women sites , mature dating , teen dating parents , how to meet married women , singles kontaktanzeigen , meet muslim women , teen dating guide , women seeking couple , women with big pussy , sexy ladies , teen dating violence stories , meet mature women , women with Tag: Need to add users from a CSV file to a security group Tag: 209767
  - 16
    - Get Operating System for all Computers in the Forest. Can anyone tell me why the "operatingSystem" field doesn't return anything, but using ADSI Edit there is a value. Please note there is no errors in the script when run. Many Thanks, SRT Code: commonNamePart = "*" Set objRootDSE = GetObject("LDAP://rootDSE") strRootAdsPath = "GC://" & objRootDSE.Get("rootDomainNamingContext") Set objConnection = CreateObject("ADODB.Connection") objConnection.Open "Provider=ADsDSOObject;" Set objCommand = CreateObject("ADODB.Command") objCommand.ActiveConnection = objConnection objCommand.Properties("Page Size") = 500 objCommand.CommandText = "<" & strRootAdsPath & ">;(&(objectCategory=computer)(cn=" & commonNamePart & "))" & ";operatingSystem,name;subtree" Set objRecordSet = objCommand.Execute If objRecordSet.EOF Then WScript.Echo "No Computer found with that name" Else WScript.Echo "Computer Name" & vbTab & "OS" Do Until objRecordset.EOF Wscript.Echo objRecordset.Fields("name") & vbTab & objRecordset.Fields("operatingSystem") objRecordset.MoveNext Loop End If objConnection.Close Tag: Need to add users from a CSV file to a security group Tag: 209765
  - 17
    - vbscript editors hi all, what editor would you recommend to write vbscript code (apart form notepad)? thanks a lot Tag: Need to add users from a CSV file to a security group Tag: 209750
  - 18
    - VBS Script/WMI results different in Windows PE 1.6 vs. Windows PE 2.0 I'm writing a small WMI script to return some information about the physical disks on a desktop. The script is to be called while Windows PE is running. Both versions of PE should support WMI, however, I'm getting different results depending on which version of PE I run the code under. I'm especially interested in getting the results for the value of InterfaceType. Under Windows PE 1.6, the value is Null and under Windows PE 2.0 the value is either IDE or USB (the correct values). All other values are returned normally. I read that Windows PE 2.0 does have expanded capabilities on what is available via WMI. I was just wondering if others had seen similar behavior or if there was a way to determine if the InterfaceType would ever be available under PE 1.6? Here is the script: *************** Sub ListDiskDriveInfo( strComputer ) Dim objWMIService, colItems Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root \cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_DiskDrive",,48) For Each objItem in colItems If objItem.InterfaceType <> "USB" then If objItem.MediaType = "Fixed hard disk media" then Wscript.Echo "Description: " & objItem.Description Wscript.Echo "DeviceID: " & objItem.DeviceID Wscript.Echo "Index: " & objItem.Index GIndex = objItem.Index + 1 Wscript.Echo "Ghost Index: " & GIndex Wscript.Echo "InterfaceType: " & objItem.InterfaceType Wscript.Echo "MediaType: " & objItem.MediaType Wscript.Echo "Name: " & objItem.Name Wscript.Echo "Partitions: " & objItem.Partitions Wscript.Echo "Size: " & objItem.Size Wscript.Echo "Status: " & objItem.Status Wscript.Echo "SystemName: " & objItem.SystemName Wscript.Echo "********************* " End If End If Next End Sub ' **************************************************************************** ' Main ' **************************************************************************** Dim strComputer '* Do '* strComputer = inputbox( "Please enter a computername or . for local computer", "Input" ) '* Loop until strComputer <> "" strComputer = "." ListDiskDriveInfo( strComputer ) ************** Tag: Need to add users from a CSV file to a security group Tag: 209746
  - 19
    - regex backreferance question I thought I was creating backreferances in this string " System Serial Number: 1036358 (oldwlrfsr200" with RegEx.Pattern = "(System Serial Number):(.*)\s($.*$)" I expected three MATCH items but the match was the whole string. I thought this would have created three matches, what happened? If I can create three matches from this string, how can I referance a match directly? Tag: Need to add users from a CSV file to a security group Tag: 209737
  - 20
    - Improving my script I have this test script: Option Explicit Dim sComputer, oWMIService, xServices, item sComputer = "." Set oWMIService = GetObject("winmgmts:\\" & sComputer & "\root\cimv2") Set xServices = oWMIService.ExecQuery("Select * from Win32_Service Where Caption='Alerter' AND State='Stopped'") For Each item In xServices If item.Caption = "Alerter" Then WScript.Echo "Doing some action because Alerter is stopped." End If Next Is there a way to determine if xServices is empty or not without using a For Each loop? For instance, if the Alerter service is started, the example script above should not have any items in the xServices collection. (btw, is xServices a collection or an object?) Thanks, Gill Tag: Need to add users from a CSV file to a security group Tag: 209736
  - 21
    - launching QuickTime I've been trying to figure out how to do this for a couple of days and I'm stumped. I'm trying to open up a QuickTime file and extract all the metadata from it (duration, size, etc.) I know this is possible, but I haven't seen anything in my searching about HOW to do it. Any help would be greatly appreciated. Brian Tag: Need to add users from a CSV file to a security group Tag: 209730
  - 22
    - Using and Array in an HTA I've taken one of my vbscripts that pre-creates computer accounts in the proper OU and threw it into an HTA. The script works quite well, but I'd like to make the domain selection drop down more dynamic. I've managed to get a list of the root domain and all it's child domains, but I need to filter out some duplicates before it goes into the drop down. What I've done is put all the data into an array and used the following code to filter out duplicates: Do Until objRecordSet.EOF strdnsRoot = join(objRecordSet.Fields("dnsRoot").Value) If objDictionary.Exists(strdnsRoot) Then objDictionary.Add strdnsRoot, strdnsRoot End If objRecordSet.MoveNext Loop The code works as it's suppose to, but when I try and dump it into the dropdown, nothing happens. For Each strKeys in objDictionary.Keys ServerSuccess.innerHTML = strKeys Next If I dump this in a standard vbscript and use wscript.echo to output the data it works properly. Am I missing something? Thanks. Tag: Need to add users from a CSV file to a security group Tag: 209729
  - 23
    - CopyHere keeps asking for overwrite confirmation Hello, I have a problem already addressed unsuccessfully in this newsgroup, but I'll try anyway. The following script (derived from another script published in this group) is supposed to extract a ZIP file to a temp folder and run a predefined installer, but the CopyHere method seems to ignore the FOF_NOCONFIRMATION and/or FOF_NOCONFIRMDIRCREATE options (in the last part of the script), as the file overwrite confirmation dialog keeps appearing. Could it be that CopyHere is fooled by the use of the Items method to enumerate the contents of the zip file? I'm looking for alternative solutions, but I cannot make use of any plugin, like a Winzip command line utility. Thank you, /_urka Option Explicit Dim WshShell, FS, SA, TempFolder, FilesInZip, PathToZipFile Const ZipFile = "\zipfile.zip" Const FileToRun = "installer.vbe" Const Params = "/S /L" Const Dest = "\whatever" Const FOF_NOCONFIRMATION = 16 Const FOF_NOCONFIRMDIRCREATE = 512 '=================================================================== 'Retrieves the current directory to create the full path to zip file '=================================================================== Set WshShell = CreateObject("WScript.Shell") PathToZipFile = WshShell.CurrentDirectory & ZipFile WScript.Echo "The zip file is in " & PathToZipFile & VBCRLF _ & "Click OK to proceed with the installation" '================================================== 'Creates a folder to extract the zip contents into '================================================== Set FS = CreateObject("Scripting.FileSystemObject") TempFolder = FS.GetSpecialFolder(2) & Dest If FS.FolderExists(TempFolder) = False Then FS.CreateFolder(FS.GetSpecialFolder(2) & Dest) End If '========================================================================== 'Extracts the zip contents into TempFolder overwriting without confirmation 'and launches the installer with the assigned parameters '========================================================================== Set SA = CreateObject("Shell.Application") Set FilesInZip = SA.NameSpace(PathToZipFile).Items SA.NameSpace(TempFolder).CopyHere FilesInZip, FOF_NOCONFIRMATION + FOF_NOCONFIRMDIRCREATE SA.ShellExecute FileToRun, Params, TempFolder Tag: Need to add users from a CSV file to a security group Tag: 209724
  - 24
    - WSH 5.6 downloads are back... WSH 5.6 downloads are back... Windows Script 5.6 for Windows XP and Windows 2000 / Windows Server 2003 Download details: Windows Script 5.6 for Windows XP and Windows 2000 <http://www.microsoft.com/downloads/details.aspx?familyid=c717d943-7e4b-4622-86eb-95a22b832caa&displaylang=en&tm> Download details: Windows Script 5.6 for Windows Server 2003 <http://www.microsoft.com/downloads/details.aspx?familyid=887fce82-e3f5-4289-a5e3-6cbb818623aa&displaylang=en&tm> -- Michael Harris MVP - Windows Server Admin Frameworks Tag: Need to add users from a CSV file to a security group Tag: 209706
  - 25
    - re: the 'switch to' message I am using VBScript to allow a program to pass data to Excel. Once the data is passed, the program re-opens the workbook which it has passed the data to in order to analyse. At certain stages during the running of the script, the following 'Server Busy' message appears: "This action cannot be performed because the other program is busy. Choose 'switch to' to activate the program and correct the program." I have been advised to use the 'objExcel.DisplayAlerts = False' instruction but this appears not to be working. Why is this happening and is there a way to avoid it? It happens at some points at certain occasions, and at other points every time the program is run. -- Charles Dean Tag: Need to add users from a CSV file to a security group Tag: 209704

I have a list of existing users in a CSV file, does anyone have a script that
I can use to add those users to an existing security group?

Thanks,

Carlos

Top

Re: Need to add users from a CSV file to a security group by Richard

Richard
Thu Sep 06 10:02:45 PDT 2007

Carlos wrote:

>I have a list of existing users in a CSV file, does anyone have a script
>that
> I can use to add those users to an existing security group?

I have an example VBScript program that adds users to a designated group
from a text file. The program is linked here:

http://www.rlmueller.net/Add%20Users%20to%20Group%202.htm

The text file must have user Distinguished Names, one per line. The program
expects you to pass the NetBIOS name of the group as a parameter (plus the
name of the file). It uses the NameTranslate object to convert the NetBIOS
name of the domain to the Distinguished Name.

The program could be revised to accept the NT names (sAMAccountNames, also
called the "pre-Windows 2000 logon name") for users in the text file. The
same NameTranslate object would be used to convert each name to
Distinguished Name. Maybe I should add another version of this program to my
web site that does that.

Comma delimited files are difficult to handle in VBScript. I have an example
linked here that uses a function. This function could be incorporated in a
program to add users to a group.

http://www.rlmueller.net/ReadCSV.htm

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--

Top