2018-02-14 01:59 AM
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
2018-02-15 11:31 AM
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.
2018-02-19 12:40 AM
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.
2018-02-19 12:54 AM
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. :-)