Importing Information from Excel to AD

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
    - Move a user into an OU while logging on Hi everyone. I am trying to move a user into a designated OU using a login script before the group policy settings are run for that user, but the group policy settings always seem to run against the OU the user is assigned to before the move. Basically, the routine I have created, checks some information in a SQL server database and if there is information missing, I want the user only have access to a limited desktop until the SQL server information has been updated. The user can then log off (or re-run a check without logging off if possible) and log back on in order to access a standard desktop. Does this sound possible? I have spent days going round in circles, but before anyone suggests a logout routine, I've been down that road. The SQL server routine is based on a daily check, so the logout theory works during the current day, but as soon as the next day comes around, the data is out of date again without the user doing anything. It really has to happen during the login process. Tag: Importing Information from Excel to AD Tag: 183007
  - 2
    - Installing software. I thought everything was grand with my script, because testing it with a test.bat works fine. But when I try to run a executable I get an error that says wshShell is not recognized. I don't know if running it on XP makes a difference. Can anyone help and/or suggest corrections. strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_ComputerSystem") Set colCDROM = objWMIService.ExecQuery("SELECT * FROM Win32_CDROMDrive") Set WshShell = WScript.CreateObject("WScript.Shell") For Each objItem In colItems Select Case Trim(objItem.Model) Case "OptiPlex GX270" WshShell.run ("c:\roxio\test.bat"), 1, True Case "Precision WorkStation 360" WshShell.run ("c:\roxio\test.bat"), 1, True Case "Precision WorkStation 370" wshShell.run "c:\roxio\test.bat", 1, True Case "Precision WorkStation 380" wshShell.run "c:\roxio\test.bat", 1, True Case "-------------------------" wshShell.run "c:\roxio\test.bat", 1, True Case Else msgbox "Your PC does not match the models selected to recieve software." End Select Next Tag: Importing Information from Excel to AD Tag: 183002
  - 3
    - Writing vbscript to Install Apps with Elevated Rights and Groups I'm trying to learn vbscript to write scripts to install apps, elevate to admin rights and use group names to direct to users that need them. Can anyone recommend recources or show me a sample script that I can replace the variables (Appname, runas and IF Groupname). Thanks in advance. Jim Tag: Importing Information from Excel to AD Tag: 183000
  - 4
    - VBScript and autoit. I've read the Groups here and found that you can use AutoIt within VBScripts. But what is required. Do I first need to do something like: Set oAutoIt = CreateObject("AutoItX.Control") and register the AutoIT dll. So when I want to call a feature like AutoITs BlockInput(0) and SplashText( ) how should I call it. oAutoit.BlockInput(0) oAutoit.SplashText() is that the way to call it? Can someone please advise......... Thanks in advance....... Tag: Importing Information from Excel to AD Tag: 182997
  - 5
    - Backup Script [WILDPACKET] System State backup runs daily on Server A. It takes 10 minutes for the backup to complete. I want the *.bkf file to copied on a server B daily. Once the *.bkf file is copied to the Server B, I want the *.bkf file deleted from Server A. On Server B, I do not wont to keep the system state *.bkf files older than 2 days, so I want to delete the files older than 2 days on server B from the folder bcos of low disk space. Please some one could do a VBscript for me. I would highly appreciate and will make my job easier. Thank you very mcuh in advance. Tag: Importing Information from Excel to AD Tag: 182996
  - 6
    - New to scripting - Help creat a scrip to move files based on date? Hi I am new to scripting and was wondering if anyone could help me with moving some files based on there data of creation. What I am after is the following: Move all file in d:\folder1\*.* between 01/01/05 - 31/01/05 to d:\folder2\012005. I have figured how to move files by the following: Set objFSO = CreateObject("Scripting.FileSystemObject") objFSO.MoveFile "D:\Script_test\Folder1\*.*" , "D:\Script_test\Folder2\" But dont know how todo the data thing. Any help would be great. Thanks James Tag: Importing Information from Excel to AD Tag: 182991
  - 7
    - List all Computers in the domain. Hi all, Does anyone have or knows where I can get the script that will search my AD and create a txe or CSV file listing all the Computers Thank you. Tag: Importing Information from Excel to AD Tag: 182990
  - 8
    - Compare profile/logon script on accounts on old domain/AD domain I need to develop a script that will compare a user account in an old NT4 domain to the new AD domain to see if the logon script entry matches. I will need to have input boxes for the NT and AD domains. If the entry does not match I will log it to a text file. The main trouble I am having is the how to access all the user accounts for a domain, compare it to the AD domain. I don't know how to enumerate that account property to compare it. I have dozens of domains and thousands of users... I always get great advice here! Thanks in Advance. Tag: Importing Information from Excel to AD Tag: 182988
  - 9
    - fun with odbc... :-( Hi! I'm trying to use odbc. So far I've got a dsn, can connect, execute a query and retrieve the rows. However, upon script exit the script crashes. This is my script: set db=createobject("ADODB.Connection") db.open("dsn=ecadbib;uid=layoutchecks_hetzer;pwd=layoutchecks_hetzer") set Rows=db.execute("select sysdate from dual") do until Rows.EOF msgBox(Rows("SYSDATE")) Rows.MoveNext loop Rows.Close msgbox("Here") db.Close msgbox("Here") Now, whenever I leave out one of the two message boxes (or both), the script crashes. It also crashes when I use wscript.createobject instead of just createobject. Does anyone have an idea what I'm doing wrong? Btw, I'm trying to connect to an oracle database. Lots of Greetings! Volker Tag: Importing Information from Excel to AD Tag: 182983
  - 10
    - Scripting FTP and SMTP server configuration Is it possible to use VBScript to automate the configuration of the Windows built in FTP and SMTP servers (from IIS)? I want to automatically add an FTP site and and SMTP domain. Any help much appreciated!!! Thanks. -- McGeeky http://mcgeeky.blogspot.com Tag: Importing Information from Excel to AD Tag: 182979
  - 11
    - sending test to printer hi how to send some test directly to a printer ? (not using shell and not only for the windows default printer) thanks Tag: Importing Information from Excel to AD Tag: 182978
  - 12
    - getting client IP address ....... is it possible to get the IP address of a client via VBS and check it against an IP range such as the following IP pool 172.16.172.0/255.255.252.0 that is from 172.16.172.1 to 172.16.175.254 Whats the best way to do such a check........... Thanks Momo Tag: Importing Information from Excel to AD Tag: 182976
  - 13
    - Update Access Database I'm encountering problem when I want to update records in the Access database. I tried to output the SQL statement in the scteen and able to show the entire statement correctly on the screen. However, when I tried to execute the SQL statement, the statement does not show on the screen and the transaction does not take place: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Reminder Report</title> </head> <body> <br> <% Dim strDBPath, SCONNECTION, dbConnection Dim strApproval, rsApproval, strRejection, rsRejection Dim intCounter, Leaveid, intTotal, strAccept, strReject strDBPath = "C:\inetpub\wwwroot\teknion\db" SCONNECTION="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "\Leaves.mdb;Persist Security Info=False; Jet OLEDB:System Database=" & strDBPATH & "\Secured.mdw;user id=dbadmin;" SET dbConnection = CreateObject("ADODB.Connection") SET rsApproval = CreateObject("ADODB.Recordset") SET rsRejection = CreateObject("ADODB.Recordset") dbConnection.open SCONNECTION intTotal = Request.Form("Counter") Response.Write intTotal For intCounter = 1 to intTotal Leaveid = Request.Form("Leaveid" & intCounter) Response.Write "The leaveid is " & Leaveid strAccept = UCase(Request.Form("Accept" & intCounter)) strReject = Ucase(Request.Form("Reject" & intCounter)) Response.Write strAccept 'Response.Write strReject If strAccept = "ON" Then strApproval = "UPDATE leave SET status='Approved' WHERE leaveid = '" & leaveid & "'" dbConnection.Execute strApproval End If If strReject = "ON" then Response.Write "Rejected" End If Response.Write "<br>" Next %> </body> </html> I hope you experts can give me some tips/hints on how to resolve this issue. Many thanks in advance. Tag: Importing Information from Excel to AD Tag: 182974
  - 14
    - Show me your... Logon Script Hey guys, I have been constantly working and reworking my logon script for my enterprise network here and I am always looking for better ways of doing things. Currently drives are mapped and files copied using security groups and thats where it gets tricky. How do you cycle through all the groups the user is in without slowing down the script? So I was wondering what you guys do? Could you post a snipet of your logon script code? Currently I make an string of the groups the user is in by doing this: For Each GroupObj In UserObj.Groups UserGroups=UserGroups & "[" & UCASE(GroupObj.Name) & "]" Next Then I have a case statment with lots of these: If InGroup("Stuff") Then mapdrive "U:", "\\server\share" End If And that uses this function: Function InGroup(strGroup) InGroup=False If InStr(UserGroups,"[" & strGroup & "]") Then InGroup=True End If End Function Problem is... the list of groups is getting pretty big and each user needs to step through each case statment. And I am thinking it would be more efficient if it would only run the parts that were required? So back to my question. Does anyone have some cool code I can nab off them? Thanks, Euan Tag: Importing Information from Excel to AD Tag: 182969
  - 15
    - Help with remote script Can anyone tell me why the below script works using the local computer name, but will not work using a remote computer name ? Thanks in advance, Mark. strComputer = "mark" folder = "c:\documents and settings" dim folder_array(20) dim folder_array_2(20) i = -1 Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colSubfolders = objWMIService.ExecQuery ("Associators of {Win32_Directory.Name='" & folder & "'} Where AssocClass = Win32_Subdirectory ResultRole = PartComponent") For Each objFolder in colSubfolders folder = split(objFolder.Name,"\",-1,1) moz_folder = "\\" & strComputer & "\c$\documents and settings" & "\" & folder(2) & "\application data\mozilla\firefox\profiles" Set objFSO = CreateObject("Scripting.FileSystemObject") If objFSO.FolderExists(moz_folder) Then i = i + 1 folder_array(i) = objFolder.Name & "\application data\mozilla\firefox\profiles" folder_array_2(i) = moz_folder end if Next For i = 0 to UBound(folder_array) Set colSubfolders2 = objWMIService.ExecQuery ("Associators of {Win32_Directory.Name='" & folder_array(i) & "'} Where AssocClass = Win32_Subdirectory ResultRole = PartComponent") For Each objFolder2 in colSubfolders2 split_folder = split(objFolder2.Name,"\",-1,1) wscript.echo "Returned (local) directory" wscript.echo objFolder2.Name wscript.echo "--------------------------" moz_folder_2 = folder_array_2(i) & "\" & split_folder(7) & "\extensions\Extensions.rdf" wscript.echo "Calculated remote filename" wscript.echo moz_folder_2 wscript.echo "--------------------------" Set objTextFile = objFSO.OpenTextFile(moz_folder_2, 1) Do Until objTextFile.AtEndOfStream input_string = objTextFile.ReadLine MyPos = Instr(1, input_string, "<RDF:Description") if MyPos > 0 then Do Until objTextFile.AtEndOfStream input_string2 = objTextFile.ReadLine MyPos2 = Instr(1, input_string2, "</RDF:Description>") if MyPos2 > 0 then exit do MyArray = Split(input_string2, chr(34), -1, 1) if Instr(1, MyArray(0), "em:version=") then version = MyArray(1) if Instr(1, MyArray(0), "em:name=") then name = MyArray(1) if Instr(1, MyArray(0), "em:description=") then description = MyArray(1) if Instr(1, MyArray(0), "em:creator=") then creator = MyArray(1) if Instr(1, MyArray(0), "em:homepageURL=") then homepage = MyArray(1) Loop wscript.echo "--------------------" wscript.echo "Name: Mozilla Firefox Extension - " & name wscript.echo "Version: " & version wscript.echo "Description: " & description wscript.echo "Creator: " & creator wscript.echo "Homepage: " & homepage name = "" version = "" description = "" creator = "" homepage = "" end if Loop Next Next Tag: Importing Information from Excel to AD Tag: 182968
  - 16
    - Help Me Fix Script Months ago I used the following vbs script to extract all the ID3 tags from a directory and put them in a tab delimited file. The file could then be opened in a spreadsheet. I lost the script but was able to locate a version on the internet that may not be complete. I don't even remember how to use it. Can someone look at the script, tell me if it is complete and how do I use it? I find reference to the output file but I'm not sure how to associate it with the directory. BTW: as you can see I am not a VBS programmer. Set objShell = CreateObject("Shell.Application") Set Ag=Wscript.Arguments Set Fldr=objShell.NameSpace(Ag(0)) Set FldrItems=Fldr.Items Set fso = CreateObject("Scripting.FileSystemObject") FName="c:\documents and settings\Dennis Marks\my documents\Directory List.txt" Set ts = fso.OpenTextFile(FName, 2, vbtrue) For x = 0 to 50 t1 = t1 & Fldr.GetDetailsOf(vbnull, x) & vbtab Next ts.write FLDR.self.path & vbcrlf ts.Write T1 & vbcrlf T1="" For Each FldrItem in FldrItems For x = 0 to 50 t1 = t1 & Fldr.GetDetailsOf(FldrItem, x) & vbtab Next t1=t1 & vbcrlf ts.Write T1 T1="" Next msgbox FName & " has a tab delimited list of all properties" -- Dennis ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Importing Information from Excel to AD Tag: 182966
  - 17
    - Adding double quote in string Dear Experts, How do I add a double-quote (") into my string as follow instead of using a single quote? Old: strBodyText = "<HTML><BODY>" & "<FORM Name='frmReminderReport' METHOD='POST' action='\teknion\leave_system\ReminderReport.asp'><TABLE Border=1><TR><TD>Supervisor</TD><TD>" & rsDistinctSupervisor("Supervisor") & "</TD></TR>" New: strBodyText = "<HTML><BODY>" & "<FORM Name="frmReminderReport" METHOD="POST" action="\teknion\leave_system\ReminderReport.asp"><TABLE Border=1><TR><TD>Supervisor</TD><TD>" & rsDistinctSupervisor("Supervisor") & "</TD></TR>" Many thanks in advance. Tag: Importing Information from Excel to AD Tag: 182965
  - 18
    - message box and blocking keyboard input..... I'm trying to test something with VBS Is it possible to have a message box show during the execution of the script.... what I mean is during the scripts execution process I have a box that just says something like "please wait while script executes" I don't need to have any buttons but just the box show during the scripts execution..... is there a way to do this............. Secondly can I block keyboard input using VBS ........ does such a command exist....... Thanks Momo Tag: Importing Information from Excel to AD Tag: 182959
  - 19
    - Controlling Internet Explorer Where do I find what methods and properties of internet explorer are available for use in vbscript within html pages? Ken Tag: Importing Information from Excel to AD Tag: 182958
  - 20
    - object in a sub [object missing?] Can I not create an object in one sub and access it from another? sub housekeeping set rs=server.createobject("adodb.recordset") end sub sub printStatistics rs.open "select max(date) from syslog.mxdb",conn end sub Microsoft VBScript runtime error '800a01a8' Object required: 'rs' /mx/new.asp, line 68 Tag: Importing Information from Excel to AD Tag: 182945
  - 21
    - Forcing a .doc in a link to save as Is it possible to prevent a user from opening a .doc with an IE link and instead forcing the .doc to be saved as? I have looked into manipulating the right-click menu but I can't be removing valid menu options. Is there a way to create my own right-click menu and only provide a "Save as" option and call it on the click or right-click of the link?? I've also tried playing with open/save dialogs but have not been able to get it to work. I've tried opening the .doc in a new window and doing a javascript "saveas" but IE only saves the .doc object and not the page contents. Can anyone give me any ideas? Thanks for your help. Marley Tag: Importing Information from Excel to AD Tag: 182943
  - 22
    - Need Example of Session Variables I have been using a 53 page Web Site for 4 years. All of a sudden four pages lose the Passwords. People have suggested using a session Variable to hold the two passwords. I have tried this for 6 days without success. Does anyone know how to store a password in a session variable for reference on all my pages. Any Help Will Be Appreciated. Bill Tag: Importing Information from Excel to AD Tag: 182941
  - 23
    - Enable/Disable NIC with a script I need to be able to Enable or disable one of the network adaptors in a server on the fly as part of a failover senario. any Ideas? Thanks, Sherpa Tag: Importing Information from Excel to AD Tag: 182934
  - 24
    - Passing Passwords Between Pages I need to pass my students password between pages for the student to take their Federal Test. PageA the student enters his Password <Input Type="Text" Name="PssWrd"> The student then goes to Page B PageB  <Input Type="Hidden" Name="APssWrd" Value="<%=Request("PssWrd")%> Above Statement PassWord comes in fine. <Map Name="District ElPaso" <! District 835 -> <Area Shape="Polygon" Coords="364, 117, 363, 130" Href="Page835.asp?DistCd=WI835"> <! District 777 -> <Area Shape="Polygon" Coords="119, 68, 111, 111" Href="Page777.asp?DistCd=WH777"> <! District 654 -> <Area Shape="Polygon" Coords="267, 58, 261, 79" Href="Page653.asp?DistCd=WD653"> <! District 569 -> <Area Shape="Polygon" Coords="82, 16, 37, 9" Href="Page569.asp?DistCd=WA569"> </Map> When I go to any of the four pages on the Map, the password will not come with any of those four pages. The pages come up fine, but no password. Does anyone know how to do this. This is the first Time I have ever called a page based on where the student selects from a map. Does anyone know what I need to do? Thanks in advance Granny Tag: Importing Information from Excel to AD Tag: 182933
  - 25
    - Script to copy text to clipboard Hello Two questions: 1. I need a simple script to copy a defined text that is set within the script to the clipboard. 2. What is the best book or source to begin learning vbs. Is there a perferred book? Needs to start at the beginning and be a simple as possible for starters. Thanks in advance. Tag: Importing Information from Excel to AD Tag: 182932
- Next
  - 1
    - ODBC SCRIPT As I can build an ODBC by means of a VBS script? Tag: Importing Information from Excel to AD Tag: 182931
  - 2
    - Session Variables Running Windows Server 2003 IIS 6.0 Session Variables are not passing from page to page Hitting refresh causes new Session ID Help!!!!! Thanks, hallgirl -- Thanks Much! hallgirl Tag: Importing Information from Excel to AD Tag: 182924
  - 3
    - Script Question Hi All, I need to run a command called moveuser (replaces the local profile with the profile of a new user) using script which is distributed via SMS 2003. The script needs to be run under the security context of a domain admin. I tried runas but it didn't work. I believe the problem is that the script runs under security context of Local System account which is not sufficient for me. The following is the example of runas which did not work. SMS 2003 reports the the script result as success. No error messages are reported. Is there anyone who would suggest some other way with an example or tell me where I'm going wrong? Regards, Yaman Dim WshShell Set WshShell = WScript.CreateObject ("WSCript.shell") WshShell.run "runas /user:newdomain\administrator " & """" & "moveuser olddomain\olduser newdomain\newuser" & """" WScript.Sleep 100 WshShell.SendKeys "P@ssw0rd~" WScript.Sleep 100 WshShell.SendKeys "~" Tag: Importing Information from Excel to AD Tag: 182921
  - 4
    - Logon Script I dont know much about scripting, and Im in somewhat of a crunch for this. I need to know how to collect a terminal services/citrix client IP address and match it to a network# from a list to determine what printers to map for that user. The problem is that I need this script to work even if there isnt a terminal service/citrix client ip. In that case it would need to use the system IP that the user is logged onto. The goal of this script is to allow users to roam around from site to site and login to any system, but have the correct printers mapped for that location. Before mapping the printers though it would need to remove any current mapped ones as well. Thank you. Tag: Importing Information from Excel to AD Tag: 182911
  - 5
    - Running VBScript in Scheduler without logging in I have a simple VBScript that calls up MS Access, runs a macro to retrieve data from an ODBC database, and then calls up MS Excel, and runs a macro to format the retrieved data. This script, as listed below, runs fine if I start it manually. It also works fine if I schedule it to run every night but with my Windows session logged on. If I leave the machine on, but without logging on, the VBScript will start but never end. I think it fails to start MS Access. I do not have Admin priviledge on the computer which is running Win XP Pro. Is this a security related issue? How can workaround this other than trying to gain Admin pivilege for my user account? -- Teddy ********* Script starts below ************ Shared_Folder = "C:\RMM\Reports" ' Create Log File if it doesn't already exist LogFilePath = Shared_FOlder & "\Mid-Week LogFile.txt" Set oFSO = CreateObject("Scripting.FileSystemObject") SET oLogFile = oFSO.CreateTextFile(LogFilePath, True) oLogFile.WriteLine(LogLine) oLogFile.WriteLine("Log File Initially Created : " &Date &" - " &Time) oLogFile.WriteLine(LogLine) Dim ObjAccess Dim ObjExcel ' ' Open Access DB and run Mid_Week_Reports ' oLogFile.WriteLine("MS Access Started: " &Date &" - " &Time) Set ObjAccess = CreateObject("ACCESS.APPLICATION") ' ObjAccess.Visible = FALSE ObjAccess.OpenCurrentDatabase ("c:\RMM\REPORTS\RMM Data Analysis (AUTO).mdb") ObjAccess.Run ("RUN_Mid_week") ObjAccess.Quit Set ObjAccess = Nothing oLogFile.WriteLine("MS Access Finished: " &Date &" - " &Time) ' ' Open Excel to update all traffic reports ' oLogFile.WriteLine("MS Excel Started: " &Date &" - " &Time) Set ObjExcel = CreateObject("EXCEL.APPLICATION") ' ObjExcel.DisplayAlerts=TRUE ' ObjExcel.Visible=TRUE ObjExcel.Run ("'C:\RMM\REPORTS\Update All Reports.xls'!Update_Traffic_Reports") ObjExcel.Quit Set ObjExcel = Nothing oLogFile.WriteLine("MS Excel Finished: " &Date &" - " &Time) Tag: Importing Information from Excel to AD Tag: 182908
  - 6
    - Sample Dictionary Script(Newbie) Can someone tell me this sample script out of the Microsoft Press book by Ed Wilson won't run properly? When I run it is displays every file in the folder, the same number of times that there are files in the folder.... IE...if there are nine files in the folder it shows all nine files nine times with a different file size for each one. Any help would be appreciated. Thanks: '=================================================================== ' ' VBScript Source File -- Created with SAPIEN Technologies PrimalSCRIPT(TM) ' ' NAME: <filename> ' ' AUTHOR: ed wilson , mred ' DATE : 9/21/2003 ' ' COMMENT: <comment> ' '=================================================================== Option Explicit Dim objDictionary Dim objFSO Dim objFolder Dim colFiles Dim objFile Dim colItems Dim colKeys Dim strKey Dim strItem Set objDictionary = CreateObject("scripting.dictionary") Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder("C:\scriptingBook") Set colFiles = objFolder.Files For Each objFile In colFiles objDictionary.Add objFile.Name, objFile.Size Next colItems = objDictionary.Items colKeys = objDictionary.Keys For Each strKey In colKeys For Each strItem In colItems WScript.Echo "filename: " & strKey & " size: " & strItem Next Next WScript.Echo "***there are " & objDictionary.Count & " files" Tag: Importing Information from Excel to AD Tag: 182905
  - 7
    - Search a text file and replace text vbscript I need some help and I still don't know the best way to accomplish this. I need to search a license file that is a regualr asci text file c:\gadgets\test.lic file and replace a line in the c:\gadgets\test.lic and save it. What is the easiest way to accomplish this? And do I save it out to a .vbs extenion? The line I need to search for is: SERVER="chicago" IPADDRESS="192.168.1. 5" The Line I need to replace with is: SERVER="corporate" IPADDRESS="192.168.1.45" Thanks for anyone who reads this and/or helps me out. -C Tag: Importing Information from Excel to AD Tag: 182904
  - 8
    - Filename with date modified appended to filename need to find a way to change filenames that relect the filename and the date modified. I have found numerous ways to get the current date and time appended to the filename but nothing with date modified. I have users that need to have this in the filename and I am in search of some help in this matter. Example is a file named test.txt with a date modified 1/31/2005. I would like the filename to be test (1/31/2005).txt. Thanks in advance ... Tag: Importing Information from Excel to AD Tag: 182903
  - 9
    - Regexp Matching... Hi! On Unix regular expressions work with brackets. So, when I have a regexp "X([0-9]*)V([0-9]*)Z" the string "X15V27Z" gives me two matches, one for each number. Is there any way to get this in VBScript regular expressions too? Lots of Greetings! Volker Tag: Importing Information from Excel to AD Tag: 182898
  - 10
    - Need help spelling out NULL vs. equal to nothing Hi All, Over the past year or so, I've gotten further in to some of the specifics of VBScript/ASP scripting and I'm having a difficult time getting a definite answer in regards to searching for an empty or un-occupied string or number. If anyone is interested in helping, I've listed some of the examples that I need clarification/correction on: 1) If the value is alphanumeric (VARCHAR), will the following work best? strValue <> "" Or strValue = "" 2) If it is numeric/integer/bit (int, bigint, numeric, etc.), or any other number-only format, is isNull the correct comparrison? Not IsNull(intValue) Or IsNull(intValue) 3) For the following example, if 'COL1' were part of a recordset that returned values from other columns, but it itself had no value, would it still be returned as NULL or as ""? Dim intNumber intNumber = 0 If Not IsNull(sp.parameters.item("@COL1").value) Then intNumber = sp.parameters.item("@COL1").value End If If you assign a numeric value as response.cookies("number") or as session("number") or as a variable="number", then will it maintain it's original datatype, or does it become string? If it becomes string, does all conversion have to occur when reading that session variable/cookie, or is there an alternative? Anyway, I appreciate the help of anyone wishing to respond. Thanks, Curt Morrison c u r t m o r r i s o n @ y a h o o . c o m Tag: Importing Information from Excel to AD Tag: 182894
  - 11
    - How to deploy a ActiveX Dll to client PCs over the internet One of my web page uses a ActiveX control a ActiveX DLL. The user PCs do not have this ActiveX DLL how can I distribute this DLL over the internet/intranet from the web page. Please kindly share the code to deploy this ActiveX control to the client PCs into a ASP page. If only a .OCX can be deployed how can I convert a Active X dll to a .OCX I do not have the source code for the Active X dll just the DLL. Thanks Karen Tag: Importing Information from Excel to AD Tag: 182893
  - 12
    - Set ACE on OU The statement below in a vbscript is used to give user da_messerjg Full Control to an OU in AD - It applies onto 'This object and all child objects'. I'm trying to find out what AceFlag(s) I need to set to make it apply onto 'Child objects only'. At the bottom of this post are all of my constants - I'm not sure if I need to put multiple constants on my AceFlags line or how to do so. Any ideas? Josh Messerschmitt objAce.Trustee = "DOMAIN\da_messerjg" objAce.AceFlags = ADS_ACEFLAG_INHERIT_ACE objAce.AceType = ADS_ACETYPE_ACCESS_ALLOWED objAce.Flags = ADS_FLAG_OBJECT_TYPE_PRESENT objAce.ObjectType = SCHEMAIDGUID_OU objAce.AccessMask = ADS_RIGHT_FULL_CONTROL objDACL.AddAce objAce 'AccessMask Const ADS_RIGHT_DS_CREATE_CHILD = &H1 Const ADS_RIGHT_DS_DELETE_CHILD = &H2 Const ADS_RIGHT_ACTRL_DS_LIST = &H4 Const ADS_RIGHT_DS_SELF = &H8 Const ADS_RIGHT_DS_READ_PROP = &H10 Const ADS_RIGHT_DS_WRITE_PROP = &H20 Const ADS_RIGHT_DS_DELETE_TREE = &H40 Const ADS_RIGHT_DS_LIST_OBJECT = &H80 Const ADS_RIGHT_DS_CONTROL_ACCESS = &H100 Const ADS_RIGHT_DELETE = &H10000 Const ADS_RIGHT_READ_CONTROL = &H20000 Const ADS_RIGHT_WRITE_DAC = &H40000 Const ADS_RIGHT_WRITE_OWNER = &H80000 Const ADS_RIGHT_SYNCHRONIZE = &H100000 Const ADS_RIGHT_ACCESS_SYSTEM_SECURITY = &H1000000 Const ADS_RIGHT_GENERIC_ALL = &H10000000 Const ADS_RIGHT_GENERIC_EXECUTE = &H20000000 Const ADS_RIGHT_GENERIC_WRITE = &H40000000 Const ADS_RIGHT_GENERIC_READ = &H80000000 Const ADS_RIGHT_FULL_CONTROL = &HF01FF 'ACE flags Const ADS_ACEFLAG_INHERIT_ACE = &H2 Const ADS_ACEFLAG_NO_PROPAGATE_INHERIT_ACE = &H4 Const ADS_ACEFLAG_INHERIT_ONLY_ACE = &H8 Const ADS_ACEFLAG_INHERITED_ACE = &H10 Const ADS_ACEFLAG_SUCCESSFUL_ACCESS = &H40 Const ADS_ACEFLAG_FAILED_ACCESS = &H80 'ACE types Const ADS_ACETYPE_ACCESS_ALLOWED = 0 Const ADS_ACETYPE_ACCESS_DENIED = &H1 Const ADS_ACETYPE_SYSTEM_AUDIT = &H2 Const ADS_ACETYPE_ACCESS_ALLOWED_OBJECT = &H5 Const ADS_ACETYPE_ACCESS_DENIED_OBJECT = &H6 Const ADS_ACETYPE_SYSTEM_AUDIT_OBJECT = &H7 Tag: Importing Information from Excel to AD Tag: 182886
  - 13
    - convert FAT32 to NTFS problem? Hi, Dear all, i wrote below script, i want to convert remote host Harddisk format from FAT32 to NTFS, it 's failed in remote hosts, but succeed in local host. would you please check it for me ? with many thanks ! Regards. Michael ************************************************************************************************************************ Const Fixed = 2 Const ForReading = 1 Set objOFSO = CreateObject("Scripting.FileSystemObject") Set oShell = Wscript.CreateObject("WScript.Shell") Set objTextFile = objOFSO.OpenTextFile("c:\myscript\list.txt",ForReading) sFile = objOFSO.GetSpecialFolder(2).ShortPath & "\" & objOFSO.GetTempName ON Error Resume Next Do while Not objTextFile.AtEndOfStream strComputer = objTextFile.ReadLine Set objWMIService = GetObject("winmgmts://"&strComputer) 'Set colLogicalDisk = objWMIService.Instancesof("win32_LogicalDisk") set colLogicalDisk = objWMIService.ExecQuery("select * from Win32_LogicalDisk where DriveType= 2") For Each objLOgicalDisk In colLogicalDisk IF UCase(ObjLogicalDisk.FileSystem) = "FAT32" Then sDiskLetter = obiLogicalDisk.DriveLetter sDiskLabel = objLOgicalDisk.VolumeName If sDiskLabel = "" Then sCmd = "%comspec% /c echo y|convert.exe " & sDiskLetter & ": /fs:ntfs" Else Set fFile = objOFSO.CreateTextFile(sFile) fFile.WriteLine sDiskLabel fFile.WriteLine "y" fFile.Close sCmd = "%comspec% /c convert.exe " & sDiskLetter & ": /fs:ntfs <"& sFile End If oShell.Run sCmd, 0, True End If Next Loop Tag: Importing Information from Excel to AD Tag: 182885
  - 14
    - Script to create scheduled task on remote computers Hi Guys, A newbie need some expert help on a script to create scheduled task on remote computers... I found one on technet; and edit slightly... strComputer = InputBox("Machine name","Remote Software Deployment") Set objService = GetObject("winmgmts:\\" & strComputer) Set objNewJob = objService.Get("Win32_ScheduledJob") errJobCreated = objNewJob.Create _ ("Monitor.exe", "********123000.000000-420", _ True , 1 OR 4 OR 16, , , JobID) If Err.Number = 0 Then Wscript.Echo "New Job ID: " & JobID Else Wscript.Echo "An error occurred: " & errJobCreated End If Can any one tell me how can I have additonal prompt boxes to allow the input for: 1. command line 2. the time task scheduled to run Thanks alot -- eang18 ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Importing Information from Excel to AD Tag: 182884
  - 15
    - VBScript in Web Page and Security Hello, I am still a bit new with writing VBScript in a web page so hopefully someone can help me with this issue I am having. I have a management server (MS 2003) in domain USERS, and on this server I have IIS running with just a simple interface on a web page right now to help automate an administrative task. However, their are users that are in the ADMIN domain that will mostly be accessing this page (along with ones from the USERS domain), however, the users in the ADMIN domain always get the ADO Security Warning dialog box everytime the script runs, "The website uses a data provider that may be unsafe. if you trust this site click OK...", while those users that log into the USERS domain are fine and do not get this error at all. How can I supress this dialog box, add code to remedy it, or change settings on the web server that will fix it. I don't want anyone to have to actually modify their own PC settings to get this to work without the warnings. Thanks, Ron Tag: Importing Information from Excel to AD Tag: 182875
  - 16
    - Problem with Copying file by DateLastModified vbs Can someone tell me what I am doing wrong with this, I'm trying to copy all files by datelastmodified the files can be anything from .doc .pdf to .dxf .vbs in fact I need to copy everything, that ONLY has been modified. I've been scratching my head with this one and I can't see what's wrong with it. Here's the code Thanks function CurrentBackupFolder() if isArray(BackupFolder) then CurrentBackupFolder = BackupFolder(WeekdayNumber) else CurrentBackupFolder = BackupFolder end if end function function BackupSubFolderName(fldrname) dim bfldrname bfldrname = replace(fldrname,":","\") bfldrname = replace(bfldrname,"\\","\") BackupSubFolderName = bfldrname end function function MakeBackupFolder(fldrname) dim bfldrname, pbfldrname, fbfldrname if len(fldrname) = 0 then MakeBackupFolder = true exit function end if bfldrname = BackupSubFolderName(fldrname) fbfldrname = fs.BuildPath(CurrentBackupFolder(),bfldrname) if not fs.FolderExists(fbfldrname) then pbfldrname = fs.GetParentFolderName(bfldrname) if not MakeBackupFolder(pbfldrname) then exit function end if fs.CreateFolder(fbfldrname) end if MakeBackupFolder = true end function function DoThisFile(fl,srcfolder,bpath) dim bf, res ON ERROR RESUME NEXT bpath = fs.BuildPath(CurrentBackupFolder(),fs.BuildPath(BackupSubFolderName(srcfolder),fl.name)) if BACKUP_ALWAYS then res = true elseif not fs.FileExists(bpath) then res = true else set bf = fs.GetFile(bpath) res = (bf.DateLastModified <> fl.DateLastModified) set bf = nothing end if DoThisFile = res end function sub DoBackup(srcfolder) dim sf, fldr, fl, bpath ON ERROR RESUME NEXT if not MakeBackupFolder(srcfolder) then exit sub end if set fldr = fs.GetFolder(srcfolder) set sf = fldr.SubFolders for each fl in sf DoBackup fs.BuildPath(srcfolder,fl.name) next set sf = fldr.Files for each fl in sf if DoThisFile(fl,srcfolder,bpath) then WriteLog "Backing up " & fl.path ,false fl.copy bpath if err.number <> 0 then WriteLog "** ERROR ** " & err.number & "; " & err.description,false CopyErrors = CopyErrors + 1 else FilesCopied = FilesCopied + 1 BytesCopied = BytesCopied + fl.size end if end if next end sub sub ShowResults dim x x = "Files copied = " & vbTab & FilesCopied & vbCr & vbLf x = x & "Bytes copied = " & vbTab & BytesCopied & vbCr & vbLf x = x & "CopyErrors = " & vbTab & CopyErrors & vbCr & vbLf x = x & "------------------------------------------------" WriteLog x,true if SHOWRESULTS_EOJ then msgbox x,0,PROGRAMID end if end sub Tag: Importing Information from Excel to AD Tag: 182873
  - 17
    - VBSCript inside ASP page am sorry if this sounds hokey but I am a newbie to ASP. I have a VBScript running in an ASP page. The script makes a connection to Oracle via and ADODB connection. When my clients connect to the ASP page they get Oracle client issues. How do I make the script run from the server side to eliminatew any oracle client issues or oracle tns names issues. Hope someone can help Paul Code <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <div align="center"><img src="pics/banner_new.jpg" width="700" height="80" /> <br /> <script type="text/vbscript"> Const adOpenStatic = 3 Const adLockOptimistic = 3 Set objConnection2 = CreateObject("ADODB.Connection") Set objRecordset2 = CreateObject("ADODB.Recordset") objConnection2.Open = "DRIVER={Microsoft ODBC for Oracle}; SERVER=<removed>; UID=<removed>; PWD=<removed>" strQuery1 = "SELECT TRUNC(log_date_time) DAY,UPPER(SUBSTR(workstation,1,3)) WORKSTATION, COUNT(*) COUNT FROM member_log WHERE logon_type='LOGON' GROUP BY TRUNC(log_date_time),UPPER(SUBSTR(workstation,1,3))" ' strQuery1 = "Select * from member_log" objRecordset2.Open strQuery1, _ objConnection2, adOpenStatic, adLockOptimistic ' If Not objRecordSet.EOF Then 'objRecordSet.MoveFirst Do Until objRecordSet2.EOF If Left(ObjRecordSet2("WORKSTATION"),3) = "W03" Then 'document.write "WESTAMPTON" & vbTab & (ObjRecordSet2("WORKSTATION")) & vbTab & (ObjRecordSet2("DAY")) & vbTab & (ObjRecordSet2("COUNT")) wh1= (ObjRecordSet2("Day")) & "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"& (ObjRecordSet2("COUNT")) & "<br>" wh = wh + wh1 testw = CInt(ObjRecordSet2("COUNT")) westh = westH + testw Elseif Left(ObjRecordSet2("WORKSTATION"),3) = "W05" Then testv = CInt(ObjRecordSet2("COUNT")) vnld = vnld + testv vn1= (ObjRecordSet2("Day")) & "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"& (ObjRecordSet2("COUNT")) & "<br>" vn = vn + vn1 Elseif Left(ObjRecordSet2("WORKSTATION"),3) = "W10" Then testnb = CInt(ObjRecordSet2("COUNT")) newb = newb + testnb nb1= (ObjRecordSet2("Day")) & "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"& (ObjRecordSet2("COUNT")) & "<br>" nb = nb + nb1 Elseif Left(ObjRecordSet2("WORKSTATION"),3) = "W05" Then testv = CInt(ObjRecordSet2("COUNT")) vnld = vnld + testv vn1= (ObjRecordSet2("Day")) & vbTab & (ObjRecordSet2("COUNT")) & "<br>" vn = vn + vn1 Elseif Left(ObjRecordSet2("WORKSTATION"),3) = "W12" Then testd = CInt(ObjRecordSet2("COUNT")) dov = dov + testd dv1= (ObjRecordSet2("Day")) & "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"& (ObjRecordSet2("COUNT")) & "<br>" dv = dv + dv1 End If objRecordset2.movenext Loop objRecordset2.Close objConnection2.Close document.write "" document.write "WESTHAMPTON" & "<br>" document.write "DATE"& "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" & "COUNT" & "<br>" document.write wh document.write "Total For WestHampton: " & westh & "<br>" & "<br>" document.write "" document.write "VINELAND" & "<br>" document.write "DATE" & "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" & "COUNT" & "<br>" document.write vn document.write "Total for Vineland: " & vnld & "<br>" & "<br>" document.write "" document.write" NEW BRUNSWICK" & "<br>" document.write "DATE" & "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" & "COUNT" & "<br>" document.write nb document.write "Total for New Brunswick: " & newb & "<br>" & "<br>" document.write "" document.write"DOVER" & "<br>" document.write "DATE"& "&nbsp" & "&nbsp" & "&nbsp" &"&nbsp"&"&nbsp"&"&nbsp"&"&nbsp" &"&nbsp" &"&nbsp" &"&nbsp" & "COUNT" & "<br>" document.write dv document.write "Total for Dover: " & dov </script> </div> <p align="center"> </p> </body> </html> Tag: Importing Information from Excel to AD Tag: 182871
  - 18
    - How to run console app with WshShell.Exec without console window? Hello, I want to execute console application with WshShell.Exec method from HTA. However, during execution new console is created and pops up before my application. Can I run console process without console window with WshShell.Exec? Note: I cannot use WshShell.Run since I need access to process' stdout/stderr streams. Thanks in advance Alex Tag: Importing Information from Excel to AD Tag: 182868
  - 19
    - Is a Wait needed Throught out my script I create and delete files and objects. For example: I copy a file to a new folder then wait 3 seconds before I see if the file exists in the new destination. I assume that the script can run faster than the copy process so the If FileExists can run before the Copy is complete. Is this true. Or does the next line not process until the previous has completed it's process. Throughout my script I have a total of a minute and 30 seconds in total waits. Tag: Importing Information from Excel to AD Tag: 182858
  - 20
    - Copy files Hi everyone. I need to create a login script that copy a lot of files from a directory for other. I've already done one like this but I need to make from a lot of directories from others. Here is the script that I'm using now: fromDir = "c:\1" toDir = "c:\2" start = Now() replaceSize = 0 copySize = 0 deleteSize = 0 noChangeSize = 0 Set fso = CreateObject("Scripting.FileSystemObject") Set logFile = fso.OpenTextFile("Sincronizacao.log", 8, True) logFile.WriteLine("") logFile.WriteLine("Iniciado ................... : " & start) logFile.WriteLine("Origem ..................... : " & fromDir) logFile.WriteLine("Destino..................... : " & toDir) If fso.FolderExists(fromDir) And fso.FolderExists(toDir) Then Call ReplicateDirectory(fromDir, toDir) Else logFile.WriteLine("Erro ...................... : Origem ou Destino inalcancaveis") End If Sub ReplicateDirectory(source, target) Set targetDir = fso.GetFolder(target) Set sourceDir = fso.GetFolder(source) Set targetDirFileList = targetDir.Files Set sourceDirFileList = sourceDir.Files Set targetDirFolderList = targetDir.SubFolders Set sourceDirFolderList = sourceDir.SubFolders For Each targetFile in targetDirFileList If fso.FileExists(source & "\" & targetFile.Name) Then Set sourceFile = fso.GetFile(source & "\" & targetFile.Name) If targetFile.DateLastModified <> sourceFile.DateLastModified Then targetFilePath = targetDir.Path & "\" & targetFile.Name 'targetFile.Delete(True) replaceSize = replaceSize + sourceFile.Size sourceFile.Copy targetFilePath Else noChangeSize = noChangeSize + sourceFile.Size End If Else noChangeSize = noChangeSize + targetFile.Size 'targetFile.Delete() End If Next For Each sourceFile in sourceDirFileList If Not fso.FileExists(target & "\" & sourceFile.Name) Then copySize = copySize + sourceFile.Size sourceFile.Copy targetDir.Path & "\" & sourceFile.Name End If Next 'For Each targetFolder in targetDirFolderList 'If Not fso.FolderExists(sourceDir & "\" & targetFolder.Name) Then 'deleteSize = deleteSize + targetFolder.Size 'targetFolder.Delete(True) 'End If 'Next For Each sourceFolder in sourceDirFolderList If Not fso.FolderExists(targetDir & "\" & sourceFolder.Name) Then copySize = copySize + sourceFolder.Size sourceFolder.Copy(targetDir & "\" & sourceFolder.Name) Else Call ReplicateDirectory(sourceFolder.Path, targetDir & "\" & sourceFolder.Name) End If Next End Sub finish = Now() logFile.WriteLine("Arquivos Identicos.......... : " & Round(noChangeSize / 1024 /1024, 1) & " MB") logFile.WriteLine("Arquivos Apagados........... : " & Round(deleteSize / 1024 /1024, 1) & " MB") logFile.WriteLine("Sincronizados............... : " & Round(replaceSize / 1024 /1024, 1) & " MB") logFile.WriteLine("Copiados para o Destino..... : " & Round(copySize / 1024 /1024, 1) & " MB") logFile.WriteLine("Tempo de execuÃ§Ã£o........... : " & DateDiff("n", start, finish) & " MIN") logFile.WriteLine("Total Transferido........... : " & Round((replaceSize + copySize) / 1024 / 1024, 1) & " MB") logFile.WriteLine("Finalizado.................. : " & finish) logFile.Close() My problem is: Need to sync a lot of Dir's with just one VBS. Tnks Tag: Importing Information from Excel to AD Tag: 182853
  - 21
    - Using vbscript to set folder permissions and change security settings Hope this is the right group for this question. I have an automated installation script that configures servers for our software installation (which does things like create shares, create windows user accouts etc etc) - these are run on Windows 2003 server. The script is actually a "dos" batch file (xxx.bat). Currently, on Windows 2003 there are three things that I would like to be able to add to the scripting, which I think I will need to use a xxx.vbs vbscript file to do. The items I want to be able to script are as follows: 1. Undisable the guest account 2. Change the permissions on a share - specifically add the guest account and allow all users and all guests to have full access to the share. 3. Change the security on a folder as per the share. 4. Change some of the local/domain security policies - particularly ones that control password aging, minimum password length etc. Can anybody point me in the right direction for any/all of the above? Thanks in advance Simon Tag: Importing Information from Excel to AD Tag: 182849
  - 22
    - naive question? I was trying to get the html of the page in my intnet explorer object into a variable I tired first internet = oIE.Document.innerhtml and I got treated to the message like not supported Obviously it would have be easy if there were some sort of clipboard function to load into variable. I know how to use execwb to get content, select all etc but that is all useless I tried sendkeys - did not work I tired selectall, copy to clipboard, then open notepad and paste and save with sendkey. that sort of work However it is vulnerable to error, user could be switching windows and cause havoc Any other ways? Tag: Importing Information from Excel to AD Tag: 182848
  - 23
    - VB editor I find the VB editor in office is very useful. Can i call it in XP environment (not in office)? Because i just do some scripts in FSO or Shell? Thanks a lot. tony Tag: Importing Information from Excel to AD Tag: 182836
  - 24
    - Msgbox is it possible to have an auto-close msgbox in a number of seconds. thx. tony Tag: Importing Information from Excel to AD Tag: 182835
  - 25
    - Collecting sysinfo from remote servers Hello, I've been given the task to modify an existing (workable) script that collects system info of the local server. I would like to run this script from one central server to remote servers and collect all info in either a single file or folder on my central server. The below script works perfectly but I am uncertain to how I can automate the process of collecting remote server info rather than performing the mundane process of copying/pasting the file to the remote server, executing and moving the output file to the central server. Any help would be appreciated.. *************Script Begin********************** '****************************************** 'SysConfig.vbs ' ' Documents Current System Configuration ' '****************************************** Option Explicit Dim SystemSet Dim System Dim Service Dim colServices Dim colProcessors Dim Proc Dim colDiskDrives Dim Disk Dim PhysicalMemory Dim NumofProcs Dim OpSys Dim colOpSys Dim strBootDevice Dim strSystemDevice Dim strSystemDirectory Dim strWindowsDirectory Dim objBIOS Dim colBIOS Dim colNetAdapter Dim NetAdapter Dim colNetAdapterConfig Dim NetAdapterConfig Dim strIPAddress Dim strIPSubnet Dim strDefaultIPGateway Dim i Dim CompSysProd Dim colCompSysProd Dim Product Dim colProducts Dim strProduct Dim Share Dim colShares Dim PageFile Dim colPageFile WScript.Echo "Date/Time of Configuration Scan: " & Now WScript.Echo "" Set SystemSet = GetObject("winmgmts:").InstancesOf ("Win32_ComputerSystem") For Each System In SystemSet WScript.Echo "Hostname: " & System.Caption WScript.Echo "Domain: " & System.Domain 'WScript.Echo System.SystemType WScript.Echo "System Memory: " & System.TotalPhysicalMemory NumofProcs = System.NumberOfProcessors Next Set colOpSys = GetObject("winmgmts:").InstancesOf ("Win32_OperatingSystem") For Each OpSys In colOpSys WScript.Echo "Operating System: " & OpSys.Caption & " " & OpSys.CSDVersion & " " & OpSys.Version WScript.Echo "Boot volume: " & OpSys.BootDevice WScript.Echo "System volume: " & OpSys.SystemDevice WScript.Echo "System Directory: " & OpSys.SystemDirectory WScript.Echo "Windows Directory: " & OpSys.WindowsDirectory wScript.Echo "Date of system install: " & OpSys.InstallDate Next Set colProcessors = GetObject("winmgmts:").InstancesOf ("Win32_Processor") WScript.Echo "Number of Processors: " & NumofProcs For Each Proc In colProcessors 'WScript.Echo Proc.SocketDesignation WScript.Echo "Processor: " & Trim(Proc.Name) Next WScript.Echo "" Set colPageFile = GetObject("winmgmts:").InstancesOf ("Win32_PageFile") For Each PageFile In colPageFile 'WScript.Echo PageFile.Caption 'WScript.Echo PageFile.CSName 'If PageFile.Description <> PageFile.Caption Then ' WScript.Echo PageFile.Description 'End If WScript.Echo "Pagefile drive: "& PageFile.Drive WScript.Echo "Pagefile filename: " & PageFile.FileName WScript.Echo "Pagefile size: " & PageFile.FileSize Wscript.Echo "Pagefile name: " & PageFile.Name Next WScript.Echo "" Set colDiskDrives = GetObject("winmgmts:").InstancesOf ("Win32_LogicalDisk") For Each Disk In colDiskDrives WScript.Echo "" WScript.Echo "Disk: " & Disk.Caption & " " & Disk.VolumeName If Not IsNull(Disk.Size) Then WScript.Echo "Disk size: " & Disk.Size End If Select Case Disk.DriveType Case 2 WScript.Echo "Drive type: Removable media" Case 3 WScript.Echo "Drive type: Local Disk" Case 4 WScript.Echo "Drive type: Network Drive" Case 5 WScript.Echo "Drive type: CD-ROM" End Select If Not IsNull(Disk.FileSystem) Then WScript.Echo "Disk filesystem: " & Disk.FileSystem End If Next WScript.Echo "" Set colCompSysProd = GetObject("winmgmts:").InstancesOf ("Win32_ComputerSystemProduct") For Each CompSysProd In colCompSysProd WScript.Echo "System model name: " & CompSysProd.Name 'If Not IsNull (CompSysProd.SKUNumber) Then ' WScript.Echo CompSysProd.SKUNumber 'End If WScript.Echo "System model version: " & CompSysProd.Version Next WScript.Echo "" Set colBIOS = GetObject("winmgmts:").InstancesOf ("Win32_BIOS") For Each objBIOS In colBIOS WScript.Echo "System Manufacturer: " & objBIOS.Manufacturer WScript.Echo "System BIOS version: " & objBIOS.Version WScript.Echo "System serial number: " & objBIOS.SerialNumber Next WScript.Echo "" WScript.Echo "-----Begin Networking Information-----" Set colNetAdapter = GetObject("winmgmts:").InstancesOf ("Win32_NetworkAdapter") For Each NetAdapter In colNetAdapter WScript.Echo NetAdapter.Caption WScript.Echo NetAdapter.Manufacturer If Not IsNull(NetAdapter.AdapterType) Then WScript.Echo NetAdapter.AdapterType End If If Not IsNull(NetAdapter.MACAddress) Then WScript.Echo NetAdapter.MACAddress End If If Not IsNull (NetAdapter.NetworkAddresses) Then WScript.Echo NetAdapter.NetworkAddresses End If WScript.Echo NetAdapter.ProductName Next WScript.Echo "" Set colNetAdapterConfig = GetObject("winmgmts:").InstancesOf ("Win32_NetworkAdapterConfiguration") For Each NetAdapterConfig In colNetAdapterConfig WScript.Echo NetAdapterConfig.Caption If IsArray(NetAdapterConfig.IPAddress) Then For i = 0 to UBound(NetAdapterConfig.IPAddress) WScript.Echo NetAdapterConfig.IPAddress(i) Next End If If IsArray(NetAdapterConfig.IPSubnet) Then For i = 0 to UBound(NetAdapterConfig.IPSubnet) WScript.Echo NetAdapterConfig.IPSubnet(i) Next End If If IsArray(NetAdapterConfig.DefaultIPGateway) Then For i = 0 to UBound(NetAdapterConfig.DefaultIPGateway) WScript.Echo NetAdapterConfig.DefaultIPGateway(i) Next End If If Not IsNull (NetAdapterConfig.MACAddress) Then WScript.Echo NetAdapterConfig.MACAddress End If Next WScript.Echo "-----End Networking Information-----" WScript.Echo "" Set colShares = GetObject("winmgmts:").InstancesOf ("Win32_Share") For Each Share In colShares WScript.Echo "" WScript.Echo "Share name: " & Share.Name WScript.Echo "Share caption: " & Share.Caption If Share.Description <> Share.Caption Then WScript.Echo "Share description: " & Share.Description End If WScript.Echo "Share path: " & Share.Path 'Debug ' WScript.Echo Share.Type 'End Debug Select Case Share.Type Case 0 WScript.Echo "Share type: " & "Disk Drive" Case 1 WScript.Echo "Share type: " & "Print Queue" Case 2 WScript.Echo "Share type: " & "Device" Case 3 WScript.Echo "Share type: " & "IPC" Case -2147483648 WScript.Echo "Share type: " & "Disk Drive Admin" Case -2147483649 WScript.Echo "Share type: " & "Print Queue Admin" Case -2147483650 WScript.Echo "Share type: " & "Device Admin" Case -2147483645 WScript.Echo "Share type: " & "IPC Admin" End Select Next WScript.Echo "" Set colProducts = GetObject("winmgmts:").InstancesOf ("Win32_Product") For Each Product In colProducts WScript.Echo "" WScript.Echo "Product name: " & Product.Name WScript.Echo "Product version: " & Product.Version If Not IsNull (Product.Vendor) Then WScript.Echo "Product vendor: " & Product.Vendor Else WScript.Echo "<no product vendor information>" End If Next WScript.Echo "" Set colServices = GetObject("winmgmts:").InstancesOf ("win32_service") For Each Service In colServices WScript.Echo "" WScript.Echo "Service: " & Service.Caption If Not IsNull (Service.Description) Then WScript.Echo Service.Description Else WScript.Echo "<no service description>" End If WScript.Echo " Executable: ", Service.PathName WScript.Echo " Status: ", Service.Status WScript.Echo " State: ", Service.State WScript.Echo " Start Mode: ", Service.StartMode Wscript.Echo " Start Name: ", Service.StartName Next WScript.Echo "" ************Script End***************** Tag: Importing Information from Excel to AD Tag: 182832

Hello,

I have written the following script to populate user info into AD. It
imports info fine for some of the fields...

Particularly I am having trouble with the "description" field. I have
deduced that when I have a number (620) it fails. If I change it to
a620 everything seems to zip right along. I have tried changing the
format of the Excel cell, and changing it to a .csv file to rule out
something goofy with Excels formatting.

If I go directly to AD and edit the field it takes numbers without any
qualms. Am I missing something, or is AD incapable of handling
numbers being imported into this field?

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open _
("h:\Scripts\test.xls")

Const ADS_PROPERTY_CLEAR = 1
Const ADS_PROPERTY_UPDATE = 2
Const ADS_PROPERTY_APPEND = 3
Const ADS_PROPERTY_DELETE = 4
intRow = 1

Do Until objExcel.Cells(intRow,1).Value = ""

Set objUser = GetObject _
("LDAP://cn=" & objExcel.Cells(intRow,1).Value & ",cn=Users,
dc=xxxxxx, dc=xxxxxx, dc=com")

objUser.Put "mail", objExcel.Cells(intRow, 2).Value
objUser.Put "description", objExcel.Cells(intRow, 3).Value
objUser.Put "physicalDeliveryOfficeName", objExcel.Cells(intRow,
4).Value
objUser.Put "title", objExcel.Cells(intRow, 5).Value
objUser.Put "department", objExcel.Cells(intRow, 6).Value
objUser.Put "telephoneNumber", objExcel.Cells(intRow, 7).Value
objUser.Put "mobile", objExcel.Cells(intRow, 8).Value
objUser.Put "facsimileTelephoneNumber", objExcel.Cells(intRow,
9).Value
objUser.Put "company", objExcel.Cells(intRow, 10).Value

intRow = intRow + 1

Loop

wscript.echo "Finished!"

objExcel.Quit

Thanks in advance for any help!

Jon Ziminsky

Top