Experda Master

Version 3.0.0.3 - Aug 19, 2025

Coming soon

• Implementing new modules
• AI insights
• Implementing dynamic table feature to more modules

Feature(s)

• Added actions in database overview module
  Create database
  Restore database
  Database backup
  Index optimization
  Update database statistics
  Database integrity check
  Shrink Database
• 🙌 Integrate a feature to render table dynamically with having features
  Show/hide columns
  Re-ordering columns
  Sticky headers
  Resize columns
• 🙌 Integrate a feature of dynamic table in
  Performance
  Waits
  Services
  Processes
  Databases
• Added a features in express jobs to persist expanded state and selected nodes even after navigating to other modules/pages and coming back.
• Integrated a feature to persist list filters and sorting on navigating to other modules/pages and coming back.
• Express jobs
• 🙌 Added support for performing actions on multiple jobs at the server level.
• 🙌 Added a support to handle database name having special characters.
• Added a feature to whitelist Agent IPs while creating a new company and allow editing of whitelisted IPs from company settings page.
• 🙌 Added a Feature to show database level alerts as grouped with nested table in expanded alerts history sidebar
• Added more filters in healthcheck module for property and status.
• Added filters for backups in database overview page.

IMPROVEMENT(s)

• 🙌 Improved to automatically select and expand upto instance location in express jobs
• Improved to have timezones selection in signup process
• Improved to show timezones based on selected country
• Improved to take installer URLs dynamically
• Improved to have free disk percentage in the Server overview > Disks and Performance > Disks
• 🙌 Improved the TreeView performance for servers containing a large number of databases (over 1000)
• Improved to hide 'transaction log' option from immediate action from backup wizard for recovery model SIMPLE
• 🙌 Improved the colors all over the sysmte according to the colors in figma for charts, progress bar, etc...
• Improved the tree-menu to have separate actions for adding or moving the server to a group.
• Improved to Hide 'Export PDF' buttons in security for onPrem
• 🙌 Improved to handle havingation for multi-language database names
• Improved to navigate to the "companies overview" page on clicking "X" icon in left sidebar.
• Improved to have an option to cancel watch task loader, which will cancel task polling and close the loader.
• Improved to change the title from sessions to 'Activity history'.
• Improved to add background color for groups of rows by sample time in Activity history module.
• Improved to hold a scroll position on enable/dsiable action in alerts and maintenance settings
• Improved to disable template selection dropdown at database level in alerts settings
• Improved to have a button to filter by "Experda category" in regular jobs
• Improved to show allocated memory and dynamic tooltip based on conditions

Fix(es)

• Fixed small issue for showing include/exclude list in alert settings list
• Fixed to remove duplicates from add/remove affiliated machine modal in settings.
• 🙌 Fixed bugs and stabilize maintenance settings module.
• Fixed auto login issue on signup page
• Fixed issue when setting up database connection first and then machine connection in add server flow
• Fixed to show global settings in onPrem version
• Fixed to hide select all checkbox from unwanted places
• Fixed to show correct server counts with template name after add/remove action in affiliated servers

Version 3.0.0.0 - Apr 17, 2025

Coming soon

• Implementing new modules
• AI insights
• Implementing a feature to render table dynamically with having features
  Show/hide columns
  Re-ordering columns
  Sticky headers
  Resize columns

Feature(s)

• Integrate app walkthrough feature in
  Companies overview
  Create company
  Add server flow
  Alerts settings
• Integrated a feature to persist list filters and sorting on navigating to other modules/pages and coming back.
• Always On
• Integrated feature modules
• Maintenance
• 🙌 Actions over database(Tree)
  Create database
  Restore database
  Database backup
  Index optimization
  Update database statistics
  Database integrity check
  Shrink Database
• 🙌 Implemented a new tree and list view for express server jobs
• 🙌 Added a new module for support/tutorial video and integrate it into all the relative pages
• Integrate a new module for sessions on server level
• Integrate a new module to add "Missing queries index" table
• Integrate Server global settings module
• 🙌 Integrate a feature module for "Notifications"
• 🙌 Integrate a feature to allow editing the existing servers
• Integrate a scheduler module
• Added new actions for jobs at company level and server level
• 🙌 Integrate export PDF and Excel in security healthcheck and suspicious activity modules, also added a support to export multiple excel files.
• Integrate a feature to have "Load more" tasks/processes in task manager(Processes), a floating modal
• Added user profile in a way that it is accessibly from whole application.

