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 Description3com-tsmux *.ip.tcp.106 3COM-TSMUX3com-tsmux *.ip.udp.106 3COM-TSMUXaep *.ip.tcp.204 AppleTalk Echo Protocolaep *.ip.udp.204 AppleTalk Echo Protocol
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
Thanks a lot !