Get-ServiceNowRecord returns empty results

[HKSausage]

I am trying to pull records from cmdb_ci_computer table, with a certain serial number and the install_status as Retired.

I tried Get-ServiceNowRecord -table 'cmdb_ci_computer' -Filter @('serial_number', '-eq', $SerialNumber), '-and', @('install_status', '-eq', 'Retired')

I get 0 records

If I remove the '-and', @('install_status', '-eq', 'Retired') part, it returns 10 records, with 9 of them having Retired install_status

I also tried
$filter = @('serial_number', '-eq', $SerialNumber),
'-and',
@('install_status', '-eq', 'Retired'),
then use the variable as in the example, but still returns 0 records

[gdbarron]

@HKSausage install_status is a reference field and querying isn’t as straightforward as serial number which is a string. You can find the name and value by using Get-ServiceNowRecord -DisplayValue all. If you run Get-ServiceNowRecord -table ‘cmdb_ci_computer’ -Property install_status -DisplayValue -First 1 you’ll get something like

Install_status
———————
@{display_value=Installed; value=1}

The ‘value’ is what you need to query for. You can also set -DisplayValue false and it will only display the value and not the name. The default is true which displays the name.