IMPROVEMENT(s)

• Improved to disable timeframe control in overview and settings pages
• Improved to add more columns in Performance > Queries
• Improved to add new tab for "Dismissed" in alerts history.
• Improved server related information in server overview headbar, and keep it open by default.
• Improved to show affiliated servers counts in alerts settings, global settings and maintenance settings.
• Improved to remove Indexes & Tables counts, and add CPU usage & IO avg. usage in database overview.
• Improved add server flow to add manual server with "Port no" attached to the server name.
• Improved to add terms and policy as mandatory checkboxes into the signup flow.
• Improved tree-menu control to show HTML tooltip instead of ngbtooltip
• Improved alerts settings to select by default SQL template and SQL tab in custom view.
• Improved to add active/inactive agent service action in agent settings.
• Improved to adjust task manager(Processes) module as needed for immediate actions.
• Improved to show 'offlineSQLServices' in companies overview.
• Improved timezones to match with country and added more, also added search feature in topbar dropdown.
• Improved to show "Suspicious activity module has stopped..." message on dynamic records count.
• Improved to select newly created template in performance, alerts, maintenance, and healthcheck settings.
• Improved to have new password indicators.
• Improved to have more agent login actions for Edit alias and Reset password.
• Improved to remove text messages area in respective settings.
• Improved pre defined filter of 'Security score over time' chart in healthcheck to get data for last 6 months.

Fix(es)

• Fixed issue with refreshing data after few actions of member in members and permission settings.
• 🙌 Fixed issue with big titles on X-Axis in chart, for now available in performance > blocking.
• Fixed to show blocks as full numbers only in performance > blocking.
• Fixed directories Pie-Chart UI issue in capacity planning.
• Fixed tabs' bottom border issue in all settings pages with tabs.
• Fixed servers count in company overview information block.
• Fixed css issue with big company name on topbar and card.
• Fixed issue while adding new group(s) to contact and adding new contact(s) to group replacing existing ones with multiselect action in contacts settings.
• 🙌 Fixed all UI/UX issues for mobile/devices.
• 🙌 Fixed issue with INT control in edit alert setting.
• Fixed chart when there is no data.
• Fixed hierarchy API payload in few pages.
• 🙌 Fixed deadlock issue with no owner-list.
• Fixed download agent link.
• Fixed issue with user session after creating a first new company.
• 🙌 Fixed sidebar alerts history action menu displacement.
• Fixed refreshing to see new invitation in members and permission.
• Fixed date filter clearing issue in expanded alerts history.
• 🙌 Fixed issue with chart showing yAxis values with decimal points.
• Fixed to have validation for "Create template" in all respective modules in settings.
• Fixed row-count issue in blacklist in suspicious activity settings.

Version 2.0 - Aug 18, 2024

Coming soon

• Implementing new modules
  • Maintenance
  • Backups
  • Actions over database
• Implementing a feature to show formatted datetime on UI according to the browser's language and environment. User can select own customize datetime format as available in topbar dropdown, which will be considered as user's selected datetime format.
• Implementing a feature to persist list filters and sorting on navigating to other modules/pages and coming back.
  • Always On

Feature(s)

• 🙌 Integrated a feature to show walktrough
• 🙌 Integrated a feature for module-wise license and permissions.
• 🙌 Integrated a feature to persist list filters and sorting on navigating to other modules/pages and coming back.
  • Blocking
  • Processes
  • Suspicious activity
  • Databases
  Database level
  • Schema > Tables
  • Schema > Indexes
  • Session
• Integrated a feature to register & license onPrem company. And show it in a list of comapnies with different appearance to manage.
• Added tooltips all over the application where required.

IMPROVEMENT(s)

• 🙌 Improved automatic adjustment of timeframe based on module and context.
• Improved blocking and deadlock for hiding loader after data is processed.
• Improved pagination when have zero results.
• Improved all APIs related to capacity-planning affected due to license, and improved the service structure for the same module.

Fix(es)

