hi , we are trying to extract information from query executer , we want to know all tables names
Hi Edgar,
First of all, it will be interesting to know the use case that you would like to achieve by requesting all table names. If possible, please could you elaborate?
In case the DMA is running Cassandra as local database, you could use the following query:
SELECT table_name FROM system_schema.tables WHERE keyspace_name = 'SLDMADB';
In case the DMA is running MySQL as local database, you could use the following query:
SHOW TABLES;
Edgar & Javier - Going into a distributed DB to try and query a consolidated list of elements and or parameters may poses its challenges.
Have you considered using our WebServices (DataMiner Web Services API reference guide) or generating such reports directly in our Dashboards (DataMiner Dashboards - DataMiner Dojo)module? I would strongly advise considering this route.
A similar use case is the combination of "Profiles" as Mediation layer, in combination with Dashboards.
Let's say you have different network devices such as Alcatel & Cisco Switches and you want to display information from both vendors in the same dashboard.
Hello Miguel,
Just a last question, if we use SELECT * FROM timetrace we get a lot of information from different time, We can extract/generate only the information from one specific day?
Regards
retrieving only the information between two specific dates can be done using the following query: SELECT * FROM timetrace WHERE t > ‘2021-03-22’ AND t < '2021-03-24' LIMIT 1000 ALLOW FILTERING
Hello Tom,
We tried the command but it generates an error:
CassandraConnection ExecuteQuery – exception executing query:
SELECT * FROM timetrace WHERE t> ‘2021-03-22’ AND t <'2021-03-24' LIMIT 1000 ALLOWS FILTERING – line 1:34 alternative not viable in character '"
We tried changing the quotes, however generating the error.
thanks for the information Miguel , yes we are trying to find out the best way to extract information from our DMA cluster from multiple devices and all of their interfaces , and we noticed that query executer can export this information in csv, we need this to do some statistics required for the organization