Export apps and their versions
It would be helpful if sccuout could expose apps as metrics like this:
sccuot_app_enabled{appname=$appname,version=$version} 1
and 0 if the app is not enabled, so we could basically sum up over the active apps/active apps with a specific label.
Query would basically look like this:
SELECT t1.appid, t1.configvalue as version, t2.configvalue as enabled FROM oc_appconfig t1, oc_appconfig t2 WHERE t1.configkey="installed_version" AND t2.configkey="enabled" AND t1.appid=t2.appid;
If we are at it, a sccuout_app_installed
metric which is just 1 for every app would also be useful, to perhaps catch config drift at nother position, we never know