The below script will find the screen aspect ratio of a computers primary video controller by querying WMI. The script stores the horizontal and vertical resolution for each video controller in an array and returns the result of dividing the …
The below SQL script will return a list of tables in a database along with the table sizes in MB. You will get a report like the below;
Updated: 02/09/2016 – Fixed multiple bugs, added disk space monitoring and now using PowerShell remoting so the script no longer needs to be run directly on a Citrix Server Details Recently I had a need for a tool that would …
Disabling and Enabling All SQL Server Agent Jobs As part of a recent Microsoft SQL Server migration project I had a need to disabled and enable all of the Agent Jobs as various points, the below scripts did the job. This …
In this post you will find some method of return some helpful information for Microsoft SQL Get a list of databases The below query will return a list of none system databases on a Microsoft SQL Server; Or you can …
Windows holds so much great information in the WMI including information on the battery. The below is a little PowerShell function that will show you what state your laptop battery is in full, charging etc. Function Check–BatteryState { param($Laptop=$env:computername) $Bstatus …
This script will allow you to migrate user’s printer connections to a new server based on the printer model or the queue name. If you would prefer a big bang approach and migrate all printers based on the server’s name, …
The below little VBS script is an example of how to pull back a list of network printers a users is connected to. This script is only pulling back the server and share names but you could retrieve other properties …
The below VB.net Console Application will simply return the MD5 hash of a file you pass to it as an argument. Exmaple Usage: “C:\test\File_MDS_Hash_Generator.exe” C:\Program Files (x86)\Microsoft Office\OFFICE11\EXCEL.EXE <enter> 3D478B8AF281FA52E8EF1BD9E7895DA5 Do NOT enclose the argument with quotes even if your …
I recently had a need to list the properties of all files in a folder and its sub folders to find files that had not been used in a long time, or files where the owner had left. In my …
