SELECT FunctionalCI

SELECT BusinessProcess

SELECT Contact

SELECT Location

SELECT Server

SELECT DatabaseInstance

SELECT NetworkDevice

SELECT UserRequest WHERE status != "closed"

UI:WelcomeMenu:MyCalls

SELECT UserRequest AS i WHERE i.caller_id = :current_contact_id AND status NOT IN ("closed", "resolved")

SELECT Incident WHERE status != "closed"

UI:WelcomeMenu:MyIncidents

SELECT Incident AS i WHERE i.agent_id = :current_contact_id AND status NOT IN ("closed", "resolved")