Hi Ram,
Are you wanting to do this via Orchestration / IntegrationHub or simply call out to ServiceNow via your powershell script?
If the latter, you can utilise the REST API Explorer which will help you with your requirement.
Build the query (nameSTARTSWITHPC &^install_status=1) and select the name field
You can then use the SEND button to see if you're getting the right data, and use the Powershell button to get a script example
# Eg. User name="admin", Password="admin" for this code sample.
$user = "admin"
$pass = "admin"
# Build auth header
$base64AuthInfo = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(("{0}:{1}" -f $user, $pass)))
# Set proper headers
$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add('Authorization',('Basic {0}' -f $base64AuthInfo))
$headers.Add('Accept','application/json')
# Specify endpoint uri
$uri = "https://instancename.service-now.com/api/now/table/cmdb_ci_computer?sysparm_query=nameSTARTSWITHPC%20%26%5Einstall_status%3D1&sysparm_fields=name"
# Specify HTTP method
$method = "get"
# Send HTTP request
$response = Invoke-RestMethod -Headers $headers -Method $method -Uri $uri
# Print response
$response.RawContent
