{"id":4298,"date":"2019-10-10T14:35:21","date_gmt":"2019-10-10T17:35:21","guid":{"rendered":"https:\/\/www.dbarj.com.br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/"},"modified":"2019-10-11T14:19:29","modified_gmt":"2019-10-11T17:19:29","slug":"how-to-export-all-your-oracle-cloud-infrastructure-billing-information","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/","title":{"rendered":"How to export all your Oracle Cloud Infrastructure billing information"},"content":{"rendered":"<p>As of today (<strong>October 2019<\/strong>), there is still no internal capability in Oracle Cloud Infrastructure to export the metadata of all the billing information you have in your OCI to a CSV, JSON or any other file that would allow us to easily import in other tools to create our own graphs.<\/p>\n<p>Meanwhile, I have some customers that work with OCI and have the requisite to create their own costs graphs and generate some linear regression estimates of future costs, like the graphs below:<\/p>\n<p id=\"qgvTifj\"><img loading=\"lazy\" decoding=\"async\" width=\"1624\" height=\"1006\" class=\"alignnone size-full wp-image-4285 \" src=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4.png\" alt=\"\" srcset=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4.png 1624w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4-300x186.png 300w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4-768x476.png 768w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4-1024x634.png 1024w\" sizes=\"auto, (max-width: 1624px) 100vw, 1624px\" \/><\/p>\n<p style=\"text-align: right;\"><em>Expenses by resource type per day.<\/em><\/p>\n<p id=\"BwnMdJe\"><img loading=\"lazy\" decoding=\"async\" width=\"1624\" height=\"1004\" class=\"alignnone size-full wp-image-4287 \" src=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f579a840fe.png\" alt=\"\" srcset=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f579a840fe.png 1624w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f579a840fe-300x185.png 300w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f579a840fe-768x475.png 768w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f579a840fe-1024x633.png 1024w\" sizes=\"auto, (max-width: 1624px) 100vw, 1624px\" \/><\/p>\n<p style=\"text-align: right;\"><em>Total Expenses per day and Linear Regression trend.<\/em><\/p>\n<p>To make this possible, I had to find a way to extract all the billing information from OCI. As the steps to manually export all the billing data are not trivial, I&#8217;ve developed a script that will do all the work.<\/p>\n<p>The script is public available at my <strong>github<\/strong> oci-scripts page: <strong><a href=\"https:\/\/github.com\/dbarj\/oci-scripts\/blob\/master\/oci_json_billing.sh\" target=\"_blank\" rel=\"noopener noreferrer\">oci_json_billing.sh<\/a><\/strong><\/p>\n<h3>How does it work?<\/h3>\n<p>The <strong>oci_json_billing.sh<\/strong> is a 100% public bash shell script tool that extracts all the Oracle Cloud Infrastructure billing information into JSON files and compact in a single zip output.<\/p>\n<ul>\n<li>It uses <strong>cURL<\/strong> and <strong>jq<\/strong> in the backend.<\/li>\n<li>Each execution of <strong>oci_json_billing.sh<\/strong> may take several minutes, however, it will not impact the OCI performance.<\/li>\n<li>Execution time is long since <strong>oci_json_billing.sh<\/strong> makes use of more than a hundred single-threaded sequentially-executed <strong>curl<\/strong> calls to produce its output.<\/li>\n<li>For more information about <strong>oci_json_billing.sh<\/strong>, refer to content and links at <a href=\"https:\/\/github.com\/dbarj\/oci-scripts\/blob\/master\/oci_json_billing.sh\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/github.com\/dbarj\/oci-scripts\/blob\/master\/oci_json_billing.sh<\/a><\/li>\n<\/ul>\n<h3>Pre-requisites<\/h3>\n<p>As already said,\u00a0<strong>oci_json_billing.sh<\/strong> depends that you have a <strong>bash shell, cURL <\/strong>and<strong> jq<\/strong>.<\/p>\n<div class=\"page\" title=\"Page 2\">\n<div class=\"layoutArea\">\n<div class=\"column\">\n<h4><span style=\"text-decoration: underline;\">Bash Shell<\/span><\/h4>\n<p>Bash is the GNU Project&#8217;s shell. It\u2019s available on most UNIX operating systems, like Linux and Mac.<\/p>\n<h4><span style=\"text-decoration: underline;\">cURL<\/span><\/h4>\n<p>cURL is a computer software project providing a library and command-line tool for transferring data using various protocols. It&#8217;s also available on most UNIX operating systems, like Linux and Mac.<\/p>\n<h4><span style=\"text-decoration: underline;\">JQ<\/span><\/h4>\n<p>JQ stands for <strong>Json Query<\/strong>, it\u2019s a parser that is required to generate and process JSON files generated by cURL. It\u2019s available at <a href=\"https:\/\/github.com\/stedolan\/jq\/releases\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/github.com\/stedolan\/jq\/releases<\/a><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ cd ~\/bin\r\n[user@localhost ~]$ wget -O jq https:\/\/github.com\/stedolan\/jq\/releases\/download\/jq-1.5\/jq-linux64\r\n100%[===========================================&gt;] 2.89M 862KB\/s in 3.8s\r\n2018-09-17 18:55:00 (776 KB\/s) - \u2018jq\u2019 saved [3027945\/3027945]\r\n[user@localhost ~]$ chmod +x jq\r\n[user@localhost ~]$ export PATH=$PATH:`pwd`\r\n[user@localhost ~]$ which jq\r\n\/Users\/myuser\/bin\/jq<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>Some linux distributions also provides JQ straight from the yum repository.<\/p>\n<h3>How to run it?<\/h3>\n<p><strong>1 &#8211;<\/strong> Download the latest version of the public tool <strong>oci_json_billing.sh<\/strong> from <a href=\"https:\/\/raw.githubusercontent.com\/dbarj\/oci- scripts\/master\/oci_json_billing.sh\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/raw.githubusercontent.com\/dbarj\/oci- scripts\/master\/oci_json_billing.sh<\/a><\/p>\n<p><strong>2 &#8211;<\/strong> Copy to server (into any directory) where it will be executed. Optionally, you<br \/>\ncan download it directly to the server using wget:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ wget https:\/\/raw.githubusercontent.com\/dbarj\/oci-scripts\/master\/oci_json_billing.sh\r\n100%[============================&gt;]  26.39K  --.-KB\/s    in 0.03s   \r\n2018-10-10 11:00:21 (979 KB\/s) - \u2018oci_json_billing.sh\u2019 saved [27027\/27027]\r\n[user@localhost ~]$ chmod +x oci_json_billing.sh<\/pre>\n<p><strong>3 &#8211;<\/strong> Execute shell script <strong><strong><strong>oci_json_billing.sh:<\/strong><\/strong><\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ oci_json_billing.sh\r\nTo run this tool, you must export:\r\n- CLIENT_USER, CLIENT_PASS, CLIENT_DOMAIN\r\n  OR\r\n- CLIENT_ID, CLIENT_SECRET, CLIENT_DOMAIN<\/pre>\n<p>Note this tool will connect in your Oracle Cloud tenancy with and IDCS Application or User to extract all the billing into a JSON file. To create and account to handle that, check this article: <a href=\"https:\/\/www.dbarj.com.br\/en\/2019\/06\/creating-read-only-account-for-rest-billing-access-on-oracle-cloud\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.dbarj.com.br\/en\/2019\/06\/creating-read-only-account-for-rest-billing-access-on-oracle-cloud\/<\/a><\/p>\n<p><strong>4 &#8211;<\/strong> Export the required set of variables and re-run the tool<strong>:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ export CLIENT_ID=\"ce4e87e6d7e08af097cea781bca899cd\"\r\n[user@localhost ~]$ export CLIENT_SECRET=\"cd78d7ab-a4b4-4fd6-269b-ebfe60cbe86c\"\r\n[user@localhost ~]$ export CLIENT_DOMAIN=\"idcs-63d482e2accd67ba76bd767cd687c6b\"\r\n[user@localhost ~]$ oci_json_billing.sh\r\nUsage: oci_json_billing.sh &lt;option&gt; [begin_time] [end_time]\r\n\r\n&lt;option&gt; - Execution Scope.\r\n[begin_time] (Optional) - Defines start time when exporting billing info. (Default is 90 days back)\r\n[end_time]   (Optional) - Defines end time when exporting billing info. (Default is today)\r\n\r\nValid &lt;option&gt; values are:\r\n- ALL         - Execute json export for ALL possible options and compress output in a zip file.\r\n- accountDetails\r\n- checkQuota\r\n- cloudLimits\r\n- promotions\r\n- serviceEntitlements\r\n- serviceResources\r\n- usage\r\n- usageCost\r\n- usageCostTaggedDaily\r\n- usageCostTaggedHourly\r\n- usageTags<\/pre>\n<p><strong>5 &#8211;<\/strong> Note you need a parameter. The <strong>1<sup>st<\/sup> parameter<\/strong> must be either:<\/p>\n<ul>\n<li><span style=\"color: #800000;\"><strong>ALL<\/strong><\/span> &#8211; Means it will scan and export all billing information found . Then it will zip the result in a single file.<\/li>\n<li><strong><span style=\"color: #800000;\">(Specific Value)<\/span><\/strong> &#8211; There are more than 10 other individually specific options you can pass and, in this case, it will export only the json for that object. The exported objected will be spooled to the stdout. You can optionally redirect to write in a specific file.<\/li>\n<\/ul>\n<p><strong>6 &#8211;<\/strong> The <strong>2<sup>nd<\/sup> and\u00a03<sup>rd<\/sup> parameters<\/strong> are optional and, if specified, defines the range of time you want to export the billing info. If omitted, the begging time will be 90 days back and the end time will be today.<\/p>\n<p><strong>Note: It&#8217;s not recommended to collect billing information for a long range of data as this can take several hours to finish! <span style=\"color: #800000;\">If running for the first time, it&#8217;s recommended keep\u00a0 2nd and 3rd parameters for just a very short period.<\/span><\/strong><\/p>\n<p><strong>7 &#8211;<\/strong> Finally, if you run it, it will also give you some warning in case you don&#8217;t export HIST_ZIP_FILE.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ oci_json_billing.sh ALL 2019-10-01 2019-10-02\r\nYou haven't exported HIST_ZIP_FILE variable, meaning you won't keep a execution hist that can be reused on next script calls.\r\nWith zip history, next executions will be much faster. It's extremelly recommended to enable it.\r\nPress CTRL+C in next 10 seconds if you want to exit and fix this.\r\n^CTerminated: 15<\/pre>\n<p>It&#8217;s very important and recommended to export <strong>HIST_ZIP_FILE<\/strong>. This parameter specifies a zip file that will store the past executions logs and jsons, so in case you re-run the tool for a given overlapped timeframe, it will only get the delta that was not yet retrieved from the cloud. All the rest will be retrieved from the historical zip file.<\/p>\n<h3>Execution Example<\/h3>\n<p>Below is a execution demo of the tool:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ ls -l oci_json_billing.sh\r\n-rwxr-xr-x  1 rodrigo.jorge  staff  35831 Oct 10 12:30 oci_json_billing.sh\r\n[user@localhost ~]$ export HIST_ZIP_FILE=\"\/Users\/rodrigo.jorge\/billing_hist.zip\"\r\n[user@localhost ~]$ .\/oci_json_billing.sh ALL 2019-10-01 2019-10-02\r\nProcessing \"oci_cloud_serviceEntitlements.json\".\r\nProcessing \"oci_cloud_serviceResources.json\".\r\nProcessing \"oci_cloud_usageTags.json\".\r\nProcessing \"oci_cloud_usageCost.json\".\r\nProcessing \"oci_cloud_usage.json\".\r\nProcessing \"oci_cloud_usageCostTaggedDaily.json\".\r\nProcessing \"oci_cloud_usageCostTaggedHourly.json\".\r\nProcessing \"oci_cloud_accountDetails.json\".\r\nProcessing \"oci_cloud_checkQuota.json\".\r\nProcessing \"oci_cloud_promotions.json\".\r\nProcessing \"oci_cloud_cloudLimits.json\".\r\n[user@localhost ~]$<\/pre>\n<p>Optionally, you can export the variable <strong>DEBUG=1<\/strong> before calling\u00a0<strong>oci_json_billing.sh<\/strong> script. You will be able to view execution steps.:<\/p>\n<p><em><strong>Note: DEBUG is automatically enabled when running with ALL option.<\/strong><\/em><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ export DEBUG=1\r\n[user@localhost ~]$ .\/oci_json_billing.sh ALL 2019-10-01 2019-10-02\r\nProcessing \"oci_cloud_serviceEntitlements.json\".\r\nProcessing \"oci_cloud_serviceResources.json\".\r\nProcessing \"oci_cloud_usageTags.json\".\r\n...\r\n\r\n## (In another Shell)\r\n\r\n[user@localhost ~]$ ls -ltr\r\ntotal 224\r\n-rw-------   1 rodrigo.jorge  staff   1582 Oct 10 13:14 access_token_1_file.json\r\n-rw-------   1 rodrigo.jorge  staff   1579 Oct 10 13:14 access_token_2_file.json\r\n-rw-r--r--   1 rodrigo.jorge  staff  33983 Oct 10 13:16 oci_json_billing_20191010131412.zip\r\n-rw-r--r--   1 rodrigo.jorge  staff    138 Oct 10 13:16 oci_json_billing_list.txt\r\n-rw-r--r--   1 rodrigo.jorge  staff      0 Oct 10 13:16 oci_cloud_usageCostTaggedDaily.json\r\n-rw-r--r--   1 rodrigo.jorge  staff      0 Oct 10 13:16 oci_cloud_usageCostTaggedDaily.json.err\r\ndrwxr-xr-x  59 rodrigo.jorge  staff   1888 Oct 10 13:16 billing_history\r\n-rw-r--r--   1 rodrigo.jorge  staff  51224 Oct 10 13:16 billing_hist.zip\r\n-rw-r--r--   1 rodrigo.jorge  staff   8868 Oct 10 13:16 oci_json_billing.log\r\n\r\n[user@localhost ~]$ tail -f oci_json_billing.log\r\n20191010131412: BEGIN\r\n20191010131412: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/itas\/idcs-63d482e2accd67ba76bd767cd687c6b\/myservices\/api\/v1\/serviceEntitlements\"\r\n20191010131413: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/itas\/idcs-63d482e2accd67ba76bd767cd687c6b\/myservices\/api\/v1\/serviceEntitlements?offset=25&amp;limit=25\"\r\n20191010131415: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/ADWC\"\r\n20191010131418: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/ANALYTICS\"\r\n...\r\n20191010131549: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/SOA\"\r\n20191010131552: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/SSI\"\r\n20191010131554: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/Storage\"\r\n20191010131557: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/VISUALBUILDERAUTO\"\r\n20191010131559: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/VisualBuilder\"\r\n20191010131600: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/resources\/containerpipe\"\r\n20191010131605: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usage\/cacct-1789adc89f08ea98a98c98b8989d98ef\/tags?tagType=ALL\"\r\n20191010131606: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usagecost\/cacct-1789adc89f08ea98a98c98b8989d98ef?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=HOURLY&amp;timeZone=UTC&amp;dcAggEnabled=Y\"\r\n20191010131611: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usage\/cacct-1789adc89f08ea98a98c98b8989d98ef?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=HOURLY&amp;timeZone=UTC\"\r\n20191010131619: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usagecost\/cacct-1789adc89f08ea98a98c98b8989d98ef\/tagged?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=DAILY&amp;timeZone=UTC&amp;tags=ORCL%3AOCIService%3DObject%20Storage\"\r\n20191010131620: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usagecost\/cacct-1789adc89f08ea98a98c98b8989d98ef\/tagged?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=DAILY&amp;timeZone=UTC&amp;tags=ORCL%3AOCICompartment%3Docid1.tenancy.oc1..aaaaaaaapcuyfcp6umbdlafqqrxzbmm7uvypvdnddfforof4q7jxro7obw7a\"\r\n20191010131622: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usagecost\/cacct-1789adc89f08ea98a98c98b8989d98ef\/tagged?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=DAILY&amp;timeZone=UTC&amp;tags=ORCL%3AOCIService%3DNetworking\"\r\n...\r\n20191010131636: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usagecost\/cacct-1789adc89f08ea98a98c98b8989d98ef\/tagged?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=DAILY&amp;timeZone=UTC&amp;tags=ORCL%3AOCICompartmentName%3DTestCases\"\r\n20191010131637: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usagecost\/cacct-1789adc89f08ea98a98c98b8989d98ef\/tagged?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=DAILY&amp;timeZone=UTC&amp;tags=ORCL%3AOCICompartmentName%3DMakroGroup\"\r\n20191010131639: curl -s -X GET -H \"Authorization: Bearer ${CLIENT_TOKEN}\" \"https:\/\/itra.oraclecloud.com\/metering\/api\/v1\/usagecost\/cacct-1789adc89f08ea98a98c98b8989d98ef\/tagged?startTime=2019-10-01T00:00:00.000Z&amp;endTime=2019-10-02T00:00:00.000Z&amp;usageType=DAILY&amp;timeZone=UTC&amp;tags=ORCL%3AOCICompartmentName%3DMachineClone\"\r\n...<\/pre>\n<h3>Checking output<\/h3>\n<p>After execution is completed, you will have an output in the format <strong>oci_json_billing_YYYYMMDDHHMISS.zip:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ ls -l\r\ntotal 1288\r\n-rw-r--r--  1 rodrigo.jorge  staff  492560 Oct 10 13:32 billing_hist.zip\r\n-rw-r--r--  1 rodrigo.jorge  staff  160891 Oct 10 13:32 oci_json_billing_20191010131412.zip\r\n[user@localhost ~]$ unzip -l oci_json_billing_20191010131412.zip\r\nArchive:  oci_json_billing_20191010131412.zip\r\n  Length      Date    Time    Name\r\n---------  ---------- -----   ----\r\n    70700  10-10-2019 13:14   oci_cloud_serviceEntitlements.json\r\n   283867  10-10-2019 13:16   oci_cloud_serviceResources.json\r\n    41910  10-10-2019 13:16   oci_cloud_usageTags.json\r\n   412495  10-10-2019 13:16   oci_cloud_usageCost.json\r\n   273442  10-10-2019 13:16   oci_cloud_usage.json\r\n   294048  10-10-2019 13:22   oci_cloud_usageCostTaggedDaily.json\r\n  7000743  10-10-2019 13:30   oci_cloud_usageCostTaggedHourly.json\r\n    51936  10-10-2019 13:30   oci_cloud_accountDetails.json\r\n   116190  10-10-2019 13:32   oci_cloud_checkQuota.json\r\n       17  10-10-2019 13:32   oci_cloud_promotions.json\r\n       51  10-10-2019 13:32   oci_cloud_cloudLimits.json\r\n      320  10-10-2019 13:32   oci_json_billing_list.txt\r\n   200703  10-10-2019 13:32   oci_json_billing.log\r\n---------                     -------\r\n  8746422                     13 files\r\n[user@localhost ~]$<\/pre>\n<p>The <strong>billing_hist.zip<\/strong> file, as mentioned before, will be used to store the execution logs. So, in case you re-run the script with overlapping times, it won&#8217;t need to get the same information again from the Cloud using cUrl, bur rather from the zip.<\/p>\n<p>To get the data, you can simply unzip the file and process it.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[user@localhost ~]$ unzip oci_json_billing_20191010131412.zip oci_cloud_usageCost.json\r\nArchive:  oci_json_billing_20191010131412.zip\r\n  inflating: oci_cloud_usageCost.json\r\n\r\n[user@localhost ~]$ jq -r '.data[] | select(.\"serviceName\"==\"COMPUTEBAREMETAL\" and .\"resourceName\"==\"PIC_BLOCK_STORAGE_STANDARD\") | [.\"costs\"[].\"computedQuantity\",.\"costs\"[].\"computedAmount\",.\"costs\"[].\"unitPrice\",.\"costs\"[].\"overagesFlag\",.\"startTimeUtc\",.\"endTimeUtc\",.\"dataCenterId\"] | @csv' oci_cloud_usageCost.json\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T00:00:00.000\",\"2019-10-01T01:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T01:00:00.000\",\"2019-10-01T02:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T02:00:00.000\",\"2019-10-01T03:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T03:00:00.000\",\"2019-10-01T04:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T04:00:00.000\",\"2019-10-01T05:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T05:00:00.000\",\"2019-10-01T06:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T06:00:00.000\",\"2019-10-01T07:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T07:00:00.000\",\"2019-10-01T08:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T08:00:00.000\",\"2019-10-01T09:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T09:00:00.000\",\"2019-10-01T10:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T10:00:00.000\",\"2019-10-01T11:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T11:00:00.000\",\"2019-10-01T12:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T12:00:00.000\",\"2019-10-01T13:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T13:00:00.000\",\"2019-10-01T14:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T14:00:00.000\",\"2019-10-01T15:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T15:00:00.000\",\"2019-10-01T16:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T16:00:00.000\",\"2019-10-01T17:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T17:00:00.000\",\"2019-10-01T18:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T18:00:00.000\",\"2019-10-01T19:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T19:00:00.000\",\"2019-10-01T20:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T20:00:00.000\",\"2019-10-01T21:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T21:00:00.000\",\"2019-10-01T22:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T22:00:00.000\",\"2019-10-01T23:00:00.000\",\"us-phoenix-1\"\r\n155.48119623655913,15.4703790255,0.0995,\"N\",\"2019-10-01T23:00:00.000\",\"2019-10-02T00:00:00.000\",\"us-phoenix-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T00:00:00.000\",\"2019-10-01T01:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T01:00:00.000\",\"2019-10-01T02:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T02:00:00.000\",\"2019-10-01T03:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T03:00:00.000\",\"2019-10-01T04:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T04:00:00.000\",\"2019-10-01T05:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T05:00:00.000\",\"2019-10-01T06:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T06:00:00.000\",\"2019-10-01T07:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T07:00:00.000\",\"2019-10-01T08:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T08:00:00.000\",\"2019-10-01T09:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T09:00:00.000\",\"2019-10-01T10:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T10:00:00.000\",\"2019-10-01T11:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T11:00:00.000\",\"2019-10-01T12:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T12:00:00.000\",\"2019-10-01T13:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T13:00:00.000\",\"2019-10-01T14:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T14:00:00.000\",\"2019-10-01T15:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T15:00:00.000\",\"2019-10-01T16:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T16:00:00.000\",\"2019-10-01T17:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T17:00:00.000\",\"2019-10-01T18:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T18:00:00.000\",\"2019-10-01T19:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T19:00:00.000\",\"2019-10-01T20:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T20:00:00.000\",\"2019-10-01T21:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T21:00:00.000\",\"2019-10-01T22:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T22:00:00.000\",\"2019-10-01T23:00:00.000\",\"us-ashburn-1\"\r\n216.07666465053762,21.4996281327,0.0995,\"N\",\"2019-10-01T23:00:00.000\",\"2019-10-02T00:00:00.000\",\"us-ashburn-1\"<\/pre>\n<h3>What about the graphs?<\/h3>\n<p>To generate some graphs over the json data, you can convert and import the output to some tool like Microsoft Excel and create a chart or even to Google Charts. I will give more details about that in a later article.<\/p>\n<p>Hope you enjoyed. #ThanksOGB<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-4298 jlk' href='javascript:void(0)' data-task='like' data-post_id='4298' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-4298 lc'>+2<\/span><\/a><\/div><\/div> <div class='status-4298 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>As of today (October 2019), there is still no internal capability in Oracle Cloud Infrastructure to export the metadata of all the billing information you have in your OCI to a CSV, JSON or any other file that would allow us to easily import in other tools to create our own graphs. Meanwhile, I have &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/\">Continue lendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[],"class_list":["post-4298","post","type-post","status-publish","format-standard","hentry","category-oracle-cloud","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to export all your Oracle Cloud Infrastructure billing information - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"In this article it&#039;s described the steps needed to extract all the Oracle Cloud Infrastructure billing data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"How to export all your Oracle Cloud Infrastructure billing information\",\"datePublished\":\"2019-10-10T17:35:21+00:00\",\"dateModified\":\"2019-10-11T17:19:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/\"},\"wordCount\":922,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/img_5d9f571c453b4.png\",\"articleSection\":[\"Oracle Cloud\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/\",\"name\":\"How to export all your Oracle Cloud Infrastructure billing information - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/img_5d9f571c453b4.png\",\"datePublished\":\"2019-10-10T17:35:21+00:00\",\"dateModified\":\"2019-10-11T17:19:29+00:00\",\"description\":\"In this article it's described the steps needed to extract all the Oracle Cloud Infrastructure billing data.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/img_5d9f571c453b4.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/img_5d9f571c453b4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2019\\\/10\\\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to export all your Oracle Cloud Infrastructure billing information\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to export all your Oracle Cloud Infrastructure billing information - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"In this article it's described the steps needed to extract all the Oracle Cloud Infrastructure billing data.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/","twitter_misc":{"Escrito por":"DBA RJ","Est. tempo de leitura":"13 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"How to export all your Oracle Cloud Infrastructure billing information","datePublished":"2019-10-10T17:35:21+00:00","dateModified":"2019-10-11T17:19:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/"},"wordCount":922,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4.png","articleSection":["Oracle Cloud"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/","url":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/","name":"How to export all your Oracle Cloud Infrastructure billing information - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4.png","datePublished":"2019-10-10T17:35:21+00:00","dateModified":"2019-10-11T17:19:29+00:00","description":"In this article it's described the steps needed to extract all the Oracle Cloud Infrastructure billing data.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#primaryimage","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/10\/img_5d9f571c453b4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2019\/10\/how-to-export-all-your-oracle-cloud-infrastructure-billing-information\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/pt-br\/"},{"@type":"ListItem","position":2,"name":"How to export all your Oracle Cloud Infrastructure billing information"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website","url":"https:\/\/www.dbarj.com.br\/pt-br\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/4298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/comments?post=4298"}],"version-history":[{"count":1,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/4298\/revisions"}],"predecessor-version":[{"id":4306,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/4298\/revisions\/4306"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media?parent=4298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/categories?post=4298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/tags?post=4298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}