• HOWTOS

  • Export / Import IPV6 Host Labels

Running Version 6.5.2185 of Network Analytics 6.5

I have taken the time - for where I have a HostsIPv6 host - I have added a "label" to help me determine the name resolution or network.

I have a significant amount of entries, for all IPv6 Hosts.

Question
1) Can I export the Readable Key value AND the associated label I have assigned ? I have tried to export via Tools / Export IP Flows all IP's. However that does not appear to give me the associated label, in the xls. Any pointers on how I export this ?

2) Once I have achieved 1) - Is it possible to import this file, to re-populate the mapping between readable key and label, in the event of corruption of the DB ?

Any pointers welcome - thanks.

    Quite a few users have asked for this capability. In our next release, expected by end of this week, Trisul will support an easy way to bulk import and export labels.

    In the meantime, if you are comfortable with scripting - you can insert them manually using SQL. The mappings are stored in the file

    /usr/local/var/lib/trisul-hub/domain0/hub0/context0/meters/persists/c-6CD742B1-C1CA-4708-BE78-0FCA2EB01A86.SQT

    (That big number is a GUID represents IPv6 Hosts)

    You can write INSERT statements like

    sqlite3 c-6CD742B1-C1CA-4708-BE78-0FCA2EB01A86.SQT
INSERT INTO "KEYS" VALUES('C1CA0000111100002222000033330000','securev6.gvt.org',NULL);

    You have to translate the IPv6 addresses like fe80::690e:6478:a712:c42f into the Trisul Key format yourself which is a full expansion of the IPv6 address with the : removed and uppercased FE80000000000000690E6478A712C2F

    You can give this a try or just wait for a couple of days, I will post back a message on this forum when the feature is available.

    Regards,

    Vivek R

      6 days later

      Hi apmitche,

      We just released a new build with this feature.

      1. Login as normal user
      2. Go to Customize > Show All > Keys
      3. Click on Import from CSV or Export to CSV against the HostsIPv6 counter group

      Thanks for waiting. Let us know if this works.

      Vivek

        Hi Vivek

        I have successfully exported to a CSV for the HostsIPv6 counter group

        Many Thanks
        Adrian

          Write a Reply...