Version 1.3.4.2 (22/11/2022)

HUMMDB-1108 No styling getting applied to installer
HUMMDB-1111 SQLPro database deploy script running constantly
HUMMDB-1110 DatabaseFileDetailsLatest.sql report script failing on dbcc information gathering when user has limited user rights

Version 1.3.4.1 (16/11/2022)

HUMMDB-1077 SQLPro installer utility tries to stop the ConductorSQLPro service even if the service does not exist
HUMMDB-1093 On Instance connection test failed, show the actual connection issue
HUMMDB-1094 MySQL and PostgreSQL instances are showing with "Windows Authentication" enabled
HUMMDB-1101 Business attributes can have duplicate names
HUMMDB-1102 Business attribute names cannot include system names
HUMMDB-1095 Rename business attributes in the import/export instances functionality
HUMMDB-1104 Add LDAP support for SQLPro login

Version 1.3.4.0 (14/11/2022)

HUMMDB-1027 Increase max business attributes to 20

Version 1.3.3.2 (07/11/2022)

HUMMDB-1084 Threshold for "Failed Live Alerts" not working correctly if the threshold is under 24 hours
HUMMDB-1083 Add Include Statement toggle on Activity Alert screen
HUMMDB-981 Add button to show column data in SQL Sense

Version 1.3.3.1 (25/10/2022)

HUMMDB-1069 Change instance selection control to a table in group edit screen
HUMMDB-1064 In table results screen make horizontal scrollbar always visible
HUMMDB-1047 The "Required" attribute of the business attributes is not enforced in bulk importing instances
HUMMDB-1046 The "Required" attribute of the business attributes is not enforced in individual instance capture
HUMMDB-1059 Add excludes functionality to Server Activity screen
HUMMDB-767 Add excludes functionality to Server Activity backend
HUMMDB-1065 Add NumberOfUndeliveredCommands, NumberOfDeliveredCommands and ErrorMessage to Replication Issues live alert
HUMMDB-1075 Change Exclusion Clause to multiline on Edit Live Alert Exclusion screen

Version 1.3.3.0 (14/10/2022)

HUMMDB-1062 Add ability to delete Server Activity Alerts
HUMMDB-1058 Missing back button on the Server Activity Alerts screen
HUMMDB-910 Allow editing of Event notification refresh schedule and email schedule times
HUMMDB-1042 Delete old Server Activity Audit History
HUMMDB-1056 Block swagger when SQLPro is run in production
HUMMDB-1055 Cannot return to live alert report screen from editor screen using the menu
HUMMDB-1053 Change business attribute screen to use edit dialog
HUMMDB-1045 Allow user to add or remove groups in edit instance screen
HUMMDB-1012 Include Instance Groups column in Instances list screen
HUMMDB-1052 Live alert screen showing scrollbar in list of live alerts screen
HUMMDB-1044 Email schedule for user queries stays in hangfire schedules even when schedule deleted
HUMMDB-1040 User should not be able to edit the permissions of their own role
HUMMDB-1039 User should not be able to edit or delete a role where user does not have all permissions in role
HUMMDB-1038 On log out and re-login in menu items are not always reset to new users permissions
HUMMDB-1037 Change "SQLPro Backup & Maintenance Report" email subject to "SQLPro Backup & Maintenance Report With Failures" when failure occurs
HUMMDB-1036 On logging in old username and role still shows in top bar
HUMMDB-1026 Empty url needs to redirect to landing page
HUMMDB-1025 Landing page logos dashboard images shared with menu logo images

Version 1.3.2.0 (30/09/2022)

HUMMDB-982 Replace Admin shell with more user-friendly alternative
HUMMDB-1013 Audit alerts logic uses SPLIT_STRING statement which isn't supported in SQL Server 2012
HUMMDB-1010 Remove "TRUSTWORTHY ON" property in for SQLPro database when enabling event notifications
HUMMDB-1008 Cannot differentiate between groups and instances in the Query Editor screen
HUMMDB-1004 Move Global Settings from appsettings.json to database
Split Instance "Bulk Operations" into "Bulk Operations" and "Import/Export" on instance screen
HUMMDB-1007 Update SQLPro audit report latest SP and CUs
HUMMDB-997 Allow user to capture groups when bulk importing instances
HUMMDB-1006 Add instance groups to CSV instance export
HUMMDB-999 Add ability to bulk enable or disable Server Activity Audit
HUMMDB-998 Need to be able to bulk delete instances
HUMMDB-1005 Cannot import same csv file of instances twice in a row
HUMMDB-987 Show number of updated instances when bulk importing instances

