tickets #131216
closedAccess to Influx DB
10%
Description
Hello team,
I have been tasked with one analytics project related to OpenSUSE.
What I am after is creating a report in Power BI with Community adoption metrics for the distributions/products/ available on Get openSUSEhttps://get.opensuse.org/ .
I understood that this data is stored in the Influx DB and therefore I am reaching out to you.
Would you please share with me what are the next step for me to request login and read rights to the database?
Thank you.
Regards,
Kalina
[cid:image001.png@01D9A462.FB2DBFD0]
Kalina Dodeva
Senior Data Analyst
SUSE
+359 88 349 0901
www.suse.com
http://www.suse.comLinkedInhttps://www.linkedin.com/company/suse/mycompany/ | Instagramhttps://www.instagram.com/lifeatsuse/ | https://twitter.com/SUSE Twitterhttps://twitter.com/SUSE |https://twitter.com/SUSE YouTube https://www.youtube.com/channel/UCHTfqIzPKz4f_dri36lAQGA
Files
Updated by crameleon 11 months ago
- Private changed from Yes to No
Hi Kalina,
I'm not sure the metrics are maintained, if I check the InfluxDB server on metrics.infra.opensuse.org, the newest release database I can find is for Leap 15.2:
> SHOW DATABASES
name: databases
name
----
_internal
openSUSE:Leap:42.1
openSUSE:Leap:13.2
openSUSE:Leap:13.1
openSUSE:13.1
openSUSE:13.2
openSUSE:Leap:42.2
openSUSE:Leap:42.3
openSUSE:Leap:15.0
telegraf
openSUSE:Factory
osrt_telegraf
openSUSE:Leap:15.1
openSUSE:Leap:15.2
osrt_access
And the last entry for openSUSE:Factory seems to be from 2021:
> USE "openSUSE:Factory"
Using database openSUSE:Factory
> SELECT * FROM release_snapshot ORDER BY time DESC LIMIT 1
name: release_snapshot
time binary_count binary_unique_count
---- ------------ -------------------
1625961600000000000 71128 310
$ date -d @1625961600
Sun 11 Jul 2021 12:00:00 AM UTC
Maybe @lkocman has more insight into this?
Kalina, if you would like access regardless, we can set you up with access to the openSUSE Heroes VPN in order for you to reach the API and shell (there does not seem to be a public web frontend or API - @someone else checking this ticket: correct me if I'm wrong).
For this, please provide us with a public GPG key, and, if possible, register an IDP account on https://idp-portal.suse.com/ and use it to log in to this ticketing system (https://progress.opensuse.org/) for easier communication in case of issues.
Cheers,
Georg
Updated by cboltz 11 months ago
crameleon wrote:
I'm not sure the metrics are maintained, if I check the InfluxDB server on metrics.infra.opensuse.org, the newest release database I can find is for Leap 15.2:
That's strange - metrics.opensuse.org displays up-to-date information that includes 15.4, therefore I'd expect that it is stored somewhere ;-)
Updated by cboltz 11 months ago
After submitting the previous comment, I noticed that there's also some data for 15.5, but the numbers are still quite small and therefore easy to overlook.
BTW: To see the very latest data, you might want to switch to the "Aggregation Frequency" to "day" instead of "month" (which is the default).
Updated by crameleon 11 months ago
- Status changed from New to Feedback
- % Done changed from 0 to 10
Hi,
as discussed in the Teams calls earlier, the data is there, but in the "osrt_access" database.
Let me know if you want access to the openSUSE Heroes VPN in order to reach the InfluxDB API, and if so, please provide a public GPG key to proceed.
Best,
Georg
Updated by witekbedyk 11 months ago
Hi,
I maintain the script which ingests the data to the mentioned DB. Please reach out to me on Slack if you have questions to the data structure.
W. Bedyk