«

»

Nutanix Era Reporting Script – Databases

One thing that i usually discuss with organisations that are either implementing, evaluating or already running Nutanix Era is how they can do reporting. This is a pretty wide topic and can include multiple aspects and the type of report required varies based on what the report purpose is e.g:

  • Capacity Management
  • Chargeback
  • Showback

Based on this i have put together a python based reporting script you can use to extract some inforamtion from your Era environment. The script can, based on your configuration, include all of the below metrics

  • Database/Instance name
  • Database(s)
  • Type
  • Database Version
  • Database Profile
  • Size GB
  • Database Owner
  • Database/Instance Create Date / Time
  • Number of clones
  • Time Machine Name
  • Time Machine Size GB
  • Time Machine SLA (Name-/-Nutanix Cluster)
  • Server VM(s) Name
  • Server VM(s) IP
  • Nutanix Cluster Placement
  • Software Profile
  • Compute Profile
  • Network Profile
  • Database Tags (Name-/-Value)
  • Time Machine Tags (Name-/-Value)
  • Database Server VM Tags (Name-/-Value)

Sample output from the script after some excel magic….

To start generating your own reports you download the script from My GitHub Repository or get the file from GitHub without browsing via this era-reporting-db link.

Thenย you need to make changes in the below section and the four (era_report_user_local_dir, era_ip, era_user and era_password) variables you have to change to make the script work.

The four Y or N config options (include_time_machine, include_dbvms,ย  include_profiles and include_tags) basically defines what is included in the report. Just change the Y for a N if you want to exclude the information.

#####################################################################################
# Consumer config section. Define the following values
#
#
era_report_user_local_dir = "_Report_Folder_Destination_Ending_With_A_Slash/"
era_ip = "_Era_Server_FQDN/IP"
era_user = "_Era_user"
era_password = "_Era_password"
#
#
# Select what to include in the report. Change Y for N if you wish to exclude a section
include_time_machine = "Y"
include_dbvms = "Y"
include_profiles = "Y"
include_tags = "Y"
#
# End of consumer section section
#
#####################################################################################

Description of what is included per config option:
  • include_time_machine includes the following information:
    • Time Machine Name
    • Time Machine Size GB
    • Time Machine SLA (Name-/-Nutanix Cluster)
  • include_dbvms includes the following information:
    • Server VM(s) Name
    • Server VM(s) IP
    • Nutanix Cluster Placement
  • include_profiles includes the following information:
    • Software Profile
    • Compute Profile
    • Network Profile
  • include_tags includes the following information:
    • Database Tags (Name-/-Value)
    • Time Machine Tags (Name-/-Value)
    • Database Server VM Tags (Name-/-Value)

The script has been tested with Nutanix Era 2.1 running from a MacBook (Catalina 10.15.7) with python 3.9. You might experience a slight difference in the script output when running from e.g. some Linux distributions.

Feel free to provide feedback for improvements if you have any suggestions.

Updated 2021-08-12: Era Reporting Script – Clones blog post and script available.
————————————————————————————————————————————————————————-