PowerShell

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 11.2.0.4.0 – 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 […]

Windows PowerShell

Play with node-powershell!

Posted on

#iHeartPowerShell One of my colleague asked me a PowerShell script to query AD User information! Yes, I did your voice! Import-Module ActiveDirectory Get-ADUser -Identity <samaccountname> But, he asked “How will I do it in NODE JS with no AD Module?” Well! it’s too deep to discuss about node js! Anyways to make it simple I […]

Windows PowerShell

Create a HPSM9 incident with an attachment using PowerShell

Posted on

  One of our valuable customer asked a script to create a HPSM9 incident with a screen shot! Yes, it is really easy if we understand the WSDL! With no wait here is the snippet #region Attaching a screen shot $Stream = [System.IO.MemoryStream]::new() $Image = [System.Drawing.Bitmap]::new(“C:\Temp\Pictures\easy.jpg”) $Image.Save($Stream, [System.Drawing.Imaging.ImageFormat]::Jpeg) $Stream.Close() $ImageBytes = $Stream.ToArray() $Attachment = New-Object […]

EWS

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 – […]