Recent Posts
Don Hite
Return To Blog Listing
Tags: Break Time, By Request, Microsoft SQL Server, Odds & Ends, PowerShell, SMS 2003 SQL Queries, Vbs Scripts
Recent Posts Tagged With 'vbs scripts'
VBS Script To Send Clients Assigned And Installed Site Codes To Excel
This VBS Script will send your resources assigned and installed site codes to Excel. VBS Script: strServer = InputBox ("Enter Site Server Name") strDatabase = InputBox ("Enter Three Letter Site Code") S...
VBS Script To Send A Specified Site Servers Roles To Excel
This VBS Script will take a remote site servers name and site code and will send the site servers roles to an Excel spreadsheet for your records. VBS Script: strComputer = InputBox("Enter Site Server Name") strSiteCode ...
VBS Script Send A remote Machines Windows Updates List To Excel
This VBS Script will send the Windows Updates from a specified machine name to excel. VBS Script: strComputer = InputBox ("Enter Machine Name") Set objExcel = CreateObject("Excel.Application") objExcel....
VBS Script Find SMS Services On A Remote Machine
This VBS Script will allow you to find SMS Services on a specified site server. VBS Script: strComputer = InputBox ("Enter Machine Name") Set objExcel = CreateObject("Excel.Application") objExcel.Visib...
VBS Script To Send Last Hardware Scan Date Info To Excel
This VBS Script will send the following information for a specifies site server to excel: The Machine Name and whether it is Obsolete or Active and its last Hardware Scan Date. VBS Script: strServer = InputBox ("Enter Site S...
VBS Script To Browse For A Folder And Delete All Files In It
This VBS Script will allow you to browse for a directory folder and will delete all of the files in it. VBS Script: Set objShell = CreateObject("Shell.Application") Set objFolder = objShell.BrowseForFolder (0, "Sel...
VBS Script To Send Machines Site Code And Domain Information From A List Of Machines To Excel
This VBS script will take a list of machine names from a text file called MachineList.Txt and will send the following information to an Excel spreadsheet taken from the “All Systems” Collection: Machine Name, Resource ID, Site Code...
Terminal Server Users VBS Script
LogonType 10 is RemoteInteractive and covers both Interactive and Remote Terminal Services sessions. This is not avalible for Windows 2000 VBS Script: strComputer = InputBox("Enter Terminal Server Name") Set objE...
VBS Script To Send Windows NT or Active Directory User Names To Excel
This VBS Script will send all of the NT or Active Directory (AD) domain user names to excel. VBS Script: strDomain = InputBox ("Enter Domain Name Or Machine Name") Set objExcel = CreateObject("Excel.Applicat...
VBS Script To Send Windows NT or Active Directory Group Names To Excel
This VBS Script will send all of the NT or Active Directory (AD) domain group names to excel. VBS Script: strDomain = InputBox ("Enter Domain Name Or Machine Name") Set objExcel = CreateObject("Excel.Applica...
VBS Script To Add Multiple MMC 2.0 Snapins And Save It
This Script Requires MMC 2.0 and Above. VBS Script: Set objMMC = CreateObject("MMC20.Application") objMMC.Show objMMC.Document.snapins.add("Active Directory Users and Computers") objMMC.Document.snapins...
VBS Script To Add An MMC Snapin From An Input Box
This Script Requires MMC 2.0 And Above. VBS Script: strSnapin = InputBox("Enter Snapin Name") Set objMMC = CreateObject("MMC20.Application") objMMC.Show objMMC.Document.snapins.add(strSnapin) &nb...
VBS Script To Monitor SQL Servers SQL Service
This VBS Script will allow you to monitor the SQL Server service state for machines in a text file called MachineList.Txt. If the service is stopped the color will be red. VBS Script: strServiceName = "MSSQLSERVER" &nb...
VBS Script To Send Clients Management Point Information To Excel
This VBS Script will take a list of machines in a text file called MachineList.Txt and will send their Management Point (MP) information to Excel VBS Script: Set objExcel = CreateObject("Excel.Application") objExcel.Vis...
VBS Script To Find A Configuration Manager Collection ID For Specified Collection Name
This VBS Script will allow you to find the collection ID for a specified collection name. VBS Script: strComputer = InputBox ("Enter Site Server Name") strSiteCode = InputBox ("Enter Site Code") strName = Inpu...
VBS Script To Send Last Hardware Scan Date Information To Excel
This VBS Script will send last hardware scan information to Excel for your sites resources. VBS Script: strServer = InputBox ("Enter Site Server Name") strDatabase = InputBox ("Enter Three Letter Site Code") &...
VBS Script To Send A Remote Machines Local Administrators List To Excel
VBS Script: strComputer = InputBox ("Enter Machine Name") Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.Workbooks.Add intRow = 2 objExcel.Cells(1, 1).Value = "Ma...
VBS Script To Send All Configuration Manager IP Subnet Boundaries To Excel
VBS Script: strServer = InputBox ("Enter Primary Parent Site Server Name") strDatabase = InputBox ("Enter Three Letter Site Code") Set objExcel = CreateObject("Excel.Application") objExcel.Visible = ...
VBS Script To Send Basic Machine Information To Excel
This VBS Script will send the following information for a specified machine name to excel: Machine Name, User Name, Operating System, Build Version, Manufacturer and Model. VBS Script: strComputer = InputBox ("Enter Machine ...
VBS Script To Retrieve Machines And Their MAC Addresses From A Specified Site Server
This VBS script will retrieve machine names and their corresponding Media Access Control (MAC) addresses and send the results to an excel spreadsheet. VBS Script: strServer = InputBox ("Enter Site Server Name") strDatab...
VBS Script To Retrieve Laptop Battery Information For A List Of Machines
This VBS script will read a text file called MachineList.Txt and will write battery information for each of the resources to an Excel spreadsheet. VBS Script: Set objExcel = CreateObject("Excel.Application") objExcel.Vi...
VBS Script To Retrieve BIOS Information For A List Of Machines
This VBS script will read a text file called MachineList.Txt and will write BIOS information for each of the machines to an Excel spreadsheet. VBS Script: Set objExcel = CreateObject("Excel.Application") objExcel.Visibl...
VBS Script To Delete Files Older Than Eight Hours
This VBS Script will delete files in a specified directory folder that are older than 8 hours. VBS Script: strFolder = "C:\Folder Name" Set Fso = CreateObject("Scripting.FileSystemObject") Set Directory...
VBS Script To Send Site Server Populated Inbox File Counts To Excel
This VBS script is an updated version of previous scripts I wrote to count files in a specified Site Servers inboxes. The original script was written to allow me to monitor the Incoming and DDM inboxes and alert me to other inboxes where a bac...
VBS Script To Scan For Machines And Return Their NOS Information
This VBS script will allow you to scan your domain for machines and retrieve their Network Operating System (NOS) basic information. VBS Script: strComputer = InputBox ("Enter Server Name") Set objExcel = CreateO...
VBS Script Get Add And Remove Programs For A Specified Machine
This VBS Script will list the add and remove installed applications for a specified machine and send the results to excel. VBS Script: strServer = InputBox ("Enter SMS Server Name") strDatabase = InputBox ("Enter T...
VBS Script To Retrieve Users Home Drive Information And Send To Excel
This VBS Script will allow you to enter an Active Directory (AD) domain name and will send the users Login name, Full name, Home drive letter and home share path to excel. VBS Script: strDomain = InputBox ("Enter Domain Nam...
VBS Script Find Machines And Users With Windows Internet Explorer 7 Installed
This VBS Script will allow you to find machines and users with Windows Internet Explorer 7 Installed. VBS Script: strServer = InputBox ("Enter Site Server Name") strDatabase = InputBox ("Enter Three Letter Site Cod...
VBS Script To Monitor SQL Server Service Information From A List Of Machines
This VBS script will read a list of SQL Server machines in a text file called MachineList.Txt and will retrieve the SQL Service information for the servers and send the results to an excel spreadsheet. VBS Script: Set objE...
VBS Script To Send Organizational Unit Names And Paths From Active Directory To Excel
This VBS Script will send Organizational Unit (OU) Names And Paths From Active Directory (AD) To Excel VBS Script: strDomainName = InputBox ("Enter Domain Name") Const ADS_SCOPE_SUBTREE = 2 Set objExcel = C...
