This is just an exercise and not a great technical content in both NODE and PowerShell. I was helping my friend to achieve his needs in PowerShell and fixed all issues as planned. All happens over a coffee right? Here comes a question from him! How can I show data processed using PowerShell in fancy […]
While working on Microservice development using NODE JS and PowerShell I have got stumped on Parameterization issue. So far I was working with single parameter all went fine and now got a new scenario where I need to work with two parameters with space as well. Interesting right? Yes, I meant the white space in […]
In this blog post I will walk you through the simple steps to create a self request form using PowerShell and NODE.JS. As you guessed, I used the below packages to make my job easy. Express node-powershell pug Our goal is to deliver a form as illustrated below! First Name: Last Name: Email: Department: Copyright […]
This blog post is to demo the speech synthesizer using PowerShell. What’s new? Well nothing, except blending the PowerShell script with Node JS. To know about Speech Synthesizer refer MSDN – Reference for PowerShell is captured in idera PowerShell Tip (Speech-Week) Yes, this reminded a project I delivered for one of our Dutch customer! Now, it’s time to […]
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
|
1 2 3 4 5 6 7 8 9 10 11 |
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 Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ORAHOSTNAME)(PORT = 15210))) (CONNECT_DATA = (SERVICE_NAME = oracle))) OK (20 msec) |
We need to get the port number – Which is really a very straight forward approach using regular expression REGEX
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
$inputData = @" 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 Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLESERVER123)(PORT = 15210))) (CONNECT_DATA = (SERVICE_NAME = oracle))) OK (20 msec) "@; $data = [Regex]::Match($inputData, "(PORT = )\d+").Value; $data |
Result : PORT […]
A colleague asked me a script to trigger an event on 5th business day from the date of submission. Changing the script condition for management is hell! We need reminder in one business day, no well make it two! Hang on, keep it for 5 business day! Here is the requirement! When user submit a […]
Indeed, many moved to SNOW (servicenow) and enjoying it where in few customers are still using legacy products! In my work place snow is in proof of concept stage. Like many automation enthusiast I love to explore both REST and SOAP for solving customer requirements. In this article I will walk you through the steps […]
BMC TrueSight – An Aerial View!!! While working on Event Management a requirement popped up “Update TruSight the slot value when orchestrator automates the event(s)”. In short the automation agent should close the alert after auto-healing. I expected a REST endpoint but unfortunately SOAP web service was the only option. To solve this we have […]
#iHeartPowerShell One of my colleague asked me a PowerShell script to query AD User information! Yes, I did your voice!
|
1 2 |
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 shared an app which […]
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
#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 ($NameSpace + ".AttachmentType") $Attachment.action = "add" $Attachment.name = "EasyDemo.jpg" $Attachment.len = $ImageBytes.Length $Attachment.contentId = "attachment" $Attachment.attachmentType = "Image/Jpeg" $Attachment.Value = $ImageBytes $IncidentInstanceType.attachments = $Attachment #endregion |
The documentation for HPSM9 is here! Get the full script from GitHub!