Version 1.3.1.1 (16/09/2022)

HUMMDB-1003 User query send schedule and email schedule use the same schedule regardless of configuration
HUMMDB-1002 Upgrade C# Nuget packages to improve backend security
HUMMDB-1001 Mail enabled flag remains false even though all mail settings are configured correctly
HUMMDB-995 Add hamburger button to hide side panel
HUMMDB-991 Live Alert history trends graph not visible in dark theme
HUMMDB-993 SQLSense dialog boxes showing unneeded scroll bars
HUMMDB-992 Dropdown lists in dialogs are getting cut off on some screens
HUMMDB-994 Trim all fields before importing csv file for instance list
HUMMDB-996 Super Admin Role should only be visible to Super Admin users
HUMMDB-989 When adding users only roles that are available to current user should be visible in the selection list
HUMMDB-990 Cannot see typed text in pill control when using dark theme
HUMMDB-984 Import csv should check for duplicate server names in import file
HUMMDB-983 "Testing Connection" or Saving new Instance doesn't have validation on all fields
HUMMDB-988 Agent offline not detected for SQL Server Web edition
HUMMDB-986 Cannot edit instance when client has corrupt Password field in dbo.Clients table
HUMMDB-985 SQLPro service fails to start up if invalid data in Password column in dbo.Clients Table
HUMMDB-975 Tweak lead blocker script to show the actual SPIDs that are getting blocked

Version 1.3.1.0 (16/08/2022)

HUMMDB-977 Allow SQLPro central to run on SQLServer 2012
HUMMDB-971 Allow editing of Reporting section schedule times
HUMMDB-973 A bad exclusion (invalid SQL syntax) for a Live alert results in 500 error for entire dashboard
HUMMDB-974 Trying to leave Live Alert Dashboard screen if auto-refresh is off results in error
HUMMDB-972 Report: SQL Server Database Files Latest - fails if auditing is enabled and SQLPro backups are not
HUMMDB-817 Old live alert history entries need to be removed after retention period is exceeded
HUMMDB-968 Backups failing after manual backup/restore performed to Azure blob storage via SSMS
HUMMDB-969 Setting Azure Blob Credentials to blank is not using global azure blob credentials
HUMMDB-967 IDValuePair Endpoint not secured
HUMMDB-966 Getting 500 error when trying to view/edit mail configuration
HUMMDB-919 Add error message if trying to run ad-hoc backup/maintenance and no databases configured
HUMMDB-960 Add MySQL Long Running Query system live alert
HUMMDB-964 Make Live Failed Jobs alert monitoring threshold configurable
HUMMDB-961 Add PostgreSQL Long Running Query system live alert
HUMMDB-959 Can no longer delete custom live alerts

Version 1.3.0.0 (21/07/2022)

HUMMDB-952 Cannot add more than one live alert exception at once
HUMMDB-938 Allow Live alerts module to work for all supported Instance Types
HUMMDB-951 Not all failed backup attempts are getting logged in SQLPro Database Audit tables
HUMMDB-846 Update SQLPro audit report latest SP and CUs

Version 1.2.9.0 (17/07/2022)

HUMMDB-922 SQLPro service fails to close if there is an outstanding query
HUMMDB-814 Make live alert schedules configurable
HUMMDB-926 Make Live alert dashboard auto refresh configurable
HUMMDB-927 Add "Remember Me" option in login
HUMMDB-925 Create live alert summary report
HUMMDB-924 Make SQLPro installer console logging more readable
HUMMDB-923 Can no longer update Conductor4SQL classic license in hub
HUMMDB-920 Can save invalid email addresses in SQLPro email editor
HUMMDB-914 Admin Role cannot make new roles
HUMMDB-921 Email lists should have at least one email address assigned to them else saving the list should not be possible
HUMMDB-915 Change name in installer and install path to ConductorSQLPro
HUMMDB-917 SQLPro fails to start if Always On is enabled for it's database
HUMMDB-918 Database detail and security report does not cater for Always On databases

Version 1.2.8.0 (30/06/2022)

