a week ago
I would like to create a BIRT report that shows the IP addresses of the individual LIFs. Unfortunately, I cannot find the table containing the IP address in the Data Source.
Does anyone know which table contains the IP address?
Solved! SEE THE SOLUTION
a week ago
The way to find out the IP address of a single LIF is
However, you will not be able to export this information by creating a report from the UI.
The Performance/LIFs page supports generating report, but it does not display the IPs.
One other more complex way is by creating a Database user, then export the information from the Database. Let me know if you would like to go that route, so we can provide more details.
thank you for your answer. But I didn't want to look at the IP in OCUM, I wanted to have all IPs of all systems displayed via an BIRT-OCUM report. In the meantime I have also found a solution - but perhaps there are others:
The standard data base / table for creating your own reports is probably ocum_report. For this, a database user with the role "Report Schema" is required in OCUM. Unfortunately, I didn't find a table/view that contains the IP address.
On my search I found that when installing OCUM (7.2.) the following MySQL databases and tables are also installed:
- scale monitor
Unfortunately, I cannot access the other databases / tables with the above-mentioned user - in BIRT. By chance, I discovered that a WFA(Workflow Automation)-database-user with the role "Report Schema" can access the following tables:
- network_lif. address
And here I find finally in the netapp_model_view >> network_lif the network_lif. address I'm looking for! Hooray.
Perhaps my comments will help other people who have similar problems. But maybe someone also knows a simpler solution.
It would also be interesting to know how - with which user (except Mysql root) - access to the other databases / tables would be possible.
Sorry, a little correction:
The WFA database user requires the role "Integration Schema" and the tables are:
netapp_model_view (not network_lif. address) - netapp_model_view (not network_lif. address)
In my pleasure, I have made a mistake. :-)