Retrieve all incidents created on this month programmatically. Indeed, it’s very simple and straight forward approach when it comes to reportings right? No, we aren’t focusing reporting table (sys_report) for now. Instead I go with simple query! Using PowerShell it’s very easy to find start and end of the month! Yes, try the below PowerShell […]
A friend of mine asked a very good question “How can I use switch case statement in PUG using variable from route?” which took an hour time to figure it out! See the documentation for case statement here. I have a route like shown below app.get(“/”, function (request, response) { child = spawn(‘powershell.exe’, [“C:\\projects\\caseDemo\\scripts\\DayOfWeek.ps1”]) child.stdout.on(‘data’, […]
This blog post is to show the steps for creating a wizard using PUG. If you are new to PUG read the API docs. It’s always a best practice to keep the code clean. Having said that, it’s a bit complex to manage if we haven’t followed naming conventions. PUG supports includes which helps us to […]
Recently I was working on the Web Framework project using PowerShell and Python which eventually made me to learn more. My requirement was to refresh the web page which helps a small monitoring team. In this blog post I will share the base logic and yes it requires improvement and in my next blog I […]
Last week I blogged about the Date Time tips with reference to SharePoint and PowerShell – Refer here. In this blog post let me show case how to implement in SharePoint practically. Create a List and name as you wish and in my case it’s “Employee Feedback”! Create two columns and name it as “WeekStart” […]
It’s been a while I worked on SharePoint List(s) which is still my area of interests. In this blog post I would like to share few tips to work with date and time for a requirement. To know the current Day of Week using PowerShell (Get-Date).DayOfWeek DayOfWeek is a get ‘able’ property so for our […]
Of late I received a request to share a PowerShell script to download attachment(s) from the given servicenow incident. Two attachments are available for the sample incident INC0010008 below is the illustration. First we need to query incident by number to retrieve sys_id and through which we get the attachment metadata. Table name incident and table_sys_id are used respectively. […]
Recently I got a request to retrieve host name and SMB share name using PowerShell. This is not new and indeed there are many ways to do it and I am sharing few I like. Consider the UNC PATH is like shown below “\\SERVER\DEMO\SMBSHARE” Our requirement is to retrieve “SERVER” and “SMBSHARE” – Well regex […]
I haven’t seen any new applications developed without REST API associated with it. Many vendors spend time to help developers who work on integrations. Lets see how we can use Node JS, PUG and PowerShell to share a web app and RESTful API Our end-goal is to meet the below requirement RESTful API Web Application […]
Recently I was working on a tiny project in which I need to make text field as READONLY when it’s backfilled by query and FREE TEXT if empty. Yes, as you guessed I use PowerShell a lot at my workplace. Having said that, let me show case the demo using PowerShell and Node JS Scenario […]