All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog.
- Added attributedCost (COST_ATTRIBUTED_COST) and attributedUsage (USG_ATTRIBUTED_USAGE)
- Added database_pdbs csv
- Fixed bugs and updated dependencies
- Added Identity Policies and Identity Domain csv to adw
- Update instantclient to version 19.23
- Update Requests to 2.32.1
- Update instantclient to version 19.22
- Added new flags -nm for override namespace and -bn for override bucketname
- Added OCI_TENANT table for child tenant display name
- Terraform deployed on ECPUs
- Added support for ECPUs
- ADB Password moved to KMS Secret
- Added showoci_csv2adw.py to load showoci csv files to adw if showoci enabled
- Simplified the setup script
- Point to OCI Python SDK Repo
- Added OCI_RESOURCES Table populated from showoci
- Fix OCI_LOAD_STATUS Constraint bug
- Added 51 ShowOCI tables to the APEX Page
- Added ShowOCI Section if ShowOCI data enabled
- Added Load statistics to Apex main page
- Added Service Grouping in cost over time report
- Added Load Status Page and OCI_LOAD_STATUS table
- Added Public Load Balancer to the Private End Point Image
- Change Image to Oracle Linux 8
- Added showoci code to the image
- Migrated cx_oracle to oracledb libraries
- Update the list price API
- Added additional output information
- Added Option to Tag resources
- Added new report to Cost Analysis
- Fix few report to include billing amendment rows
- Fix error with script run_single_daily_usage2adw.sh
- Added second special tag key and corresponding reports and charts
- Added Report for Cost Analysis
- Fix few bugs
- Added OCPU report by service to daily_report and Data Statistics page
- New Marketplace Version
- Added option to run report on all Tenants when multi tenants loaded
- Amended APEX application for version 21.1
- Amended the APEX Theme
- Added instructions to the installation guide how to change the Autonomous database to private endpoint.
- Added Parallel queries for better performance for both APEX and usage2adw.py
- Added table view in APEX Application for current usage
- Redesign the usage over time on APEX Application
- Remove Oracle IDCS prefix from the tag special if exist
- Added OCI_INTERNAL_COST for internal usage
- Added OCPU and Storage report to the daily shell script
- Added gather stats crontab weekly with script run_gather_stats.sh
- Fixed bug calling reference update
- Added option to specify one Tag Key to extract the data to TAG_SPECIAL column , use -ts
- Added the Tag Special to filter and reports.
- Fixed filter by Tag Data Bug
- Added Pagination call to the list_objects
- Added tenant aggregation for cost report
- Added sub tenants in daily report
- Added functionality for faster deployment (Step by Step installation amended)
- Added functionality to support Market Place Image with automatic deployment
- Changed shell scripts to support credential at file config.user
- Added flag -sr to skip public rate
- Fix Public Rate new SKUs
- Added TENANT_ID with 6 last digits to support organization
- Aligned to APEX Version 20.1
- Aligned to one cost instead of Paygo/Monthly
- Added monthly consumption in the Data Statistics tab
- Added sleep 0.5 to the public API call to avoid too many requests error
- Change Public Rate API to use one value only after OCI change costs
- Added Full + Parallel scan when retrieving max cost and usage file
- Support for Cost column changed - OCI amend the column billingUnitReadable to skuUnitDescription
- Added daily report script with step by step configuration - requires OCI Email setup
- Fixed bug on Apex related to the column change for Cost Report
- Added flags to skip usage or skip cost with -sc and -su
- Added buffer size and array size for database multi insert to avoid large transaction failing
- Added Hourly cost over time
- Added Summary cost per day to the Data Statistics - if you manage many tenants, it is a great view to see them all
- Added Cost by SKU to the Cost Over Time - Daily/Weekly and Monthly
- Added Rate Card with OCI_PRICE_LIST and using API to obtain info, Thanks to Fabio for the Idea and the API
- Added discount and public rate to the cost report
- Added performance improvements to Cost by adding index OCI_COST_1IX and reference table OCI_COST_REFERENCE
- Added Graph Report Selector to the Cost pages
- Added accumulative Chart to Cost
- Added Manual Descriptions for products that don't have.
- Added More Charts to Cost Over Time
- Added More Charts to Cost Analysis
- Added connectivity to the home region where bling bucket exist
- Added performance improvements by adding stats tables OCI_USAGE_STATS and OCI_COST_STATS and indexes OCI_USAGE_1IX, OCI_COST_1IX, Please run the load script before importing the APEX app in order to create those tables and index
- Added limit, prefix and start to the list_object call
- Added support for special chars
- Added Currency Code to the pages
- Added checks if columns exist in the file to avoid failure
- Added Support for null overage
- Align code to use functions properly
- Added table OCI_USAGE_TAG_KEYS for tags
- Added table OCI_COST and OCI_COST_TAG_KEYS for cost usage
- Added support for cost files
- Added Cost Analysis and Cost Overview to the APEX App
- Added support for tags - TAGS_DATA columns to the table OCI_USAGE
- Added step by step installation guide for instant principles
- Added APEX Application to query the data
- Initial Release