Query list of apps installed in Salesforce

Requirement

We can get the list of items in the Force.com app menu or App Launcher from the ‘AppMenuItem’ sobject. So, purpose is to get the list of apps installed from appexchange or created in a salesforce organization.

Solution

There is a sobject ‘PackageLicense’ represents licenses for installed managed packages.

SELECT  Id, AllowedLicenses, NamespacePrefix, Status, CreatedDate,ExpirationDate,
IsProvisioned,LastModifiedDate 
FROM PackageLicense