HUMMDB-913 Mailer fails to start if no config setup
HUMMDB-909 Change SQLPro service name to ConductorSQLPro as it's easy to confuse it with the current Conductor4SQL classic service
HUMMDB-911 Hide "Login With Azure AD" button if Azure AD not setup
HUMMDB-908 SQLPro looses license if hub not accessible
HUMMDB-901 Allow manual license installs in SQLPro
HUMMDB-904 Cannot log into SQLPro if there is no license file
HUMMDB-900 When using Windows service account login during SQLPro install service fails to start

Version 1.2.7.0 (23/06/2022)

Fixed: Refreshing screen on landing page looses permissions
Epic HUMMDB-891 Add Azure AD authentication support to SQLPro

Version 1.2.6.0 (15/06/2022)

HUMMDB-890 Job details report script returning duplicate Job IDs
HUMMDB-887 If database name is repeated with a different case we end up with duplicates in configuration screen
HUMMDB-889 Failure to back up to Azure blob storage is getting logged by SQLPro monitoring as an "Out of Window" error

Version 1.2.5.0 (08/06/2022)

HUMMDB-883 Show installation progress when installing SQLPro service
Fixed: No styling for Conductor4SQL Setup web app
HUMMDB-882 SQLPro not running after using the setup utility
HUMMDB-881 Replace SQLPro installer with web installer
HUMMDB-878 Outstanding count for Queries modules always returning zero

Version 1.2.4.0 (30/05/2022)

HUMMDB-876 Cannot edit live alerts on fresh application install
HUMMDB-644 Allow SQLPro to run in an Azure AppService
HUMMDB-875 Create view scripts failing when creating a new central database for SQLPro
HUMMDB-828 Allow adhoc backups, maintenance, index rebuilds
HUMMDB-827 Add azure credentials to a database level for backups
HUMMDB-748 SQLPro views are not encrypted
HUMMDB-872 Move to the latest CU/SP information out of query logic

Version 1.2.3.0 (18/05/2022)

HUMMDB-870 Can no longer create custom live alerts
HUMMDB-864 No confirmation message when trying to delete custom live alerts
HUMMDB-865 Fix build warnings in code base
HUMMDB-863 The logo on login screen still points to www.hummdb.com rather than www.conductor4sql.com
HUMMDB-857 Upgrade SQLPro backend to .net 6
HUMMDB-862 Refactor: Move App.config into appsettings.json
HUMMDB-861 Cleanup "No Comms" history logic
HUMMDB-860 History for "No Comms" not working when live alerts executed through scheduler

Version 1.2.2.0 (10/05/2022)

HUMMDB-855 "No Comms" and "No Server Activity Auditing in 24 Hours" have no history
HUMMDB-851 Apply the latest angular/npm security patches

Version 1.2.1.9 (06/05/2022)

HUMMDB-823 Create live alert history screens
HUMMDB-830 Update SQLPro audit report latest SP and CUs

Version 1.2.1.8 (03/05/2022)

HUMMDB-843 Cleanup entity framework includes between linking tables
HUMMDB-839 Add thresholds editor to Live Alert edit screen

Version 1.2.1.7 (21/04/2022)

HUMMDB-840 Get an error if we try to generate sql migrations for SQLPro database
HUMMDB-809 Allow user to edit thresholds for live alert queries
HUMMDB-836 Health Dashboard "SQLPro enabled" filter not working
HUMMDB-835 Add return to live alert screen from the edit screen
HUMMDB-820 Instance add/edit screen and instance import template has column name discrepancies
HUMMDB-821 Move Health dashboard edit screen to health dashboard

Version 1.2.1.6 (07/04/2022)

HUMMDB-822 Saved Queries editor isn't always showing the right query
HUMMDB-832 Build failing on build lab due to formatting fixes
HUMMDB-829 Add Live alert exclusions config to live alerts edit dialog in UI
HUMMDB-825 Simplify live alert edit screen
HUMMDB-819 Update SQLPro audit report latest SP and CUs
HUMMDB-804 Add from and to filters to the Server Activity Audit report

Version 1.2.1.5 (31/03/2022)

HUMMDB-806 Add exclusions/ignores to live alerts backend
HUMMDB-813 Long running query alert showing incorrect run time
HUMMDB-812 Import database backups and restores in event notifications
HUMMDB-808 Increase long-running query threshold to 2 minutes
HUMMDB-805 Old live alerts don't clear from the live alert screen

