How can I search IPAM for the hostname for a 'Used' IP Address, in Powershell

Question

I'm working on a decom script and looking to simply search for an IP based on hostname field, and to be able to set that IPAddress status to Available.

KMSigma.SWI · Accepted Answer

Because "Hostname" could mean any 'label' field, you're probably better off searching all of them.

SELECT IPAddress
     , Status
     , Alias
     , DnsBackward
     , DhcpClientName
     , SysName
     , ResponseTime
FROM IPAM.IPNode
WHERE DnsBackward LIKE 'HOSTNAME%'
   OR SysName = 'HOSTNAME'
   OR DhcpClientName LIKE 'HOSTNAME%'
   OR Alias LIKE 'HOSTNAME%'

Then you can just send the IP and the new status ('Available') to the ChangeIpStatus verb.