Search found 182 matches

by rasimmer
Mon Feb 23, 2009 8:11 am
Forum: VBScript
Topic: Is this possible?
Replies: 2
Views: 903

Is this possible?

Yes you can. You would use ADO to connect to the DB and do a query. Something like (http://www.netstumbler.org/f24/simple-vbscript-update-ms-access-database-18601/): Set MyConn = CreateObject("ADODB.Connection") MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesNetwork Stumble...
by rasimmer
Mon Feb 23, 2009 1:28 am
Forum: VBScript
Topic: batch copy
Replies: 2
Views: 853

batch copy

Well, the script is simple FOR_READING = 1 Set objFSO = WScript.CreateObject("Scripting.FileSystemObject") Set objComputers = objFSO.OpenTextFile("C:computers.txt", FOR_READING, False) Do Until objComputer.AtEndOfStream strComputerName = Trim(objComputer.ReadLine) Copy_Folder(strComputerName) Loop S...
by rasimmer
Wed Feb 18, 2009 6:30 am
Forum: VBScript
Topic: Pulling Data From .CSV Txt File
Replies: 5
Views: 2153

Pulling Data From .CSV Txt File

You're reading excel like a DB, so it would be like: objRecordset.Open "Select * FROM ~tab_name~ Where Computer Name = '#" & strHireDate & "#"', _ In Excel, the "table" is the tab name and you need to have apostrophes around your search. You have computer names named by hiredate? If you are trying t...
by rasimmer
Wed Feb 18, 2009 6:15 am
Forum: VBScript
Topic: Comparison Scripting
Replies: 9
Views: 2994

Comparison Scripting

In your first FOR you add all of the dictionary objects for Server1 and then either add the printer if the key doesn't exist from Server1: dct.Add element, "Server2" or append the second second server to the key: dct(element) = dct(element) & ",Server2" So, any printers that were added would be on t...
by rasimmer
Wed Feb 18, 2009 1:32 am
Forum: VBScript
Topic: Comparison Scripting
Replies: 9
Views: 2994

Comparison Scripting

This is making my brain hurt, so maybe someone else has done this and can help me along. Basically I have 2, one dimensional arrays that are sorted alphabetically. The arrays contain print driver names from servers, which I want to compare what drivers are loaded on serverA and serverB. The output w...
by rasimmer
Wed Feb 18, 2009 1:32 am
Forum: VBScript
Topic: Comparison Scripting
Replies: 9
Views: 2994

Comparison Scripting

This is making my brain hurt, so maybe someone else has done this and can help me along. Basically I have 2, one dimensional arrays that are sorted alphabetically. The arrays contain print driver names from servers, which I want to compare what drivers are loaded on serverA and serverB. The output w...
by rasimmer
Fri Feb 13, 2009 4:33 am
Forum: VBScript
Topic: invalid argument in HTA file
Replies: 11
Views: 8301

invalid argument in HTA file

What line are you getting the error on? You also might want to edit your post and take your IP's out of there, just a suggestion.rasimmer2009-02-13 11:45:29
by rasimmer
Fri Feb 13, 2009 12:25 am
Forum: VBScript
Topic: Script help
Replies: 10
Views: 3580

Script help

Well, your not doing a simple script and this isn't a simple query your trying to pull off and in scripting there is 100 ways to do the same thing. If it were me, I would remove all of the !, only query one group and basically get the computers that are in that group and put it into a text file. Dum...
by rasimmer
Thu Feb 12, 2009 6:35 am
Forum: VBScript
Topic: Script help
Replies: 10
Views: 3580

Script help

Are you using the AND (&) or OR (|) operator in the script?
by rasimmer
Thu Feb 12, 2009 2:22 am
Forum: VBScript
Topic: Script help
Replies: 10
Views: 3580

Script help

Your getting the error because it doesn't like the query your passing and isn't executing it. Remove one the parentheses from the first 2 lines, like: & "(|!memberOf=cn=WSUS PC Tier1,ou=WSUS,dc=mydomain,dc=net)" _& "(|!memberOf=cn=WSUS PC Tier2,ou=WSUS,dc=mydomain,dc=net)" _& "(!memberOf=cn=WSUS PC ...