fbpx

Knowledge Base

You are here:
Print

How to configure High-level PowerPoint & Excel Reports

Cloudockit’s high-level reports will help you to quickly view changes in your resources, resource categories, resource types, applications, warnings, and their costs. Follow the step-by-step guide below.

Choosing Your Subscriptions/Accounts/Projects

After login in on generate.cloudockit.com, you will have the option of choosing the subscriptions/accounts/projects you would like to document.

Cloudockit SaaS

With Cloudockit SaaS, you only have the option of documenting 1subscription/account/project at a time. Select the one you wish to document.

Cloudockit Desktop & Container

Select the subscriptions/accounts/projects you wish to document or select the check box All Subscriptions.

Please note that for Google Cloud billing data, only 1 project can be selected at a time

Setting-up in Cloudockit

DOCUMENTS TAB

From the Documents tab, select the PowerPoint/Excel checkbox.

In the corresponding detailed page, select the desired documents output. Excel and/or PowerPoint.

From the drop-down menu, select the desired period frequency for the display, either Weekly or Monthly.

Note: monthly frequency is currently not available for Cloudockit SaaS.

  • This will compute the resource changes from period to period.
  • This will automatically set the corresponding timeframe to get the overall billing information for your environement, as either the costs incured for the previous week (7 days, Monday to Sunday) or previous month (first to last day of the previous month).

WORKLOADS TAB

Select the resource types you wish to include in the scan.

  • If you only need the Dashborad documents to be generated, the Billing workload won’t be needed in this case, since it will be automatically set.
  • For Azure, this feature uses the Azure Cost Management API to get an overview information on costs, therefore the Standard/EA/CSP do not apply in this case.
  • For Google Cloud, the GCPBigQueryDataSet & GCPBigQueryTable of the corresponding selected project, so at this time you can select one project at a time.

ORGANIZE CONTENT TAB

If you wish to have information about your applications, select Tag under Organize resources by application, and enter the tag(s) that represent your application(s).

Cloudockit SaaS

To display all the selected subscription information in Cloudockit SaaS, select the checkbox of the subscriptions you want to scan under Add other subscriptions in the document.

Cloudockit Desktop & Container

To display all the selected subscription information in Cloudockit Desktop of Container, select the checkbox Generate a single document for all environments.

DROP-OFF TAB

Select your drop-off location while making sure to have a new folder as the drop-off for this configuration.

In the SaaS version, do not select Cloudockit Storage because snapshots used to compute the data changes cannot be stored in that folder.

SCHEDULING TAB

To have the most accurate results, save the current settings as a schedule, with a frequency that matches the one selected in the first step.

Note: monthly frequency is currently not available for Cloudockit SaaS.

For example :

  • If you selected Weekly, you can save the schedule to run on every Monday.
  • If you selected Monthly, you can save the schedule to run on the first day of every month.

By doing so, your resource changes, and their costs will always be at the same level, and the information displayed will always reflect their current state.

For more information on Scheduling please visit Schedule Documents & Diagrams Generation

IMPORTANT NOTES

It is important to keep the same settings (selected environments, workloads, filters, and drop-off folder) location selected to have accurate information displayed from period to period.

If you have different configurations, We recommend having a separate folder in your Drop-Off location for each set of configurations.

If at some point, the selected options are not as expected, the data/cost changes displayed may be inaccurate, and you will see a warnings table in the PowerPoint, describing the cause of inaccuracy.

Output

The generated document formats are Excel (.xlsx) and PowerPoint (.pptx)

Both documents contain charts and tables summarizing the selected environment’s evolution and significant changes for the selected period frequency. Charts are all customizable, by right-clicking on the chart and changing the chart type for example or to visualize the attached information in the form of a table. 

Table of Contents