Hello everyone,
I am an intern helping my network engineering team to automate things in SolarWinds using Python scripts. My last project concerns extracting/updating information for every subnet. We use different servers for testing and production. I created a script extracting information from the database using the tables IPAM.GroupReport and IPAM.GroupNodeAttr. Afterwards, I run the same script in the Orion webserver. Unfortunately, it failed. I realised that I am not able to access the table IPAM.GroupNodeAttr. So, I opened the database manager to look ta the tables, and I noticed that the manager displays different names for the same tables.
Here are my questions.
Do you know why there are different table names between these servers?
Even though the database manager displays different table names, I am able to access some tables that are not being shown. I know these table names from the script I created for the testing server (database manager in testing server displays different table names).
Even though I can extract information using the database manager, I am not able to extract these information using a Python script. It is like the tables are not there. Has anyone faced it before?
Thank you in advance,