The information about processors, cores and logical processors is a bit confusing. However, since it may be required for Windows and SQL server licensing [1], below some queries and links. Get details about SQL Server installations: select distinct fcm.Name as [Machine Name], arp.DisplayName0, sys.Active0 , WS.LastHWScan as [Last Inventory], sys.CPUType0 as [CPU Type], p.Name0 as… Read More »
Changing the account that is running a service is a little bit tricky with PowerShell. The script below will replace the current account (let’s assume it’s local system) with a local user account that the script creates and adds to the local admin group. Local admin rights are generally not required for the purpose of… Read More »
Measure the bandwidth between a Site Server and its Site Systems The script below will test the available bandwidth between the Primary server and all site systems that belong to the infrastructure. The result will be saved as html and csv. The measurement is done by taking the time it takes to copy a 100MB… Read More »
The script gives you details about the updates in an update group including the size of each update. Mind that a download for a certain kb article may consist of different installation files for different releases (like x86, x64, amd etc.) or different languages. The report should help you to figure out how much content… Read More »