Count User Logins This Week by License Type in Salesforce

A simple SOQL query to return a count of all users that have logged into Salesforce THIS WEEK based on having a full salesforce license.

If you need to query by other license types you should check the table UserLicence for the different licences your system has available, then using those values instead of SFDC to determine if they are being used/logged in.

Select 
  COUNT(Id)
From 
  User
WHERE
  IsActive = true AND
  LastLoginDate = THIS_WEEK AND
  Profile.UserLicense.LicenseDefinitionKey = 'SFDC'

Add Hyperlinks to an Entire Column using VBA in Excel

Count User Logins This Week by License Type in Salesforce

Similar