Export Protocol Group

[d.pereyra]

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

[Christopher Walsh]

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

[d.pereyra]

Thanks a lot !