I am investigating the UIM database to understand how the information is stored.
Here is the CM_GROUP_DYNAMIC table which shows some group definitions.
grp_id 5 & 24 are interface groups.
Do you know where are the :ca.Element/* data stored?
Where are the interface aliases stored in UIM? (snmp devices)
I believe all of the interface information including alias is store in the
Hope this helps
unfortunately I am afraid that I can only find Hexa references in this table.
The datomic_kvs table is not your typical SQL table - it's unlikely you will be able to glean any useful information from it. It's not really intended to be interacted with by an end-user the way a normal SQL structured table is, there is a whole different query language and technology involved.
You can read more about it here: Datomic - Home
Unfortunately, though, this probably won't help you much either - at this point, the Datomic data in UIM is pretty much a "black box" and there is no real visibility into the raw data for interfaces.