Script help please (unlock locked out accounts) NEWBIE

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
    - Batch file or VB script for more automated USMT? I have created individual batch files for scanstate and loadstate where I edit them for each user. I have to manually change the user name, manually change the file name of the batch files I create for each user, and manually name the share name and location where each user's data is saved. Is there a way to make this much easier, such as a batch file or VB script that simply prompts you for the user name and the site (user name entered at the prompt then being used to automatically choose the username for scan state and load for loadstate, as well as create/name a directory based on user name to store the USMT data. Site name entered would determine from what location scanstate and load state executables would run and where the data files would be saved so that it always saves the data to the local site of the user rather than across a WAN). Basically I want an interface that is very simple and prompts: Are you collecting data from the old PC or loading data to the new PC? (A or B) Which site? (4 choices) What is the user name? The person running the tool should only need to run the tool, enter the answers to those 3 prompts. They would run it from the old PC to collect the data, wait for the data to be saved to the network share, then run it at the new computer to load the data. It would great if it at least show a message saying loadstate or scanstate is in progress and then show when completed sucessfully. I doubt I could be the first person to think of this, so maybe something like this has already beeen created or else can someone help with this? Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194940
  - 2
    - RegExp Help Hi, Ok, this may be stupid on my part, but I hate asking for help since it is an affirmation that I am not as smart as I think I am.. Anyhow...I wrote a ADSI script that automates the creation of distribution groups. Sometimes users provide illegal or unsupported characters for the name of the group so I need to escape the characters in order to Put the distinguished name of the object. Most likely the name that is provided will only have one of these characters. I just don't understand the matches object well enough to use firstindex, etc...Here is some sample code I have. Thanks for any help provided. strData = "my+test?hel>lo" Set regEx = New RegExp regEx.Pattern = "\+|\?|\>" regEx.IgnoreCase = True regEx.Global = True Set Matches = regEx.Execute(strData) For Each match In matches StringToReplace = regEx.Replace(strData, "\" & match.value) Next Set regEx = Nothing WScript.Echo StringToReplace Output: my\>test\>hel\>lo Intended Output: my\+test\?hel\>lo Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194938
  - 3
    - How to read Registry STRING_EXPAND_SZ WITHOUT EXPANDING? How can I read a STRING_EXPAND_SZ value from the Registry and get the %SystemRoot% (or any other possible substitute string for that matter) verbatim, without being substituted? Thanks in advance. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194931
  - 4
    - VBScript and MSOffice Is it possible to harvest all the fieldnames and 1st line of data from all xls and mdb's using vbscript? The reason is to verify a company computer does not have SSN's or bank account or checking account files, or cc numbers on it. A policy might be in place but to actually audit hundreds of machines would take months, and by then I would need to audit again! To find all the files is easy, but to make things simple I would want to gleam all the data into a csv file with the machine name, filename and path in case you found one you would know where it came from. Is this out of the range of reasonable for vbscript? Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194919
  - 5
    - SQL query: Error as if column is not there? Hello, I'm having a strange problem. I get an error "Item cannot be found in the collection corresponding to the request name or orginal," even though WEISGSUPPORT is contained within the BladeAlias column: Set objRecordSet = objConnection.Execute("Select BladeOwner, CageSerialNum, SlotNum FROM SMBlades WHERE BladeAlias = 'WEISGSUPPORT';") Do While Not objRecordset.EOF strResults = strResults & objRecordSet("BladeAlias") & vbnewline objRecordset.MoveNext Loop I get the error at the first line in the do...loop. Why is this happening? It's driving me crazy! Thanks for the help, Matt Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194914
  - 6
    - Copy folder off network share, overright if existing, and run a specified program I have been fighting with this all morning. I need to copy a folder off of a network share, overright the folder if it exists on the local machine and run a specified program with switches as a administrator. Can you please help with this. Network Share path \\server\software\folder Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194906
  - 7
    - Creating a Link Checker So my boss has been killing me about creating a link checker, what I need to know is there a sample script somewhere to get me started on creating a checker? Basically we have a ton of links and want to check if they are valid as in not hardcoded, not sure I want to check if the link is actually working cause that might not be an easy thing to pull off. Reason I am doing vbs is cause we cannot install anything on our server and running something client side is not dependable. With a vbs file I can just schedule it and produce a report and email it to myself or anyone else who needed to see if there were broken links. Any leads to good example scripts? Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194904
  - 8
    - Bulk Delete groups from AD I am trying to bulk delete groups from AD using VBScript. I have a list of the distinguished names of the groups in an Excel spreadsheet. My problem is that the groups span accross several domains in my AD forest and i am unable to find a script which will delete an object purely by the distinguished name. All the scripts i have found have to at least bind to the domain container first. Can anyone help me with this? Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194902
  - 9
    - Date Conversion from DD/MM/YYY hh:mm:ss to YYYYMMDDhhmmss I would like to make a date conversion from DD/MM/YYY hh:mm:ss to YYYYMMDDhhmmss in vbscript. Thanks for your help. youyoupapayou Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194899
  - 10
    - I'm tring a VBscripting to send a fax, can someone please help me? Hey.. I'm running some vba code to change a certain sheet accordingly to some information. This sheet then should be faxed to a certain client, the problem is that Every sheet differs to their respective client and ther's 500 clients. How will I be able to send every sheet to it's respectible customer, with the click of one button? I can already print every sheet with the specific information, but how will I fax it without having to enter the details of 500 people, can I use a vbscript file and how do I do that? Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194898
  - 11
    - Web expression Hi, I would like to know is there a generic rule that I can follow to determine if the string is a valid URL? eg. prefix is http, www...etc. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194896
  - 12
    - Error message I have created a kixform login script (I've also posted this question on the kixforms board). The form contains a hyperlink to the H: drive and a hyperlink to the S: drive. The first time I click either I get an error message simillar to: Windows cannot find 'ldist,:1588:4064,h:\' Make sure you typed the name correctly, and then try again. To search for a file, click on the Start button, and then click search. After I click on OK and then reclick on the link, everything works fine. Has anyone experienced anything simillar to this? Thanks, Jeremy Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194894
  - 13
    - detect if a sidebar panel is open in IE I am using this script to open sidepanels in IE: <script language="VBScript"> set objShell = CreateObject("Shell.Application") bReturn = objShell.ShowBrowserBar("{FF059E31-CC5A-4E2E-BF3B-96E929D65503}", true) </script> but I can only open panels, not close them, because I don't know how to detect whether a panel is already open. I'd like to have it this way: if panel=open then objShell.ShowBrowserBar("{FF059E31-CC5A-4E2E-BF3B-96E929D65503}", true) else objShell.ShowBrowserBar("{FF059E31-CC5A-4E2E-BF3B-96E929D65503}", false) end if Is it possible to detect the state of side bars in IE? If yes, please provide the necessary code. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194892
  - 14
    - Using Run to access Start Is there a way to use WScript.Shell's Run method to invoke Start? The reason is that I want to get ahold of a pseudo-hidden environment variable, %cmdcmdline%. For example, if (on Win XP) at the Cmd window you type: SET XY=%cmdcmdline% SET you will see how that cmd window was invoked (simply typing echo %cmdcmdline% might lead to odd results). Start has the characteristic, that it will preserve the environment variable settings. Thus, if at the Cmd window you type: START cmd.exe SET XYZ=%cmdcmdline% SET you'll see that the results are the same as for the original Cmd window. That is why I would like to be able to use CreateObject('WScript.Shell')->Run to invoke Start. However, Run seems not to know about Start. Any ideas? Or perhaps someone has a better method? I've tried Set aEnv=CreateObject("WScript.Shell").Environment("Process") then aEnv('cmdcmdline'), aEnv('=cmdcmdline'), and friends without success. Thanks, Csaba Gabor from Vienna Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194890
  - 15
    - knowing if LAN is working Hi, I would like to start a simple visual basic script, or batch file, as soon as the connection to the LAN is working. My problem is: how can i know when the LAN is working? I would need something like this: LanWorking = False; while ( LanWorking == False ) wait 1000 LanWorking = CheckLan( ) ... how can I do this? thanks for every help! Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194885
  - 16
    - move program window location after opening I would like to open a program window, example the command prompt and move its location on the screen. I would like to move it to the left corner or right corner of the screen. I can use the RUN command to execute the program - but it opens at any location on the screen, I need to force it to open on the left hand or right hand corner - fixed location every time the vbscript is run. Thanks in advance. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194882
  - 17
    - Script checks for computer membership in group I am new to scripting and I am trying to figure out how to do the following: Have a login script check to see if the computer running the script is a member of a specific group. If it is, then do one thing. If not, then do something else. I am using VBScript to map drives based the users group membership but I am not sure how to check the computer group membership. Any advice? F. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194881
  - 18
    - Codeaholic's StandardLibrary.vbs Someone asked for my StandardLibrary.vbs file. After some weeks in close combat with the "black dog" (an animal I'm sure some of you are, unfortunately, familiar with) I have finally struggled out of the pit long enough to get in posted: <http://codeaholic.blogspot.com/2006/08/vbscript-standard-library.html> Kind regards, Bruce. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194878
  - 19
    - Help with Permission Denied Hi Folks, Need a hand here. I just got a new Car Stereo that takes SD cards, but the file format is WAY different than what Windows Media player synchs to the cards. I'm trying to read a .m3u playlist file and take each song and copy it to the SD card in a 8 character folder name of the play list. I keep getting "Permission Denied" errors. The music lives on a server in my house and I'm attempting to copy mp3 over the network to my SD card local to my client by double clicking on the .vbs file. Here is the script so far: (PS, it's not optimized, or cleaned up) ------ Set objFSO = CreateObject("Scripting.FileSystemObject") Dim PlayListName Dim SFNPlayListName Dim PlayListFile Dim SDCardDrive ' Changable Playlist Options PlayListName = "Driving Trax" PlayListFile = "\\server\Music\Playlists\Driving.m3u" SFNPlayListName = "DRVNG" SDCardDrive = "G:" 'Check to see if the target exists, if it does, delete it DestDir = SDCardDrive & "\" & SFNPlayListName If objFSO.FolderExists(DestDir) Then Set DelFolder = objFSO.GetFolder (DestDir) DelFolder.Delete End If 'Re create the folder and prep for copy Set MakeFolder = objFSO.CreateFolder(DestDir) Const ForReading = 1 Set plFile = objFSO.OpenTextFile(PlayListFile, ForReading) Do Until plFile.AtEndOfStream txtLine = plFile.ReadLine If Len(txtLine) <> 0 Then If Left(txtLine, 1) <> "#" Then 'Wscript.Echo ("Copy " & txtLine & " to " & DestDir) If ObjFSO.FileExists(txtLine) Then Set ws = WScript.CreateObject ("WScript.shell") ObjFSO.CopyFile txtLine, DestDir ' Permission Denied here! End If End If End If Loop plFile.close Wscript.Quit ----- I labelled the line I get permission denied on, I can't for the life of me figure out why, because if I take the commented "echo" line and copy and paste it into a CMD window, it works fine. Moreover, if I replace that permission denied line with: Call ws.run("cmd.exe /c copy " & Chr(34) & txtLine & Chr(34) & " " & DestDir & "\") It works fine (although it opens up about 80 CMD windows and freezes explorer until the copy is complete). Any idea why I'm getting permission denied here? Does the WSH block access to copy files (I was able to delete above?!?) or something? Thanks for the help! Sean Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194877
  - 20
    - About create users and move them to appointed OU. Hi, everyone. I am going to create 10 users who names client 1 to client 10, and then move them to the appointed OU which names "SYS" I prepared 2 vbscripts. 1st: create 10 users: source code: Set objRootDSE = GetObject("LDAP://rootDSE") Set objContainer = GetObject("LDAP://cn=Users," & _ objRootDSE.Get("defaultNamingContext")) For i = 1 To 10 Set objLeaf = objContainer.Create("User", "cn=Client" & i) objLeaf.Put "sAMAccountName", "UserNo" & i objLeaf.SetInfo Next WScript.Echo "Users created." 2st: move them to OU (the name for ou is "SYS") Const ADS_PROPERTY_APPEND = 3 Set objRootDSE = GetObject("LDAP://rootDSE") Set objContainer = GetObject("LDAP://cn=Users," & _ objRootDSE.Get("defaultNamingContext")) Set objOU = objContainer.Create("OU", "cn=SYS") objOU.Put "sAMAccountName","SYS" objOU.SetInfo For i = 1 To 10 strDN = ",cn=Users," & objRootDSE.defaultNamingContext objOU.PutEx ADS_PROPERTY_APPEND, "member", _ Array("cn=UserNo" & i & strDN) objOU.SetInfo Next WScript.Echo "Users added to the OU." But , oh no, script failed. who can tell me what's wrong with "it" (I mean the script)? Thanks for everyone. Hope everything goes well with you. KejiaLi coming from China email: kejiali@gmail.com Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194876
  - 21
    - Function help Hi, I have a stream which returns a value as shown below, 1190 Chris Grove 1058 GEORGE EVANS 1231 Susan D Elowson How do I return just the Numbers preceding the names? Any help is sincerely appreciated. Thx, Sunny Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194875
  - 22
    - Local Account: PasswordLastChanged Anyone successful getting passwordlastchanged on local accounts? I can get this for domain accounts but the same vbs code (using the WinNT provider) doesn't seem to work for local accounts. TIA Dave Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194871
  - 23
    - How to create a script to execute an application in the "Visual C++ 6" Hi, My objective is to execute an application that is in the directory of the open project. For in such a way i created this script: language="VBScript" function fnShellExecuteVB() dim objShell set objShell = CreateObject("Shell.Application") objShell.ShellExecute "notepad.exe", "", "", "open", 1 set objShell = nothing end function Sub test() fnShellExecuteVB End Sub In this script I am trying to execute notepad.exe as test and am receiving the following message from error: "Permission Denied" please, somebody knows what to make to execute an application in a macro in the "Visual c++ 6"? And how to obtain the directory of an open project? much thankful, helin Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194869
  - 24
    - VB Script for RegEx file processing ' VB Script Document option explicit Dim objRegExpr Set objRegExpr = New regexp Dim InputFileName, OutputFileName, Result objRegExpr.Pattern = InputBox("Regex String :","RegEx","CUSTOMER TOTAL\s+=\s+[0-9\.]+") if ( objRegExpr.Pattern <> "" ) then ' for cancel. InputFileName = InputBox("Input file path and name :","Input File","y:\fix\roc\dated.txt") if ( InputFileName <> "" ) then ' for cancel. OutputFileName = InputBox("Output file path and name :","Output File","Regex.txt") if ( OutputFileName <> "" ) then ' for cancel. if ( MsgBox ( "Process file?", vbOKCancel, "Process") = vbOK ) then objRegExpr.Global = True objRegExpr.IgnoreCase = True Dim colMatches Dim objMatch Dim RetStr Dim objFSO,objFileRead,objFileWrite,strLine Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFileRead = objFSO.OpenTextFile(InputFileName, 1, false) Set objFileWrite = objFSO.CreateTextFile(OutputFileName) Do While objFileRead.AtEndOfStream = False strLine = objFileRead.ReadLine Set colMatches = objRegExpr.Execute(strLine) For Each objMatch In colMatches ' Iterate Matches collection. objFileWrite.WriteLine(objMatch.Value) Next Loop end if end if end if end if Wscript.Echo "Regex Done" Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194868
  - 25
    - Permissions needed to query ROOT\MicrosoftExchangeV2? I have a script that queries mailboxes using: strComputer = ExchServer Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & _ "\ROOT\MicrosoftExchangeV2") ...but it is failing on GetObject with "permission denied". What permissions do I need to query MicrosoftExchangeV2? I've already given it full access on MicrosoftExchangeV2 via the WMI CPL. I've also made it an Exchange Admin. The only way I can get it to successfully query is making it a Domain Admin or Local Admin of the Exchange server. Thanks Trevor Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194867