Version 1.2.1.4 (18/03/2022)

HUMMDB-802 Email lists for mailer getting cached
HUMMDB-795 Table styling not working on audit/sql-environment-audit
HUMMDB-800 Browsers offering to save the username and password for mail server setup
HUMMDB-799 Browsers offering to save the username and password for instances
HUMMDB-798 Windows service failing on startup
HUMMDB-793 Add Description and Terms and Conditions fields to SKUCategory
HUMMDB-792 Add export to XLSX functionality to Audit history screen
HUMMDB-794 Table global filter kept but value not shown when changing screens

Version 1.2.1.3 (03/03/2022)

HUMMDB-790 Fix database relationship between SkuItem and SkuCategory
HUMMDB-789 SQL Sense not bringing back explicit select permissions for windows logins
HUMMDB-785 Health - SQL Server Job Details Script needs to be optimised

Version 1.2.1.2 (17/02/2022)

HUMMDB-769 SKU database sizes are hardcoded in SQLPro
HUMMDB-780 Change SQLPro to use new hub (hub.conductor4sql.com)
HUMMDB-774 Add auto restart to SQLPro service failure
HUMMDB-766 Allow public view of the sku items and database size legend
HUMMDB-765 Add full screen code editor button toggle

Version 1.2.1.1 (03/02/2022)

HUMMDB-760 Multiple alert like filters not working correctly
HUMMDB-759 Add "Not Like" Filters for Event Notification alerts
HUMMDB-737 Add audit email alerts
HUMMDB-753 500 Error when editing Billing configuration on SQLPro Hub
HUMMDB-754 Cannot see the full stacktrace of unhandled errors in the hub
HUMMDB-738 Add screen for viewing the "Server Activity Audit" information
HUMMDB-752 Angular build errors when regenerating the front end services
HUMMDB-750 Implement Husky to force code-formatting before committing
HUMMDB-751 Upgrade prettier to v2.5.1
HUMMDB-747 Bulk import instances giving 500 error
HUMMDB-749 Database list not populating if "Server Activity Audit" is enabled
HUMMDB-742 Enable session_state in select tables
HUMMDB-746 Enabling "Server Activity Audit" should not be allowed if the Audit module is disabled
HUMMDB-745 SQLSense fails with exception on first load of screen in clean database
HUMMDB-744 Error "RunDuration" missing when creating Reporting.vwHummdbDatabaseBackupHistory view

Version 1.2.1.0 (28/01/2022)

HUMMDB-736 Add live alert "No Server Activity Auditing in 24 Hours"
HUMMDB-740 Script GetHummdbServerConfigurationDifferences returning information from deactivated instances
HUMMDB-739 Test event notifications in uat
HUMMDB-721 Improve styling of Conductor4SQL POV checklist
HUMMDB-735 Rename "Event Notifications" to "Server Activity Audit"

Version 1.2.0.9 (27/01/2022)

HUMMDB-724 Add event notifications support for MsSQL in SQLPro
HUMMDB-719 Allow users to add additional email lists from the saved user query screen
HUMMDB-720 Delta to Json MySQL and PostgreSQL test scripts
HUMMDB-714 Add ability to add new schedules from saved queries
HUMMDB-715 Create new POV checklist on Conductor4SQL Hub

Version 1.2.0.8 (15/01/2022)

HUMMDB-718 Simplify SQLPro webservice hosting logic
HUMMDB-716 Refactor current dynamic form logic on hub
HUMMDB-712 Update SQLPro to Angular 13
HUMMDB-708 Upgrade SQLPro hub to angular 13
HUMMDB-711 Add PerHour option in SQLPro SKUs
HUMMDB-704 Adjust look and feel of table on /internal/live-alerts
HUMMDB-706 Show name of user that has logged into the SQLPro hub
HUMMDB-705 Add logout menu item to the SQLPro hub
HUMMDB-707 Add production hub database to source control for local development testing
HUMMDB-702 Add Conductor4SQL logo to SQLPro hub internal pages
HUMMDB-97 Store DBCC table results errors
HUMMDB-586 Database reindexing/reorganising should not occur if dbcc checkdb fails
HUMMDB-703 Add SQLPro theme colors to SQLPro hub
HUMMDB-701 Cannot add more than one additional license type on the hub