• Fix no-timezone issue for the user for new company and user invited to the new company.
• Fixed network mini chart when have more than one card.
• Fixed toggle check position on error in active/inactive action in manage servers under settings.
• Fixed interval secs numeric textbox value update issue in performance settings.

Version 1.7 - Jul 08, 2024

Coming soon

• Implementing a feature to show formatted datetime on UI according to the browser's language and environment. User can select own customize datetime format as available in topbar dropdown, which will be considered as user's selected datetime format.
• Implementing Module wise permissions based on plan and license.
• Implementing a feature to persist list filters and sorting on navigating to other modules/pages and coming back.
  • Blocking
  • Processes
  • Suspicious activity
  • Databases

Feature(s)

• Added global search and sorting for healthcheck list under server security.
• Added enabled/disabled job column, sorting, and filtering on company and server level.
• 🙌 Integrated a feature to persist list filters and sorting on navigating to other modules/pages and coming back
  • Server > Jobs
  • Waits
  • Services
• Added a feature to switch to the last user-selected intervals in timeframe automatically.
• 🙌 Integrated required field validation in edit alerts.

IMPROVEMENT(s)

• 🙌 Improved last duration column to show human readable duration in jobs and jobs history.
• Improved message for manually adding duplicate server in add-server process.
• Improved by adding tooltip in database progressbar chart for logsize growth.
• Improve queries table sort order to DESC by default with respective columns.
• Remove 'Activation status' from database overview.
• Improved by showing toaster on changing the timeframe automatically.
• Improved loader closing after processing response in deadlock and blocking

Fix(es)

• Fixed database overview storage progressbar chart having issue when moving between servers.
• 🙌 Fixed router events subscriptions by unsubscribing. Issue was having stack of subscriptions on revisit.
• Fixed duplicate API calls for overview pages in certain condition.
• Fixed filter button hidden in small screen.
• Fixed database filter for server tree.
• Fixed edit-server process should take is_Impersonate: false for connection type as SQL.
• Fixed 'Choose databases and finish' button in manage databases process when clicked directly without altering databases.
• Fixed area charts legends issue not changing when moving between servers, specially in all different waits charts.
• Fixed timeframe to take correct timeframe for capacity planning in history mode.
• 🙌 Fixed add/edit connection modal
  • overflow in body in add/edit server process
  • all fields are now enabled, even if user selects default mode
  • save button to be disabled while performing any action
  • cancle button to break the loop for getting open task progress
  • disable edit while some action is in process
• Fixed partitions progressbar issue in server capacity planning.
• Fixed range-datepicker to be disabled for non custom timeframes.
• Fixed edit alerts to handle null/empty values for INT type control.
• Fixed pagination in databases on apply and clear filters.
• Fixed database backups history to be displayed as MB or GB in database overview.
• Fixed UI bug in server tree when have no data.
• Fixed jobs history showing wrong datetime according to timezone on company levlel.
• Fixed 'Status' and 'Last run status' multiselect filter having dulicate options on revisit for multiple times.

Version 1.6 - Jun 09, 2024

Coming soon

• Implementing a feature to show formatted datetime on UI according to the browser's language and environment. User can select own customize datetime format as available in topbar dropdown, which will be considered as user's selected datetime format.
• Implementing Module wise permissions based on plan and license.

Feature(s)

• 🙌 Added a feature to support "Timezone" throuout the application.
  • All the dates throuout the application will show datetime according to selected timezone.
  • Instant data refresh when user changes the timezone.
  • Maintain user wise timezone.
  • Maintain company wise timezone.
  • Maintain server wise timezone.
• Integrated improved APIs on suspicious activity setting for list and actions.
• Integrated improved APIs on suspicious activity list and actions under security module.
• 🙌 Integrated a feature to persist list filters and sorting on navigating to other modules/pages and coming back.
  • Companies overview
  • Company overview
  • Company > Jobs
  • Queries list on CPU, Memory and Disks
  • Queries
  • Priority queries
• 🙌 Added a feature to show if filters are applied, in all the list all over the system.
• 🙌 Integrated a feature for multi browser tabs session. Maintaining login, logout, switching company, moving to companies, etc... sessions.
• Added server and database filters in alerts history expanded modal.
• Integrated Agent Settings
  • Agent logins - list of agent logins and can download agent
  • Agent services - can change repository server
