BC ISV telemetry app : Administration > Inventory > 'latest' app per tenant

[fvet]

@KennieNP

The current Administration > Inventory report, provides an overview of the different app versions installed on a certain environment.

We're looking for an extension of the PBI report / extra page, that provides a better overview of the 'current' / latest version installed on a certain environment / tenant.

Something similar like https://github.com/waldo1001/waldo.BCTelemetry/blob/c2e98b3f4cb30553dbf6fc8d433acf7ab9578222/Application%20Lifecycle/BaseQuery.kql#L28C1-L28C1

traces
| where timestamp >= ago(90d)
| where customDimensions.eventId == 'LC0010'
| where isnotempty(customDimensions.extensionName)
| extend aadTenantId = tostring(customDimensions.aadTenantId)
    , extensionId = tostring(customDimensions.extensionId)
    , extensionName = tostring(customDimensions.extensionName)
    , extensionPublisher = tostring(customDimensions.extensionPublisher)
    , environmentType = tostring(customDimensions.environmentType)
    , extensionVersion = tostring(customDimensions.extensionVersion)
    , extensionPublishedAs = tostring(customDimensions.extensionPublishedAs)
| summarize max(extensionVersion) by extensionName, aadTenantId
| order by extensionName, aadTenantId

PS: Traces followed by an uinstall, not followed by a newer install might be excluded?

Having some stats on the latest / max extension version would allow us to better track which tenants have not yet upgraded to the latest version of our apps. In addition, it would also allow to build a 'Apps by Domain' matrix, showing the tenants (domain) with the most number of apps installed or to show the most popular apps (highest number of installs)

Next to the above report, we have a separate database to manage 'app licensing' using other tooling then the telemetry signals. Comparing these licenses against the telemetry based report should more or less give the same results and provide an overview of the numbers of 'active' apps that are currently installed on all our tenants.