Grabbing a certain file from a networked machine

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
    - Print file to windows queue I'm looking for a way to programmatically (vbscript) to send data to a windows print queue (no user interface). The request to me was to have a web form that the user can fill out and then the web application would take this form data and send it to a print queue. I've googled several times and couldn't really find anything specific (probably just wrong keywords). Any help would be greatly appreciated. BBB Tag: Grabbing a certain file from a networked machine Tag: 164061
  - 2
    - Install network OR Local printer - script I learned how to use cnprt2.exe to install a network printer as default utilising the LOCATION=Suite variable. How do I take one step further to say if LOCATION is not suite OR if location=classx then connect to local printer EpsonC84 on LPT1 Server is 2k3 w/s are XP Pro SP2 Thanks Tag: Grabbing a certain file from a networked machine Tag: 164060
  - 3
    - Search Domain I would like to search a network domain for workstations then check each work station found for the installation of a particular program and if found ad a short cut to the all users startup. Is VBscript (or VB6) a logical way to do this? Where would I look to for information to start such a script? Thanks Martin Tag: Grabbing a certain file from a networked machine Tag: 164059
  - 4
    - Possible to get DFS information through WMI on Windows 2000? Windows 2003 has the "Win32_DfsNode" class, and a couple of others - is there a way when using a Windows 2000 environment to get information about DFS shares? In particular, how to determine which physical server is being connected to when a DFS share is in use? ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Grabbing a certain file from a networked machine Tag: 164057
  - 5
    - WMI query to get disk I/O and process creating files Is there a class in WMI to monitor when disk activity happens and then what process is creating the I/O to the disk? We have a server that when a file is created it is causing the drives to spin at full capacity and we cannot stop it without rebooting. We think we know what it is, but cannot be sure. So we want to monitor the disk activity and see what is causing the drives to spin at full capacity. TIA Tag: Grabbing a certain file from a networked machine Tag: 164055
  - 6
    - Removing Temp Files I regularly have to remove spyware/adware from different client PCs. Some of these PCs have multiple users. The first thing I do is boot into safe mode and remove all temp files, temp internet files, and cookies out of each users profile and delete the temp files out of the windows\temp folder. I was looking for a way to automate this process. Disk Cleanup does not remove all instances of these file. Does anyone know of a script or batch file that will clear out all file in the directories mentioned above? I also install 3 programs with regularity; SpyBot, Ad-Aware, and Spyware Blaster. If I could utilize a script or batch file to install all three at the same time that would be great. I understand that this may sound lazy. However, I do this with such regularity, with different clients at different locations. I am just looking for something to help automate the process. Thank you all in advance for your advice. I greatly appreciate it! Michael D. Alligood Tag: Grabbing a certain file from a networked machine Tag: 164050
  - 7
    - How to determine the supported interfaces of an ADSI object Is there any way (using VBScript) to determine the supported interfaces of a random ADSI object ? Best regards Johnny Nielsen Tag: Grabbing a certain file from a networked machine Tag: 164049
  - 8
    - Question about query sql server database I have a SQL Server possiblely with a database installed on it. I want to test if the database is installed and query for a table if it is installed. How do I do it with VBScript code? Any sample code? Tag: Grabbing a certain file from a networked machine Tag: 164048
  - 9
    - Registry Changes I have been tasked to write a script to manually update several local security policy entries in a large list of computers but without the use of group policy! All reserach I have done indicates the Administrative Templates section is registry addressable and is easy enough to script updates to, but not the Security Settings or Windows Settings sections, as they write to the Registry's protected area in HKLM\Security. Does anyone have any suggestions? Without calling secedit and template files, I've found no other alternatives. Thanks, Jack Tag: Grabbing a certain file from a networked machine Tag: 164047
  - 10
    - Printer driver unknown error on Script I have a win2003 server, and a bunch of XP Pro machines logging into it. I have written a script to map the shared printer durring login, but I get the following error upon execution: Script: \\server\netlogon\script.vbs Line: 3 Char: 1 Error: The printer driver is unknown Code: 80070705 Source: (null) The script is written as follows: Set WshNetwork = CreateObject("WScript.Network") PrinterPath = "\\server\share" wshNetwork.AddWindowsPrinterConnection PrinterPath wshNetwork.SetDefaultPrinter "\\server\share" It is my understanding that anything after Win 2000 or NT, that the driver does not need to be pre-loaded on the PC running the script, according to this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsmthaddwindowsprinterconnection.asp Tag: Grabbing a certain file from a networked machine Tag: 164046
  - 11
    - OnKeyDown Event - Unicode Ok, the OnKeyDown event handler allows me to cancel a key down event if the pressed key is not allowed. I understand that the value in window.event.keyCode is the Unicode value of the key pressed and not the keyCode of the character? So...if I want to write client-side (SIMPLE!!) script to not allow specified values, but allow other values (such as a formatted phone number) and auto-format the number entered (such as automatically enter the dashes and parens) ... how would YOU go about doing it? I've done it several times...but right now, I'm checking just about every value possibly that can be entered....isn't there a better way? (I have to make sure the user can delete, insert, et cetera...and paste too...but all data has to be validated and formatted prior to accepting the keystroke...) Any help would be appreciated... thanks Mythran Tag: Grabbing a certain file from a networked machine Tag: 164041
  - 12
    - Script to populate a profilePath to ALL Users in an OU i need some advise in modifying the below script-example so that i can use it to give ALL my users in an OU a profilePath because i don't want to add the profilePath to each of 800 users manually :-( The profilePath should be something like \\server\profiles\%USERNAME% The example creates the profilePath for only one user, but i need to create them on the fly for all. Any help is much appreciated !! regards Thomas Set objUser = GetObject _ ("LDAP://cn=Myerken,ou=Management,dc=NA,dc=fabrikam,dc=com") objUser.Put "profilePath", "\\sea-dc-01\Profiles\myerken" objUser.SetInfo Tag: Grabbing a certain file from a networked machine Tag: 164035
  - 13
    - Prevent Keystrokes Is the any scripts that could prevent any keystrokes for a period of time? Thank you in advance. Tag: Grabbing a certain file from a networked machine Tag: 164029
  - 14
    - VBScript to change smtp mail address Hello, I need to change the smtp mail address in exchange properties of AD objectfor lots of distribution groups. Can anyone guide me to a ADSI/VBSbscript to get to those properties Thx, Didier Tag: Grabbing a certain file from a networked machine Tag: 164026
  - 15
    - creating local printer port.. Hello everybody, Can somebody help me getting a vbscript that creates a "Local Printer Port" ? So far I could get information only on "TCP/IP printer port" but my requirement is creating a "Local Printer Port". Thank you, Vinod. Tag: Grabbing a certain file from a networked machine Tag: 164025
  - 16
    - CSV Header Row is incomplete Help! I'm trying to help out another post in this newsgroup. I don't understand why the following does not display each field in the header row. Only "Customer" is displayed along with all of the data columns. Watch for word-wrap. << test.csv >> Material, Customer, month 10000,19ABC, 122004 << test.vbs >> Option Explicit '* Const cVBS = "test.vbs" Const cCSV = "test.csv" Const cDIR = "C:\Temp\" Const cDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=?;Extended Properties=""text;HDR=NO;FMT=Delimited""" '* Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adCmdText = &H0001 '* Dim intRST intRST = 0 Dim strRST '* Dim objADO Set objADO = CreateObject("ADODB.Connection") objADO.Open Replace(cDSN,"?",cDIR) Dim objRST Set objRST = CreateObject("ADODB.Recordset") objRST.Open "SELECT * FROM " & cCSV, objADO, adOpenStatic, adLockOptimistic, adCmdText '* Do Until objRST.EOF WScript.Echo "#" & objRST.Fields.Count For Each strRST in objRST.Fields WScript.Echo "*" & strRST Next objRST.MoveNext Loop '* Set objRST = Nothing Set objADO = Nothing However, it will work if I change the CSV to: << test.csv >> 0,1,2 10000,19ABC, 122004 The above is based on: Much ADO About Text Files http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/ht ml/scripting03092004.asp Thanks in advance. Tag: Grabbing a certain file from a networked machine Tag: 164024
  - 17
    - How to import a arbitrary CSV file into SQL Server or Oracle from command line I have a CSV file with the first row in the CSV file to be the column headers. The file is as follows: Material, Customer, month,qty, sales 10000,19ABC, 122004, 90.5, 10000 20000,20ABC, 122004, 80.5, 12000 30000,21ABC, 122004, 70.5, 14000 40000,22ABC, 122004, 60.5, 16000 50000,23ABC, 122004, 50.5, 18000 I want to import this file from DOS command prompt command line into SQL Server or Oracle table. I am aware of tools like Bulk Insert in SQL Server or sqlloader in Oracle to import these files into the database but I want something simple to run from a command line given the database, table name, server name,etc can import this file by a make table into a Oracle or SQL Server table. Also, if possible I want to set a command line option to insert into the target table if existing rather than creating it. Can somebody please share a ADO VBscript that given the DSN can import a CSV file with column headers into a SQL or Oracle database. Thanks Karen Tag: Grabbing a certain file from a networked machine Tag: 164021
  - 18
    - How can I write some text? Hi, Is it possible to write some text at the bottom of what is already on the page so I can flash a message for example. If I use document.write it wipes the whole page and starts again at the top. Dave Tag: Grabbing a certain file from a networked machine Tag: 164018
  - 19
    - add Printer at logon Hi, I'm trying to add printer at logon on clients with win98 and win2003 sbs server. I install on the server, the drivers for win98. I've found a lot of script but doesn't works well. Someone could help me? This is what I have found on the VBS documentation: AddWindowsPrinterConnection Method Adds a Windows-based printer connection to your computer system. Windows NT/2000: object.AddWindowsPrinterConnection( strPrinterPath ) Windows 9x/Me: object.AddWindowsPrinterConnection( strPrinterPath, strDriverName[,strPort] ) Arguments object WshNetwork object. strPrinterPath String value indicating the path to the printer connection. strDriverName String value indicating the name of the driver (ignored if used on Windows NT/Windows 2000). strPort Optional. String value specifying a printer port for the printer connection (ignored on Windows NT/Windows 2000). Remarks Using this method is similar to using the Printer option on Control Panel to add a printer connection. Unlike the AddPrinterConnection method, this method allows you to create a printer connection without directing it to a specific port, such as LPT1. If the connection fails, an error is thrown. In Windows 9x/Me, the printer driver must already be installed on the machine for the AddWindowsPrinterConnection method to work. If the driver is not installed, Windows returns an error message. Example 1 The following code uses the AddWindowsPrinterConnection method to connect a network printer to a Windows NT/2000 computer system. [VBScript] Set WshNetwork = WScript.CreateObject("WScript.Network") PrinterPath = "\\printserv\DefaultPrinter" WshNetwork.AddWindowsPrinterConnection PrinterPath Example 2 The following code uses the AddWindowsPrinterConnection method to connect a network printer to a Windows 9x/Me computer system. [VBScript] Set WshNetwork = WScript.CreateObject("WScript.Network") PrinterPath = "\\printserv\DefaultPrinter" PrinterDriver = "Lexmark Optra S 1650" WshNetwork.AddWindowsPrinterConnection PrinterPath, PrinterDriver I have tryed this but it doesn't works on my 98 clients. Help pls. Thank you Tag: Grabbing a certain file from a networked machine Tag: 164017
  - 20
    - Sending messages with a complex body format I need to create a message with a quite complex body format (in term of fonts, pictures, signatures, logos and so on) and sent it using Outlook Automation. The samples I found look like the following: .Body = "This is the body of the message." &vbCrLf & vbCrLf A possible solution could be creating a message, saving it and then using Outlook Automation to send a copy just adding the recipient. Where can I find documentation and/or samples about sending messages with a complex format? Regards Mario Tag: Grabbing a certain file from a networked machine Tag: 164016
  - 21
    - ADSI Scripting Question A generic ADSI scripting question. How do you retrieve information about or manipulate an object in Active Directory if you don't want to specify the LDAP path in the script. For example; take a list of users in a text file, they could be located in many different OUs and then move the accounts to a newly created OU. Thanks in advance for any assistance. Tag: Grabbing a certain file from a networked machine Tag: 164015
  - 22
    - Modifying Local Policy - User Rights Policy with VBScript Hi there, I've been searching forever, and can't figure out how to edit a local policy with VBScript. I dont think using a command line tool is an option, unless it is included with XP Pro. Basically, I've created a user, assigned it to a service, but cannot figure out how to grant the user "Log in as a service" policy membership. I hope someone can help, I'm losing my mind. Darren Tag: Grabbing a certain file from a networked machine Tag: 164014
  - 23
    - Need install vbs script I have not used VB scripting before and hope to get some help from the experts out there. We need to create a .vbs file that will accomplish the following: 1) Get the path to the Windows system directory (SYSTEMROOT). 2) Call the .NET installutil.exe utility from within the appropriate folderin SYSTEMROOT to register a service we wish to install. This is a command line utility. So in our case, we would need to do something like: "C:\WINNT\Microsoft.NET\Framework\v1.1.4322 \installutil.exe myprogram.exe" 3) Same as #2 above but for the regasm.exe utility. Thanks in advance for any assistance you can provide. Tag: Grabbing a certain file from a networked machine Tag: 164009
  - 24
    - Question about vbscript and actual calls to GetIdsOfnames and Invoke on IDispatch Hi, Not sure if this is the correct forum to post in but here goes. I have what I see as a problem. I have created my own COM interface, call it IMyInterface for this discussion, in which I do my own implementation of IDispatch and do not rely on ATL for this. I also use the vbscript as the engine for my own implementation if IActiveScriptSite. I was under the impression that when using late binding for vbscript that IDispatch::GetIdsOfNames is called only once for a particular function( Is this correct? ). Ex function svcentry Dim fso Set fso = CreateObject("MyLib.MyInterface.1") for i = 0 to 10 fso.Sleep(100) next end function I would have expected that my interface would only be asked for id of Sleep once. This is not the case. GetIdsOfNames is called for EACH iteration of the loop. Is this the way that Vbscript always behaves or do I need to specify something for the engine so that it will store the DISPIDs of the items that it uses somewhere? It seems taht the more objects that I have as members of my interface the slower it will run in vbscript: Ex fso.memA.memB.memC = 9 would have to make about 4 calls to getidsofnames just to execute this one line, and if this line is repeated over and over say in a loop the speed hit could be fairly bad. If anyone can enlighten me I'd appreciate it. Or if this is not the correct forum than can someone point me to that as well. Thanky ou for your time. -Mac Dyer Tag: Grabbing a certain file from a networked machine Tag: 164008
  - 25
    - Transactional MSMQ I need to create a transactional msmq using vb script. The queue is created but not as a transactional one. Can anyone help? On Error Resume Next Dim Queue Set Queue = CreateObject("MSMQ.MSMQQueueInfo") Queue.PathName = ".\private$\MyQ" Queue.Create IsTransactional = True queue.label="MyQLabel" Thank you Tag: Grabbing a certain file from a networked machine Tag: 164000
