Check if group exists before creating it

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
    - Check all files in all subfolders and obtain newest file Hello all. What I'm trying to do is the following: 1. Get a list of all files in all subfolders from a starting point (D:\Test). 2. Get the newest file from this list. 3. Indicate whether this newest file is more than 90 minutes old. Searching through previous posts, I've used elements of 3 different scripts to put a new script together: '~~~ Create Dynamic Array for Filenames Dim arrFiles(), i Redim arrFiles(-1) sFolder = "D:\Test" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder(sFolder) Set colFiles = objFolder.Files CheckSubFolders(objFolder) Sub CheckSubFolders(objFolder) Set colFolders = objFolder.SubFolders For Each objSubFolder In colFolders Set colFiles = objSubFolder.Files '~~ Populate the array with filenames from each SubFolder For Each objFile In colFiles Redim Preserve arrFiles(UBound(arrFiles) + 1) arrFiles(UBound(arrFiles)) = objFile.Path Next '~~ Repeat subroutine until all SubFolders have been checked CheckSubFolders(objSubFolder) Next End Sub '~~~ From the Array of Filenames get the newest file Dim vDT, vFName, NewestFile For i = 0 To UBound(arrFiles) Set oFile = objFSO.GetFile(arrFiles(i)) WScript.Echo oFile.Path & vbTab & oFile.DateLastModified IF oFile.DateLastModified > vDT Then vFName = oFile.Path vDT = oFile.DateLastModified End If Next NewestFile = vFName Wscript.Echo vbCrlf & NewestFile & vbCrlf '~~~ Check if newest file is more than 90 minutes old Set oFile = objFSO.GetFile(NewestFile) IF DateDiff("n",oFile.DateCreated,Now) > 90 Then Wscript.Echo "File is more than 90 minutes old." END IF Set objFSO = nothing Set objFolder = nothing Set colfiles = nothing Set colFolders = nothing Set oFile = nothing My script works fine, but I'm guessing it could probably be streamlined and some redundancy removed. Or, maybe there's a completely different and better method that can be used. Any suggestions would be greatly appreciated. Thanks. - Dave Tag: Check if group exists before creating it Tag: 206004
  - 2
    - Creating an Domain DFS Root link Hi all, i used the script strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root \cimv2") Set objDfsNode = objWMIService.Get("Win32_DfsNode") errReturn = objDfsNode.Create _ ("\\atl-dc-02\Scripts","\\atl-dc-02","Scripts", _ "New Dfs node for shared scripts.") but this is creating the DFS root for standalone server but not for the "Domain DFS root" if the value of "errReturn is 0" it means that the dfs kink is created but if a non 0 value is returened it means that the script failed. so the above script works fine for creating standalone dfs link but not for the domain dfs root link Is there a way we could create a Domain DFS Root link thru script? if yes pls let me know Tag: Check if group exists before creating it Tag: 205999
  - 3
    - Why did a subroutine fix my problem? I posted a few days ago about an 800A0046 permissions issue I was seeing only on a specific server as a specific type of user in regards to a CreateObject fuction. I saw an example of someone else's FSO script that used a subroutine to call their createobjects so I thought I would try it, and it worked! but I don't know why. Here is the script that bombs with a permissions denied for CreateObject on line 2 (only for local admins and domain users; for domain admins it runs fine): Dim fso Set fso = CreateObject("Scripting.FileSystemObject") MsgBox "Hello World" Set fso = nothing Here is the script that runs fine for all users: Dim fso sub blabla Set fso = CreateObject("Scripting.FileSystemObject") end sub MsgBox "Hello World" Set fso = nothing Any idea why the subroutine fixed the issue? Thanks! Tag: Check if group exists before creating it Tag: 205996
  - 4
    - Configuring a script, entering values Hi All! I maintain a server checking script that we use to perform daily tasks on an array of servers such as check free disk space, which services have stopped e.t.c. I've recently created an installer for this to help make the process a little easier (since some functions require the use of an exe) which nicely places all the needed files into a set location. What I'd really like to do though is this: The script itself has several variables that must be defined (such as the servers in the array and the username/password it logs onto each server with e.t.c.). I'd like to make it so that after the installer finishes it runs another script (which I can setup in the installer no problem, its the script I need help with). I'd like it so that this secod script bring up prompt boxes (or whatever you want to call them) where you can then enter in the information needed for each variable, so you'd be prompted to enter in the servers in the array, the username to be used e.t.c. The idea being that you'd have no actually need to go into the script itself uness you encountered a problem. How would I go about doing this? Can it be done through a script or do I need to do this some other way? Any advice/help would be much appreciated :-) Thanks, Sam -- _______________________________ Sam Richardson Technical Support Administrator Central Business Services ________________________________ Tag: Check if group exists before creating it Tag: 205989
  - 5
    - Search for Files by creation date Hey guys, I'm new to vbs. (Don't they all say that?) I'm trying to automate a task at work using vbs. Basically, I need a count of files from a folder AND sub-folders for all .pdf files created today. The path is Z:\C89\ and it remains constant and the file names are formatted as such: xxxx20070518.pdf, where the current date + 5 days is embedded into the file name. (I can't get the wildcard to work-that's why I thought I'd mention it.) Next, I'd like for the script to send me the results in an email. e.g. "The C89 folder has 50 pdf files" We use Windows Exchange on XP/2003 here. I've tried to piece together code from different sites, but I always end up with some error. I don't mind cracking open a book and learning vbs from scratch-which I intend to do, but I'm up against a deadline. Regards~ Tag: Check if group exists before creating it Tag: 205985
  - 6
    - Use a style in onmouseover? Is it possible to "call" or use a style in a DIV onmouseover/onmouseout? For example: <DIV ID="SC1" onmouseover=<MY_STYLE_1> onmouseout=<MY_STYLE_2> Style="border:1px solid #54BC00;"> If so, how do you reference it? Examples much appreciated... Thanks Tag: Check if group exists before creating it Tag: 205978
  - 7
    - UPnP data readout Hi, can somebody suggest me a url to some API information to UPnP and VBS ? I need to build a script which allows me to a) determine a UpNP capable router on my net and b) readout some schema information for example: um:schema-upnp-org:service:WANPPPConnection:1-> GetExternalIPAddress(String) I Found this Script to set a port mapping via upnp but have no clue how to simple read already present information: '=========================================================== 'This program forwards a port via UPnP Set nat = CreateObject( "HNetCfg.NATUPnP") Dim mappingPorts Set mappingPorts = nat.StaticPortMappingCollection MsgBox("Click OK to forward the port") 'Map the SIP port mappingPorts.Add 5060, "UDP", 5060, "10.0.0.100", TRUE, "SIP" 'Get some info about the currently mapped ports for each mappingPort in mappingPorts MsgBox(mappingPort.externalIPaddress) Next MsgBox("Click OK when finished") 'Remove the mapped port mappingPorts.Remove 5060, "UDP" '=========================================================== thanks. Tag: Check if group exists before creating it Tag: 205976
  - 8
    - HTA / IE7 question... Hi, folks!!! I'm trying to write up an HTA application to do various tasks. I have included a copy of some code to illustrating one of the things I'm trying to do. I am to open a PDF report from this HTA script. I have tried this script on one XP machine with IE6 -- works fine! The other XP machine with IE7 -- nothin! Both machines have Acrobat Reader installed. If I try to open a TXT file using this method I have no problems with IE6 or IE7. Does anyone know what gives?!? ===============test.hta=============== <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <HTA:Application border="thin" borderStyle="normal" caption="yes" maximizeButton="no" minimizeButton="no" showInTaskbar="yes" windowState="normal" innerBorder="yes" navigable="no" scroll="no" scrollFlat="yes" /> <script src="VBSlib.vbs" language="VBScript"></script> <script language="VBScript"> Dim oShell : Set oShell = CreateObject("WScript.Shell") Dim szCmd : szCmd = Chr(34) & App.Path &"\Report.PDF""" MsgBox szCmd oShell.Run szCmd </script> </head> <body> </body> </html> ================================== TIA... Tag: Check if group exists before creating it Tag: 205970
  - 9
    - Check for missing user group in computer account I need to check each of my computer accounts in active directory for a specific user group. If it exists move on to the next computer account, if it is missing add the user group to the computer account and move on to the next computer account. The script needs to be for global groups and not local computer groups. I hope someone can help. Tag: Check if group exists before creating it Tag: 205969
  - 10
    - DSACLS Script to Export Permissions Anyone have a script or link to export permissions for objects using DSACLS? If there is another method that would be great as well. Looking for a method to script out the SELF permissions on all user accounts to find discrepancies. Thanks, James Chong (MVP) Tag: Check if group exists before creating it Tag: 205961
  - 11
    - VBScript BITS Can the Background Intelligent Transfer Service be configured with VBScript? I want to set up a job in a log on script. Tag: Check if group exists before creating it Tag: 205939
  - 12
    - Inventory Script Below is an excellent inventory script I found on www.windowsitpro.com. It works great but I'd like to add three properties. 1. From the Win32_ComputerSystemProduct, the IdentifyingNumber (the computer's serial number) 2. From the Win32_ComputerSystem class, the UserName and the PrimaryOwnerName ( the username on the Computer Systems tab) Can someone please confirm that the following modifications to the script would be correct? 1. Win32_ComputerSystemProduct doesn't exist in the script. So , just before objfile.close, I need to add: strProperties = _ "IdentifyingNumber" QueryInstances "Win32_ComputerSystemProduct",strProperties,"None" 2. And I need to add UserName and PrimaryOwnerName to the Win32_ComputerSystem query like this: strProperties = _ "CreationClassName,Manufacturer,Model,Name,NumberofProcessors," & _ "SystemType,TotalPhysicalMemory,UserName,PrimaryOwnerName" QueryInstances "Win32_ComputerSystem",strProperties,"None" Thanks, Jeremy CODE 'On Error Resume Next directive is specified so that users 'are not bothered by potential operational errors with the script. 'On Error Resume Next 'Using both of these flags of the WbemFlagEnum enumeration 'makes a semisynchronous WMI call. See "Making a Semisynchronous Call" 'in the WMI SDK for more information. Const wbemFlagReturnImmediately = 16 Const wbemFlagForwardOnly = 32 'WbemCimtypeEnum Enumerations used in the script Const wbemCimtypeUint32 = 19 Const wbemCimtypeSint64 = 20 Const wbemCimtypeUint64 = 21 'Formatting and number conversion constants Const HR = "----" Const KB = 1024 Const MB = 1048576 Const GB = 1073741824 'Change this to the UNC path where inventory files should be created 'Anyone running this script must have read and write access to the 'path. strInvFilePath = "\\sea-fs-02\hw\" 'If each user will run this inventory file locally, do not change the value 'of strComputer. strComputer = "." 'Connect to WMI Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") 'Determine the OS because not all classes listed here are supported 'on all versions of the Windows operating systems strProperties = "CreationClassName,Version,CSName,Caption" Set objOS = objWMIService.ExecQuery _ ("SELECT " & strProperties & " FROM Win32_OperatingSystem",_ ,wbemFlagReturnImmediately + wbemFlagForwardOnly) For Each Setting in objOS strCreationClass = Setting.CreationClassName intVersion = Setting.Version strCSName = Setting.CSName strCaption = Setting.Caption Next 'Check for a file named after the computer. If it doesn't 'exist, then create a file that contains the computer's 'hardware inventory. Set objFSO = CreateObject("Scripting.FileSystemObject") strFileName = "HrdWrInv_" & strCSName & ".txt" strFullName = objFSO.BuildPath(strInvFilePath, strFileName) If (objFSO.FileExists(strFullName)) Then WScript.Quit Set objFile = objFSO.CreateTextFile(strFullName) 'Write the Operating System name and version but nothing more. 'The goal is to collect hardware inventory, not software inventory 'and configuration information. objFile.WriteLine("OSInformation:") objFile.WriteLine("CreationClassName: " & strCreationClass) objFile.WriteLine("ComputerName: " & strCSName) objFile.WriteLine("Caption: " & strCaption) objFile.WriteLine("Version: " & intVersion) 'The name property is automatically returned (because it's a key value), so 'it's not absolutely necessary to specify it in strProperties strProperties = _ "CreationClassName,Manufacturer,Model,Name,NumberofProcessors," & _ "SystemType,TotalPhysicalMemory" QueryInstances "Win32_ComputerSystem",strProperties,"None" 'Page file information. strProperties = _ "Name,MaximumSize" QueryInstances "Win32_PageFileSetting",strProperties,"None" 'Physical memory information. 'Note, total memory is aggregated and listed with win32_computersystem so there's 'no need to query the memory classes, such as Win32_PhysicalMemoryArray or 'Win32_PhysicalMemory. However, if you need to find out how much memory 'a computer will hold, it's useful to query Win32_PhysicalMemoryArray as 'shown strProperties = _ "MaxCapacity,CreationClassName" QueryInstances "Win32_PhysicalMemoryArray",strProperties,"None" 'SCSI Disk controller information strProperties = _ "Name,Manufacturer,Description,CreationClassName" QueryInstances "Win32_SCSIController",strProperties,"None" 'IDE Disk controller information strProperties = _ "Name,Manufacturer,Description,CreationClassName" QueryInstances "Win32_IDEController",strProperties,"None" 'Phyiscal Media information 'Note, this class is only in XP (ver5) and the Windows 'Server 2003 family (ver5). 'Win98SE reports a version number of 4 (4.10.2222) If Mid(intVersion,1,3) >= 5.1 Then strProperties = _ "SerialNumber,CreationClassName" QueryInstances "Win32_PhysicalMedia",strProperties,"None" End If 'Logical Disk information strProperties = _ "DriveType,Description,DeviceID,CreationClassName" QueryInstances "Win32_LogicalDisk",strProperties,_ "DriveType!=3 AND DriveType !=4" 'Disk drive information strProperties = _ "Caption,Description,DeviceID,InterfaceType," & _ "Manufacturer,MediaType,Model,Partitions,Size,CreationClassName" QueryInstances "Win32_DiskDrive",strProperties,"None" 'Processor information strProperties = _ "Manufacturer,MaxClockSpeed,ExtClock,ProcessorType," & _ "Revision,Version,CreationClassName" QueryInstances "Win32_Processor",strProperties,"None" 'NIC information strProperties = _ "Manufacturer,MACAddress,ProductName,AdapterType,CreationClassName" QueryInstances "Win32_NetworkAdapter",strProperties,_ "AdapterType='Ethernet 802.3' AND ProductName !='Packet Scheduler Miniport'" 'Monitor information strProperties = _ "Description,MonitorType,CreationClassName" QueryInstances "Win32_DesktopMonitor",strProperties,"None" 'Video adapter information strProperties = _ "Name,MaxRefreshRate,AdapterRAM,CreationClassName" QueryInstances "Win32_VideoController",strProperties,"None" 'Motherboard information strProperties = _ "Description,Manufacturer,Product,CreationClassName" QueryInstances "Win32_BaseBoard",strProperties,"None" 'BIOS information strProperties = _ "Manufacturer, Name,SoftwareElementID,SMBIOSBIOSVersion," & _ "SMBIOSMajorVersion,SMBIOSMinorVersion,Version" QueryInstances "Win32_BIOS",strProperties,"None" objFile.Close '*****Subroutines and Functions********* Sub QueryInstances(objClass,Properties,Conditions) If Conditions = "None" Then strSelect = "Select " & Properties & " From " & objClass Else strSelect = "Select " & Properties & " From " & objClass & _ " Where " & Conditions End If Set objClassName = _ objWMIService.ExecQuery _ (strSelect,,wbemFlagReturnImmediately + wbemFlagForwardOnly) intCounter = 0 ' Can use the following to determine the # of items in the sWbemObjectSet but ' it's processor intensive and it means that you can't use a semi-synchronous ' call because the count property doesn't work with wbemFlagForwardOnly. ' WScript.Echo "# of items in collection: " & objClassName.Count For Each objComponent in objClassName If intCounter = 0 Then objFile.WriteLine(HR) objFile.WriteLine(Mid(objClass,7) & ":") End If For Each objProperty in objComponent.Properties_ 'Start by verifying that there's a value in the property. 'If not, it isn't necessary to perform the evaluation in this loop. If ISNull(objProperty.Value) Then objFile.WriteLine(objProperty.Name & ": Not available") Else If objProperty.CIMType <> wbemCimtypeUint32 And _ objProperty.CIMType <> wbemCimtypeUint64 And _ objProperty.CIMType <> wbemCimtypeSint64 Then objFile.WriteLine(objProperty.Name & ": " & _ objProperty.Value & " " & _ GetUnits(objClass,objProperty.Name)) Else strUnits = GetUnits(objClass,objProperty.Name) intValue = _ SizeFormat(objProperty.Name,objProperty.Value,strUnits) objFile.WriteLine(objProperty.Name & ": " & intValue) End If End If intCounter = intCounter + 1 Next If intCounter > 1 Then objFile.WriteLine(HR) Next objFile.WriteLine(HR) objFile.WriteLine() End Sub Function GetUnits(ClassName,ClassProperty) Set objSchemaClass = objWMIService.Get(ClassName) For Each objClassProperty in objSchemaClass.Properties_ If objClassProperty.Name = ClassProperty Then For Each objQualifier in objClassProperty.Qualifiers_ If LCase(objQualifier.Name) = "units" Then GetUnits = LCase(objQualifier.Value) End If Next End If Next End Function Function SizeFormat(PropertyName,RawValue,Units) Select Case LCase(Units) Case "bytes" If int(RawValue/GB) >= 1 Then SizeFormat = Round((RawValue/GB),1) & " gigabyte(s)" ElseIf int(RawValue/MB) >= 1 Then SizeFormat = int(RawValue/MB) & " megabyte(s)" Else SizeFormat = RawValue & " byte(s)" End If Case "kilobytes" If int(RawValue/MB) >= 1 Then SizeFormat = Round((RawValue/MB),1) & " gigabyte(s)" ElseIf int(RawValue/KB) >= 1 Then SizeFormat = int(RawValue/1024) & " megabyte(s)" Else SizeFormat = RawValue & " kilobyte(s)" End If Case Else SizeFormat = RawValue & " " & Units End Select End Function Tag: Check if group exists before creating it Tag: 205927
  - 13
    - Call to VBScript fails Working in an HTA; how can the following code line: <SPAN onclick=msgbox("xxx") language=vbscript>Menu Item One</SPAN> in the code below, be made to call a VBScript sub rather than display a message box? I have already tried many combinations including the obvious: <SPAN onclick="Test" language=vbscript>Menu Item One</SPAN> The full code is below: <HTML> <HEAD> <TITLE>Popup Custom Navigation Menu Sample</TITLE> <SCRIPT LANGUAGE="vbscript"> Set oPopup = window.createPopup Function contextMenu lefter = window.event.offsetX+10 topper = window.event.offsetY+10 oPopup.document.body.innerHTML = oContextHTML.innerHTML oPopup.show lefter, topper, 200, 65, window.document.body window.event.returnValue=false End Function Sub ItemOne </SCRIPT> </HEAD> <BODY oncontextmenu="contextMenu"> <h1>Creating Custom Context Menus with the Popup Object</h1> Right-click anywhere on the document to see a customized popup navigation menu. <DIV ID="oContextHTML" STYLE="display:none;"> <DIV onmouseover=this.style.background="gold" onmouseout=this.style.background="#e4e4e4"> <SPAN onclick=msgbox("xxx") language=vbscript>Menu Item One</SPAN> </DIV> <DIV onmouseover=this.style.background="gold" onmouseout=this.style.background="#e4e4e4"> <SPAN onclick=msgbox("yyy") language="vbscript">Menu Item Two</SPAN> </DIV> </DIV> </BODY> </HTML> Thanks much for your assistance. Tag: Check if group exists before creating it Tag: 205926
  - 14
    - Can a Div take a "Float" position? Could someone please correct my syntax to set a control to float? MyDivID.style.position="float" I get an error using Office 2003; Win XP; and IE 6. Thanks for your assistance. Tag: Check if group exists before creating it Tag: 205922
  - 15
    - Write to the window I need to define a one line area of the window in which to write some text right to the screen; how do I do that and then use a reference to it? For example, I tried: <Div Name="txtArea"></Div> Then tried to write to it: txtArea.Value="Hello" But of course this failed... Your examples would be much appreciated...thanks Tag: Check if group exists before creating it Tag: 205918
  - 16
    - date format problem i need to use datediff to calculate the difference in minutes between Now() and a date returned from a 3rd party object. Now() returns the date as: "5/10/2007 7:15:42 PM" my object returns it as: "Thu, 10 May 2007 19:13:09 -0400" datediff chokes on this. is there any way i can convert that ugly date to one that datediff can use? please say yes and give me an example :( Tag: Check if group exists before creating it Tag: 205915
  - 17
    - Script to change password for Local Admin account question Ok...as my education continues into the world of scripting (still a infant here), I have some questions. I need to reset the password of all the local domain accounts on our servers. I thought a script + GPO would be a handy method. Since I am pretty new at scripting, I decided to google for some suggestions and came up with a few interesting things and wanted to ask some questions here. First, I found this one from 'The Scripting guy': Set objOU = GetObject("LDAP://OU=Finance, DC=fabrikam, DC=com") objOU.Filter = Array("Computer") For Each objItem in objOU strComputer = objItem.CN Set objUser = GetObject("WinNT://" & strComputer & "/ Administrator") objUser.SetPassword("i5A2sj*!") Next You change the OU and Domain as you suggested. Which brings a quick question. Suppose your OU has spaces. Something like: Server bin Does that change how you set it up in the script? Do you need to quote it within the quotes? That script seems fairly straightforward. Then I found this one: '------------------------------------------------------------------------------- ' Initialization - Declare variables '------------------------------------------------------------------------------- Dim fsoIn, fsoOut Dim inFile, outFile Dim arrComputerNames Dim objUser Dim strComputer Dim newPassword Dim ErrorOccurred Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 Const inFilename = "servers.txt" Const outFilename = "ChangePwdServers.log" '------------------------------------------------------------------------------- ' Main script '------------------------------------------------------------------------------- On Error Resume Next ErrorOccurred = False ' Insert WARNING here... Msgbox ("WARNING: This script will change the local administrator password for every " & _ "computer listed in SERVERS.TXT. If any services are running with the local " & _ "administrator credentials, those services must be updated, or they won't " & _ "start on the next boot. For this script to work, you must have administrative " & _ "privileges on all of the remote computers you are changing the password for.") ' Get new password newPassword = Inputbox ("Please enter the new password.") ' Open the input file and skip the header line Set fsoIn = CreateObject("scripting.filesystemobject") Set inFile = fsoIn.OpenTextFile(inFilename, ForReading, True) inFile.Skipline ' Open the log file (append mode) and timestamp the entry Set fsoOut = CreateObject("scripting.filesystemobject") Set outFile = fsoOut.OpenTextFile(outFilename, ForAppending, True) outFile.writeline (Now & vbTab & "Starting script...") While Not inFile.AtEndOfStream arrComputerNames = Split(inFile.Readline, vbTab, -1, 1) ' arrComputerNames(0) contains the computer name strComputer = arrComputerNames(0) ' Connect to the computer\administrator account Set objUser = GetObject("WinNT://" & strComputer & "/Administrator, user") If Err.Number <> 0 Then outFile.writeline Now & vbTab & "Error connecting to " & strComputer & " --- " & Err.Description Err.Clear ErrorOccurred = True Else ' Set the password for the account objUser.SetPassword newPassword objUser.SetInfo If Err.Number <> 0 Then outFile.writeline Now & vbTab & "Error setting password for " & strComputer & _ "\Administrator" & " --- " & Err.Description Err.Clear ErrorOccurred = True Else outFile.writeline (Now & vbTab & "Password set for " & strComputer & "\Administrator") End If End If Wend ' Clean up the environment outFile.writeline (Now & vbTab & "Ending script...") inFile.close outFile.close If ErrorOccurred Then msgbox "Script completed with errors. Please check the log file." Else MsgBox "Script completed successfully." End If Ok...not only is it VERY complex for me, but why the huge need for code for something like this? You look at the first one and it seems straightforward and easy. The second, looks like a lot of extra, possibly unnecessary work. I thought i'd start here. Thanks, Jas Tag: Check if group exists before creating it Tag: 205914
  - 18
    - Odd 800A0046 Permission Denied error OK, I am no scripting king, but I know when something doesn't make sense. I have one Citrix server out of four that generates an 800A0046 errors on the CreateObject launching the login script. So I created a simple script that has objFSO defined: 'On Error Resume Next Dim objFSO Set objFSO = CreateObject("Scripting.FileSystemObject") MsgBox "Hello World" Set objFSO = nothing When executed from the suspect citrix server as a testuser with basic domain user rights, I get Permission denied: 'CreateObject'. Now just to make sure it wasn't a local rights issue for filer permissions, I granted the testuser local admin permissions to the server and I get the same thing. I did install SP6 for for vb 6.0 and that didn't help. Got any ideas? Thanks Kevin Tag: Check if group exists before creating it Tag: 205910
  - 19
    - cant append to string and use as object i build a collection by executing a wql query. i need to echo a specific property, of an instance in a class. this is fine if its all hardcoded. im passing args to the script so that i can grab any property, class, instance. the problem is that i cant seem to append anything to the "objItem." in my for loop consider this query: Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\somecomputer\root\cimv2") Set colItems = objWMIService.ExecQuery("SELECT someProperty FROM someClass WHERE Name = 'someName'") the below would work fine: For Each objItem In colItems wscript.echo objItem.AvgDiskReadQueueLength Next but if AvgDiskReadQueueLength was passed as an argument and stored in strProp, the below fails For Each objItem In colItems wscript.echo objItem. & strProp Next i really need this to work. any ideas? Tag: Check if group exists before creating it Tag: 205904
  - 20
    - Auto sizing control to display a path In an HTA, I need a control or other object that can grow and shrink based on its contents; I need this to stay on one line; the user cannot edit it, but it needs to be accessible for read/write from VBScript. The contents will be a string network path to a folder selected by the user (I can already do this part), thus the varying lengths needed. What is the best control/tool to use for this? Can an example for read/write please be included? Thank you very much. Tag: Check if group exists before creating it Tag: 205892
  - 21
    - cant make vbscript/outlook work hi everyone. VERY annoying problem. i have a script that has to run every 5 minutes and check the contents of an exchange inbox. the script cannot run on the exchange server so as far as i know i MUST have outlook installed on the computer that runs the script. (if this isnt true PLEASE tell me how to do this without outlook) so we installed outlook and created a profile for the mailbox in question. the script works fine... but ONLY if we stay logged in. im assuming its because the logged in user sees only the outlook profiles that THEY created. so when no one is logged in, it doesnt work. can someone please explain how i can do this? i either have to do it without outlook, or with outlook in such a way that when no one is logged on the script can still access the profile. and no... i cant leave the server logged on and locked :( Tag: Check if group exists before creating it Tag: 205891
  - 22
    - vbscript and domain credentials Using vbscript, is there a way to ask for username and password, and then run the rest of the task based on those credentials? What I'm doing exactly is this: I've created a script to allow me to add domain users to the local admin group on a remote machine or lab of machines. Unfortunately, in order to run it and have it run properly on the remote machine, it must be run by someone who already has their domain account in the machine's local admin group. What I'd like to do is have it ask me for the machine's local admin acct and password, then, using those credentials, add the new domain accounts to the local admin group. Any ideas? Thanks, Doug Tag: Check if group exists before creating it Tag: 205886
  - 23
    - Removing non-ASCII characters from a text file. Hello Everyone, I am new to VB Scripting. So, please forgive me, if this is basics. I would like to write a script, which will take a text file as input, read line by line, replace any non-ASCII characters with '' and send the result set into a different text file. I want to replace any character that is not in [A-Za-z 0-9 \.,\?'""!@#\ $%\^&\*-_=\+;:<>\/\\\|\}\{\[\]`~] How do I do that? Any pointers are appreciated. Thanks, -Pavan Tag: Check if group exists before creating it Tag: 205879
  - 24
    - What newsgroup to use? Hi I noticed that there is a "microsoft.public.programming.scripting.vbscript" group. There seemed to be no messages. I saw somewhere that those "programming" are prefererred or you get answers there. I have no problems with this group and Google supports only it too, so I really have no choice. But does someone know more of this. LM Tag: Check if group exists before creating it Tag: 205875
  - 25
    - vbScript on VISTA Problems? Are there major problems with using vbScripts in my application installation on VISTA systems? I've searched the net and basically found that the the vbscript.dll is included with that operating system, but is not registered. It seemed from the various posts that simply registering the .dll solved the problem. Is there a reason this .dll is included and not registered or was this just an oversight by Microsoft? If an oversight, are there plans to remedy this by registering it in the future or including registration of it in a hotfix or service pack? If there are any other problems outside of this information, which may cause problems with including vbScripts in installations that may be run on VISTA, please let me know. THANKS in advance for any and all information you may provide. Tag: Check if group exists before creating it Tag: 205873
- Next
  - 1
    - Embedded Media Player gives exception as HTA, not in HTML on Vista I'm trying to get an embedded media player in an HTA application. On Windows XP I was able to do this; now on Vista I get several exceptions when I start playing the wmv file: "Windows - Bad Image; Exception Processing Message 0xc000007b Parameters ........." The code below works without exceptions if I start it as HTML. When I run it as HTA, and start playing a video file (using mediaPlayer.URL="video.wmv"), first I get several exceptions, and the video starts playing. Exactly the same code works on Windows XP (as HTA and as HTML). Please help. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <body> <span id="mediaPlayerSpan" > <object id="mediaPlayer" height="348" width="658" classid="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6"> <param name="uiMode" value="none" /> <param name="stretchToFit" value="false" /> </object> </span> <script type="text/javascript">  </script> </body> </html> Tag: Check if group exists before creating it Tag: 205872
  - 2
    - WMI hi, i want to check WMI settings, with script, on remote pc but i get the error "access denied", please help me. Tag: Check if group exists before creating it Tag: 205869
  - 3
    - Get window click unless on a control I'm working on an HTA in which I would like to have a VBScript run if a user clicks anywhere on the window - unless a control (e.g. a button or list box) is clicked. Is this possible? If so, could an example be posted please? Thanks much! Tag: Check if group exists before creating it Tag: 205864
  - 4
    - Searching webpage table object I am searching a webpage table object in which neither the table nor the elements have been named. This has forced me to search all <TD>s on the page for a match. Once I have the match I can read any cell in that row by using parentElement and cell number. Is there an easy way to refer back to the parent row, row collection and table? I have tried nested parentElement but it does not seem to work. If I could get the parent table, and the row index of the cell I would be set. Tag: Check if group exists before creating it Tag: 205860
  - 5
    - need to check date on email in outlook inbox i need to run a script on a server that will look in a specific exchange mailbox, and find the date on the oldest message in the inbox. the server where the script will run is NOT an exchange server and does not have outlook installed. few questions... MUST i have outlook installed on the server where the script runs? we'd rather not if at all possible. and second... anyone have any idea, or example on how best to do this? :) thanks in advance! Tag: Check if group exists before creating it Tag: 205857
  - 6
    - VB Scripting and Databases... hi guys, i need some help with a database issue ... i have a module - Sub A - which opens a database and imports a text file into the database, - while the database is open it calls module -Sub B which also needs the same database and extracts data to a text file. following is the psuedo code sub A create object called objconnection create object called varconnection set objrecordset set varrecordset open objconnection open varconnection objrecordset.open (select * from table) varrecordset.open (select specific field from table) create filesystemobject start a recursive search for txt files store the file paths and parent folder in vardatabase do until end of text files go to the first text file and open for reading read the lines and store in objdatabase (when you meet a "tab" put into next field) update the recordset call sub B with path to file move to next text file close objconnection,varconnection,objrecordset,varrecordset End Sub A Sub B objectconnection to database1 objectrecordset.open select table.field from table1 where value.table1 = value.table2 objectFSO open file for appending select the fileds from the database write to file in the given path close recordset and connection and fso. End Sub B if i run this on 1 file then its fine ... but when i tried it on 30+ files it slowed down and missed some lines in the text files and didn't even create some text files ... i'm lost as to what is going on ... my best guess is that i've created too many connections to database and files and they are not opening and closing in time for the next process therefore misses things out ... anybody have any idea how i can sort this issue out... thanks, Tag: Check if group exists before creating it Tag: 205854
  - 7
    - Reposition and/or resize controls on the fly In an HTA, is it possible to re-position and/or resize controls, like buttons and list boxes on the fly? If so, could someone please post example code as to how to do it? Thanks for your help... Tag: Check if group exists before creating it Tag: 205846
  - 8
    - Dynamically Creating DAO Object I'm trying to determine what the version of DAO is and create an object for it. Code: -------------------- version=<Version property found here> Set objDAO = CreateObject("DAO.DBEngine." & version) -------------------- -- djp ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Check if group exists before creating it Tag: 205837
  - 9
    - excel i am making a program in excel/visual basic. it has a password. i'dont want that the first user makes a copy and gives it to somebody else (who can use the same password)..... idea anyone? sory for my bad english vanja from croatia Tag: Check if group exists before creating it Tag: 205833
  - 10
    - quick help with vbscript and outlook i need to run a script on a server that will look in a specific exchange mailbox, and find the date on the oldest message in the inbox. the server where the script will run is NOT an exchange server and does not have outlook installed. few questions... MUST i have outlook installed on the server where the script runs? we'd rather not if at all possible. and second... anyone have any idea, or example on how best to do this? :) thanks in advance! Tag: Check if group exists before creating it Tag: 205823
  - 11
    - trying to read a registry value DWORD Hi all I am trying to check what hardware profile this local machine is using. I want keep some drivers not running when they are not needed. This much I got. There is 4 profiles in my pc, and current profile was number 3. But there is no "hit", the last print command does not work. There is also a code in "http://cwashington.netreach.net/depo/view.asp? Index=570&ScriptType=vbscript" but it gives an error. This code is from MS. The code: Const HKEY_CURRENT_USER = &H80000001 Const HKEY_LOCAL_MACHINE = &H80000002 strComputer = "." Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\default:StdRegProv") strKeyPath = "SYSTEM\CurrentControlSet\Control\IDConfigDB\" strValueName = "CurrentConfig" oReg.GetDWORDValue HKEY_CURRENT_USER,strKeyPath,strValueName,dwValue Wscript.Echo "CurrentConfig: " & dwValue strKeyPath = "SYSTEM\CurrentControlSet\Control\IDConfigDB\" strValueName = "CurrentConfig" oReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue Wscript.Echo "Current WSH Trust Policy Value: " & strValue 'dwValue=3 if dwValue=0 then Wscript.Echo "A hit" Tag: Check if group exists before creating it Tag: 205821
  - 12
    - Use script to navigate web page? There is a web site I get information from. The site displays pages of items with individual checkboxes to select each item. There is also a checkbox to select all the item checkboxes. And there is the page numbers with Next and Previous. What I would like to do is log in to the site and navigate to the page I need, then automate (by script??) going through each page and selecting the Select All Checkboxes On This Page box. On the page, I can use Find to get to Next, tab once and hit Enter to go to the next page. And I can use Find to get Select All, Shift+Tab gets the checkbox before the words, and the spacebar selects the checkbox. I can do this for a couple of pages - more than 10 and I start wondering if I missed any! Plus I can't help but feel that a script or other automatino can do this much faster than I can! I do a bit of VBA macros in Word and Excel, and a few VB scripts (with much help!). I'm wondering if a script would help here, or if another way would be better - or if I should drop the idea of automating this all together. Ed Tag: Check if group exists before creating it Tag: 205817
  - 13
    - SaveAs method not Working Hello all, Looking for a little help all the examples in MSDN have Doc.saveas("Myfile.doc") I want to use a variable and haveing tried such, it is just not working. doc.saveas(strMyDocs & "\" & ResID & ".doc") I have tried stuffing all into one variable and splitting it out into many but to no avail. but if I hardcode it .... All the variables have the correct data I am thinking that as soon as SAVEAS is called the Vars loose their ohhh whats the word.... "scope"/"meaning" .. There has to be a way around this Thanks in adavance to any and all that assist Tag: Check if group exists before creating it Tag: 205815
  - 14
    - WBemScripting.SWbemSink and Do Loop - Explained Hello all. Consider the following script, used for Monitoring Entry-Level Events, from: http://www.microsoft.com/technet/scriptcenter/guide/sas_reg_teyz.mspx?mfr=true strComputer = "." Set objReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\default") Set wmiSink = WScript.CreateObject("WbemScripting.SWbemSink", "SINK_") wmiServices.ExecNotificationQueryAsync wmiSink, _ "SELECT * FROM RegistryValueChangeEvent WHERE Hive= " _ & "'HKEY_LOCAL_MACHINE' AND KeyPath= " _ & "'SOFTWARE\\Microsoft\\Windows NT\ \RegisteredOwner' AND " _ & "ValueName='CSDVersion'" Wscript.Echo "Listening for Registry Change Events ..." & vbCrLf Do While(1) WScript.Sleep 1000 Loop Sub SINK_OnObjectReady(wmiObject, wmiAsyncContext) Wscript.Echo "Received Registry Change Event" & vbCrLf & _ "------------------------------" & vbCrLf & _ wmiObject.GetObjectText_() End Sub I'm trying to understand how the script works. As for the the WMI Sink Event portion, I think I have a handle on it: (1) You instantiate a connector and a Sink: strComputer = "." Set objReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\default") Set wmiSink = WScript.CreateObject("WbemScripting.SWbemSink", "SINK_") (2) You hook the connector to the Sink via an Asynchronous query: wmiServices.ExecNotificationQueryAsync wmiSink, _ "SELECT * FROM RegistryValueChangeEvent WHERE Hive= " _ & "'HKEY_LOCAL_MACHINE' AND KeyPath= " _ & "'SOFTWARE\\Microsoft\\Windows NT\ \RegisteredOwner' AND " _ & "ValueName='CSDVersion'" (3) You set up Event handlers: Sub SINK_OnObjectReady(wmiObject, wmiAsyncContext) Wscript.Echo "Received Registry Change Event" & vbCrLf & _ "------------------------------" & vbCrLf & _ wmiObject.GetObjectText_() End Sub What I can't understand exactly is the Do...Loop: Do While(1) WScript.Sleep 1000 Loop What is going on in the Loop other than sleeping for 1 second? Is the Subroutine SINK_OnObjectReady being called within the loop? If so, how? Any help with clarifying this would be greatly appreciated. Thanks. - Dave Tag: Check if group exists before creating it Tag: 205813
  - 15
    - Right click menu to call VBScript I copied this code from a MS website and it creates a nice right click menu; question: how can I alter the code in the line that reads: <SPAN ONCLICK="TestThis">Call VBScript</SPAN> to actually call a VBScript sub? The VBScript is between <Script> tags that preceed this code: <BODY oncontextmenu="contextMenu(); return false;"> <h1>Creating Custom Context Menus with the Popup Object</h1> Right-click anywhere on the document to see a customized popup navigation menu. <DIV ID="oContextHTML" STYLE="display:none;"> <DIV onmouseover="this.style.background='gold'" onmouseout="this.style.background='#e4e4e4'" <SPAN ONCLICK="TestThis">Call VBScript</SPAN> </DIV> </DIV> </BODY> Your help would be much appreciated... Tag: Check if group exists before creating it Tag: 205808
  - 16
    - Closing application properly I need some help w/ a possible VBScript for closing an application properly. Here is the situation: I need to do a backup of a very odd application. When backup's occur, all users must be out of that application. The only sticky part here is the application is very fussy as to how it has to be closed. If it is closed improperly, it will not allow the backups to occur. What I would like help with: vbs that warns users that they are going to be logged off of application 'Z' in 'x' minutes w/ a 5 minute reminder and then makes winoac.exe (application) active and starts sending the logout key sequence (just several esc keys). Because my knowledge of vbs (or any kind of scripting) is so minimal I'm embarrassed to post what I have thus far (which is actually wscript inside of vbs). Any help that you all can provide would be great! --script-- Option Explicit Dim objShell 'Time out option in seconds Set objShell = WScript.CreateObject("WScript.Shell") 'Bring application active objShell.AppActivate "winoac" 'Sending messages objShell.Popup "You will be logged off in 15 seconds", 5 wscript.sleep (1000) objShell.Popup "You will be logged off in 10 seconds", 5 wscript.sleep (1000) objShell.Popup "You will be logged off in 5 seconds", 5 wscript.sleep (1000) objShell.Popup "You Are being logged off!", 5 'Bring Application Active objShell.AppActivate "winoac.exe" 'Send 1st ESC key & Sleep objShell.SendKeys "{ESC}" wscript.sleep (1000) 'Send 2nd ESC key & Sleep objShell.SendKeys "{ESC}" wscript.sleep (1000) 'Send 3rd ESC key & Sleep objShell.SendKeys "{ESC}" wscript.sleep (1000) 'Send 4th ESC key & Sleep objShell.SendKeys "{ESC}" wscript.sleep (1000) 'Send 5th ESC key & Sleep objShell.SendKeys "{ESC}" wscript.sleep (1000) 'Send 6th ESC key & Sleep objShell.SendKeys "{ESC}" wscript.sleep (1000) 'Send 7th ESC key & Sleep objShell.SendKeys "{ESC}" wscript.sleep (1000) Set objShell = Nothing WScript.Quit 0 Thanks again, Tag: Check if group exists before creating it Tag: 205806
  - 17
    - serverxmlHTTP authentication on Windows Server 2003 x64 problem. I have a problem getting serverXMLHTTP to authenticate under Windows x64. If I run cscript test.vbs from the 64-bit command prompt. http.status = 200 If I run cscript test.vbs from the 32-bit command prompt. http.status = 401 (anonymous user tries to logon). I don't know if this is vbscript or MSXML or Windows x64. Anyone have any ideas? Here is my code for test.vbs: set http = wscript.createobject("MSXML2.ServerXMLHTTP") http.open "GET", "http://xxxxx/test/logon_user2.asp", false http.send *** Sent via Developersdex http://www.developersdex.com *** Tag: Check if group exists before creating it Tag: 205804
  - 18
    - Hide controls until needed Is it possible to hide a control until it is needed? Like a visible or hidden property? In particular I'm looking at a listbox and a button... Could someone please post example code that does it? Thanks a lot for your help. Tag: Check if group exists before creating it Tag: 205803
  - 19
    - Securing sdql connection string in old asp I have an old asp app that I am managing and I haven't been given the go ahead to rewrite the system. It has a db connection in directly in the asp with username and password. What steps can I take to secure this connection string? Thanks -- Tyler Tag: Check if group exists before creating it Tag: 205801
  - 20
    - Reading Binary File Hello all. I am in the process of converting some VB 6 code to a VB Script. One of the things this code does is read in a binary file and then return text to be put into a table. The function from the VB 6 code is this (watch for word wrap): Public Function GetMenuData(ByVal strTableName As String, nOffset As Integer, nLen As Integer) As String On Error Resume Next Dim strTableData As String Dim oFs As Scripting.FileSystemObject Set oFs = CreateObject("Scripting.filesystemobject") If oFs.FileExists(strTableName) Then Dim hFile As Integer hFile = FreeFile Open strTableName For Binary Access Read As #hFile strTableData = String$(nLen, " ") '&H0) Get #hFile, nOffset, strTableData Close #hFile Else g_oErr.AddMessage MODULE_NAME, "GetMenuData", "Missing " & strTableName, App Debug.Print "Table " & strTableName & " is missing." 'This will force the application to stop Debug.Assert (1 = 2) End If Set oFs = Nothing GetMenuData = strTableData End Function Not having worked with binary files, I did some research and found some code from the internet which seemed to do what I wanted. I made a couple of modifications. The new VB Script code is this: Function GetMenuData(strTableName,nOffset, nLen) Dim I, S, oInFile Dim oFs, Binary Set oFs = CreateObject("Scripting.filesystemobject") If oFs.FileExists(strTableName) Then Set oInFile = oFS.OpenTextFile(strTableName, 1) Binary = oInfile.ReadAll For I = nOffset To nlen S = S & Chr(AscB(MidB(Binary, I, 1))) Next msgbox S GetMenuData = S End If End Function The new code doesn't return anything. I know the binary files have data in them. Is there anything wrong with the script? Also, is there an easy way to see what is in the binary file? Thanks, Jennifer Tag: Check if group exists before creating it Tag: 205800
  - 21
    - Backup NT Security Log I am trying to use the below script to backup, compress and ship the local security log using MOM 2005. If I don't add in the compress logic it works fine. Can you one assist me? I want to accomplish two things that are not in the script by defult: compression and adding the time to the file name. Please ignore any references to MOM within the script. Original script came from Andrzej's @ http://blogs.technet.com/alipka/archive/2006/04/09/424757.aspx Thanks for your time and help in this matter. strComputer = "." 'place for temporary storage of backed up logs strLogTempPlace = ScriptContext.Parameters.Get("LogTemp") 'server SMB share to which you want to transfer backed up logs (MOM agent action account mast have write permissions on NTFs and share level strLogDestPlace = ScriptContext.Parameters.Get("LogDest") strError = 1 strInformational = 4 strEventMessage = "Backup of EventLogs has been done to files:" intEventErrorID = 112 intEventTypeError = 1 intEventTypeSuccess = 0 strEventSrc = "Backup Logs Script" strYear = DatePart("yyyy",DateAdd("d",-1,Date)) strMonth = DatePart("m",DateAdd("d",-1,Date)) If Len(strMonth) = 1 Then strMonth = "0" & strMonth strDay = DatePart("d",DateAdd("d",-1,Date)) If Len(strDay) = 1 Then strDay = "0" & strDay Set objWMIService = GetObject("winmgmts: {impersonationLevel=impersonate,(Backup,Security)}!\\" & strComputer & "\root\cimv2") ' Check computer name Set colName = objWMIService.ExecQuery("Select * from Win32_ComputerSystem") For Each objName in colName strCompName = objName.Name Next ' get event logs Set colLogFiles = objWMIService.ExecQuery("Select * from Win32_NTEventLogFile where LogFileName='Security'") For Each objLogfile in colLogFiles ' create file name strFileName = strCompName & "_" & Left(objLogfile.LogfileName,3) & strYear & strMonth & strDay & ".evt" ' copy logs to file errBackupLog = objLogFile.BackupEventLog(strLogTempPlace & strFileName) If errBackupLog <> 0 Then CreateEvent intEventErrorID, intEventTypeError, strEventSrc, "Can not back up " & objLogfile.LogfileName & " EventLog." & "Check server for errors." ScriptContext.Quit Else strEventMessage = strEventMessage & Chr(13) & strFileName objLogFile.ClearEventLog() End If Next set objWMI = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") set objFile = objWMI.Get("Cim_Datafile='" & strCompName & "_*" & strYear & strMonth & strDay & ".evt" & "'") WScript.Echo objFile.Name intRC = objFile.Compress If strLogDestPlace <> "" Then Set fso = CreateObject("Scripting.FileSystemObject") fso.MoveFile strLogTempPlace & strCompName & "_*" & strYear & strMonth & strDay & ".evt", strLogDestPlace strEventMessage = strEventMessage & chr(13) & "Logs are copied to " & strLogDestPlace End If 'generate MOM event CreateEvent intEventErrorID, intEventTypeSuccess, strEventSrc, strEventMessage 'event create subroutine Sub CreateEvent(intEventNumber,intEventType,strEventSource,strEventMessage) Set objEvent = ScriptContext.CreateEvent() objEvent.EventNumber = intEventNumber objEvent.EventType = intEventType objEvent.EventSource = strEventSource objEvent.Message = strEventMessage ScriptContext.Submit objEvent End Sub Tag: Check if group exists before creating it Tag: 205799
  - 22
    - Establishing SMTP address to NT accounts Dear All. I have a task I am to eager to complete.... :) I have a number of not mail-enabled user accounts, and I need to assign external SMTP addresses to them. I can't find accounts' attributes to be updated.... Many thanks in advance for any feedbacks! Andriy Tag: Check if group exists before creating it Tag: 205797
  - 23
    - Multiple record retrieval and updating I am trying to write a web app to assist in our stock take. I need to know how to pull all our inventory out of SAP and display it on a page, with an input filed for each item where the count for that item can be entered. And then how to write that value back to the database once the data capturer has captured all the counts. Hope that makes sense. Tag: Check if group exists before creating it Tag: 205792
  - 24
    - List devices with ConfigManagerErrorCode = 1? How can I get a list of devices with error code 1? I've put together this small script which should be able to list devices with an errorcode <> 0, but for some reason it doesnt list devices with errorcode 1. Other errorcodes seem to be listed fine. ___________________________________________________________________________ set osvc = getObject("winmgmts:root\cimv2") Set devices = osvc.InstancesOf("Win32_PNPEntity Where ConfigManagerErrorCode <> 0") For Each device In devices wscript.echo "Device: " & device.ConfigManagerErrorcode & " " & device.name Next ___________________________________________________________________________ I've tried setting the selection to "Win32_PNPEntity Where ConfigManagerErrorCode = 1" but no luck with that either. If a user clicks the Cancel button when the "Found New Hardware" wizard appears the device ends up with error code 1, so it would be a great help if I could catch those devices as well, in a troubleshooting script. Any suggestions? /Robert Tag: Check if group exists before creating it Tag: 205790
  - 25
    - VB6 "unspecified automation error -2147467259 " I have a VB6 app and am trying to update the proxyAddresses (multi- value) attribute in our Active Directory and am getting the following error: 'run-time error "-2147467259 (80004005)': Unspecified error I can set single-value attributes (e.g., "description", "mail") just fine but not proxyAddresses. I can't see anything wrong and wonder if someone out there has the magic touch. The ultimate goal is to ADD or DELETE entries in this attribute. The preliminary code follows that does work for everything else, it seems, but this: Private Sub WriteAttributes() Dim adoCommand, adoConnection, strBase Dim objRootDSE, strDNSDomain, strQuery, adoRecordset, aryValues(1) Dim strName, strCN, colMail, strMail, objUser, strDN, strNewAddress As String Const ADS_PROPERTY_CLEAR = 1 Const ADS_PROPERTY_UPDATE = 2 Const ADS_PROPERTY_APPEND = 3 Const ADS_PROPERTY_DELETE = 4 Set adoCommand = CreateObject("ADODB.Command") Set adoConnection = CreateObject("ADODB.Connection") adoConnection.Provider = "ADsDSOObject" adoConnection.Open "Active Directory Provider" adoCommand.ActiveConnection = adoConnection Set objRootDSE = GetObject("LDAP://RootDSE") strDNSDomain = objRootDSE.Get("defaultNamingContext") strBase = "<LDAP://" & strDNSDomain & ">" strFilter = "(&(objectCategory=Person)(objectClass=User)(homeMDB=*))" strAttributes= "distinguishedName,cn,sAMAccountName,employeeID,mail,proxyAddresses" strQuery = strBase & ";" & strFilter & ";" & strAttributes & ";subtree" adoCommand.CommandText = strQuery adoCommand.Properties("Page Size") = 10000 adoCommand.Properties("Timeout") = 30 adoCommand.Properties("Cache Results") = False Set adoRecordset = adoCommand.Execute Do Until adoRecordset.EOF colMail = adoRecordset.Fields("proxyAddresses") For Each strMail In colMail strDN = adoRecordset.Fields("distinguishedName") Set objUser = GetObject("LDAP://" & strDN) objUser.Description="My new description" '(this works fine) objUser.mail="MyNewMail.Address@company.com '(this works fine) '<<Failing code runs here - see examples below<< objUser.SetInfo Next Loop End Sub *** The failing code, which sits right after the objUser.mail attribute write, looks like this (all the following approaches failed with the same code): 1) Attempt 1: Set objUser = GetObject("LDAP://" & strDN) objUser.PutEx _ ADS_PROPERTY_UPDATE, "proxyAddresses", "MyEmail.Address@Company.com" 2) Attempt 2: strNewAddress="MyEmail.Address@Company.com" Set objUser = GetObject("LDAP://" & strDN) objUser.PutEx ADS_PROPERTY_UPDATE, "proxyAddresses", strNewAddress 3) Attempt3: strNewAddress="MyEmailAddressCompanycom" 'No special characters. Set objUser = GetObject("LDAP://" & strDN) objUser.PutEx ADS_PROPERTY_UPDATE, "proxyAddresses", strNewAddress 4) Attempt 4: Dim aryNewAddress(1) aryNewAddress(0)="MyEmail.Address@Company.com" Set objUser = GetObject("LDAP://" & strDN) objUser.PutEx ADS_PROPERTY_UPDATE, "proxyAddresses", aryNewAddress(0) Tag: Check if group exists before creating it Tag: 205785

Hi all,

Having "borrowed" this script and modified, it works fine by itself.
I want to use this as part of a loop to create groups and populate
from a file with format group|user

' SimpleGroup.vbs
' Sample VBScript to create a Global Security Group
' Author Guy Thomas http://computerperformance.co.uk/
' Version 2.4 - May 2005
' ----------------------------------------------------------'

Dim strOU, strGroup, strDNSDomain
Dim objOU, objGroup, objUser

' Check - Make sure you have the OU referenced by strOU
strOU = "OU=Newport,"
strNewGp = "Coal Porters1"
strNewGpLong = "CN=" & strNewGp

Set objRootDSE = GetObject("LDAP://RootDSE")
strDNSDomain = objRootDSE.Get("DefaultNamingContext")

' Create new Group
Set objOU = GetObject("LDAP://" & strOU & strDNSDomain )
Set objGroup = objOU.Create("Group",strNewGpLong)
objGroup.Put "sAMAccountName", strNewGp
objGroup.setInfo

Wscript.Quit

' End of Simple Group VBScript.

So if I have a group that already exists, it dies. How can I check
for the existence of a group before objGroup.setInfo?

Top

Re: Check if group exists before creating it by Jeremy

Jeremy
Tue May 15 04:57:44 CDT 2007

You need to capture the error and handle it. An unhandled error leads to
the script terminating. The laziest way, but often the most effective for
administrative scripts, is to stick an On Error Resume Next command at the
top of your script. It basically just says, do what I say and if it fails,
pick yourself up and carry on. I've inserted it inline below.

<bakins@gmail.com> wrote in message
news:1179165719.110010.226890@l77g2000hsb.googlegroups.com...
> Hi all,
>
> Having "borrowed" this script and modified, it works fine by itself.
> I want to use this as part of a loop to create groups and populate
> from a file with format group|user
>
>
> ' SimpleGroup.vbs
> ' Sample VBScript to create a Global Security Group
> ' Author Guy Thomas http://computerperformance.co.uk/
> ' Version 2.4 - May 2005
> ' ----------------------------------------------------------'
> On Error Resume Next
> Dim strOU, strGroup, strDNSDomain
> Dim objOU, objGroup, objUser
>
> ' Check - Make sure you have the OU referenced by strOU
> strOU = "OU=Newport,"
> strNewGp = "Coal Porters1"
> strNewGpLong = "CN=" & strNewGp
>
> Set objRootDSE = GetObject("LDAP://RootDSE")
> strDNSDomain = objRootDSE.Get("DefaultNamingContext")
>
> ' Create new Group
> Set objOU = GetObject("LDAP://" & strOU & strDNSDomain )
> Set objGroup = objOU.Create("Group",strNewGpLong)
> objGroup.Put "sAMAccountName", strNewGp
> objGroup.setInfo
>
> Wscript.Quit
>
> ' End of Simple Group VBScript.
>
>
> So if I have a group that already exists, it dies. How can I check
> for the existence of a group before objGroup.setInfo?
>

Top