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 […]
Recently I was working on piece of code which retrieves TrueSight alert information. I got stuck with “Invalid Long Type:” – Doesn’t make sense right? Come lets see it detail! Consider you have an alert ID like “mc.pncell_[HOSTNAME].1a5ed3bb.0” using the below snippet you can retrieve the result (resultHandle)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
param ( $AlertID ) try { $Url = "http://HOSTNAME:PORT/imws/services/ImpactManager" $QueryEventByID_Body = @" <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:imap="http://blueprint.bmc.com/ImapiElems"> <soapenv:Header/> <soapenv:Body> <imap:QueryEventByID> <imap:eventId>$($AlertID)</imap:eventId> <imap:imname>IM_TS</imap:imname> </imap:QueryEventByID> </soapenv:Body> </soapenv:Envelope> "@ $QueryEventByID_Params = @{ Uri = $Url Body = $QueryEventByID_Body Method = 'POST' Headers = @{ SOAPAction = 'QueryEventByID' } ContentType = 'text/xml;charset=UTF-8' } $QueryEventByID_Request = Invoke-WebRequest @QueryEventByID_Params $QueryEventByID_Response = [xml]($QueryEventByID_Request) $QueryEventByID_Response.Envelope.Body.QueryResultHandle_output } catch { $_.Exception } |
We need the resultHandle for RetrieveQueryResults operations. Now let […]
In my last blog post I shared about ‘Scripted REST API’ getDisplayValue() tip. Now, here lets see Out of the Box option. When we query the CI with a query “sysparm_query=name=$($ConfigurationItem)&sysparm_limit=1”
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
param ( $ConfigurationItem = 'Car-3' ) try { $Uri = "https://dev42835.service-now.com/api/now/table/cmdb_ci?sysparm_query=name=$($ConfigurationItem)&sysparm_limit=1" $admin = "admin" $password = "admin" | ConvertTo-SecureString -AsPlainText -Force $Credential = New-Object pscredential -ArgumentList ($admin , $password) $Result = Invoke-RestMethod -Uri $Uri -Method Get -Credential $Credential [pscustomobject]@{ Name = $Result.result.name ManagedBy = $Result.result.managed_by.value Vendor = $Result.result.vendor.value } } catch { $_.Exception } |
We get the output illustrated below. Now, add sysparm_display_value=true in the URL and see the results as actual values instead of ID
|
1 2 3 4 5 6 7 8 9 10 |
$Uri = "https://dev42835.service-now.com/api/now/table/cmdb_ci?sysparm_query=name=$($ConfigurationItem)&sysparm_limit=1&sysparm_display_value=true" $admin = "admin" $password = "admin" | ConvertTo-SecureString -AsPlainText -Force $Credential = New-Object pscredential -ArgumentList ($admin , $password) $Result = Invoke-RestMethod -Uri $Uri -Method Get -Credential $Credential [pscustomobject]@{ Name = $Result.result.name ManagedBy = $Result.result.managed_by.display_value Vendor = $Result.result.vendor.display_value } |
After […]
This article is to demo the available features (Service Hooks | Web Hooks) in VSTS and other possibilities to avoid manual interventions. You can think about any best fits your needs at your environment. For now, let me create a VSTS Work Item (Task) automatically for the repository code push – I would like to […]
For my current project assignment I was asked to share a PowerShell script which creates VSTS build + phase dynamically. To make this blog short let me show a simple build definitions sample. With no wait here is the code
|
1 2 3 4 5 6 7 8 9 10 |
$Token = "Personal Access Token" $Authentication = [Text.Encoding]::ASCII.GetBytes(":$Token") $Authentication = [System.Convert]::ToBase64String($Authentication) $Headers = @{ Authorization = ("Basic {0}" -f $Authentication) } $Body = Get-Content "C:\Projects\servicenow\buildDef.json" $Uri = "https://about-powershell.visualstudio.com/servicenow/_apis/build/definitions?api-version=5.0-preview.6" $Result = Invoke-WebRequest -Method Post -Uri $Uri -Headers $Headers -Body $Body -ContentType "application/json" $Result |
Step 1: You need Personal Access Token (PAT). Go get it. Step 2: Convert […]
In my last blog I explained basics of “Scripted REST API” – Now, let me show the simple trick to query all incidents and changes for the given configuration item. In my case CAR-3 is a CI which has one incident record and for our demo lets create a Scripted REST API to fetch required […]
In this blog post let me walk through the simple steps to create a “Scripted REST API” which simply prints the hardcoded values. This is a beginners guide so let’s keep things easier! Navigate here to get some more information.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
{ "Name": "Chendrayan Venkatesan (Chen V)", "Role": "ITPro", "Department": "Information Technology", "Skills": [ "PowerShell", "REST", "servicenow", "Python", "SharePoint", "Office 365" ] } |
Step 1: Login to servicenow Step 2: Search for Scripted REST API – in Filter […]