AndrewTavis_WMDE added a comment.
A follow up request from @Manuel on this was for the total IPs that are
accessing Scholia. The following query was run for this:
SELECT
count(
DISTINCT CASE
WHEN query LIKE '%# tool: scholia%' THEN http.client_ip
END
) AS total_comment_ips,
count(
DISTINCT CASE
WHEN http.request_headers['user-agent'] LIKE '%Scholia%' THEN
http.client_ip
END
) AS total_user_agent_ips
FROM
event.wdqs_external_sparql_query
WHERE
query LIKE '%# tool: scholia%'
OR http.request_headers['user-agent'] LIKE '%Scholia%'
Results are:
- Total IPs is: `29,145`
- total_comment_ips: `28,960` (99.4%)
- total_user_agent_ips: `185` (0.6%)
TASK DETAIL
https://phabricator.wikimedia.org/T353453
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, dcausse, Aklapper, Manuel, Danny_Benjafield_WMDE,
Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz,
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, KimKelting, LawExplorer,
_jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
