Querying installed Managed package version numbers from Apex in 2018

Question

This was asked in 2015 - Querying Managed package version from Apex - (and in other posts here) but I want to check that there has been no change to this in the last 3 years.

We have several managed packages and want to introduce another small managed package (that cannot have compile-time dependency on the others) that contains links to a documentation server. The documentation is versioned there to match the managed package versions, so we would like to automatically discover the current version of all our managed packages. Then the correct links can be offered. An SObject we could query would be ideal...

How can these versions best be found using Apex code with these constraints?

Answer 1

Why not query InstalledSubscriberPackage using tooling API?

SELECT Id, SubscriberPackageId, SubscriberPackage.NamespacePrefix,
SubscriberPackage.Name, SubscriberPackageVersion.Id,
SubscriberPackageVersion.Name, SubscriberPackageVersion.MajorVersion,
SubscriberPackageVersion.MinorVersion,
SubscriberPackageVersion.PatchVersion,
SubscriberPackageVersion.BuildNumber
FROM InstalledSubscriberPackage
ORDER BY SubscriberPackageId

Source:https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_installedsubscriberpackage.htm

Answer 2

Unlike the other answers, this query lets you do this directly in Apex using SOQL

Publisher[] publishers = [SELECT Id, DurableId, Name, NamespacePrefix, IsSalesforce, MajorVersion, MinorVersion FROM Publisher]

Note: The patch version number is not stored on this table

Answer 3

I know this is very old but I think that using a query like below can help you, and that is using "pure Apex":

PackageLicense[] licensedPackages = [select NamespacePrefix, Status from PackageLicense];

Even better if you know the namespace prefix (e.g. n):

PackageLicense[] licensedPackages = [select Status from PackageLicense where NamespacePrefix = 'n'];

That is only going to show if this was licensed.