You need to sign in to do that
Don't have an account?
Ikram Momin 16
Fetch ManagedPackages assigned to user
Hiii
I am using below query to fetch ManagedPackages assigned to users in org :
SELECT PackageLicenseId, UserId FROM UserPackageLicense
My users query is :
SELECT Id, Username, LastName, FirstName FROM User
Is there any query to fetch ManagedPackages assigned to users in users query ?
I recommend checking the post https://salesforce.stackexchange.com/questions/21180/get-the-list-of-users-licensed-for-a-managed-package
UserPackageLicense lets you see which users are licensed for a particular package: The PackageLicense object lets you see the stats on the number of licensed users available and currently in use in your org for a particular package, as well as when the app was installed and when it expires:
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
Below query will provide me Name of users who are assigned with any Managed Packages.Below query will not give me users whom any managedpackage is not assigned
SELECT Name FROM User WHERE Id in ( SELECT UserId FROM UserPackageLicense)
However. I want All Users from Users table along with managedpackage assigned if any.