How to find a specific firewall rule?

Question

Trying to delete a IP host record. I get an error: "Host could not be deleted. Firewall rule exists for the host" 
 How do I find, which firewall rule is the one in question?

lferrara · Answer

Kari, 
 you need to perfom these steps: 
 
 from the GUI, go to Host and Services > IP Host and they write down the hostname (for example iPhone) 
 connect to XG cli > option 5 > option 3 
 type: psql -U nobody -d corporate 
 type: SELECT * FROM tblhost WHERE hostname='iPhone'; (please respect the upper and lower case 
 Write down the hostid number (in my case is 11) 
 type: SELECT * FROM tblfwsource; to check if the hostid is here (this is the source FW rule table) 
 type: SELECT * FROM tblfwdest; to check if the hostid is here (this is the destination FW rule table) 
 
 in one of these 2 last tables you should find the relations hostid (11) and fwruleid (xxx). This id corresponds to Firewall rules inside the GUI. If the rule is still there, delete it, otherwise you need to delete the row using postgresql commands. 
 Let us know. 
 Regards