Get-ServiceNowRecord -Table 'cmdb_ci_computer' examples

[jwarren126]

Are there any good examples on retrieving filtered records from the computer table? I'd like to automate reading getting data from this table.

[gdbarron]

Hi @jwarren126. Did the examples for Get-ServiceNowRecord not get it done? What are you looking to do?

[jwarren126]

Specifically I'm looking to retrieve a set of computer records from the cmdb_ci_computer table, but I'm struggling with the syntax of the -Filter parameter when trying to combine multiple filters. It's not entirely clear how the -group option works in combination with -and and -or sets.

[gdbarron]

Instead of just and/or, sometimes you want to find items with multiple filters as well as other items with multiple filters at the same time. Let's say, taking random properties of cmdb_ci_computer, you want (can_print is true and monitor is false) or (cost greater than 500 and OS contains the word mac). This would return results where can_print is true and monitor is false is true OR cost greater than 500 and OS starts with the word Mac is true. It's as if you ran 2 queries and combined the results. For this example, the filter would look like -Filter @('can_print, '-eq', $true), 'and', @('monitor', '-eq', $false), 'group', @('cost', '-gt', '500'), 'and', @('os', '-startswith', 'Mac').

Here's the SN definition for group

Here's the example for Get-ServiceNowRecord which explains it. If this can be made better, please submit an enhancement request or PR.

[jwarren126]

It's as if you ran 2 queries and combined the results.

Perfect explanation that helped make it clear. Thank you so much!

[gdbarron]

answer above...