Modules

All Modules

ARS Requests ARS Tasks Accounts Accounts, Endpoint Accounts, Endpoints Analytics Audit Logs Audit Trail Campaign Certification Connections Connections, Job Control Panel Customers Email History Endpoints Entitlement Values External Connections Job Control Panel Request Access Role Assignments Roles Rules Rulesets Security Systems User Accounts User Group User Groups Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLES

SELECT CASE customertype WHEN 1 THEN 'Data Security' WHEN 2 THEN 'Grouping' WHEN 3 THEN 'Request Rules' ELSE CONCAT('Unknown (',customertype,')') END AS Customer_Type, COUNT(*) AS Total_Customers FROM customer GROUP BY customertype ORDER BY Total_Customers DESC;
                    

SELECT CASE status WHEN 1 THEN 'Active' WHEN 0 THEN 'Inactive' ELSE CONCAT('Unknown (',status,')') END AS Customer_Status, COUNT(*) AS Total_Customers FROM customer GROUP BY status ORDER BY Total_Customers DESC;