• Integrated Manage servers(Server permission) module under settings. Plan details.
• 🙌 Added a feature to support button in toaster.
• Added a support for "Self Compare Chart" feature for CPU and Memory usage chart in small screens.
• 🙌 Integrated splitter(user can resize the pane) on
  • Performance settings
  • Alerts settings
  • Suspicious activity settings
• 🙌 Integrated dynamic grouping selection in Capacity Planning charts on server and database level.
• Integrated Agent services status and tooltip on companies dashboard.

IMPROVEMENT(s)

• Improved start and end datetime in request to send in UTC.
• Improved Always On accordion design.
• Improved blocking chart by aggregating to top 20 results by "run duration" and a note for the same.
• Improved some inner page to get effect of timezone change like queries details, alerts history sidebar.
• Improved notes color, now will be in blue.
• Improved to do not show 'Show alert lines' filter from charts except CPU and Memory.
• Improved by adding filters for Suspicious activity under settings.
• Improved Always On module to disable "No_Databases" records accordion, change the accordion arrow icon and show a tooltip for the same.
• Improved alerts history modal to open in Active alert tab, get distinct categories using new API, and send server name in action APIs.
• Improved Always On to get AO group details use Group_ID in API.
• Improved blocking and deadlock list datetime colums to show timezone wise dates as response(XML string) is always coming with UTC.
• Improved Always On module to have null as filter option for Failover mode and Health status.
• Improved suspicious activity settings by adding refresh button.
• Improved server permission in settings with loader while active/inactive the server.
• Improved title and removed Failover mode detail at AG level in Always On.
• 🙌 Improved chart component to support special/customized format on X-Axis.
  • Implemented in suspicious activity over time chart in security
• Improved Security score over time in healthcheck and Suspicious activity over time in suspicious activity charts to have start time and end time information in sub title in chart header.
• 🙌 Improved Performance and Healthcheck settings, do not allow to remove servers which are already added.
• Improved to show primary server always at the first position on "Database list" in Always On.
• 🙌 Improved invitated user singup flow if user is reloading or clicking again from the invitation email.
• Improved charts zoomin & zoomout by reset zoom when date or aggregation changes(deprecated).
• Improved company > jobs last run status and job status fileters with having null option to clear individual filter.
• Improved by adding close button on sidebar alerts modal.
• Improved edit databases flow by adding loader upto end and requesting update to only databases which are altered.

Fix(es)

• Fixed Blocking by query chart showing even stacks with value 0.
• 🙌 Fixed client wise token to be attached to the header in request.
• Fixed processes with wrong paging which always gets 10 results.
• Fixed add-server modal CSS leakage problem over other pages.
• Fixed capacity planning chart datetime for vertical line as per timezone improvement.
• Fixed blocking to show "View query" and "View XML" buttons at parent level and "View query" only at the child level.
• Fixed "tempdb summary" and "tablecounts" charts when having non-linear data.
• Fixed capacity-planning charts when having negative value in projected data.
• Fixed job history dates not changing accordingly timezone at company and server level.
• 🙌 Fixed chart loosing grouping & aggregation on auto refresh, manual refresh, refresh toggle(play/pause).
• Fixed a issue of custom date(when timeframe selection is custom) starting and ending being same on route change.
• Fixed alerts settings scroll issue, due to new splitter feature.
• 🙌 Fixed issues in timeframe for mobile mode, disable few timeframes based on route (currently in capacity-planning "Last 10 min", "Last 1 hour", "Last 8 hours" like options are disabled).
• Fixed CSS leackage from dashboard filters.
• Fixed CSS to show Fix css to show header icons(refresh, alerts history) in mobile mode.
• Fixed query table filtering & sorting on CPU, Memory and Disks.
• 🙌 Fixed default aggregation on compare charts based on timeframe selected.
• 🙌 Fixed issue with special token appended to URL as query params.
• Fixed issue with Waits progressbar like chart and its tooltip in server overview.
• Fixed data and log files collapsible in capacity planning on database levlel.
• Fixed chart options titles from filters to 'Grouping' & 'Aggregation'.
• Fixed alert history action process by sending full server name from alert history details.
• Hide kill sessions button and kill session action menu in sessions.
• Fixed CSS glich disturbig chart blocks in capacity planning on both the level.
• Fixed members and permission group list by refreshing list on changing the permission.
• Fixed "change repository server" process & API calls.
• Fixed pagesize value issue in pager.

