«

»

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 and the two new column are highlighted in a light blue color:)

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.py 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 inforamtion.

#####################################################################################
# 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.
————————————————————————————————————————————————————————-