Retrieve Oracle instance port number using PowerShell | REGEX

Posted on

A requirement popped up to get the Oracle instance(s) port number before building a connection string for establishing a connection. Team used tnsping utility which returns results like shown below TNS Ping Utility for 64-bit Windows: Version – Production on 09-MAR-2018 04:44:04 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: D:\app\oracle\product\11.2.0\network\admin\sqlnet.ora […]


Get High Priority Email Message as a Phone Call using EWS API and PowerShell

Posted on

A colleague shared a blog post and asked me a script to get high priority email using PowerShell? Well, it’s the same way  by modifying the search filter as required as shown below. $SearchFilter = [Microsoft.Exchange.WebServices.Data.SearchFilter+IsEqualTo]::new([Microsoft.Exchange.WebServices.Data.EmailMessageSchema]::Importance, “High”) and the below is the view to get the number of email we need from the inbox – […]


Retrieve SharePoint Site Groups Information Using PowerShell

Posted on

A colleague asked me a script to retrieve SharePoint Site Groups information by excluding the user’s information and added he couldn’t use Select-Object cmdlet to exclude user’s collection in the group property. Yes, it’s not possible! But, we have a fix for it and here is the PowerShell script to get Group properties by ignoring […]