)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce’s authentication reporting requires date field inputs, creating a logical gap when trying to identify users with no authentication history since they have no dates to reference.
You’ll learn how to eliminate this constraint through direct data access and create comprehensive authentication analysis that includes never-accessed accounts.
Access complete authentication data using Coefficient
CoefficientSalesforceSalesforceeliminates this constraint through direct data access and flexible filtering. Coefficient’s ability to handle null values in date fields provides accurate identification of enabled accounts with no authentication history, while nativereports fail when mandatory date selection excludes null login timestamp records in.
How to make it work
Step 1. Import User object without date constraints.
Access all User records including Username, IsActive, LastLoginDate, Email, and Profile.Name fields. This gives you the complete dataset without date field requirements blocking access to users with no authentication events.
Step 2. Filter for enabled accounts with no authentication.
Apply IsActive = TRUE filter combined with LastLoginDate is blank to find users with no login events. This identifies accounts that are provisioned but have never been accessed by their assigned users.
Step 3. Cross-reference with LoginHistory for comprehensive analysis.
Optionally import LoginHistory object to confirm zero authentication events. Use formulas liketo count actual login events per user and verify accounts with truly no access history.
Step 4. Create advanced authentication analysis workflows.
Combine User and LoginHistory data to identify accounts that are provisioned never accessed. Schedule exports back to Salesforce to flag unused active accounts for deactivation, and set up automated compliance reporting for security audits.
Start comprehensive authentication tracking
Begin trackingThis approach provides accurate identification of enabled accounts with no authentication history while eliminating the date field constraints that block standard reporting.your complete authentication data without limitations today.
