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