How to create a search that returns trial customers who do not have a purchased license

If you want to target emails to trial customers who do not have a purchased license, you can create a search that excludes customers with a permanent or subscription license.

• Launch the QLM Management Console

• Go to the Manage Keys tab

• Click Search and then Edit Searches

• Click Add to add a new search

• Set a name to: Trials that expired in last 30 days

• Set the SQL fied to: licenseModel='trial' and Email Not In (Select Email from qryLicenseInfo where licensemodel<>'trial' and Email is not NULL) and SubscriptionExpiryDate > [today_start-30] and SubscriptionExpiryDate < [today_start] and IncludeInMailList <> 0 and Disabled=0

• Click Ok

Now you can create a scheduled task that uses this search.