Version 1.5 - Mar 24, 2024

Coming soon

• Implementing a feature to persist list filters on navigating to other components and coming back. (Need to re-write all filters on companies overview).
  • Applying to the companies overview list
  • Applying to the company overview list
  • Applying to the queries list
  • Applying to the priority queries list
• Implementing a feature to show if filters are applied in all the list all over the system.
• Implementing multi browser tabs session. Maintaining login, logout, switching company, moving to companies, etc... sessions.
• Implementing to show all agents status for each company on companies overview.(deprecated for now)

Feature(s)

• 🙌 Added feature to support deadlock diagram with two different types of locks.
• Integrated manage databases module on "Add Server" and independent.
• 🙌 Added XML viewer for deadlock XML.
• 🙌 Added XML viewer for blocking XML.

IMPROVEMENT(s)

• Improved by moving ellipse effect class from td to span in AO to avoid td style glich.
• Improved add/edit server Multi-Edit connection flow popup style.
• 🙌 Improved queries chart color, radius and width as per the figma.
• Improved sql query viewer by changing plugin config options.

Fix(es)

• Fixed by refreshing tree after removing server.
• Fixed alerts setting list overflow problem when having lot of data for each severiry.

Version 1.4 - Mar 08, 2024

Feature(s)

• 🙌 Integrated Multi-Edit connection for Add and Edit server
• Added enter key event feature for machine & database connection to submit the form just on hit enter

IMPROVEMENT(s)

• Improved close button appearance, visibility timing and position in loader.
• Improved add/edit server
  • Popup closing issue on validating, even if the update is pending in edit mode
  • Changed interval and maxAttempts as required for each task involved in the process
  • Toaster should not be visible on "choose servers & continue" as we are showing the status modal
• Improved memory usage chart for maximumYAxis to get it dynamically based on response data
• Improved alert history modal
  • Mobile mode design
  • 🙌 Show threshold lines, annotation circles and area chart
  • Show "View details" option on expanded mode as well
  • Chart should be loaded at least for alert 'Machine SQL Process CPU Over Threshold'
  • Small alerts history will show active/inactive status
• Improved AO(under High availability) should only be available for supported servers

Fix(es)

• Fixed blocking list showing only which has blocking_session_id = 0.
• 🙌 Fixed css leakage problem from healthcheck to other components.
• Fixed issue related to tasks API getting called again & again even if it's completed with restricting multiple enter key press.
• Fixed closing popup issue on ESC key for queries side.
• Fixed issue with enter mobile verification step, was going back on enter mobile number step in signup flow.

Version 1.3 - Feb 27, 2024

Coming soon

• Implementing multi browser tabs session. Maintaining login, logout, switching company, moving to companies, etc... sessions.
• Implementing to show all agents status for each company on companies overview.

Feature(s)

• Added actions on groups list in members & permission.
• Added option to dismiss loader while it's in progress(not used anywhere).
• Added chart type change option for main chart component. And implemented on wait chart.

IMPROVEMENT(s)

• Improved change comapny dropdown search by showing partners(parent) if its client matches and if partner matches show full partner.
• Improved cpu & memory first chart to show annotation and alert area chart only for raw data.
• 🙌 Improved int(number) type control value handling with showing alert if entered number is not in between min and max number and will be reset onblur in edit alert settings.
• Improved AO - Hide Job sync, Link sync, and Login sync and show only if the SQL version is 2022 and beyond.
• Improved when overview pages are shown we move timeframe to 10 mins
• Improved capacity planning
  • Load directories only once partitions are loaded
  • Showing change in percentage with different color code according to positive and negative
  • Add a tooltip for the directories' data(The system displays only folders that contain databases and backup files.)
  • Change the dropdown option from "Percentage of growth" to "Actual growth"
• Improved action menu availability based on memberInvitationStatusType
• Improved alerts history sidebar
  • Navigate from company overview and open
  • Navigate to server or database components and open
  • Auto refresh mechanism
  • Show "dismissed" status over "active/inactive"
  • Alert history details severity indication