- Next
  - 1
    - change administrator password for all client in a domain I want make a script so that it can change all the adminitrator password of the clients in the domain. thank you Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194861
  - 2
    - Rename a local user account via WMI or ADSI I am looking for any method to rename a local user account via WMI or ADSI or any other means that would be resident on W2K, WXP, W2K3, &&> -- Semper Fi, Red Please post to newsgroup only Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194840
  - 3
    - email settings Is there a way to get the users email information from running a script on the users desktop, the info i need is email address mail server additional mail boxes if any shared calendars pst files Thank you Bob Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194839
  - 4
    - VBscript to change excel cell values I need to open an excel spreadsheet and with a vbscript take the value in column 1 and parse it into column 2 and 3. Right now the spreadsheet only has this column 10.1.1.2/24 10.2.2.2/24 I need to run a script that will convert the spreadsheet into this format with 3 columns. 10.1.1.2/24 10.1.12 24 10.2.2.2/24 10.2.2.2 24 Would I use a script something like this: Option Explicit Dim strSheet, intRow Dim objExcel, objSpread Dim strComputer strSheet = "c:\test.xls" ' Open the Excel spreadsheet Set objExcel = CreateObject("Excel.Application") Set objSpread = objExcel.Workbooks.Open(strSheet) intRow = 2 'Row 1 often containes headings ' Here is the loop that cycles through the cells Do Until objExcel.Cells(intRow, 1).Value = "" strComputer = objExcel.Cells(intRow, 1).Value intRow = intRow + 1 Loop objExcel.Quit WScript.Quit What do I place in the loop to accomplish the copy paste and parse? Thanks for your help. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194835
  - 5
    - sendkey ENTER to a remote computer I need to send an enter key to a remote computer. I would prefer not having a vbscript on the remote if possible. I understand there are a few ways of doing this so any and all suggestion are welcome. I am running windows xp and need vbs code to sendkey ENTER to 50 computers on a network. I tried creating a file on the remote machine located at "C:\Script\SendEnter.vbs" to try and run remotely because i understand it is not possibly to sendkeys remotely but I cant seem to launch it. I was also thinking about dynamically creating script and running it on the the remote but I can't seem to get an application to run interactively on a remote machine either. this code works. On the remote machine, a "notepade.exe" process is running but there is no visible notepad to interact with. So I was unable to run a vbs file to send the Enter Key using this approach. strComputer = "RmoteMachine" Set objReg=GetObject( _ "winmgmts:{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\CIMV2:Win32_Process") result = objReg.Create ("notepad.exe", null, null,procID) I have also tried the following which returns an activeX object error. set oController = CreateObject("WSHController") set oProcess = oController.CreateScript ("C:\Script\SendEnter.vbs", strComputer) oProcess.Execute While oProcess.Status <> 2 WScript.Sleep 100 WEnd WScript.Echo "Done" All I would like to do is send an ENTER key to an active popup window on a remote machine during a login. Thanks for your assistance. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194831
  - 6
    - WMI: Memory Type, Intel GMCH & ICH Are there WMI classes available that will report the following?: Memory Type (DDR, SDR, etc.) GMCH version/stepping (Intel Graphics & Memory Controller Hub) ICH version/stepping (I/O Controller Hub) Thanks, -- Bill Baker Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194826
  - 7
    - Setting HTML based wallpaper? I've got a script that will set the wallpaper to an ActiveDesktop, HTML based wallpaper. I can set the wallaper, but without a reboot or opening the desktop properties and toggling the wallpaper choice, the settings don't apply immediately. If there a way to refresh the desktop or force a refresh programatically, and without having to pop up the desktop proeprties window? Here's my scritpt as it stands right now: '~~~~~~~~~~~~~~ BEGIN CODE ' Set the wallpaper path WP = "%SystemRoot%\Web\Wallpaper\ActiveWallpaper.html" ' Edit the registry to set the wallpaper choice Set objShell = CreateObject("WScript.Shell") objShell.Regwrite "HKCU\Control Panel\Desktop\WallPaper", "" objShell.Regwrite "HKCU\Control Panel\Desktop\TileWallPaper", 0 objShell.Regwrite "HKCU\Control Panel\Desktop\WallPaperStyle", 0 objShell.Regwrite "HKCU\Software\Microsoft\Internet Explorer\Desktop\General\WallPaper", "" objShell.Regwrite "HKCU\Software\Microsoft\Internet Explorer\Desktop\General\TileWallPaper", 0 objShell.Regwrite "HKCU\Software\Microsoft\Internet Explorer\Desktop\General\WallPaperStyle", 0 objShell.Regwrite "HKCU\Software\Microsoft\Internet Explorer\Desktop\General\WallPaper", WP objShell.Regwrite "HKCU\Control Panel\Desktop\WallPaper", WP ' Open the Desktop Properties window and toggle/apply to force the desktop objShell.Run "control desk.cpl" WScript.Sleep 300 objShell.AppActivate "Themes" WScript.Sleep 300 objShell.SendKeys "{tab}" WScript.Sleep 300 objShell.SendKeys "{tab}" WScript.Sleep 300 objShell.SendKeys "~" Set objShell = nothing '~~~~~~~~~~~~~~ END CODE Obviously, I'd like to apply the wallpaper without rebooting or having to mess with the desktop properties window. Any help would be greatly appreciated! Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194818
  - 8
    - Adjust computer discription from Excel to Active directory I want to update computers description using an excell with the computername and the discription. new discription should be added behind any existing description for the computer in Active directory. this is the code i have but i'm stuck: Dim Row As Integer Dim oUser As IADsUser Dim oComp As IADsComputer Dim HowMany As Integer Set RootDse = GetObject("LDAP://RootDSE") DomainContainer = RootDse.Get("defaultNamingContext") 'Set oOU = GetObject("LDAP://OU=Test,OU=EU Users,DC=EU,DC=qplas,DC=com") Set conn = CreateObject("ADODB.Connection") conn.Provider = "ADSDSOObject" conn.Open "ADs Provider" Row = 2 HowMany = 0 Do Until Cells(Row, 1) = Empty Name = Trim(Cells(Row, 1).Value) Description = Trim(Cells(Row, 2).Value) 'Construct an LDAP query to Active Directory looking for users with the specified attributed, 'first name, last name, address, etc. 'LDAPStr = "<LDAP://" & DomainContainer & ">;(&(objectCategory=user)(givenName=" & gname & ")(sn=" & sname & ")(streetaddress=" & mailingaddress & ")(l=" & city & "));adspath;subtree" ldapstr = "<LDAP://" & DomainContainer & ">;(&(objectCategory=computer)(Name=" & Name & "));adspath;subtree" Set RS = conn.Execute(ldapstr) If RS.RecordCount > 0 Then Set oComp = RS.Fields(0) If Description <> "" Then tmpDiscription = oComp.Get("Description") finaldiscription = tmpDiscription + " - " + Description oComp.Put "Description", finaldiscription End If oComp.SetInfo HowMany = HowMany + 1 Else MsgBox Name & " Not found" End If Set oComp = Nothing Set RS = Nothing Row = Row + 1 Loop MsgBox HowMany & " computers updated" End Sub code blocks when here: Set oComp = RS.Fields(0) i can't get my computer object out of the Recordset. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194809
  - 9
    - XML Help In my VB script I generate an XML object which has XML of the form (see below). It has to be like this as I get the XML from an API What I need to next in my ASP page is parse the XML in name value pairs - however I need to sort on the 1st value e.g I need something like this 5 65-MOV-317 5 65-MOV-318 5 65-MOV-319 5 65-MOV-330 5 66-MOV-317 3 65-MOV-001 3 65-MOV-002 3 65-MOV-003 3 65-MOV-331 3 66-MOV-315 etc..... I haven't a clue how to achieve this, please any help would be greatfulyl recieved <Report> - <Row> - <Column> <Value>1</Value> </Column> - <Column> <Value>65-MOV-317</Value> </Column> </Row> - <Row> - <Column> <Value>5</Value> </Column> - <Column> <Value>65-PV-636</Value> </Column> </Row> - <Row> - <Column> <Value>5</Value> </Column> - <Column> <Value>65-RV-113</Value> </Column> </Row> - <Row> </Report> Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194808
  - 10
    - Can you create a timed loop? I am attempting to shorten the default timeout period when mapping a network drive via a logon script (useful when the server is down) from the default of 45-50 seconds to 10 seconds. Users with a dozen or more mappings affected like this can end up waiting 10+ minutes for the logon script to complete. Does anyone know a way to do this in VBScript? (NOTE: I don't want to go the one size fits all setting, a timeout on the whole script via Properties > Script > Stop script after specified number of seconds.) i.e. Do (loop for up to the next 10 seconds while waiting for this operation to complete) objNet.MapNetworkDrive L:,\\srvname\share Loop -Chris Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194801
  - 11
    - Issue with users losing rights to their registry (Script help) Hello all. I been having an issue with users that logon to terminal services losing permissions in the registry. To try to narrow it down to a specific server an trying to write a logoff script that tries to write a value to the registry and logs the server, user and time that the error occurs. The issue is that I cannot trap the error using regWrite.. is there a better way... Or a way I can through a script verify if a user has rights to their hive on logoff.. Any help would be awesome.. Here is what I have so far. Set sho = CreateObject("Wscript.Shell") Set fso = CreateObject("Scripting.FileSystemObject") Set nwo = CreateObject("WScript.Network") If Not fso.FolderExists("c:\applog") Then fso.CreateFolder("c:\applog") End If 'Set outFile = fso.CreateTextFile("\\GO001W2K037\profiles4\HiveLog\Hivelog.txt",8) If Not not fso.FileExists ("C:\Applog\Hivelog.txt") Then Set outFile = fso.CreateTextFile("C:\Applog\Hivelog.txt",8) Else Set outFile = fso.openTextFile("C:\Applog\Hivelog.txt",8) End If strMachineName=sho.expandenvironmentstrings("%computername%") strUserName=sho.expandenvironmentstrings("%username%") Checkit=sho.RegWrite("HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\System\ICANDOIT",0,"REG_DWORD") If Checkit <> 0 Then outFile.Writeline (VbCrLf) outFile.Writeline ("User: " & strUserName & VbCrLf & "Server: " & strMachineName & VbCrLf & "Time: " & Now) End If outFile.Close WScript.Quit Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194798
  - 12
    - Insert Data I try to insert some data in my table name customer(Customer_Name, Street, Account_No) from data: [Customer's Name] [Street] [Account Number] How to i do that needs help ----------------------------------------------------- Set con = Server.CreateObject("ADODB.Connection") sConnection ="Provider=MSDASQL.1;Persist Security Info=False;Data Source=emp1" con.Open(sConnection) Function EnumerateFolder( sFolder ) Dim fso, ts, data Set fso = CreateObject("Scripting.FileSystemObject") Set fol = fso.Getfolder ( server.mappath(sfolder) ) For each fil in fol.files Set customer = CreateObject("Scripting.Dictionary") Set ts = fil.openastextstream(1) ary = Split(ts.ReadAll(),"[") ts.Close For i = 1 to Ubound(ary) data = Split(ary(i),"]") customer.Add data(0), data(1) Next next End Function EnumerateFolder "c:\txt" Function test(s) Select Case s Case "[Dat" test = True Case "[Nov" test = True Case "[Sub" test = True Case "[Cus" test = True Case "[Str" test = True Case "[Cit" test = True Case "[Acc" test = True Case "[Ins" test = True Case "[Las" test = True Case "[PPV" test = True Case "[Mon" test = True Case "[Cur" test = True Case "[Typ" test = True Case "[Lan" test = True Case "[CRC" test = True Case "[Eve" test = True Case "[Sum" test = True Case "[Box" test = True Case "[MD" test = True Case "[Con" test = True End Select End Function -----SAMPLE DATA----- [Date] Sat Aug 05 14:06:12 EDT 2006 [Novell ID] NSMITH4 [Subject] PPV / VOD Research - Dispute - 1st Time - 711579 [Customer's Name] EDWARD CAMPBELL [Street] 5 WHEELER AVE APT 2 [City, State, Zip] BRIDGEPORT CT, 06606 [Account Number] 006-0416-08 [Install Date] 06/21/2001 [Last Known Event Date] 06/29/2006 [PPV Hold] No [Monthly Rate] 186.52 [Current Services] Optimum Voice OOL FamilyorAbv OR$20Discount iO Silver Pkg iO Box PPOF Addset: C/Rdy OV World Call OV Ported Number [Type of Request] Dispute - 1st Time [Language] English [CRC PIN Instructions] Yes [Event Numbers/Date Range] #77922 6/29, #78306 6/29, #77716 6/28, #77312 6/28 [Summary] cust states that they and no one in the household ever ordered those ppv movies.cust requesting credit of $35.80. [Box Verification by Customer] 2,SABKDTHBF,Yes,Yes,Yes,Yes [MD Page ID] 1 [Control Number] 651789 Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194797
  - 13
    - Help with cancelling a meeting with webdav I don't get it, what am I missing here? It sends the meeting no problem, but not as a canclled meeting, and it does remove the meeting from the calendar, but the sent e-mail is not cancelled. Any ideas? Set XMLreq = CreateObject("Microsoft.xmlhttp") XMLreq.open "PROPPATCH", oField, False, sDomain&sUserName, sPasswd xmlstr = "<?xml version=""1.0""?>" _ & "<g:propertyupdate "_ & " xmlns:g=""DAV:"" "_ & " xmlns:e=""http://schemas.microsoft.com/exchange/"" "_ & " xmlns:mapi=""http://schemas.microsoft.com/mapi/"" "_ & " xmlns:mapit=""http://schemas.microsoft.com/mapi/proptag/"" "_ & " xmlns:x=""xml:"" xmlns:cal=""urn:schemas:calendar:"" "_ & " xmlns:dt=""urn:uuid:c2f41010-65b3-11d1-a29f-00aa00c14882/"" "_ & " xmlns:header=""urn:schemas:mailheader:"" "_ & " xmlns:mail=""urn:schemas:httpmail:""> "_ & " <g:set> "_ & " <g:prop> "_ & " <g:contentclass>urn:content-classes:calendarmessage</g:contentclass> "_ & " <e:outlookmessageclass>Ipm.Schedule.Meeting.Canceled</e:outlookmessageclass> "_ & " <e:x-priority-long dt:dt=""int"">2</e:x-priority-long> "_ & " <mail:subject>"&oRs.Fields("urn:schemas:httpmail:subject").value&"</mail:subject> "_ & " <mail:htmldescription>User Termination, Meeting Cancelled: "&oRs.Fields("urn:schemas:httpmail:subject").value&"</mail:htmldescription> "_ & " <header:cc>"&ccfield&"</header:cc> "_ & " <header:bcc>"&bccfield&"</header:bcc> "_ & " <header:to>"&tofield&"</header:to> "_ & " <cal:meetingstatus>CANCELLED</cal:meetingstatus> "_ & " <cal:dtend dt:dt=""dateTime.tz"">"&endtime&"</cal:dtend> "_ & " <cal:dtstart dt:dt=""dateTime.tz"">"&starttime&"</cal:dtstart> "_ & " <cal:alldayevent>"&isallday&"</cal:alldayevent> "_ & " <cal:busystatus>"&oRs.Fields("urn:schemas:calendar:busystatus").value&"</cal:busystatus> "_ & " <cal:method>CANCEL</cal:method> "_ & " <cal:instancetype dt:dt=""int"">"&oRs.Fields("urn:schemas:calendar:instancetype").value&"</cal:instancetype> "_ & " <cal:responserequested dt:dt=""boolean"">0</cal:responserequested> "_ & " <cal:removefromcalendar dt:dt=""boolean"">1</cal:removefromcalendar> "_ & " <cal:uid>"&oRs.Fields("urn:schemas:calendar:uid").value&"</cal:uid> "_ & " <mapi:appstateflags dt:dt=""int"">7</mapi:appstateflags> "_ & " <mapi:finvited dt:dt=""boolean"">1</mapi:finvited> "_ & " <mapi:responsestatus dt:dt=""int"">1</mapi:responsestatus> "_ & " <mapi:responsestate dt:dt=""int"">0</mapi:responsestate> "_ & " <mapi:response_requested dt:dt=""boolean"">0</mapi:response_requested> "_ & " <mapi:busystatus dt:dt=""int"">0</mapi:busystatus> "_ & " <mapi:intendedbusystatus dt:dt=""int"">0</mapi:intendedbusystatus> "_ & " </g:prop> "_ & " </g:set> "_ & " </g:propertyupdate> " Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194786
  - 14
    - Case Select, Printers comparing IP addresses Hi All, I interested in a small project. I have a vbscripts to find the IP address of the local machine. I would like the 3rd octet of the IP to be compared to a list using Case Select to allows users to choose printers avaliable in their own building. IP is detected 3rd Octet is stored in a variable That varible becomes one of the Case Select choices The Case Select then presents a list of available printers. Any Ideas? Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194777
  - 15
    - Session Variables in Firefox Hello, I am using ASP/VBScript. For some reason, Firefox will not pass my session variables, while IE and Netscape will. I can't imagine what's wrong. I was able to recreate the problem with the two test pages below. I tested these pages in the three aformentioned browsers: FFTEST1.ASP <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Page 1</title> <meta name="GENERATOR" content="Microsoft FrontPage 6.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> </head> <body> <% Session("fftest") = "Hello!" %> <p><a href="fftest2.asp">Go to second page >>></a></p> </body> </html> FFTEST2.ASP <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Page 2</title> <meta name="GENERATOR" content="Microsoft FrontPage 6.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> </head> <body> <% = Session("fftest") %> </body> </html> What could the problem possibly be? Thanks for any help you can give. Chris Smith Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194776
  - 16
    - Login Alias This there a WMI 32 class that can get the current login alias, I want to make a text file with the alias. I currently use the script below to open a text file. strComputer = "." Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFSO.CreateTextFile("c:\software.tsv", True) Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194775
  - 17
    - How to run a Script using the System account I'm trying to run a script to find out the ACL for all the folders on oneof my file servers, but since I also dont have access on some of the folders like finance and HR, the script fails. The only way I can think of without changing the permissions on the HR and Finance folders is to run the script using the builtin SYSTEM account. If anybody know how to run a script using the system account, please let me know. Cheers Arvind Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194769
  - 18
    - Open Folder Location Using HTA I've never had a problem opening a folder location until this one. The location I want to open is: C:\Documents and Settings\%username%\Local Settings\Temporary Internet Files The two methods I would typically use are below. Set objShell = CreateObject("Wscript.Shell") objShell.Run "C:\Documents and Settings\%username%\Local Settings\Temporary Internet Files" -- OR -- Set objShell = CreateObject("Wscript.Shell") ShellRun = objShell.Run ("%comspec% /c Start "C:\Documents and Settings\%username%\Local Settings\Temporary Internet Files", 0, 1) I understand its due to the spacing in Temporary Internet Files as the path can be written: C:\DOCUME~1\tmaynard\LOCALS~1\Temporary Internet Files. I either need an environmental variable I've overlooked, a way to include spaces (all my attempts at single quotes don't work) or another method all the way around. Thanks, Tommy Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194768
  - 19
    - mssqlserver scripting Does anyone know if there is a scripting object that allows you to interface with Microsoft SQL Server? I would like to query such things as the number of SQL instances, and the location of their logfiles. A similar object to the one for IIS (IIS://LocalHost/W3svc) would be ideal. Many thanks, Neil Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194767
  - 20
    - Variable not being passed Hello, I'm hoping someone can help me with this. We have change all our login scripts to vbscripts instead of batch files. All works great except on two machines. They get an error saying cannot find netlogon because the script has strDomainServer =%logonserver%\netlogon on one of the lines. The thing is, I can do a Start-Run %logonserver%\netlogon and it opens the folder on the domain controller just fine. I changed the script to strDomainServer =\\"mydomain.com", but that won't work either, but I think it might be getting hungup on a different variable now. For whatever reason, it doesn't appear that the machine can pass the variable info on (ie. computer name, user name). Does anyone have any suggestions? I could reformat the machines, but would rather fix the problem. Thanks! Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194762
  - 21
    - Help needed for a script Hi, I need some help for writing a script. My problem is this. I have a pile of 200 or so floppy disks. I have to get all the contents from each disk into a separate folder on a hard drive. I have looked at the floppies some of them have Volume names and some of them don't. I would like to keep the volume name if it exists and use it for naming the folder. I suspect that maybe some od the floppies have identical volume names and so I mus t have away to differenciate between any two floppies (and folders) which would have the same name. I think that adding a timestamp to the name of the folder would be OK. I have looked at the floppies - again - some of them have viruses !! and some of them don't. So this is what I'd like to do. 1. Put the floppy in the floppy drive. 2. Click on a vbscript that would Read the voulume name Run my AV programme to scan for viruses and let me deal with any bad things Make a new unique folder on the hard drive XCopy a:\*.* /s with all subfolders and hidden and system files to the new unique folder. Give me a yell when it's done! 3. Ask for anew floppy and start over again Maybe I should deal with the viruses first and then run a simpler script that would just copy ? Anyway, any help appreciated. TIA AMD Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194760
  - 22
    - Wscript.Shell Issue Hi, I use the following vbscript for opening the documents in their respective exe's i.e., a .doc file in WINWORD.exe and a.txt file in Notepad.exe. <script language=VBScript> Sub ShowFiles(fileLink) Set objShell = CreateObject("Wscript.Shell") objShell.Run fileLink End Sub </script> fileLink - The path comes from the Database For this script to work properly, I have enabled the ActiveX controls settings in the Internet Explorer - Tools options. As per our design, on the click of an image that lies next to the document name column in a Datagrid, the document should open in the intended exe. But this does not happen all the time. Sometimes it opens the document but most of the time it throws a script error as "The System cannot find the specified file path.". But if I take the path from "View Source" property and place it in the "Run Window" I am able to access the file. Please help me in resolving this issue. Thanks in advance. -- Samba! Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194757
  - 23
    - Local groups that user belongs to Hello! I need a script, that will list me all user and groups, that he belongs to. But in special way: user1 group1 group2 group3 user2 group1 group2 etc I have this script, but i don't know how to change it.... :( Set colGroups = GetObject("WinNT://.") colGroups.Filter = Array("group") For Each objGroup In colGroups For Each objUser in objGroup.Members If objUser.name = "test" Then Wscript.Echo objGroup.Name End If Next Next Anyone help me? Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194751
  - 24
    - execute a file from vbscript hello to all. how can I execute a file (file.cmd or file.bat, or another) from vbscript? thank you in advance. greetings.. Scorpion. Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194750
  - 25
    - Fill the field... Hi. I wonder if it is possible to resolve my task with only VBScript. I want to add to IE context menu an item wich fill any field in web-page with some text. Through my little research I've discover how I can add the "fill text" to context menu wich point to any script file i wosh. But I can't realise how to write this script =( I'm very new to scriupting, so I'd be very appreciated if someone helped me. -- Regards, Alexander Trofimov Tag: Script help please (unlock locked out accounts) NEWBIE Tag: 194749

G'day all
I've got two questions if you will
The below script (that I hacked together )will unlock a users account
that has entered the wrong password too many times but I have a
problem with the user interface. I want our helpdesk people to be
able to use the loginID instead of the users full name.
How can I get the fullname from a user input of the loginID
so that I can then use that in the GETOBJECT section?

How can I find out all the options for objUser ?
I suppose this is some sort of comand reference

Thanks regards
Mark
Aus

*****SCRIPT START**************************

'Get the user name
UserLOGID = InputBox("Enter the Login ID of the User you wish to unlock")

'if Cancel selected - exit
If (UserLOGID = "") Then Wscript.Quit
'Get the Organizational Unit
OrgInput=InputBox( _
"Select the Organizational unit by number" & vbCRLF & vbCRLF _
& " 1 - SITE1" & vbCRLF _
& " 2 - SITE2" & VbCrLf _
& " 3 - SITE3" & vbCRLF _
& " 4 - SITE4" & vbCRLF _
& " 5 - SITE5" & vbCRLF _
& " 6 - SITE6" & vbCRLF _
& " 7 - SITE7" & vbCRLF & VbCrLf )

'if Cancel selected - exit
If (OrgInput = "") Then Wscript.Quit

If (OrgInput = "1") Then OrgUnit="SITE1"

If (OrgInput = "2") Then OrgUnit="SITE2"

If (OrgInput = "3") Then OrgUnit="SITE3"

If (OrgInput = "4") Then OrgUnit="SITE4"

If (OrgInput = "5") Then OrgUnit="SITE5"

If (OrgInput = "6") Then OrgUnit="SITE6"

If (OrgInput = "7") Then OrgUnit="SITE7"

MsgBox ("You're unlocking "& UserLOGID & VbCrLf _
& "from Organizational Unit "& OrgUnit)

'error check input
If (INSTR("1234567",Action)=0) OR (Len(Action)>1) then
y = msgbox("Unacceptable input passed -- '" & OrgUnit & "'", _
vbOKOnly + vbCritical, "That was SOME bad input!")
Wscript.Quit
End If

Set objUser = GetObject _
("LDAP://cn="& UserLOGID &",ou="& OrgUnit
&",ou=People,dc=internal,dc=business,dc=big,dc=com,dc=au")

objUser.IsAccountLocked = False
objUser.SetInfo

MsgBox ("Account has been unlocked" & vbOKOnly)

Wscript.Quit

*****SCRIPT END**************************

Top