- Next
  - 1
    - Using VBscript on Exchange 2003 server Hello, My goal is to run VBscripts on specific public folders on an exchange 2003 server. For example, when a message is inserted into a public folder named 'DivArchive' a vbscript would execute. That script would change certain things and resend the message. How do you assign a VBscript to run on a Exhange server following different events? Thanks, Nick Tag: Grabbing a certain file from a networked machine Tag: 163997
  - 2
    - use text file for strComputer in VBS script I am trying to scan my network using this script listed below to scan a list of servers from a text file. I can scan a single computer just fine but unable to get this to pull from a list of servers from a text file. Any help would be greatly appreciated. '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 = "E:\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: Grabbing a certain file from a networked machine Tag: 163996
  - 3
    - Could not complete cursor operation because the table schema changed after the cursor was declared Hi, My stored procedure was working fine but when i made added 2 fields to my table and then made subsequent changes to my sp it give me the following error: "Could not complete cursor operation because the table schema changed after the cursor was declared" it works fine from back end (query analyser) but when i execute from my dot net code it give the above error. does anyone help please ? Tag: Grabbing a certain file from a networked machine Tag: 163993
  - 4
    - Change file's modification date? Can someone suggest how I might be able to update the modification date of a file to the current date & time without losing the content of the (binary) file? Thanks. --Philip Tag: Grabbing a certain file from a networked machine Tag: 163992
  - 5
    - vbs to rename files in the directory This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C4AA6D.E3ECA330 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Hi, The following script is supposed to rename all files start with sg and = with extension .dat, it will remove the prefix sg from the file name. eg = : sgtestfile.dat --> testfile.dat. However, it is not working as expected, it returns error: "G:\Script\Test\rename.vbs(1, 19) Microsoft VBScript compilation error: = Expected end of statement Exit code: 1 , 0001h" Dim strPrefix As String, strExtension As String, strPath As String=20 Dim strFilePattern As String, strstrOldName As String, strNewName As = String=20 =20 strPrefix =3D "SG"=20 strExtension =3D "DAT"=20 strPath =3D "G:\Script\Test\"=20 =20 strFilePattern =3D strPath & strPrefix & "*." & strExtension=20 =20 Dim strFileFinder As String=20 strFileFinder =3D Dir(strFilePattern)=20 =20 Do Until strFileFinder =3D ""=20 strOldName =3D strPath & strFileFinder=20 strNewName =3D strPath & Right(strFileFinder, Len(strFileFinder) = - Len(strPrefix))=20 Name strOldName As strNewName=20 strFileFinder =3D Dir=20 Loop=20 Can anyone help, I feel that the line "strFileFinder =3D = Dir(strFilePattern)" is having problem. Thanks Frank ------=_NextPart_000_000E_01C4AA6D.E3ECA330 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312"> <META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The following script is supposed = to rename all=20 files start with sg and with extension .dat, it will remove the prefix = sg from=20 the file name. eg :  sgtestfile.dat --> = testfile.dat.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2> However, it is not working as = expected, it=20 returns error:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>"G:\Script\Test\rename.vbs(1, 19) = Microsoft=20 VBScript compilation error: Expected end of statement </FONT><FONT = face=3DArial=20 size=3D2>Exit code: 1 , 0001h"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>    Dim strPrefix As = String,=20 strExtension As String, strPath As String <BR>    Dim=20 strFilePattern As String, strstrOldName As String, strNewName As String=20 <BR>     <BR>    strPrefix =3D "SG"=20 <BR>    strExtension =3D "DAT" <BR>    = strPath =3D=20 "G:\Script\Test\" <BR>     <BR>   =20 strFilePattern =3D strPath & strPrefix & "*." & strExtension = <BR>     <BR>    Dim strFileFinder As = String=20 <BR>    strFileFinder =3D Dir(strFilePattern)=20 <BR>    <BR>    Do Until strFileFinder =3D = ""=20 <BR>        strOldName =3D strPath = &=20 strFileFinder <BR>        strNewName = =3D=20 strPath & Right(strFileFinder, Len(strFileFinder) - Len(strPrefix))=20 <BR>        Name strOldName As = strNewName=20 <BR>        strFileFinder =3D Dir=20 <BR>    Loop <BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Can anyone help, I feel that the=20 line "strFileFinder =3D Dir(strFilePattern)" is having = problem.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Frank</DIV> <DIV><BR></DIV></FONT></BODY></HTML> ------=_NextPart_000_000E_01C4AA6D.E3ECA330-- Tag: Grabbing a certain file from a networked machine Tag: 163990
  - 6
    - Host to get list of Unconfigured Components Does anyone know of a script that will display a list of unconfigured components on a 2003 Server? Thanks Tag: Grabbing a certain file from a networked machine Tag: 163988
  - 7
    - Create local account in XP I am looking for a way to check to see if an account exists in XP, and if not, create it, and keep running the VBS code until it is created and has Admin privileges(just in case the user add or group add fails). The only script I have now is the following to create the user. The questions I have are: 1) Am I creating the user correctly using VBS? (The code does work, but is there an easier way?) 2) How can I accomplish the goal as stated above using some type of VBS code? Thank you, Matthew CODE ---- WshShell.Run "NET USER AUTOCAD XXXXXXX /ADD /ACTIVE:YES /COMMENT:AUTOCAD /EXPIRES:12/31/2004 /FULLNAME:AUTOCAD /PASSWORDCHG:NO" WshShell.Run "NET LOCALGROUP ADMINISTRATORS AUTOCAD /ADD" Tag: Grabbing a certain file from a networked machine Tag: 163987
  - 8
    - Checking Domain Membership IsMember not working correctly I'm using IsMember to check for Domain Admins. I must be doing something wrong because it comes back positive for all users. Here's the code strGroup = "Domain Admins" If IsMember(strGroup) Then MsgBox "Hello" End If Function IsMember(strGroup) ' Function to test for group membership. ' strGroup is the NT name (sAMAccountName) of the group to test. ' objGroupList is a dictionary object, with global scope. ' Returns True if the user is a member of the group. If IsEmpty(objGroupList) Then Call LoadGroups End If IsMember = objGroupList.Exists(strGroup) End Function Sub LoadGroups ' Subroutine to populate dictionary object with group memberships. ' objADObject is the user object, with global scope. ' objGroupList is a dictionary object, with global scope. Dim objGroup Set objGroupList = CreateObject("Scripting.Dictionary") objGroupList.CompareMode = vbTextCompare For Each objGroup In objADObject.Groups objGroupList(objGroup.name) = True Next Set objGroup = Nothing End Sub Tag: Grabbing a certain file from a networked machine Tag: 163986
  - 9
    - Accsessing a .pst file via code for publishing to extranet Hi, Is there any way I can access the details from a Personal email folder storage file (.pst) without having to have it in a mail box. Jeni Tag: Grabbing a certain file from a networked machine Tag: 163977
  - 10
    - Adding to Path environment variable I've been looking for a way to add a directory to Path for an installer. I need to set Path permanently, not just while the command prompt is open, so I can't use the set command. I figured I should write somewhere in the registry, so I searched the registry for a directory currently in the Path system variable, but I couldn't find it. I think I found where PATH data is stored for the owner, but I'd rather set the Path for all users. I could call the command line program PathTool ( http://www.digievo.co.uk/software.asp?category=1 ) from my script to add to Path, but PathTool is a 72K exe with features that I don't need. The VBScript at http://www.winguides.com/scripting/reference.php?id=138 seems more practical for my needs, but I need some help to customize it. I only have access to Windows XP. With a little help from a VBScript reference (since I don't know VBScript), I was able to customize the VBScript to add to Path on XP and other NT based systems. I came up with the following script: Set WshShell = WScript.CreateObject("WScript.Shell") Set WshEnv = WshShell.Environment("SYSTEM") WshEnv("Path") = WshEnv("Path") & ";directory/to/add/goes/here" All I need is a way to sniff out Windows 95, 98 and Me and change the code as needed when one of those systems is detected. My best guess is to learn how to read the registry from the command prompt and see if "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\PathName" contains "C:\WINNT" and if not, assume it's Windows 95, 98, or Me and (somehow) add to the Path in autoexec.bat, but I don't think users of my product would appreciate me playing a guessing game with their registry. Any help would be appreciated. Barry Tag: Grabbing a certain file from a networked machine Tag: 163976
  - 11
    - overwrite some files Hi, I'm Nicola a sysadmin who really needs to start studying some kind of scripting language........ I need to overwrite some files from a server to a lot of clients in our network, not to all and the conditions are: 1)to find a folder called "c:\sigla" 2)the files on the server are newer then the clients' one. All the computers are in a windows 2003 domain (active directory is up and running) and use a Microsoft OS, from NT workstation to XP. Tag: Grabbing a certain file from a networked machine Tag: 163974
  - 12
    - Determine user idle time in script Is there a way to determine (through WMI, or some other way) time user has been idle (no mouse or keyboard events)? Drazen! Tag: Grabbing a certain file from a networked machine Tag: 163973
  - 13
    - ASP, Link Variables and Forms I am having a brain freeze and need help with an easy question. I have a page called RemoveClass.asp with a form that has a button to remove a class. There is one form for each class. They all have the same name. Here is what my code looks like: 'start looping <form name="form1" action="RemoveClass.asp?RemoveClass=<%=ObjRS("ClassID")%>" method="post"><INPUT type="submit" value="Remove" name=RemoveClass></form> 'move to next class 'next loop The problem is that when the Remove submit button is clicked the browser goes to RemoveClass.asp not RemoveClass.asp?RemoveClass=?ID12345. I viewed the source and there don't seem to be any errors. The class ID is being inserted properly and when I enter the link manually with the RemoveClass variable name it works. How do I put this variable in the link? I know I did this before and I think it was with the action property. Any ideas? Thanks for the help. Tag: Grabbing a certain file from a networked machine Tag: 163962
  - 14
    - How can i use "LIKE" ? I want to compare two string and want to use "LIKE" (user define a string format), how can I do ? Tag: Grabbing a certain file from a networked machine Tag: 163961
  - 15
    - Get all users from AD I have a Vbs script which changes dis[play name to "surname, forename". What code do I need to connect to AD and apply this to each user? Any help appreciated Gordon Tag: Grabbing a certain file from a networked machine Tag: 163959
  - 16
    - Sending Email From DOS Prompt.. Hi, I found this on web in this it's using local smtp server.if i want to use remote smtp server what changes should i make. '-------------------------------------------------- ' ' Sends email from the local SMTP service using CDONTS objects ' ' Usage: ' sendmail -t <to> -f <from> -s "<subject>" -b "<message>" ' sendmail [-help|-?] ' '-------------------------------------------------- Option Explicit On Error Resume Next Dim objSendMail, oArgs, ArgNum Dim strTo, strFrom, strSubject, strBody Set oArgs = WScript.Arguments ArgNum = 0 While ArgNum < oArgs.Count Select Case LCase(oArgs(ArgNum)) Case "-to","-t": ArgNum = ArgNum + 1 strTo = oArgs(ArgNum) Case "-from","-f": ArgNum = ArgNum + 1 strFrom = oArgs(ArgNum) Case "-subject","-s": ArgNum = ArgNum + 1 strSubject = oArgs(ArgNum) Case "-body","-b": ArgNum = ArgNum + 1 strBody = oArgs(ArgNum) Case "-help","-?": Call DisplayUsage Case Else: Call DisplayUsage End Select ArgNum = ArgNum + 1 Wend If oArgs.Count=0 Or strTo="" Or strFrom="" Or _ strSubject="" Or strBody="" Then Call DisplayUsage Else Set objSendMail = CreateObject("CDONTS.NewMail") objSendMail.From = strFrom objSendMail.To = strTo objSendMail.Subject = strSubject objSendMail.Body = strBody objSendMail.Send Set objSendMail = Nothing End If ' Display the usage for this script Sub DisplayUsage WScript.Echo "Usage:" WScript.Echo " sendmail -t <to address> -f <from address> -s " & _ Chr(34) & "<subject>" & Chr(34) & " -b " & Chr(34) & _ "<message body>" & Chr(34) WScript.Echo " sendmail [-help|-?]" WScript.Echo "" WSCript.Quit End Sub Tag: Grabbing a certain file from a networked machine Tag: 163955
  - 17
    - Need Script Please !! unlock local Adminstrator accounts on 140 machines We had a virus which I got under control. It tried to hack every administrator account on the local machines and therefore locked about every one of them. I am just learning scripting, and not a pro by any means yet. I have about 140 machines and the names of the machines. I can put the names in a txt or csv file. I have tried a few things but just can't get it working. Any help would be appreciated. A script template where I could fil in the blanks IE: csv file or text file or domain info etc would be greatly appreciated. stoneyw@triad.rr.com Tag: Grabbing a certain file from a networked machine Tag: 163954
  - 18
    - Taskbar toolbars Is it possible to add a custom toolbar to the taskbar using VBScript? This would be the same as right-clicking on the taskbar, choosing Toolbars, then "New toolbar". Are these toolbars stored in the registry somewhere? Tag: Grabbing a certain file from a networked machine Tag: 163951
  - 19
    - VBscript to send mail Dear all how do i write a script, to send mail to myself if the anti-virus is not installed.we use exchange 2000. Eashwar Tag: Grabbing a certain file from a networked machine Tag: 163948
  - 20
    - How to start a excelfunction Hello, How can I start an Excel Sub or Function? set xlApp = CreateObject("Excel.Application") xlApp.Visible = True set WB = xlApp.workbooks.open _ ("F:\XY.xls") name of function = test1 what is the right code? run WB? Thank you Wolfgang Tag: Grabbing a certain file from a networked machine Tag: 163946
  - 21
    - Running vbscript when PC starts I want to run a vbscript each time my PC starts and before any user has login. The vbscript changes user passwords. Where should I place or install the script? Thanks Tag: Grabbing a certain file from a networked machine Tag: 163934
  - 22
    - XCACLS not reading file path with space When I run the function below, all works well until there is a space in a folder name. Then XCACLS only reads to the space and then errors out because of bad path... Any ideas... Function Subfolder(Folder) For Each objFolder in Folder.Subfolders ReDim Preserve arrSubfolders(intSize) ReDim Preserve arrPermissions(intSize) arrSubfolders(intSize) = objFolder.Path 'arrPermissions(intSize) = objFolder.Permissions Set objFSO = WScript.CreateObject("Scripting.FileSystemObject") Set objShell = WScript.CreateObject("Wscript.Shell") objName = arrSubfolders(intSize) objFileName = objFolder.Name & ".txt" Set objTextFile = objFSO.CreateTextFile(objFileName) objTextFile.Close Set objTextFile = objFSO.OpenTextFile(objFileName, 1) objShell.Run "cmd /c cscript xcacls.vbs " & objName & "> " & objFileName, intWindow, True objTextFile.Close intWindow = 0 Set objTextFile = objFSO.OpenTextFile(objFileName, 1) Do While objTextFile.AtEndOfStream <> True strText = objTextFile.ReadLine 'Put info into spreadsheet here If Mid(strText, 12, Len(objRecordSet.Fields("Name").Value)) = objRecordSet.Fields("Name").Value Then objSheet.Cells(row,6).Value = objFolder End If ReDim Preserve arrPermissions(intSize) arrPermissions(intSize) = arrPermissions(intSize) & vbLfCr & strText WScript.Echo strText Loop objTextFile.Close intSize = intSize + 1 Subfolder objFolder Next End Function Thanks.... Tag: Grabbing a certain file from a networked machine Tag: 163932
  - 23
    - Sub fails syntax check, but only within function I have a blob of code that I run as part of a custom action within a Windows Installer session. This code runs flawlessly every time it has run. I decided to get cute and use error-handling, so I wrapped the code in a function declaration. Now it bombs instantly with a syntax error. I don't understand why. code .. .. code works fine, but Function SomeFunction() code .. .. code End Function dies. Does this make sense? There is a subroutine in the code blob that calls itself recursively (it's a registry delete code blob). Can you not run subs within functions? Any help would be appreciated. Tag: Grabbing a certain file from a networked machine Tag: 163926
  - 24
    - Help with debugging Can someone please tell me why the following code does not behave correctly? When processing the "IF THEN" statement it chooses the correct "exe" from the INPUTBOX and the MSGBOX I create runs correctly but then the script continues to process the next statement after the "ELSE" and displays the second msg box as well, even though it correctly does not run the 2nd executable. What am I doing wrong? How do I isolate the MSGBOX to only the first statement? Option Explicit On Error Resume Next Dim objShell Dim objScriptExec Dim strmsg1 Dim strmsg2 method = InputBox ("Run test 1 or test 2?", "TEST", "1") strmsg1 = MsgBox ("You are test1", 64, "1") strmsg2 = MsgBox ("You are test2", 64, "2") Set objShell= CreateObject("Wscript.Shell") If method = "1" Then Set objScriptExec = objShell.Exec ("1.exe") strmsg1 Else If method = "2" Then Set objScriptExec = objShell.Exec ("2.exe") strmsg2 End If Any help would be appreciated, thanks! I'm trying ;) Derek Tag: Grabbing a certain file from a networked machine Tag: 163925
  - 25
    - Select Case problem I am trying to write a script that will perform some commands on all folders in a directory that start with a list of characters. For now I am just echoing the folder names. In this case I need all folders that start with a, b, or c. In the code below I am creating a virable named oCaseString that = "a","b","c". When the line [Case oCaseString] is read it does not find any matches even though there are a number of directories that start with a, b, or c. If I change th line to [Case "a","b","c"] it works. I cannot figure out why the variable is not working. Any help will be greatly appreciated. ============================= Set oFile = CreateObject("SCripting.FileSystemObject") homePaths = Array("serverName|shareName|a.b.c") For Each Item In homePaths tmp1 = Split(Item, "|") tmp2 = Split(tmp1(2), ".") For i=LBound(tmp2) To UBound(tmp2) tmp3 = tmp3 & chr(34) & tmp2(i) & Chr(34) & "," Next tmp4 = (Len(tmp3) -1) oCaseString = Left(tmp3, tmp4) oString = Chr(34) & "a" & Chr(34) & "," & Chr(34) & "b" & Chr(34) Set oFolder = oFile.GetFolder("\\" & tmp1(0) & "\" & tmp1(1)) Set oSubFolderList = oFolder.SubFolders For Each Folder In oSubFolderList Select Case LCase(Left(Folder.Name, 1)) Case oCaseString ' Case "a","b","c" WScript.Echo folder.name Case Else WScript.Echo "x" End Select Next Next Tag: Grabbing a certain file from a networked machine Tag: 163920

Hi
I have some roving colleagues with laptops who are supposed to be making
backups of certain files (mostly PST) when they check back to the office.
But they don't. Is there any reliable VBS way to grab a file from a laptop
once the machine is hooked back onto the lan ?

All these machine have a certaine name beginning with "PORT"
PORT-HARRY
PORT-JENNY etc

I imagine it would be feasible to have a script that would run - say -every
two hours on a server that would check to see if a "PORT-xxx" machine had
reconnected and then scan its entire C: disk looking for PST files? Then
copy them somewhere safe on the server?

Could anyone please give me some ideas on how to do that ?

TIA

Mosalie Rignon

Top

Re: Grabbing a certain file from a networked machine by Bruce

Bruce
Wed Oct 06 16:59:59 CDT 2004

Mosalie,

If you are using Win 2000 or XP, you might want to look at the
Synchronization Manager ...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;312171

I don't know if it applies to other versions of Windows.

Alternatively, if you are sure you want to script it yourself, you might
want to consider working the other way around ... that is, adding a trigger
to the local machine's logon script to detect if the lan is available and
then do a copy to the fileshare of interest.

Bruce

"Mosalie Rignon" <Mosalie.Rignon@bidon.net> wrote in message
news:4163eaa8$0$17764$8fcfb975@news.wanadoo.fr...
> Hi
> I have some roving colleagues with laptops who are supposed to be making
> backups of certain files (mostly PST) when they check back to the office.
> But they don't. Is there any reliable VBS way to grab a file from a laptop
> once the machine is hooked back onto the lan ?
>
> All these machine have a certaine name beginning with "PORT"
> PORT-HARRY
> PORT-JENNY etc
>
> I imagine it would be feasible to have a script that would run -
say -every
> two hours on a server that would check to see if a "PORT-xxx" machine had
> reconnected and then scan its entire C: disk looking for PST files? Then
> copy them somewhere safe on the server?
>
> Could anyone please give me some ideas on how to do that ?
>
> TIA
>
> Mosalie Rignon
>

Top