3
votes
Login History Subdivision and City
I don't believe that using the admin feature to log in as another user writes to the login history because otherwise it would cause the "Last Login Date" to be inaccurate but I could be ...
- 3,964
2
votes
Accepted
Can't include related User and Network fields in a LoginHistory query?
Like English language, there are more exceptions than rules in Salesforce :) Not being able to do parent reference query on Parent fields sometimes is one of them.
Salesforce typically populates "...
- 1,762
2
votes
I want to get number of user logged in to salesforce with specific profile
In these situations, it helps to know which fields you do have access to. The SOAP API documentation is where I tend to turn to. In the SOAP API docs for LoginHistory, we see that there is a UserId ...
- 59.3k
1
vote
Accepted
Track Login and Logout Time of Every User In Salesforce and Community Users
Is "/event/LogoutEventStream" event is free for all?
It is free for Enterprise, Unlimited, and Performance Edition orgs. These orgs get the API Total Usage, CORS Violation Record, Hostname ...
- 481k
1
vote
How can I calculate daily active users for salesforce logins?
The object you probably want is LoginHistory. This gives you every login attempt by every user in your org. Note, it includes attempts, so you would need to filter by successful logins.
- 24.9k
1
vote
Unable to see last login or the login history for some users
Welcome to Salesforce Stack Exchange (SFSE)!
That usually means that the user has never logged in.
- 2,505
1
vote
How to create a batch to count the worked days of the users based on LoginTime
Depending on the number of results, you can just write your query like this:
SELECT DAY_ONLY(LoginTime), UserId
FROM LoginHistory
WHERE DAY_IN_WEEK(LoginTime) NOT IN (1, 7)
GROUP BY UserId, ...
- 481k
1
vote
Accepted
Why there are question marks in "User" column in Setup Audit Trail CSV file?
I had the same problem. The solution that worked for me was to change my user's language to the one I'm seeing question marks for (in my case, Hebrew).
After that I downloaded the file, opened it in ...
- 334
1
vote
Accepted
SOQL aggregate maxing out SOQL limits
The rows from your Left Inner Join do not count against your governors. If you're running into row limits, it is strictly because you have too many UserLogin records.
If you want to know the number ...
- 149k
1
vote
How to set application in Salesforce LoginHistory?
At this time, it does not appear to be possible to set the application using simple-salesforce. I've tried setting a number of things in client code, and found none that will cause the application to ...
- 115
Only top scored, non community-wiki answers of a minimum length are eligible