Overview
You might want to find users of your instance who have completed the registration process and have been active for a specific period of time. This article provides information on how to achieve this need.
Information
Reports in Kayako Classic lets you access the huge amount of data in your helpdesk and turn that data into useful information.
Kayako Classic allows you to create your own using Kayako Query Language (KQL). KQL is the syntax used to define a report. KQL is used to specify the data you want to include in your reports and how the data should be displayed.
A sample KQL syntax that would allow you to achieve this need is the following:
SELECT 'Users.Full Name', 'Users.Creation Date', 'Users.Last Update', 'Users.Last Visit',
'Users.Is Validated' From 'Users'
WHERE 'Users.Creation Date':Year = <enter year>
Use the above syntax to build your report. To learn more about building reports in Kayako, visit the Introduction to Building and Running Reports article.
NOTE: Change the date criteria for your query per the date and time shortcuts explained in KQL Condition & Operator Reference article.
Here's a breakdown of the syntax:
- 'Users.Full Name' - This will give you the full name of the user account.
- 'Users.Creation Date' - This field will give you the user account creation date.
- 'Users.Last Update' - This field will give you the date/time when the user account was last updated.
- 'Users.Last Visit' - This field will give you the date/time the user's last logged into his/her account at the support center.
- 'Users.Is Validated' - This field will show a "Yes" when the user has verified his/her email, (i.e. user account is verified). Otherwise, it will show as "No".
This is a sample generated report using the above syntax.