User's list

Salesforce

 

Salesforce is the most popular cloud CRM with a focus on sales and support. Skyvia requires Salesforce Enterprise edition or higher.

Data of users with a non-customer profile

Query Text

SELECT "Username", "Email", p.name, isactive 
   FROM "User" u, "Profile" p 
   WHERE p.id = u.profileid and p.name not like 'Customer%' and isactive = true 
   ORDER BY email
  

Open Query