DX Unified Infrastructure Management

 View Only
  • 1.  Export Protocol Group

    Posted Apr 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




    Diego Pereyra

  • 2.  Re: Export Protocol Group
    Best Answer

    Broadcom Employee
    Posted Apr 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 Apr 07, 2017 08:12 AM

    Thanks a lot !