Ana içeriğe geç

Retrieving user hostname information in reports - Bilgi Bankası / Developer & Reporting / DPQL Examples - Deskpro Support

Retrieving user hostname information in reports

Yazarlar listesi

If you have the Resolve User Hostnames app installed, you can get hostname information for messages. This gives you insight into how users are connecting to the helpdesk, since the hostname often indicates the user's ISP, university, section of your network etc.

To retrieve a message hostname, use tickets_messages.hostname. Note that this is a field of the tickets_messages table, so you must select FROM tickets_messages, but you can use cross-referencing to include fields from other tables.

Here's a simple example query to display hostnames for all user messages, split up by ticket:

 

SELECT tickets_messages.ticket.person, tickets_messages.hostnameFROM tickets_messagesWHERE tickets_messages.hostname <> '' AND tickets_messages.person.is_user = 1 SPLIT BY tickets_messages.ticket.id

 

 

The hostname field will be empty for messages created before you installed the app. Specifying 

WHERE tickets_messages.hostname <> ''

means that messages where the hostname is empty are not listed.

 

Specifying

tickets_messages.person.is_user = 1 

in the WHERE clause filters out agent messages.

Yararlı Yararlı değil

96 kişiden 43 kişi bu sayfayı yararlı buldu

Bir yorum ekle

Bir yorum gönderebilmek için lütfen oturum açın ya da kayıt olun.

Bir parola hatırlatıcısına ihtiyacın var mı?