• Improvemed jobs list by combininng "job executing status" in "last run status" column, moved "status" column to last position".
• Improved by adding loaders when toggling(ENABLED/DISBALED) alert settings from the list.
• Big improvements in mobile mode
  • Separate server tree
  • Sidebar menu
  • Server navigation from overview
  • Dynamic user profile image on sidebar menu
  • Remove tree actions
  • Overall application design improvements
• Improved blocking list with correct value for "Type and Status" column.
• Improved by removing pagination from job history based on SQL server version(Not supporting on Server 2005, 2008 and 2008 R2).
• Improved signup flow by omit verification code step when isVerificationCodeBySMSRequired: false.
• Improved invite existing group modal by filtering existing groups for members.

Fix(es)

• Fixed pagesize reset issue in company-jobs on clearfilter.
• Fixed server tree scroll problem in mobile mode.
• Fixed auto toggle OFF behaviour on closing edit alert settings sidebar.
• Fixed mobile view breadcrumbs.
• Fixed server tree scroll issue.
• 🙌 Fixed position problem of machine and database connection modal on add/edit server.
• Fixed affiliate/include/exclude server popup close event not raised on add server in onPrem version alert settings.
• Fixed select all and conditionally hide the checkbox on the members list.
• Fixed healthcheck chart glich on auto refresh for multiple times in server overview.
• Fixed signup complete step(phone and regioncode was missing).
• 🙌 Fixed selection and expand parent on moving to server or database in server tree.
• Fixed few things on server tree: group with space, checkbox and menu click.
• Fixed generateHealthCheckReport action success function for refreshing chart and list(problem was from backend).
• Fixed addtowhitelist action by refreshing list in suspicious activity setting.

Version 1.2 - Jan 21, 2024

Feature(s)

• 🙌 Integrated server edit access for groups.
• Added sorting on Table Index Prediction in capacity planning.
• Added feature to move server while creating server group.
• Added no-support deadlock feature on server-performance depending on the SQL version.
• 🙌 Frontend pagination applied to.
  • Server jobs module.
  • Job history module.
• Added serialized info textarea for api-playground page.
• 🙌 Added soring on company overview list.
• 🙌 Big feature: Can use external json file as environment variables.
• 🙌 Added query priority list with filters.
• 🙌 Added OnPrem environment changes all over the system.
• 🙌 Added shimmer like loader for chart in processes and services lists.
• 🙌 Integrated "Load more" for task manager list.
• 🙌 Added API playground page(currently only for task bases APIs).
• Added sorting in jobs history modal on company and server level.
• Added refresh and auto refresh for jobs at company level.
• Added a new column for last run status in jobs.
• Added sorting in jobs on company and server level.
• Added a feature to treeview to make group level node not clickable.
• Added pagination in job histories.
• Added paging in AO.

IMPROVEMENT(s)

• Improved members inactive group row appearance.
• Improved user invitation and signup flow for OnPrem version.
• Improved reset password flow for OnPrem version.
• Improved by separeted API calls for client validation on global settings for onCloud and onPrem.
• Improved for onPrem singup flow for making mobile number optional.
• Improved "GroupName" in tree and application to handle space and other special characters.
• Improved server tree to can select multiple/all servers and databases.
• Improved remove server action as if same server is selected redirect to company overview.
• Improved add server auto check on successful validation.
• Improved "Copy all steps" action in job history modal.
• Improved performance modules and AO by adding loaders.
• Improved priority queries loading in tabs in modal.
• Improved with adding loaders on various places in alert settings.
• Improved no-data desing for invite existing group modal.
• Improved getCurrentClientAllUsersShrinkedData API call by adding isIncludeUsersThatConnectedOnltByBusinessAffiliate: true for
  • alert history list in expanded mode
  • edit alerts settings to get contacts and groups
• Improved server hierarchy API payload adding isReturnServicesStatuses: true to get services status.
• Improved AO for keeping it expanded on auto refresh.
• Improved directory capacity planning with growth percentage.
• 🙌 Improved with adding a colored bullet for each line of the series with the checkbox in the list block in capacity planning
• 🙌 Major improvements over the database level capacity planning for making projection type, percentage projection, and aggregation dynamic.
• Improved global search in AO.
• Improved sql service status if it is not online or offline, show N/A.
• Improved progress-bar for status over time in AO.
• Improved filters on error-log and failovers model in AO.
• Improved "Reset password" flow and password validator.
• Improved contact filter visuals and change to ngModel

