MY Notes

script that has WMI connection error will skip it and move to next

by

strComputer = “MYcomputername” Set objExcel = CreateObject(“Excel.Application”) objExcel.Visible = True objExcel.Workbooks.Add intRow = 2 objExcel.Cells(1, 1).Value = “Logon Name” objExcel.Cells(1, 2).Value = “Full Name” objExcel.Cells(1, 3).Value = “Description” objExcel.Cells(1, 4).Value = “Domain” objExcel.Cells(1, 5).Value = “Password Changeable” objExcel.Cells(1, 6).Value = “Password Required” objExcel.Cells(1, 7).Value = “Password Expires” objExcel.Cells(1, 8).Value = “Account Disabled” objExcel.Cells(1, 9).Value = … Read more

Excel output Script : for file version check well explained

by

Correct Script Set Fso = CreateObject(“Scripting.FileSystemObject”) Set InputFile = fso.OpenTextFile(“MachineList.Txt”) Set objExcel = CreateObject(“Excel.Application”) objExcel.Visible = True objExcel.Workbooks.Add intRow = 2Do While Not (InputFile.atEndOfStream) strComputer = InputFile.ReadLine intRow = intRow +1 objExcel.Cells(1, 1).Value = “System Name”objExcel.Cells(1, 2).Value = “Version”Set objWMIService = GetObject(“winmgmts:” & strComputer & “rootcimv2”)Set colFiles = objWMIService.ExecQuery _     (“Select * from CIM_Datafile … Read more

Sysprep parameters

by

Sysprep parameters You can use the following optional parameters with the Sysprep command in Windows XP: -activated – Do not reset the grace period for Windows product activation. Use this parameter only if you have activated the Windows installation in the factory.Important The product key that you use to activate the Windows installation must match … Read more

DNS Bulk ADD

by

use ease:– For /F %a in (list.txt) do addaptr.bat %a list.txt sample input is addaptr.BAT DNSSERVERNAME COMPUTERSNAMETOBEADD.DOMAINNAME.COM IPADDRESS addaptr.bat 10.0.0.20 QTEST.PADDYMADDY.COM 10.0.0.23   script:- ::  addaptr.bat::::  Purpose:         Add an A and PTR record using dnscmd.exe::::  Usage:           addaptr dnsserver fqdn ipadd::::                     dnsserver  DNS server’s ip, hostname or “.” if the::                                DNS service is running on local … Read more