DX Infrastructure Manager

Expand all | Collapse all

Export Protocol Group

Jump to Best Answer
  • 1.  Export Protocol Group

    Posted 04-06-2017 11:37 AM

    Hello again!

    Today I will like to export a list of all entries of Protocol Groups (ip tcp udp), it is in mysql db  for export maybe ?

     

    Only the first 1000 of 128747 protocols are shown. Please refine your seach.


    This Protocol Group consists of the following protocols

    Protocol sorted in ascending order Encapsulation Description
    3com-tsmux *.ip.tcp.106 3COM-TSMUX
    3com-tsmux *.ip.udp.106 3COM-TSMUX
    aep *.ip.tcp.204 AppleTalk Echo Protocol
    aep *.ip.udp.204 AppleTalk Echo Protocol

    .....

     

    Thanks

    Diego Pereyra



  • 2.  Re: Export Protocol Group
    Best Answer

    Posted 04-06-2017 11:55 AM

    Try this query, this is what runs when pulling up the full protocol list on the protocol groups page, except I removed the 1000 limit.  This command can be run from a regular cmd prompt and it will pipe the results to protocols.txt in the directory where you ran the command.

     

    mysql -D reporter -t -e "SELECT ID, IfNull(pd.Name, p.Name) as 'Name', Encapsulation, IfNull(pd.Description, p.Description) as 'Description'  FROM protocol_definitions p left outer join protocol_domains pd on pd.protocolId = p.id and pd.domainId = 1 INNER JOIN protocol_groups pg on p.ID=pg.ProtocolID and groupID=1 ORDER BY Name, Encapsulation;" > protocols.txt



  • 3.  Re: Export Protocol Group

    Posted 04-07-2017 08:12 AM

    Thanks a lot !