Query Hosts not in Hostgroups

[FCC_Nagios_Support]

Good Morning,

What is the Query to NagiosXI to get hosts which are not in two HostGroups ("status in production" neither "status move to production").

Thanks and Regards

[scottwilkerson]

There isn't any query that provides this information.

You would have to craft a script that pulls information from the API, the relevant API endpoints are
GET objects/hostgroupmembers
GET objects/host