«

»

Nutanix NDB Reporting Script Databases Version 1.1

Just a quick note to let you know that i have updated the NDB, formerly known as Era, DB Reporting script with one new column, Database/Instance Status, which will be reported as the following:

Information about the reporting script can be found in the original blog post which is available here. In short it let’s you create a report including the following inforamtion:

  • Database/Instance name
  • Database(s)
  • Type
  • Database Version
  • Database Profile
  • Size GB
  • Database Owner
  • Database/Instance Status
  • 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)

To start generating your own reports you download the script from My GitHub Repository or get the file from GitHub without browsing, just click 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.3 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.
————————————————————————————————————————————————————————-