I have tried to create a report on LoginHistory but this object is not visible in list of custom report type creation.
I also tried to create using standard Users report type but there I can't see Platform, Application and some other fields of LoginHostory are not present.
FYI - Application, Platform and some other fields are not filterable in query.
#Salesforce Developer #Salesforce Admin
@Ajaypal Ajaypal this is a limitation of standard Salesforce reporting on LoginHistory.
LoginHistory is queryable, but it is not a good source for standard Salesforce Reports/Dashboards because it is not available like a normal reportable object/custom report type. Also, fields like Application and Platform
are not filterable in SOQL, so you usually need to query by date first and then group/filter the results outside the query.
Reference:
https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_loginhistory.htmFor Salesforce mobile app adoption, the practical options are:
Use Setup → Login History
and export the data. Salesforce also has a help article specifically for tracking Salesforce for Android/iOS logins from Login History:
https://help.salesforce.com/s/articleView?id=000386301&type=1Or use SOQL/API and pull recent login records, then process the result in Excel, Tableau, CRM Analytics, or a custom object:
SELECT Id, UserId, LoginTime, Application, Platform, LoginType, Status, SourceIp
FROM LoginHistory
WHERE LoginTime = LAST_N_DAYS:30
ORDER BY LoginTime DESC
Then filter/group the exported result for mobile values like Salesforce for iOS / Salesforce for Android.
For Salesforce-native dashboards, create a small custom object such as Mobile Login Snapshot, load summarized LoginHistory data into it daily, and report from that custom object.
If you have Shield Event Monitoring, that is the better long-term route. Event Monitoring Analytics gives deeper usage/adoption insights from event data:
https://help.salesforce.com/s/articleView?id=analytics.bi_app_admin_wave.htm&type=5The standard Lightning Usage App
is also useful for general Lightning adoption, but it will not fully replace mobile-specific LoginHistory/Event Monitoring analysis:
https://help.salesforce.com/s/articleView?id=xcloud.lex_lightning_usage_app.htm&type=5
