Windows PowerShell

TIP: Query servicenow Incident record using PowerShell and REST API

Posted on

In order to query the servicenow incident records and to list out the required fields use the sysparm_fields column which helps in optimization. Now,  See the code, result and performance All Fields

Here is the result! (8 seconds for one record)

Selected Fields!

It’s 6 seconds! Approximately we get 2 seconds […]

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

We need to get the port number – Which is really a very straight forward approach using regular expression REGEX

Result : PORT […]

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!

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 shared an app which  […]

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

The documentation for HPSM9 is here! Get the full script from GitHub!