Display Metrics for OSS Index / Guide

[msymons]

Current Behavior

Sonatype is deprecating OSS Index and moving to Guide

Guide allow 500 credits per month (equivalent to 5000 queries) for free and has a Pro plan offering 5000 credits for $100 per month. Beyond this level one has to request a custom quote... but it does promise "volume discounts".

For a daily check of each PURL, Guide can handle just 4 projects of 40 components each.

Proposed Behavior

Display some metrics data on OSS Index/Guide configuration screen.

1. Display total number of unique PURLs in projects that are not active.

select count(distinct c."PURLCOORDINATES")
from "COMPONENT" as c
inner join "PROJECT" as p on p."ID" = c."PROJECT_ID"
where p."ACTIVE" is distinct from false;

This query would need to be tweaked if functionality is implemented to allow inclusion/exclusion of analysis for projects based on (say) tags

2. Display usage metrics. This can be done using the Guide Usage API.

Checklist

• I have read and understand the contributing guidelines
• I have checked the existing issues for whether this enhancement was already requested