Skip to content

dbarj/oci360

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

OCI360 - Oracle Cloud Infrastructure 360º View

What is OCI360?

Oracle Cloud Infrastructure 360º View is a free open-source framework and tool to generate fancy html output of your tenancy that allows for quick analysis of an existing cloud estate to better optimize the use of cloud resources. You can also adapt it to generate your own queries and create some custom reports over your OCI tenancy.

The tool installs nothing and all it needs is a database schema to generate and read your tenancy model (more info below). It takes around 30 minutes to execute.

Output ZIP file can be large (several MBs), so you may want to execute OCI360 from a system directory with at least 1 GB of free space.

OCI360 uses moat369 API to generate html and graphs output. If you are familiar to edb360 and sqld360, you will notice they all have the same Look'n Feel.

For a full sample report from my tenancy, check http://oci360.dbarj.com.br/.

How does it work?

OCI360 will load and convert all the JSON information of your OCI tenancy into Oracle Database tables and views, creating a full metadata structured model. After the model is created on your database, it will query those tables and create reports about your OCI.

The overall execution can be divided in 3 steps:

Exporter Phase

First, the tool will connect to OCI through the delivered command line interface (OCI-CLI) and get tenancy metadata in JSON format.

Exporter

Converter Phase

Later, the tool will collect the JSON files output by the extractor and load the data to an Oracle Database for analysis and reporting.

Converter

Reporter Phase

Finally, the tool will pull the data from the Oracle database to generate tables and charts that are then output in HTML format for consumption.

Reporter

Execution Steps

For the execution steps, please check the Wiki Page.

Results

  1. Unzip output OCI360_YYYYMMDD_HH24MI.zip into a directory on your PC.

  2. Review main html file 00001_oci360_index.html.

Output

Sample Sections

Below are some sections generated by OCI360:

Infrastructure View

Output

Compute Instances Info

Output

Subscribed regions Map

Output

Space Summary

Output

Backup Utilization Forecast

Output

Shapes per Compute

Output

Volume Treemap

Output

For a sample full report from my tenancy, check http://oci360.dbarj.com.br/.

Latest changes

Check CHANGELOG.md for more info.