Is it possible to know (from Freshdesk) whether a ticket is attached to a Salesforce contact or account?

Yes, the details pertaining to the Salesforce contact information are displayed under the requester info section in a ticket.

Please navigate to the Tickets tab -> click on the ticket to go to the details page where the requestor information would be displayed at the right of the ticket description.