Fix(es)

• 🙌 Fixed add server popup css leakage which was affecting all the modals in the system.
• Fixed group and server name in dashboard filters.
• Fixed to allow adding only "active contacts" to group and contacts to "active groups".
• Fixed duplicate hierarchy calls while moving beteween companies and company dashboard.
• Fixed servers names on UI to show with "\" instead of "---".
• Fixed performance settings saving flow on server level.
• Fixed contact and contact group list to load inactive ones by removing filterByIsActive: true from payload.
• Fixed remove member flow from side drawer in members & permission
• Fixed user phone number change flow in user profile setting.
• Fixed checkbox selection issue on add/remove selected servers in add server.
• Fixed user and company profile pages, was not showing error for file upload.
• Fixed capacity planning charts with negative values.
• Fixed on Timeframe Done pass the latest time and send the new time to autorefresh.
• Fixed priority queries list to show only if is_Priority: true in server hierarchy response.
• Fixed sorting icon position if column is too small.
• Fixed pagesize change on clearfilter along performance modules.
• Fixed no-data-available design on filtering jobs on server level.
• Fixed database overview history task continue on moving to other components.
• Fixed getServersCredentials payload by adding optionalFilterByIsActive: true for edit servers.
• Fixed registeredDevicesStr undefined error while login.
• Fixed rename server group action.
• Fixed issue with getTaskResultsBy called even after it is finished in API playground page.
• Fixed null company information breaks the page.
• Fixed company overview server list on changing the company.
• Fixed pagination at company level and sorting when moving between servers.
• Fixed jobs sorting with FE pagination, was applying only on current page results.
• Fixed text/title on alert settings module based on weather it is server or machine on various places like list, tabs, affiliate page, include/exclude, etc...
• Fixed FE filters to work in conjuction in server jobs.
• Fixes and improvements over paging, sorting and filtering in jobs.
• Fixed disk palette colors.
• Fixed by clearing chart filters while navigating from tree menu in capacity planning.
• Fixed issue in capacity planning with getting error on point click of database prediction from database level as dbfiles from API was coming null, also added error toaster for the same.
• Fixed legend toggling issue in chart in capacity planning.
• Fixed default template delete action in alert settings.
• Fixed database overview history by placing a separate loader for it.
• 🙌 Fix mini chart for same values in datasource. Affected on server and databases overview, performance-networks.
• Fixed healthcheck security details payload for identifier1

Version 1.1 - Nov 26, 2023

Feature(s)

• Integrated filters for Groups and Contacts in settings
• Added auto refresh and Play/Pause in expanded alerts history list.
• Added filter external users and multi delete users on members and permission
• 🙌 Introduce frontend pagination.
  • Applied to Databases module.
• Added feature to refresh the token based on expiresInSeconds as received in last refresh-token response.
• Integrated job history at the company & server level.
• 🙌 Implement Resize sidebar with SF controls(Removed custom resizer as it was not stable).
• 🙌 Implement custom resize for the sidebar.
• Implement AO logs and AO failovers shown in the sidebar modal in the Always on module.
• Implement deadlock and blocking chart on the server overview
• 🙌 Integrated User profile under settings
• Auto refresh on companies overview
• Added two actions on Suspicious activity in the settings
  • Add application to the whitelist
  • Add login to whitelist
• Show victim or process statement on deadlock.
• Added two actions for the server and database from the tree
  • Dismiss all alerts
  • Delete all alerts
• Added two actions for invited member
  • Resend invitation
  • Cancel invitation
• Added severity-wise alert indication in the server tree on each level, i.e. group, server and database. Works based on conditional logic.

Company
• Jobs

Company > Server
• Jobs
• High availability
  • Always On

Company > Settings
• User profile
• Agent setting

Salient features
• 🙌 Edit server connection
• Manage Tags from tree
• 🙌 Application Logout

IMPROVEMENT(s)

