get-date

PowerShell Tip of the Week: Get name of a month and number of days

Recently I was working on a new report for entire environment. I had to calculate servers total uptime and downtime in previous month. I prepared script for that and one of the tasks was to check what was previous month name and number of days. Name of a month Concept of uptime report was that script will gather start/stop/crash information from eventlog and calculate time between of those events. It …

certificate

PowerShell Tip of the Week: Get certificate remotely

Get certificate details from remote machines. In this post I wanted to share simple script which check certificates expiration date. Get certificate details To get certificates details we can use Get-ChildItem command and provide cert path Cert:\LocalMachine\My. In this example I was looking for certificates which subject contains my computer name: As you can see above we get Thumbprint and Subject properties as default. In this case expiration date is …

Event ID's

PowerShell Tip of the Week: Query multiple event ID’s remotely

In my daily work I often need to look for specific event ID’s on all computers. As my environmnet contains mostly server core machines I always use PowerShell script for checking that. Multiple event ID’s Get-WinEvent cmdlet gets events from event logs, including classic logs, such as the System and Application logs, and the event logs that are generated by the Windows Event Log technology.  It also allows you to …

PowerShell Tip of the Week: SQL Server Native Client version

Recently I had to extract SQL Server Native Client version from all of my SQL machines. I would like to share simple script for extracting that information remotely from registry. SQL Server Native Client To find version using PowerShell we need to know where is it located. Easiest way for me was extracting this from registry: SQL Server 2008/2008 R2:– HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion SQL Server 2012/2016:– HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI11\CurrentVersion You …

PowerShell Tip of the Week: Create Invoke-WebRequest from Chrome

This week PowerShell tip will show you how to create Invoke-WebRequest from Chrome. Each scripter who wanted to properly use Invoke-WebRequest command to access some url knows that it is not so easy. Every time headers or some additional settings must be adjusted to properly gather all the data. Last update of Chrome web browser gives awesome functionality for PowerShell developers. In Chrome Dev Tools option to copy whole Invoke-WebRequest …

PowerShell Tip of the Week: Compare two CSV files

In this article I wanted to show you how to compare two CSV files using Compare-Object command. It might be useful if you run some scans on regular basis and want to check if they contains the same data. Compare-Object Script is based on Compare-Object cmdlet which compares two sets of objects. One set of objects is the “reference set,” and the other set is the “difference set.” The result …

PowerShell Tip of the Week: Combine multiple CSV files

Recently I had to combine multiple files and count unique users from them. Script is pretty simple but it might me useful in some troubleshooting sessions. Below you can find two examples about how can this be done. Combine CSV files I created folder called Files on my desktop and pasted there user lists in CSV format. Files contains multiple columns but I was focusing only on Samaccountname: File example …

PowerShell Tip of the Week: Check connectivity to multiple servers

You can find multiple articles on our blog about checking connectivity. This time I want to show you how to check it for bunch of servers on specific port. Check connectivity Script will use Test-NetConnection command where you can specify port number. For single machine you can use the following one-liner script: On the beginning you have to provide servers and destination servers againts which you want to check connection: …

PowerShell Tip of the Week: Building your first chart report

Today’s short tip will be about building your first chart report. You can find several articles on our blog about memory utilization. This time you will learn how to get results in columns chart. Chart report As some of you already know PowerShell allows you to create charts and graphs. To do this we need to use .Net classes. The System.Windows.Forms.DataVisualization.Charting namespace contains methods and properties for the Chart Windows …

PowerShell Tip of the Week: Uninstall SCCM client

Today’s short tip is about SCCM client uninstall process. One of the tasks for complete client removal is, of course, running ccmsetup.exe uninstall command. To do this for a bunch of servers we can use Invoke-Command. Uninstall SCCM client On the beginning its worth to check if ccmsetup.exe file exists on the affected machine. To verify this we are going to use Test-Path command which will return “True” of “False” value: File selection can be done using System.Windows.Form feature called OpenFileDialog: …