Common Helpdesk Custom Field Queries

Is there a list of commonly used queries for help desk custom fields. I am setting up a help desk, but I don't know sql. I am looking for queries I can cut and paste into the custom fields in the que customization --> Ticket layout section. Things like auto populating a field with a machine name or IP Address.