• Improved edit server for wrong multiple toasters and validations.
• 🙌 Improved alert settings save, to synchronize the API calls in order.
• As toasters are by type, improved toasters all over the system.
• 🙌 Improved toaster look and feel as per its type.
• Improved edit server connection.
• Show complete template alert email configuration from the backend.
• Added global filter in suspicious activity.
• Improved by removing Navigation Observer for same component navigation all over the application.
• Improved task type APIs success and failure conditions.
• Improved filters and searchbox UI/UX all over the application.
• Added global search in sessions.
• Improve AppRefresh during route change, interval and date change.
• Reset interval in play mode and date picker change(take new DateTime when clicking play or changing timeframe).
• Improve interval for app Pause/Play.
• Added description in services change status modal.
• Hide auto refresh(play/pause) on non-refresh modules.
• Open agent details on completion of creating a company(Resurfaced as now need to open same from multiple places).
• 🙌 Improved boolean type alert rearrange when have control.
• 🙌 Select the server on the tree if we navigate inside the server from company overview.
• Changed time formats all over the application from 'HH:mm, DD.MM.YYYY' to 'DD/MM/YYYY HH:mm'.
• Improved chart titles across the application.
• Improve dbfiles chart in capacity planning, had issue with the filename.
• Stop auto refresh for capacity planning and sessions
• Show offline database as disabled in the tree, though actions and navigations are possible.
• 🙌 Ground level change on server capacity planning for handling projection type, percentage projection and aggregation dynamically
• Improve appRefresh during route change for non-refresh routes
• 🙌 Show server name with "//" and send server name to API call payload as "---" all over the application.
• Separate API call for blocking chart
• Reset timeframe to take new DateTime on route change
• Add SQL service filter and improve server active/inactive filter on company overview
• Improved server and database headbar css problem
• Auto refresh on tables and indexes
• Reset filters from the lists on moving between servers or databases
• Improved sorting on disks for databases and database files blocks.
• Cosmetic improvements in capacity planning.
• Improved processes small chart with dynamic y-axis.
• Improved databases small chart with dynamic y-axis.
• Separate two action types(application & login) on Suspicious activity settings.
• Made human-readable legends on temdb summary chart.
• Improved calculation of projected array and date for capacity planning.
• Converted textbox to ejs numeric textbox on performance settings.
• Added navigations from each block on the server overview.

Fix(es)

• Fixed issue showing the wrong severity for sms config in the alert setting.
• Fix performance components navigation with the wrong server, if navigated from the tree.
• Fixed interceptor to do logout on unautorized-401 error again, using throttleTime.
• Fixed errors on the dashboard and databases when there is no data.
• Fixed the z-index issue with the sidebar.
• Member can't be added to Business Affiliate group.
• Fixed interceptor to do logout on unautorized-401 error.
• Fixed twice API calling issue on components.
• Added a fix for top 10 data selection issue in capacity planning charts.
• Send seconds in DateTime used for payloads.
• Fixed DateTime timezone used in payload.
• Fixed signup flow, for user clicks again from invitation email.
• Fixed edit alert controls with no value.
• Fixed app tree view as the tree is expanded at the group level only using expand all button.
• Fixed CPU and Memory double tooltip issue.
• Fixed capacity planning modules when moving between server anddatabase.
• Fixed alert history(both views) action menu visibility problem.
• Update manage tags list after update.
• Added cosmetic fixes on "add server" and "company overview".
• In Members and permission group list group can't change its permission to the Owner.
• Fixed tablesindexes growth calculation ondatabase capacity planning
• 🙌 Fixed server anddatabase capacity planning charts for missing dates data and point click for projected data
• Fixed the issue by removing "WaitMS" text from the wait charts legend
• Fixed tablesindexes list ondatabase capacity planning to show data bydatabase

Version 1.0 - Sep 12, 2023

Feature(s)

Authentication
• Login
• Register

Company
• Companies overview
• Company overview

Company > Server
• Server overview
• Performance
  • CPU
  • Memory
  • Disk
  • Network
  • Blocking
  • Deadlock
  • Queries
  • Temp DB
  • Waits
  • Services
  • Processes
• Security
  • Health check
  • Suspicious activity
• Capacity planning
• Databases

Company > Server > Database
• Database overview
• Schema
  • Tables
  • Indexes
• Sessions
• Capacity planning

Company > Settings
• Company profile
• Members & Permission
• Contacts
• Global setting
• Performance
• Alerts
• Security
  • Health check
  • Suspicious activity

Salient features
• Add server
• Alerts history list
• Moving server from one group to another using Drag and Drop