07-08-2002 06:28 AM - edited 03-01-2019 11:37 PM
does anyone know how to connect directly, via dbreader/dbreader.html or isql, to the rme database ?
which password has the dba account ?
i will try to get detail information from the inventory, which i can't get from the normal reporting tools.
thank you for any help
christoph
07-08-2002 09:16 AM
Querying the db directly is not recommended. Even if you know the db password, the db schema is not published, so how would you know which tables to refer to?. You could easily end of corrupting the db, not supported.
07-09-2002 12:06 AM
Thank you for answering my question. I understand that it may be difficult to find the right information in the rme-database when the schema isn't known. But what do you think about getting information about the serial numbers of about appr. 1100 routers ? This information is already retrieved by rme-inventory but only gets extracted by the detailed device report. This report can be activated for only 50 devices at a time and is formatted in a way which makes it impossible to work on by excel. When creating a custom report for the information i need (serial number from all modules within the router) i get only the chassis serial number.
I want to access the database to retrieve information not to change something.
07-09-2002 02:28 AM
Hi,
You can create a custom report in Resource Manager Essentials -> Administration -> Inventory (report type "Serial Number").
When you run this custom report, you can save the report as a CSV file.
As for the 50 device limit, a patch is available to remove this, please contact the TAC for this.
regards,
Sharath
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide