I was experimenting “Filter HTML Table rows using PUG” and got a PING for the same requirement! It’s easy using CDN and JS Script (I used it only for demo purpose.) For sure, I will walk you through the steps in bootstrap consumptions later in my blog post. I say “NO” for CDN because of […]
This blog post is to answer the question I received in my inbox as result of my previous System Information Web Apps using Node JS, PUG and PowerShell. How to highlight table cells using PowerShell ? I wanted to show process information and if the handle is greater than 600, change the background as brown! […]
It all started with a simple question “How to deliver reports to clients?” simple ASK and solution is further more simple. Yes, using NODE JS and PowerShell we can play with data! Since I can’t share client data and to keep this blog simple let me show a easiest way to retrieve system information as […]
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 […]
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 […]
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 […]