As a LIR we want to extract all records for which we are registered as mnt-by. We tried: https://apps.db.ripe.net/db-web-ui/query?searchtext=-i%20mnt-by%20ISOC-MNT but it appears there is some limit at which point all results are blocked for an undetermined time. Also, we don't want to do copy/paste but rather would like that ability to download or API or script the results. Any clue? We also like the app: https://stat.ripe.net/widget/address-space-hierarchy but again here we didn't find a method to download/script/API the results. Any clue? Thanks, Hank
On Tue, Feb 07, 2023 at 07:22:03PM +0200, Hank Nussbacher via db-wg wrote: Hi,
As a LIR we want to extract all records for which we are registered as mnt-by. We tried:
https://apps.db.ripe.net/db-web-ui/query?searchtext=-i%20mnt-by%20ISOC-MNT
but it appears there is some limit at which point all results are blocked for an undetermined time.
This is related to the amount of personal data retrieved from the database. Try to limit it with -r flag.
Also, we don't want to do copy/paste but rather would like that ability to download or API or script the results.
Any clue?
I suggest using either https://rest.db.ripe.net/search?inverse-attribute=mnt-by&source=ripe&query-s... or https://rest.db.ripe.net/search.json?inverse-attribute=mnt-by&source=ripe&qu... Both already include -r flag. More info at https://apps.db.ripe.net/docs/11.How-to-Query-the-RIPE-Database/03-RESTful-A...
We also like the app:
https://stat.ripe.net/widget/address-space-hierarchy
but again here we didn't find a method to download/script/API the results.
Any clue?
Try opening the page under "source data" at the bottom of the hierarchy graph. Hope that helps. Best, Piotr -- Piotr Strzyżewski
07-02-2023 19:22 +0200, Hank Nussbacher wrote:
As a LIR we want to extract all records for which we are registered as mnt-by. We tried:
https://apps.db.ripe.net/db-web-ui/query?searchtext=-i%20mnt-by%20ISOC-MNT
but it appears there is some limit at which point all results are blocked for an undetermined time.
Also, we don't want to do copy/paste but rather would like that ability to download or API or script the results.
Any clue?
Hello Hank I would suggest downloading the db from https://ftp.ripe.net/ripe/dbase/ and filtering the records there, as mnt-by is included in the export. Best regards -- INCIBE-CERT - Spanish National CSIRT https://www.incibe-cert.es/ PGP keys: https://www.incibe-cert.es/en/what-is-incibe-cert/pgp-public-keys ==================================================================== INCIBE-CERT is the Spanish National CSIRT designated for citizens, private law entities, other entities not included in the subjective scope of application of the "Ley 40/2015, de 1 de octubre, de Régimen Jurídico del Sector Público", as well as digital service providers, operators of essential services and critical operators under the terms of the "Real Decreto-ley 12/2018, de 7 de septiembre, de seguridad de las redes y sistemas de información" that transposes the Directive (EU) 2016/1148 of the European Parliament and of the Council of 6 July 2016 concerning measures for a high common level of security of network and information systems across the Union. ==================================================================== In compliance with the General Data Protection Regulation of the EU (Regulation EU 2016/679, of 27 April 2016) we inform you that your personal and corporate data (as well as those included in attached documents); and e-mail address, may be included in our records for the purpose derived from legal, contractual or pre-contractual obligations or in order to respond to your queries. You may exercise your rights of access, correction, cancellation, portability, limitationof processing and opposition under the terms established by current legislation and free of charge by sending an e-mail to dpd@incibe.es. The Data Controller is S.M.E. Instituto Nacional de Ciberseguridad de España, M.P., S.A. More information is available on our website: https://www.incibe.es/proteccion-datos-personales and https://www.incibe.es/registro-actividad. ====================================================================
On Wed, 8 Feb 2023 at 12:09, Ángel González Berdasco via db-wg <db-wg@ripe.net> wrote:
07-02-2023 19:22 +0200, Hank Nussbacher wrote:
As a LIR we want to extract all records for which we are registered as mnt-by. We tried:
https://apps.db.ripe.net/db-web-ui/query?searchtext=-i%20mnt-by%20ISOC-MNT
but it appears there is some limit at which point all results are blocked for an undetermined time.
Also, we don't want to do copy/paste but rather would like that ability to download or API or script the results.
Any clue?
Hello Hank
I would suggest downloading the db from https://ftp.ripe.net/ripe/dbase/ and filtering the records there, as mnt-by is included in the export.
It depends what Hank wants to do with these objects. The ftp files are filtered to remove any data that could possibly be considered as personal data. So you only get a limited amount of data for each object. He may still end up having to query for the full object data. (In my dreams) what we really need is a form of authenticated queries so you can download full versions of all objects that you maintain, without any limits or filtering... cheers denis co-chair DB-WG
Best regards
-- INCIBE-CERT - Spanish National CSIRT https://www.incibe-cert.es/
PGP keys: https://www.incibe-cert.es/en/what-is-incibe-cert/pgp-public-keys
====================================================================
INCIBE-CERT is the Spanish National CSIRT designated for citizens, private law entities, other entities not included in the subjective scope of application of the "Ley 40/2015, de 1 de octubre, de Régimen Jurídico del Sector Público", as well as digital service providers, operators of essential services and critical operators under the terms of the "Real Decreto-ley 12/2018, de 7 de septiembre, de seguridad de las redes y sistemas de información" that transposes the Directive (EU) 2016/1148 of the European Parliament and of the Council of 6 July 2016 concerning measures for a high common level of security of network and information systems across the Union.
====================================================================
In compliance with the General Data Protection Regulation of the EU (Regulation EU 2016/679, of 27 April 2016) we inform you that your personal and corporate data (as well as those included in attached documents); and e-mail address, may be included in our records for the purpose derived from legal, contractual or pre-contractual obligations or in order to respond to your queries. You may exercise your rights of access, correction, cancellation, portability, limitationof processing and opposition under the terms established by current legislation and free of charge by sending an e-mail to dpd@incibe.es. The Data Controller is S.M.E. Instituto Nacional de Ciberseguridad de España, M.P., S.A. More information is available on our website: https://www.incibe.es/proteccion-datos-personales and https://www.incibe.es/registro-actividad.
====================================================================
--
To unsubscribe from this mailing list, get a password reminder, or change your subscription options, please visit: https://lists.ripe.net/mailman/listinfo/db-wg
Hi Denis, Colleagues,
On 8 Feb 2023, at 13:36, denis walker via db-wg <db-wg@ripe.net> wrote:
...
It depends what Hank wants to do with these objects. The ftp files are filtered to remove any data that could possibly be considered as personal data. So you only get a limited amount of data for each object. He may still end up having to query for the full object data.
(In my dreams) what we really need is a form of authenticated queries so you can download full versions of all objects that you maintain, without any limits or filtering...
cheers denis co-chair DB-WG
Authenticated queries have been on the DB team's backlog for a while. If there is interest I suggest we turn it into an NWI and prioritise it. A limit is normally applied when querying for objects that could contain personal data: https://apps.db.ripe.net/docs/12.Access-to-Personal-Data/#blocking-access-to... With authenticated queries, there will be no query limit for objects maintained by the user's own maintainer. Also an unfiltered object can be returned without limit for a user's own objects. Regards Ed Shryane RIPE NCC
participants (5)
-
denis walker -
Edward Shryane -
Hank Nussbacher -
Piotr Strzyzewski -
Ángel González Berdasco