Chen V – Page 2 – Chen V PowerShell Blog

Tip: Retrieve servicenow CI item values using REST API (Turn on Display Value)

Posted on 28th July 201829th July 2018

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”

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
}

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

$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
}

$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 […]

PowerShell

Tip: Create a VSTS Tasks based on GIT repository code push (EVENT)

Posted on 24th July 201824th July 2018

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 […]

PowerShell

Create VSTS Build Definitions using PowerShell

Posted on 23rd July 201824th July 2018

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

$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

$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 […]

PowerShell

Tip: Retrieve servicenow incidents and cmdb records for given configuration item | Scripted REST API and PowerShell

Posted on 20th July 201820th July 2018

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 […]

servicenow

Tip: Create Scripted REST API in servicenow and consume it in PowerShell

Posted on 19th July 2018

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.

{
    "Name": "Chendrayan Venkatesan (Chen V)",
    "Role": "ITPro",
    "Department": "Information Technology",
    "Skills": [
        "PowerShell",
        "REST",
        "servicenow",
        "Python",
        "SharePoint",
        "Office 365"
    ]
}

{

"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 […]

Windows PowerShell

TIP: Query servicenow Incident record using PowerShell and REST API

Posted on 18th July 201820th July 2018

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

function Get-ServiceNowIncident {
    [CmdletBinding()]
    param (
        [Parameter(Mandatory, ValueFromPipeline, ValueFromPipelineByPropertyName)]
        $IncidentID,

        [Parameter(Mandatory)]
        [pscredential]
        $Credential
    )
    try {
        $Uri = "https://dev42835.service-now.com/api/now/table/incident?sysparm_query=number=$($IncidentID)"
        $Result = Invoke-RestMethod -Uri $Uri -Method Get -Credential $Credential
        $Result.result | ConvertTo-Json
    }
    catch {
        $_.Exception
    }
}

Measure-Command -Expression {Get-ServiceNowIncident -IncidentID INC0000059 -Credential admin}

function Get-ServiceNowIncident {

[CmdletBinding()]

param (

[Parameter(Mandatory, ValueFromPipeline, ValueFromPipelineByPropertyName)]

$IncidentID,

[Parameter(Mandatory)]

[pscredential]

$Credential

)

try {

$Uri = "https://dev42835.service-now.com/api/now/table/incident?sysparm_query=number=$($IncidentID)"

$Result = Invoke-RestMethod -Uri $Uri -Method Get -Credential $Credential

$Result.result | ConvertTo-Json

}

catch {

$_.Exception

}

Measure-Command -Expression {Get-ServiceNowIncident -IncidentID INC0000059 -Credential admin}

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

Days              : 0
Hours             : 0
Minutes           : 0
Seconds           : 8
Milliseconds      : 468
Ticks             : 84680174
TotalDays         : 9.80094606481481E-05
TotalHours        : 0.00235222705555556
TotalMinutes      : 0.141133623333333
TotalSeconds      : 8.4680174
TotalMilliseconds : 8468.0174

Days : 0

Hours : 0

Minutes : 0

Seconds : 8

Milliseconds : 468

Ticks : 84680174

TotalDays : 9.80094606481481E-05

TotalHours : 0.00235222705555556

TotalMinutes : 0.141133623333333

TotalSeconds : 8.4680174

TotalMilliseconds : 8468.0174

Selected Fields!

function Get-ServiceNowIncident {
    [CmdletBinding()]
    param (
        [Parameter(Mandatory, ValueFromPipeline, ValueFromPipelineByPropertyName)]
        $IncidentID,

        [Parameter(Mandatory)]
        [pscredential]
        $Credential
    )
    try {
        $Uri = "https://dev42835.service-now.com/api/now/table/incident?sysparm_query=number=$($IncidentID)&sysparm_fields=number,state,opened_at&sysparm_limit=1"
        $Result = Invoke-RestMethod -Uri $Uri -Method Get -Credential $Credential
        $Result.result | ConvertTo-Json
    }
    catch {
        $_.Exception
    }
}

Measure-Command -Expression {Get-ServiceNowIncident -IncidentID INC0000059 -Credential admin}

function Get-ServiceNowIncident {

[CmdletBinding()]

param (

[Parameter(Mandatory, ValueFromPipeline, ValueFromPipelineByPropertyName)]

$IncidentID,

[Parameter(Mandatory)]

[pscredential]

$Credential

)

try {

$Uri = "https://dev42835.service-now.com/api/now/table/incident?sysparm_query=number=$($IncidentID)&sysparm_fields=number,state,opened_at&sysparm_limit=1"

$Result = Invoke-RestMethod -Uri $Uri -Method Get -Credential $Credential

$Result.result | ConvertTo-Json

}

catch {

$_.Exception

}

Measure-Command -Expression {Get-ServiceNowIncident -IncidentID INC0000059 -Credential admin}

Days              : 0
Hours             : 0
Minutes           : 0
Seconds           : 6
Milliseconds      : 540
Ticks             : 65405344
TotalDays         : 7.57006296296296E-05
TotalHours        : 0.00181681511111111
TotalMinutes      : 0.109008906666667
TotalSeconds      : 6.5405344
TotalMilliseconds : 6540.5344

Days : 0

Hours : 0

Minutes : 0

Seconds : 6

Milliseconds : 540

Ticks : 65405344

TotalDays : 7.57006296296296E-05

TotalHours : 0.00181681511111111

TotalMinutes : 0.109008906666667

TotalSeconds : 6.5405344

TotalMilliseconds : 6540.5344

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

Node JS

Auto Deploy Code to servers using GitHub WebHooks and Node JS Microservice

Posted on 2nd July 2018

Just to help my team to move code to servers easily I made this solution. Yes, like many organization we do have different environments like TEST, DEVELOPMENT, STAGE and PRODUCTION and each use different config files and credentials. So, simply I used webhooks by following below instructions. Go to your GitHub repo settings. Choose Hooks from […]

Node JS

Query Service-now CMDB to retrieve Contact Information using PowerShell, SNOW REST API and Node JS

Posted on 20th June 201820th June 2018

In this blog post I will walk you through the solution I implemented by building “RESTful” for “REST” API. Sounds weird right? Yes, this is a challenge I faced at ac client environment! For a business reason team decided to customize the servicenow endpoints. So, as expected dependency in increased along with that technical challenges. […]

Node JS

Node JS – Store Self Requests Form information in SQL

Posted on 26th May 201826th May 2018

This article is to show simple steps to save the form information in SQL – The cool part is, this solution works as web app and REST API as well. The intention of this quick write up is to show how MSSQL and msnodesqlv8 helped me to solve the needs. Step 1 – Create Table as […]

Node JS

Build RESTful API using Node JS and consume it using PowerShell | Google Translate

Posted on 20th May 201820th May 2018

I started my session by thanking matheuss and one raised voice “Hey, Thanks Mr.Sundar Pichai!” – Yay! Good One! I just lost my focus and managed to push back! Yes, I really appreciate the author who made this possible nearly 2 years before. So, what’s new I can do using this NPM package? With no wait […]

Chen V PowerShell Blog

I Multiply Happiness by Sharing!

Author: Chen V

Tip: Retrieve servicenow CI item values using REST API (Turn on Display Value)

Tip: Create a VSTS Tasks based on GIT repository code push (EVENT)

Create VSTS Build Definitions using PowerShell

Tip: Retrieve servicenow incidents and cmdb records for given configuration item | Scripted REST API and PowerShell

Tip: Create Scripted REST API in servicenow and consume it in PowerShell

TIP: Query servicenow Incident record using PowerShell and REST API

Auto Deploy Code to servers using GitHub WebHooks and Node JS Microservice

Query Service-now CMDB to retrieve Contact Information using PowerShell, SNOW REST API and Node JS

Node JS – Store Self Requests Form information in SQL

Build RESTful API using Node JS and consume it using PowerShell | Google Translate