servicenow.psm1
<#
.SYNOPSIS Discover privileged Assets on an ServiceNow server. .DESCRIPTION This cmdlet may be used to discover privileged Assets on an ServiceNow server. When a credential is not supplied to this cmdlet, it will automatically look for an open access request with a matching asset name or network address and use that access request to get the password to run the discovery. If no access request is found, the cmdlet will prompt for an Asset name and password to use. .PARAMETER NetworkAddress IP address or hostname of a ServiceNow database. .PARAMETER Credential A PowerShell credential object that can be used to connect to the database server to execute the discovery job. .INPUTS None. .OUTPUTS System.Management.Automation.PSObject. .EXAMPLE Get-SgDiscServiceNowAsset servicenow.test.env .EXAMPLE Get-SgDiscServiceNowAsset servicenow.test.env -Credential (Get-Credential) #> function Get-SgDiscServiceNowAsset { [CmdletBinding()] param ( [Parameter(Mandatory=$true,Position=0)] [string]$NetworkAddress, [Parameter(Mandatory=$false)] [PSCredential]$Credential = $null ) if (-not $PSBoundParameters.ContainsKey("ErrorAction")) { $ErrorActionPreference = "Stop" } if (-not $PSBoundParameters.ContainsKey("Verbose")) { $VerbosePreference = $PSCmdlet.GetVariableValue("VerbosePreference") } if (-not $Credential) { # doing this here allows error action and verbose parameters to propagate $Credential = (Get-SgDiscConnectionCredential $NetworkAddress) } # make sure ServiceNow is installed if (-not (Get-Module InvokeQuery)) { try { Import-Module ServiceNow } catch { throw "ServiceNow Asset discovery in safeguard-discovery requires ServiceNow. Please run: Install-Module ServiceNow." } } if (-not (Set-ServiceNowAuth -url $NetworkAddress -Credential $Credential)) { throw "Could not connect to ServiceNow" } $local:Results = @() # computers $limit = 100 do { $skip = 0 $local:computers = Get-ServiceNowTableEntry -Table 'cmdb_ci_computer' -Skip $skip -First $limit foreach ($local:computer in $local:computers) { $local:Results += New-Object PSObject -Property ([ordered]@{ AssetName = $local:computer.asset.display_value; State = "$($local:computer.operational_status)"; OperatingSystem = "$($local:computer.os) $($local:computer.os_version)"; HostName = $null; IpAddress = $local:computer.ip_address; Description = "safeguard-discovery" }) } $skip = 0 + $limit } while ($local:computers.Count > 0) # assets do { $skip = 0 $local:assets = Get-ServiceNowTableEntry -Table 'alm_asset' -Skip $skip -First $limit $local:computers = $local:assets | Where-Object{ $_.sys_class_name -eq 'Hardware' } foreach ($local:computer in $local:computers) { $local:Results += New-Object PSObject -Property ([ordered]@{ AssetName = $local:computer.display_name; State = "$($local:computer.install_status)"; OperatingSystem = $local:computer.model.display_value; Description = "safeguard-discovery" }) } $skip = 0 + $limit } while ($local:assets.Count > 0) $local:Results } |