root@avl2101p:/etc/puppet/bin (master)# hammer host list
---------------------------------------------------------------------------
NAME                 | OPERATING SYSTEM ID | MAC | IP | ID  | HOST GROUP ID
---------------------------------------------------------------------------
av1l622p.it.internal |                     |     |    | 345 |
av2l005p.it.internal | 3                   |     |    | 32  | 5


root@avl2101p:/etc/puppet/bin (master)# hammer host list --search 'status.pending = 1 and status.enabled = true and hostgroup_fullname !~ Oracle' --per-page 500
---------------------------------------------------------------------------
HOST GROUP ID | MAC | IP | ID  | OPERATING SYSTEM ID | NAME
---------------------------------------------------------------------------
13            |     |    | 217 | 2                   | av2l073p.it.internal
13            |     |    | 235 | 3                   | av2l104p.it.internal

root@avl2101p:/etc/puppet/bin (master)# hammer --output csv host list --search 'status.pending = 1 and status.enabled = true and hostgroup_fullname !~ Oracle' --per-page 500
Id,Name,Operating System Id,Host Group Id,IP,MAC
217,av2l073p.it.internal,2,13,"",""
235,av2l104p.it.internal,3,13,"",""