Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics: 1. Get all mac or IP detected by netdisco ? (Gallavardin Antoine) 2. Re: Get all mac or IP detected by netdisco ? (Oliver Gorwits) 3. Re: Get all mac or IP detected by netdisco ? (Gallavardin Antoine) 4. Macsuck from offline device ?? (Oliver B?hrig)
--- Begin Message ---Hello all I'm using netdisco since 1 year, it save me several hours per month.Now I trying to connect it with an home made CMDB based on FusionDirectory [1]I was able to request netdisco for fetching macAddress ( trough API with php and python)Now I want to compare all mac detected in my network and compare it to my officiel CMDB in order to detected unauthorized device (no radius authentification system isn't in place but it's planned, I need to get all allowed mac before)I try to get it trough API but I always get a empty response , my search pattern is *:*:*:*:*:* (for mac) or *.*.*.* for ip ( no success) documentation indicate that sql is allowed but wich one ?Do you have any clue ? Thanks in advance ! Antoine [1] https://marketplace.fusiondirectory.org/plugin.php?name=netdisco -- Antoine Gallavardin INRAE - SIIR Auvergne Rhone Alpes - DSI-INFRA
--- End Message ---
--- Begin Message ---Hi Antoine, If you use the /api/v1/search/node API endpoint, set partial=true and use "_" for the search, then it will return all nodes. This works because "_" is an SQL wildcard for any character, so it's a bit of an undocumented hack. Note that if there are more than 10,000 nodes then the report will fail. If that's a problem, let me know and we can probably fix it. The API call would be something like: http://localhost:5000/api/v1/search/node?q=_&partial=true hope this helps, regards, Oliver. On Wed, 24 Aug 2022 at 07:17, Gallavardin Antoine < [email protected]> wrote: > Hello all > > I'm using netdisco since 1 year, it save me several hours per month. > > Now I trying to connect it with an home made CMDB based on > FusionDirectory [1] > > I was able to request netdisco for fetching macAddress ( trough API > with php and python) > > Now I want to compare all mac detected in my network and compare it to > my officiel CMDB in order to detected unauthorized device (no radius > authentification system isn't in place but it's planned, I need to get > all allowed mac before) > > I try to get it trough API but I always get a empty response , my search > pattern is *:*:*:*:*:* (for mac) or *.*.*.* for ip ( no success) > documentation indicate that sql is allowed but wich one ? > > Do you have any clue ? > > Thanks in advance ! > > Antoine > > > [1] https://marketplace.fusiondirectory.org/plugin.php?name=netdisco > > -- > Antoine Gallavardin > INRAE - SIIR Auvergne Rhone Alpes - DSI-INFRA > > > > _______________________________________________ > Netdisco mailing list > [email protected] > https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---Hi Oliver
Working great !!
For the moment, I don't have more than 10000 node (for the moment)
Indeed, maybe a pagination system could be useful.
Certainly I'll have more question about API content because I try to draw the front panel of a network device, but following the constructor , the result is very different ,but it's for another thread
Thanks Again !
Antoine
Le 24/08/2022 à 11:01, Oliver Gorwits a écrit :
Hi Antoine,
If you use the /api/v1/search/node API endpoint, set partial=true and use "_" for the search, then it will return all nodes. This works because "_" is an SQL wildcard for any character, so it's a bit of an undocumented hack. Note that if there are more than 10,000 nodes then the report will fail. If that's a problem, let me know and we can probably fix it. The API call would be something like:
hope this helps,regards,Oliver.
On Wed, 24 Aug 2022 at 07:17, Gallavardin Antoine <[email protected]> wrote:
Hello all
I'm using netdisco since 1 year, it save me several hours per month.
Now I trying to connect it with an home made CMDB based on
FusionDirectory [1]
I was able to request netdisco for fetching macAddress ( trough API
with php and python)
Now I want to compare all mac detected in my network and compare it to
my officiel CMDB in order to detected unauthorized device (no radius
authentification system isn't in place but it's planned, I need to get
all allowed mac before)
I try to get it trough API but I always get a empty response , my search
pattern is *:*:*:*:*:* (for mac) or *.*.*.* for ip ( no success)
documentation indicate that sql is allowed but wich one ?
Do you have any clue ?
Thanks in advance !
Antoine
[1] https://marketplace.fusiondirectory.org/plugin.php?name=netdisco
--
Antoine Gallavardin
INRAE - SIIR Auvergne Rhone Alpes - DSI-INFRA
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/-- Antoine Gallavardin INRAE - SIIR Auvergne Rhone Alpes - DSI-INFRA 5 rue de la Doua CS 20244 69625 Villeurbanne Cedex +33 4 72 20 86 19 (ligne directe) +33 6 43 55 13 86
--- End Message ---
--- Begin Message ---Hi all,I am running Netdisco version 2.52.7 and got some interesting SQL output from my report.ip | last_discover | last_macsuck | --------------+---------------------+---------------------+- 10.42.4.51 | 2022-08-24 10:03:08 | 2022-08-20 00:45:22 | *10.42.4.143 | 2022-06-04 10:00:28 | 2022-08-24 10:58:51 | 10.42.5.14 | 2022-08-24 10:02:05 | 2019-09-01 15:12:02 | *10.42.5.31 | 2022-05-17 06:01:39 | 2022-08-24 10:53:23 | 10.42.14.84 | 2022-08-24 10:02:55 | 2022-08-14 02:50:18 |The macsuck date from the tagged entries got a current date, but the device was switched off since the last_discover date. It is the same date in the webGUI. The device 10.42.5.31 (and also 10.42.4.143) is not reachable on the network. (really removed from)The discovery date is correct but the date from last_macsuck can not be correct.Any ideas whats going wrong ? Thanks Regards Oliver Buehrig
smime.p7s
Description: S/MIME Cryptographic Signature
--- End Message ---
_______________________________________________ Netdisco mailing list - Digest Mode [email protected] https://lists.sourceforge.net/lists/listinfo/netdisco-users
