iMonnit Enterprise Script Changelog
Source: ConfigData\Upgrade Installation scripts (versions 3.5.0.0 through 4.0.5.4)
Baseline schema reference: ConfigData\Full Installation (current full install = 4.0.5.4)
Purpose: Knowledge base of database schema, data, and procedure changes for support and documentation. Compiled from upgrade SQL where the software team does not maintain a separate changelog.
Notes:
- Descriptions are inferred from SQL (headers,
ALTER/CREATE/INSERT, and procedure names). Product marketing wording may differ. ReleaseNoterows in many versions only contain a generic “Welcome to Enterprise Version X” message; real change detail comes from the scripts themselves.- Stored procedure lists are summarized by theme when a version refreshes a large number of procs.
Table of contents
- 4.0.5.4
- 4.0.5.3
- 4.0.5.2
- 4.0.5.0
- 4.0.4.0
- 4.0.3.4
- 4.0.3.1
- 4.0.3.0
- 4.0.2.1
- 4.0.2.0
- 4.0.1.6
- 4.0.1.5
- 4.0.1.0
- 4.0.0.0
- 3.6.2.0
- 3.6.1.2
- 3.6.1.1
- 3.6.1.0
- 3.6.0.0
- 3.5.0.0
Version 4.0.5.4
Author / date: TJB — 1/20/2026 (Script 1); 01/20/2026 (Script 2)
| Version | Change | Description |
|---|---|---|
| 4.0.5.4 | GatewayStatus backfill | Inserts missing GatewayStatus rows for any Gateway that does not already have a status record. |
| 4.0.5.4 | MonnitUtil_AccountIDTree function | Adds/recreates MonnitUtil_AccountIDTree so account-tree logic is available under the MonnitUtil name expected by Account_ModelSearch (companion to earlier Util_AccountIDTree-style behavior). Script header: previously added as Util_AccountIDTree but Account_ModelSearch specifically looks for MonnitUtil. |
| 4.0.5.4 | Release note & DB version | Welcome release note; DBVersion → 4.0.5.4 . |
Version 4.0.5.3
| Version | Change | Description |
|---|---|---|
| 4.0.5.3 | Report recipient search procedures | Adds ReportRecipientData_SearchPotentialReportRecipient and Customer_SearchPotentialReportRecipient for picking report recipients (mirrors notification recipient search patterns). |
| 4.0.5.3 | Release note & DB version | Welcome release note; DBVersion → 4.0.5.3 . |
Version 4.0.5.2
Author / date: TJB — 9/4/2025
| Version | Change | Description |
|---|---|---|
| 4.0.5.2 | PreferenceType 18 – Default Rule Pause Duration | Adds preference type “Default Rule Pause Duration” (default Manual ) with options: Indefinitely/Manual, 1–4 Hours, 1–3 Days, 7 Days, 14 Days, 1 Month (duplicate-safe inserts). |
| 4.0.5.2 | Missing stored procedures | Ensures CustomerFavorite_LoadByCustomerIDAndAccountID and Notification_RuleFilterHomePage exist (needed for index-page favorites and rule filtering). |
| 4.0.5.2 | Release note & DB version | Welcome release note; DBVersion → 4.0.5.2 . |
Version 4.0.5.0
Author / date: JFK — 9/18/2024 (header template present; change detail taken from SQL)
| Version | Change | Description |
|---|---|---|
| 4.0.5.0 | CredSessionLength config | New ConfigData key CredSessionLength = 20 ; release note; DBVersion → 4.0.5.0 . |
| 4.0.5.0 | Cable & sensor programming | New Cable table (SKU, application, revisions, sensor link). Sensor gains ForceOverwrite, LocalConfigOptions, IsCableEnabled, CableID (FK). CalibrationCertificate can link to Cable; SensorID made nullable. New CableAudit, ProgrammerAudit, SensorProfile, SensorProfileIndex. Defaults/backfill for several sensor radio timing fields. |
| 4.0.5.0 | WiFi 2 hardware | New PowerSource “WF2 (AA)”; SensorType WiFi_2; GatewayType Wifi_2 (ID 38) with full default capability profile. |
| 4.0.5.0 | BSNFirmware | New table for radio firmware metadata. |
| 4.0.5.0 | Inbound/Outbound packet rebuild | Tables dropped and recreated with clustered keys on date/APN/GUID/day; GUID defaults to newid(). |
| 4.0.5.0 | PreAggregatedData | New PreAggregatedData for summarized sensor data. DataMessage and DataMessage_Last gain ApplicationID. ReportQuery gains RequiresPreAggs, SensorLimit, FK to ReportType. |
| 4.0.5.0 | Notification schema | HasResetAccAction, PushMsgText, IgnoreMaintenanceWindow; IsActive and ENotificationClass NOT NULL; snooze default reset to 240 minutes; recipient/log FK tightening. |
| 4.0.5.0 | Push & phone ISO codes | CustomerPushMessageSubscription gains LastSentDate/Name; Customer gains NotificationPhoneISOCode / NotificationPhone2ISOCode; CustomerSchedule FKs refined. |
| 4.0.5.0 | Accounts & billing | Account auto-bill/payment fields; AccountIncrement; OnlineOrder, OrderItem, Payment; Product PK enforced. |
| 4.0.5.0 | API & usage logging | APIUsageDetail; CassandraLog, MeaApiLog, ServerStatusLog, DataTableStatistics; FKs on APIKey / AccountAPIKey. |
| 4.0.5.0 | Credits | CreditLog; FKs on Credit to Account and activating Customer. |
| 4.0.5.0 | Certificate report models | CertificateNotificationModel / CertificationAcknowledgementModel for email/report payloads. |
| 4.0.5.0 | CustomerFavorite | Ordered bookmarks for sensors, gateways, maps, notifications, reports, locations. |
| 4.0.5.0 | CustomCompanyDevice / PopupNoticeRecord | Custom device settings; popup notice tracking with SKU and firmware ignore list. |
| 4.0.5.0 | GatewayStatus | New table for gateway power/last-comm/IP status. |
| 4.0.5.0 | SeverityLevel | Lookup table for severity number + label. |
| 4.0.5.0 | Theme / SMS / Country | AccountTheme AlphanumericSenderID; Country alphanumeric/pre-registration flags; AccountThemeStyle FK cleanup. |
| 4.0.5.0 | Maintenance & external data | MaintenanceWindow.StartDate; ExternalDataSubscription connection info/verb/SendRawData updates; attempt FK to NotificationRecorded. |
| 4.0.5.0 | Visual map / help / OTA FKs | VisualMapGateway FKs; VisualMap.Image → varbinary(max); SystemHelp FKs; OTARequest / OTARequestSensor FKs. |
| 4.0.5.0 | Other alters | DebugLog.Message → varchar(max); maintenance link notes → varchar(max); NetworkAudit/FromNetworkID; ReportSchedule.SendAsAttachment nullable; GatewayLocation NOT NULL tightenings; ChangeLog/NotificationNote/AuthenticateDevice/FirmwareCache FKs. |
| 4.0.5.0 | Applications | Humidity_5PCal (147), Motion Temp Water (150), Five Input Dry Contact (151), Dual Pulse Counter (153), Resistive Bridge Meter (154), Latched Dual Control (158). |
| 4.0.5.0 | Customer permissions | Show Dashboard (55), View Locations (56), Can Access Billing (57), Can Create Calibration Certificate (58), Allow Admin Account Linking (59), Can Create Locations (60). |
| 4.0.5.0 | PreferenceType 17 | Location Sorting (default 1 , int). |
| 4.0.5.0 | SVG icons | Bulk insert/update of interface/sensor icons (through roughly ID 515). |
| 4.0.5.0 | Type rename | User-defined type DataMessageInsert_Type renamed to DataMessageInsert_Type_Old. |
| 4.0.5.0 | Stored procedures – major refresh | Very large Script2 refresh covering OTA, notifications/rules, credits, pre-aggregation, cable/sensor, equipment/HVAC/refrigeration dashboard loaders, favorites, location overview/search, gateway/CSNet, reporting, API/webhooks, translation, and shared maintenance procs. |
| 4.0.5.0 | Commented dashboard objects | Script 1 contains commented-out CREATE statements for Dashboard/Equipment/HVAC/Fault/Advertisement-style tables; those objects are not created by the upgrade as written. |
Version 4.0.4.0
| Version | Change | Description |
|---|---|---|
| 4.0.4.0 | NotificationRecordedID type fix | Drops and re-adds ExternalDataSubscriptionAttempt.NotificationRecordedID as BIGINT NULL to correct incorrect typing introduced in 4.0.3.1 (script notes it had been DATETIME). |
| 4.0.4.0 | DB version | DBVersion → 4.0.4.0 . |
Version 4.0.3.4
| Version | Change | Description |
|---|---|---|
| 4.0.3.4 | SVG icon – circle-profile | Inserts circle-profile icon (SVGIconID 424) if not already present. |
| 4.0.3.4 | DB version | DBVersion → 4.0.3.4 . |
Version 4.0.3.1
| Version | Change | Description |
|---|---|---|
| 4.0.3.1 | DebugLog (new table) | Diagnostic logging (IdentifierType /IdentifierValue , severity, server, code path, message). |
| 4.0.3.1 | Customer.PWACreateDate | Tracks when Progressive Web App access was created for the user. |
| 4.0.3.1 | ExternalDataSubscriptionAttempt.NotificationRecordedID | New bigint column linking webhook/subscription attempts to a NotificationRecorded row. |
| 4.0.3.1 | Stored procedures | Updates Credit_LoadAvailable; adds DeviceStatusModel_LoadByAccountID and DeviceTestingModel_LoadByGatewayID. |
| 4.0.3.1 | DB version | DBVersion → 4.0.3.1 . |
Version 4.0.3.0
Author / date: NLN — 2/15/2023 (header lists Primary Changes explicitly)
| Version | Change | Description |
|---|---|---|
| 4.0.3.0 | DataMessage_Last | New table holding each sensor’s latest data message for query optimization. Upgrade backfills from DataMessage where the sensor’s last communication matches the latest GUID (recent messages relative to UTC “now”). |
| 4.0.3.0 | Notification.LocalAlertText bug fix | Column dropped and re-added as varchar(255) . Script 2 backfills from the first 63 characters of NotificationText for local-alert delivery recipients. |
| 4.0.3.0 | Cell data usage | New DataUseLog and DataUseList for gateway cellular data tracking (daily/monthly use, carrier metadata, status). |
| 4.0.3.0 | Visual maps & GPS | New VisualMapGateway ; VisualMap gains MapType and nullable Width/Height; Gateway gains GPSPing, LastLocationDate, WarrantyStartDate; new LocationMessage for GPS fixes. |
| 4.0.3.0 | SAML & identity | New SamlEndpoint ; Account gains SamlEndpointID and AllowCertificateNotifications; Customer gains ByPass2FAPermanent, SamlNameID, ForceLogoutDate; AccountTheme gains SupportsSaml and AllowPWA. |
| 4.0.3.0 | PWA push subscriptions | New CustomerPushMessageSubscription (Web Push endpoint, keys, GUID). |
| 4.0.3.0 | Calibration certificate notifications | New CertificateNotification, CertificateNotificationLink, CertificateAcknowledgement; scheduled task NotifyCertificateExpiration (ID 16). |
| 4.0.3.0 | CustomerLinkRequest | New table for account-linking requests (email, link code, activation). |
| 4.0.3.0 | Maintenance preference levels | MaintenanceWindow.SeverityLevel; MaintenanceWindowCustomer.Type; new MaintenanceWindowQueue; PreferenceType 15/16 for Maintenance Pop Up Level and Maintenance Notification Level with severity options. |
| 4.0.3.0 | Account theme styling seed | New AccountThemePropertyType/Property; seeds AccountThemeStyleType entries and default style group/values for the active theme; widens style values; DisplayOrder added. |
| 4.0.3.0 | Maps API key theme property | Inserts AccountThemePropertyType Maps_API_Key. |
| 4.0.3.0 | ExternalDataSubscription class | Adds eExternalDataSubscriptionClass (default 1). |
| 4.0.3.0 | Packet GUID / day columns | OutboundPacket and InboundPacket gain Day and GUID columns; InboundPacket CreateDate default UTC. |
| 4.0.3.0 | Other schema | NotificationRecipientLog, SensorFirmware; Sensor.WarrantyStartDate; EmailTemplate.Template → varchar(max). |
| 4.0.3.0 | Applications | Advanced Vibration 2 (142), Site Survey (143), Pressure 750 PSI (144), Pressure 3000 PSI (145). |
| 4.0.3.0 | SVG icons refresh | Truncates and repopulates SVGIcon with updated sensor/interface icons. |
| 4.0.3.0 | Stored procedures | Cell data use calculators/loaders; DataMessage update/quick/bulk; notification/certificate/SAML/maps/location/customer-link/PWA/packet/theme property procedures updated or added. |
| 4.0.3.0 | Release note & DB version | Welcome release note; DBVersion → 4.0.3.0 . |
Version 4.0.2.1
| Version | Change | Description |
|---|---|---|
| 4.0.2.1 | ChangeLog tables | New ChangeLog and ChangeLogItem for published version changelog entries (version, release date, typed headings/details). |
| 4.0.2.1 | Gateway / integrations | ExternalDataSubscription.IgnoreSSLErrors ; Gateway SendUpdateModuleCommand , isGPSUnlocked , SendGPSUnlockRequest ; GatewayType.ModuleUpdateURL . |
| 4.0.2.1 | GatewayType – Edge Gateway | Inserts GatewayType 37 Edge Gateway; updates firmware/GPS/OTA fields on multiple existing types. |
| 4.0.2.1 | Application inserts / renames | Motion Plus (138); renames several applications (e.g. Pressure, Vehicle Counter-Detection, Current Meter 500 Amp, Tilt Detection). |
| 4.0.2.1 | UI / permissions / features | Preference option display-name updates; CustomerPermissionType visibility/description tweaks; Feature 18, 20–23 category → Premiere. |
| 4.0.2.1 | SVG icons | Updates/adds icons including activeSensors and DownloadFirmware. |
| 4.0.2.1 | Config / release | Config URL update; DB version 4.0.2.1 ; welcome ReleaseNote. |
| 4.0.2.1 | Stored procedures | New AuthenticateDevice_LoadByCustomerID, ReportQuery_LoadByAccount, Credit_LoadExhaustedByAccountID, ChangeLog_LoadRecentPublished; alters Preference_LoadPreferences. |
Version 4.0.2.0
| Version | Change | Description |
|---|---|---|
| 4.0.2.0 | NotificationRecorded text migration | Migrates NotificationText to nvarchar(max) via a temp column. Only the most recent 1000 rows are copied forward before rename (older long text beyond that may need a custom migration per script comments). Also adds NotificationGUID and Unicode upgrades for Reading / NotificationSubject (with staging _Old columns). |
| 4.0.2.0 | Customer security (2FA / hashed passwords) | Adds HomepageLink , Password2 , Salt , WorkFactor , TOTPSecret , ByPass2FA , TFAMethod ; narrows legacy Password ; Unicode names. |
| 4.0.2.0 | AccountVerification (new table) | Pending account signup records with IANA timezone, verification code, and hashed password fields. |
| 4.0.2.0 | API keys (new tables) | APIKey and AccountAPIKey with salt/work factor/hashed secret. |
| 4.0.2.0 | AuthenticateDevice (new table) | Trusted devices for two-factor authentication. |
| 4.0.2.0 | IPBlacklist (new table) | Failed login tracking by IP. |
| 4.0.2.0 | OTA / firmware (new tables) | OTARequest , OTARequestSensor , FirmwareCache for over-the-air firmware update requests, per-sensor status, and cached firmware payloads. |
| 4.0.2.0 | IanaTimeZone (new table) | IANA territory → Windows TimeZone mapping (large insert set for account creation). |
| 4.0.2.0 | NotificationNote (new table) | Notes on notification triggers; NotificationTriggered.HasNote . |
| 4.0.2.0 | ReportType / SystemHelp | New ReportType categorization; ReportQuery gains ReportType linkage; new SystemHelp for contextual help content. |
| 4.0.2.0 | Gateway / Sensor OTA columns | Gateway: OTARequestActive , public key fields. Sensor: TemplateSensorID , FirmwareDownloadComplete . GatewayType: SupportsOTASuite , min OTA firmware version flags. |
| 4.0.2.0 | Notification templates Unicode | Subject / VoiceText → nvarchar(2000) with _Old columns retained. |
| 4.0.2.0 | Theme / webhooks / company | AccountTheme IsTFAEnabled ; theme style binary defaults; ExternalDataSubscriptionProperty string expansion; CustomCompany CompanyProfileID . |
| 4.0.2.0 | Subscription type NOT NULL | Backfills null AccountSubscriptionTypeID to 5, then makes column NOT NULL. |
| 4.0.2.0 | Application / PowerSource | Light Sensor PPFD (139); PowerSource ALTA W2S (19). |
| 4.0.2.0 | ConfigData – security & load | Adds server load flags, firmware cache timing, template network ID, password WorkFactor, and IP blacklist thresholds/time windows. |
| 4.0.2.0 | Reporting / OTA gateway defaults | Seeds ReportType Enterprise; enables SupportsOTASuite / min firmware on gateway types 7, 30, 32, 33; clears legacy LatestGatewayPath / SensorInterpretorPath; sets DefaultServerInterfaceActive on many types. |
| 4.0.2.0 | Preferences & SVG icons | Preference display names; new PreferenceType 14 “Days to Load” / Default Chart Display (1–90 days). Large SVGIcon insert/update batch. |
| 4.0.2.0 | Stored procedures | New AccountVerification, APIKey, IPBlacklist, AuthenticateDevice, OTARequest, FirmwareCache, and ReportType loaders; alters Customer_Authenticate and related reporting/preference/notification procs. |
| 4.0.2.0 | Release note & DB version | Updates release note / DB version to 4.0.2.0 . |
Version 4.0.1.6
| Version | Change | Description |
|---|---|---|
| 4.0.1.6 | Application – Food Probe | Inserts Food Probe (128) with trigger profile and default ranges. |
| 4.0.1.6 | Subscription feature link | Ensures SubscriptionTypeFeatureLink 128 links AccountSubscriptionType 5 to Feature 2 if missing. |
| 4.0.1.6 | Inactive language cleanup | Removes inactive language selections from theme preference links, Preference, and PreferenceTypeOption (keeps English/active defaults). |
| 4.0.1.6 | Release note & DB version | Release note; DBVersion → 4.0.1.6 . |
Version 4.0.1.5
| Version | Change | Description |
|---|---|---|
| 4.0.1.5 | Calibration facilities | Inserts if missing: CalLabCo, KWJ Engineering, Laboratory Testing, Custom Facility. |
| 4.0.1.5 | Unicode name columns | Converts key name fields to nvarchar(255) on SensorGroup, Customer (UserName/FirstName/LastName/Title), SensorAttribute (Name/Value), and VisualMap.Name for international characters. |
| 4.0.1.5 | Application inserts | Soil Moisture (135), Digital Temperature (136), Three Phase 20 Amp Meter (137). |
| 4.0.1.5 | Date preference corrections | Corrects PreferenceTypeOption / Preference date format strings (yyyy-MM-dd , dd.MM.yyyy ). |
| 4.0.1.5 | Stored procedures | Alters account/customer search and chart/recipient search procs for Unicode name fields. |
Version 4.0.1.0
| Version | Change | Description |
|---|---|---|
| 4.0.1.0 | Install caution (SensorPrint / IsAuthenticated) | Script notes that Sensor print / DataMessage.IsAuthenticated changes can interrupt sensor communication while Script 2 drops and recreates DataMessage_BulkInsert and type DataMessageInsert_Type . Messages attempted during that window can fail until Script 2 completes. |
| 4.0.1.0 | Announcements (new tables) | Announcement and AnnouncementViewed for in-app announcements with per-customer read state. |
| 4.0.1.0 | Theme styling (new tables) | AccountThemeStyleGroup , AccountThemeStyleType , AccountThemeStyle for configurable theme styling. |
| 4.0.1.0 | Credit (new table) | Notification credit instances (script notes some credit/classification features as not fully used yet). |
| 4.0.1.0 | Sensor authentication print | Adds Sensor.SensorPrint (varbinary(max) ), SensorPrintDirty ; adds DataMessage.IsAuthenticated (nullable for historical rows). |
| 4.0.1.0 | Account / Gateway | Account.HideData , IsHxEnabled ; Gateway cellular fields M1BandMask , NB1BandMask , UMNOProf , SIMAuthType . |
| 4.0.1.0 | ReleaseNote / theme / tasks | ReleaseNote gains AccountThemeID , Title , Subject , Image , Link ; AccountTheme gains AllowAccountCreation ; ScheduledTasks gains RunOnMinute . |
| 4.0.1.0 | Credits / GatewayType | Credit classification fields on credit settings/types; GatewayType.IsGatewayBase (default 1). |
| 4.0.1.0 | SensorType / GatewayType inserts | SensorType 6 PoE, 7 LTE; GatewayType 35 POE Sensor, 36 LTE Sensor. |
| 4.0.1.0 | ThemeAdmin permission | CustomerPermissionType 78 ThemeAdmin (“Manage Account Themes”, SuperAdmin); seeds missing customer permissions. |
| 4.0.1.0 | SVG icons | Adds icons for Propane Tank Monitor, Alta Three Phase Current Meter 500, Triggered Tilt. |
| 4.0.1.0 | DataMessage type/proc recreate | Drops and recreates DataMessageInsert_Type (with IsAuthenticated) and DataMessage_BulkInsert . |
| 4.0.1.0 | Stored procedures | Announcement load/mark-read; theme style loaders; credit availability/overdraft/remaining; message/report/account/group alters. |
| 4.0.1.0 | Release note & DB version | Release note; DBVersion → 4.0.1.0 . |
Version 4.0.0.0
Author / date: NLN — 2020-01-23
| Version | Change | Description |
|---|---|---|
| 4.0.0.0 | Safer upgrade transaction model | Script 1 runs in a transaction with NOEXEC rollback handling so a failed upgrade does not leave a partially applied schema. |
| 4.0.0.0 | SVGIcon (new table) | Theme-aware SVG icons (Name , ImageKey , Category , HTMLCode , optional AccountThemeID , IsDefault ). |
| 4.0.0.0 | DBErrorLog (new table) | Database procedure error logging (ProcName , Date , Urgency , Message , Params ). |
| 4.0.0.0 | Customer groups (new tables) | CustomerGroup , CustomerGroupLink , CustomerGroupRecipient , CustomerGroupNotification — account-scoped user groups linked to customers and notifications. |
| 4.0.0.0 | SensorGroupGateway (new table) | Associates gateways with sensor groups. |
| 4.0.0.0 | SensorMessageAudit (new table) | Audit trail for sensor messaging events. |
| 4.0.0.0 | Product (new table) | Catalog-style product records (SKU, pricing, premier limits, notification credits, etc.). |
| 4.0.0.0 | TypeLookup (new table) | Lookup values keyed by table/column/TypeID . |
| 4.0.0.0 | CalibrationCertificate (new table) | Sensor calibration certificates tied to sensors and calibration facilities. |
| 4.0.0.0 | CustomCompany tables | CustomCompany , CustomCompanyGateway , CustomCompanySensor for custom company branding/metadata on gateway types and applications. |
| 4.0.0.0 | PreferenceTypeOption (new table) | Per-theme options for preference types. |
| 4.0.0.0 | ID sequence tables | GatewayIDSequence , SensorIDSequence for ID sequence tracking. |
| 4.0.0.0 | PreAggregation (new table) | Pre-aggregated sensor statistics (min/max/avg, counts, voltage/signal averages) keyed by date/sensor/GUID. |
| 4.0.0.0 | Gateway schema | Adds SKU ; Name → nvarchar(255) ; NTPServerIP → varchar(255) . |
| 4.0.0.0 | Sensor schema | Adds TimeOfDayControl (default 0) and SKU . |
| 4.0.0.0 | Notification / recipient | NotificationRecipient.CustomerGroupID ; Notification.SMSText → nvarchar(255) with SMSText_Old retained during migration. |
| 4.0.0.0 | Account schema | Adds store/MEA link GUIDs, recovery email, verification code/date, and APICallLimit (default max int). |
| 4.0.0.0 | AccountTheme / AdvancedNotification | EnableClassic (default 0); AdvancedNotification gains UseDatums and eDatumType . |
| 4.0.0.0 | Sensor groups | SensorGroupSensor : DatumIndex , Alias ; SensorGroup.Type . |
| 4.0.0.0 | Reporting / export | ExportStatistics.AccountID ; ReportSchedule.SendAsAttachment (default 1). |
| 4.0.0.0 | Other column / Unicode adjustments | Customer.AccountID nullable; translation/tag field length and Unicode adjustments across localization-related tables; AuditLog.Record expansion. |
| 4.0.0.0 | Application inserts | H2S Gas (56), ThreePhasePowerMeter (108), Propane Tank Monitor (124), G-force Max & Avg (126), ThreePhaseCurrentMeter500 (129), Triggered Tilt (130) — inserted if missing. |
| 4.0.0.0 | ConfigData keys | Adds InboundSettings , RunScheduledReports , LogNetworkExceptions , DefaultHolderAccountID , IsEnterprise (if missing). |
| 4.0.0.0 | GatewayType renames | ID 7 → Ethernet Gateway 3; 30 → ELTE Gateway; 33 → Ethernet Gateway 4. |
| 4.0.0.0 | Language / Feature | Language ID 2 set inactive; adds inactive languages 4–9 (Polish, Korean, Thai, German, Hebrew, Italian). Feature 29 “Can view MultiCharts” (view_multichart , Premiere). |
| 4.0.0.0 | PowerSource / Preferences | Adds Alta D and ALTA Ind Cold; PreferenceType 11 Hide System Health; 12 Disable Account Checklist. |
| 4.0.0.0 | Reporting seed data | Seeds ReportParameterType 1–10; ReportQuery entries (Account Report, Sent Notifications, Sensor/Network export, Logged Notes, No Notification Profile, Reseller User List); ScheduledTasks for Scheduled Report and AutomatedNotifications; links Feature 29 to subscription type 5. |
| 4.0.0.0 | Time zones | Adds India Standard Time and Central Standard Time (Mexico). |
| 4.0.0.0 | Translations re-seed | Truncates/rebuilds TranslationLanguageLink and TranslationTag with a large UI string set. |
| 4.0.0.0 | Release note & DB version | Release note for 4.0.0.0; DBVersion → 4.0.0.0 . |
| 4.0.0.0 | Stored procedures – notifications & groups | Alters core notification/recipient/triggered/recorded procs; adds full CustomerGroup procedure set and related customer/account cleanup. |
| 4.0.0.0 | Stored procedures – maps, messages, reports | Adds gateway location / equipment profile / sensor-group gateway loaders; message-by-GUID and chart loaders; many Report_* procedures (Account, Battery Health, Access Log, Sent Notifications, Audit Log, Sensor/Network Export, No Notification Profile, Log Notes, Reseller User List). |
| 4.0.0.0 | Stored procedures – SVG, translation, audit, integrations | Adds SVGIcon loaders, translation search/incomplete-tag loaders, SensorMessageAudit search/counts, external subscription account loaders, inbound/outbound packet cleanup, HoldingTable load, and GetLocalTime function. |
Version 3.6.2.0
Author / date: NLN — 03/11/2019
| Version | Change | Description |
|---|---|---|
| 3.6.2.0 | DataMessageNote.MessageDate | Adds MessageDate so notes can be associated with the message timestamp. |
| 3.6.2.0 | Sensor.TransmitPowerOptions | Adds configurable transmit power options on sensors. |
| 3.6.2.0 | Gateway interface toggles | Adds MQTT/NTP/HTTP/BACnet interface active flags, NTP server IP and sample rate, HTTP service timeout, disable-network-on-server-error, and ResetInterval (default 168 hours). |
| 3.6.2.0 | GatewayType – EGW2 | Inserts EGW2 (ID 33), firmware 1.0.1.13, Modbus/SNMP-capable defaults. |
| 3.6.2.0 | GatewayType – LTE defaults | Adjusts ID 32 defaults (channel mask, poll interval, host sensorsgateway.com , queue expiration). |
| 3.6.2.0 | Application – Advanced Vibration | Inserts Advanced Vibration (ID 111). |
| 3.6.2.0 | Release note & DB version | Documents Advanced Vibration and EGW2; DBVersion → 3.6.2.0 . |
Version 3.6.1.2
Author / date: NLN — 01/23/2019
| Version | Change | Description |
|---|---|---|
| 3.6.1.2 | Schema | No new tables or column alters; data-only gateway/application updates. |
| 3.6.1.2 | GatewayType rename | Gateway type ID 30 renamed from Multigateway to ELTE (when present). |
| 3.6.1.2 | GatewayType insert | Adds LTE Gateway (ID 32) with firmware 1.0.1.9 and cellular/LTE-oriented defaults. |
| 3.6.1.2 | Application inserts | CO Meter (116), CarDetect (119), Current Meter - 500A (120), Voltage Meter - 500 VAC (122), Voltage Detection - 200 VDC (123). |
| 3.6.1.2 | Release note & DB version | Release note documents new sensor profiles and LTE gateway; DBVersion → 3.6.1.2 . |
Version 3.6.1.1
Author / date: NLN — 11/5/2018
| Version | Change | Description |
|---|---|---|
| 3.6.1.1 | Schema | No table, column, or stored procedure schema changes (code-oriented release per script). |
| 3.6.1.1 | ConfigData – NewAccountNotificationEmail | Inserts NewAccountNotificationEmail = invalid@invalid.com (placeholder until configured). |
| 3.6.1.1 | Release note & DB version | Welcome release note; DBVersion → 3.6.1.1 . |
Version 3.6.1.0
Author / date: NLN — 9/21/2018
| Version | Change | Description |
|---|---|---|
| 3.6.1.0 | NotificationRecorded GUID | Adds NotificationRecordedGUID (uniqueidentifier , default newid() ). |
| 3.6.1.0 | ExternalDataSubscription credentials | Adds Username and Password for authenticated webhook/subscription endpoints. |
| 3.6.1.0 | Customer compliance / lifecycle | Adds NotificationOptIn , NotificationOptOut , CookieAcceptanceDate , DeleteDate . |
| 3.6.1.0 | Sensor aware-state tracking | Adds LastNormalDate , FirstAwareDate , LastAwareDate , and timeoffset so aware-duration logic can use sensor state instead of scanning all DataMessage history. |
| 3.6.1.0 | Gateway MQTT / SNMP | Adds SNMP community string, communication preference, system options, and a full MQTT settings set (port, broker, credentials, client/topic, intervals, keep-alive, ack timeout, queue flush, behavior flags). |
| 3.6.1.0 | AccountTheme default subscription | Adds DefaultAccountSubscriptionTypeID (default 5). |
| 3.6.1.0 | Account API access tokens | Adds AccessToken , AccessTokenExpirationDate , APIRevoked . |
| 3.6.1.0 | NotificationTriggered original reading | Stores OriginalReading and OriginalReadingDate when a notification fires. |
| 3.6.1.0 | AccountSubscription typing | Links subscriptions to AccountSubscriptionTypeID / LastKeyUsed . |
| 3.6.1.0 | AccountSubscriptionType (new table) | Named subscription tiers with KeyType , AllowedSensors , Rank , Tags . |
| 3.6.1.0 | Feature gating (new tables) | Feature and SubscriptionTypeFeatureLink map subscription types to feature keys (Premiere/Beta/Admin categories). |
| 3.6.1.0 | ExternalDataSubscriptionProperty (new table) | Name/value properties per subscription (string/binary, typed). |
| 3.6.1.0 | CustomerMobileDevice (new table) | Multiple registered mobile devices per customer with primary flag and push targeting fields. |
| 3.6.1.0 | Validation (new table) | Token-based validation records (type, value, expiration, opt-in). |
| 3.6.1.0 | AccountThemePreferenceTypeLink (new table) | Theme-level preference defaults and override rules. |
| 3.6.1.0 | Localization tables reintroduced | New tag-based localization stack: Language , TranslationTag , Translation , TranslationLanguageLink (distinct from the legacy translation tables removed in 3.5.0.0). |
| 3.6.1.0 | Subscription type seed | Seeds Basic (ID 1) and Premiere / Premiere_Standard_365 (ID 5); existing subscriptions set to type ID 5. |
| 3.6.1.0 | Feature seed | Seeds ~24 feature definitions (heartbeat limits, maps, multi-user/network, dashboards, calibration, webhooks, voice/SMS/email, API, advanced/scheduled notifications, push, multi-edit, etc.) and links Premiere to applicable features. |
| 3.6.1.0 | AdvancedNotification #1 SQL | Replaced with sensor FirstAware/LastAware/LastNormal logic (no longer scans DataMessage history for aware duration). |
| 3.6.1.0 | Application maintenance | Conditional inserts (PIR-Alta, Air Quality, Differential Pressure, Ultrasonic, CO2, Light, ThreePhaseCurrent, Voltage Meter 200 VDC, AirSpeed, etc.) and conditional deletes of unused application IDs when no sensors reference them. |
| 3.6.1.0 | PreferenceType seed | Date Format, Time Format, Site Theme, Page Layout, Language, Allow Classic Link. |
| 3.6.1.0 | Language seed | English (active), Spanish (active), French (inactive). |
| 3.6.1.0 | TranslationTag seed | Large initial set of UI translation tags for Overview navigation, top bar, index, date picker, and related screens. |
| 3.6.1.0 | ConfigData | Adds HardTheme = Default ; sets DBVersion to 3.6.1.0 ; inserts release note. |
| 3.6.1.0 | Stored procedures | New subscription/feature, webhook attempt, notification history/recipient, localization, and customer-delete procedures; targeted alters across accounts, customers, gateways, data messages, and external subscriptions. |
Version 3.6.0.0
| Version | Change | Description |
|---|---|---|
| 3.6.0.0 | CustomerPreference (new table) | Per-customer preference storage (Name , Value , PreferenceGroup , DisplayName ) with FK to Customer . |
| 3.6.0.0 | System email queue (new tables) | SystemEmailContent (templates) and SystemEmail (outbound queue with retry/status) for platform-generated emails. |
| 3.6.0.0 | Account Tags | Adds optional Tags on Account for labeling/search. |
| 3.6.0.0 | PreferenceType typing | Adds DefaultValue and ValueType so preferences can declare typed defaults. |
| 3.6.0.0 | Sensor read-config flags | Adds ReadGeneralConfig1–3 and ReadProfileConfig1–2 so the platform can request refreshed sensor configuration blocks. |
| 3.6.0.0 | Notification action capability flags | Adds HasUserNotificationAction , HasControlAction , HasLocalAlertAction , HasSystemAction , HasThermostatAction to describe which action types a notification supports. |
| 3.6.0.0 | AccountTheme dashboard / push | Adds EnableDashboard and AllowPushNotification . |
| 3.6.0.0 | Gateway StartDate | Adds StartDate (default UTC now) for gateway lifecycle tracking. |
| 3.6.0.0 | Customer mobile / push fields | Adds OverviewThemeID , AllowPushNotification , MobileDeviceId , MobileDeviceName , MobileDeviceType . |
| 3.6.0.0 | MaintenanceWindowCustomer tracking | Adds CreateDate , ModifiedDate , Status , AttemptCount for maintenance notification delivery tracking. |
| 3.6.0.0 | AuditLog expansion | Adds AccountID and ActionDescription ; FK to Account . |
| 3.6.0.0 | ReportQuery Tags | Adds Tags for categorizing report queries. |
| 3.6.0.0 | ExportStatistics date range | Adds FirstMessageDate / LastMessageDate ; makes first/last message ID columns nullable. |
| 3.6.0.0 | AdvancedNotificationParameter Units | Widens Units to varchar(200) . |
| 3.6.0.0 | Application inserts | Thermocouple (86), UltrasonicRangerIndustrial (105), CO2 Meter (106), LightSensor (107), ThreePhasePowerMeter (108), ThreePhaseCurrentMeter (109), DwellTime (110). |
| 3.6.0.0 | CustomerPermissionType inserts | Customer Can Update Firmware, Reset Start Date, Support Advanced, Account View. |
| 3.6.0.0 | ConfigData – system email | Adds RunSystemEmailProcessing = True and SystemEmailProcessCount = 100. |
| 3.6.0.0 | Release note & DB version | Inserts release note; sets ConfigData.DBVersion to 3.6.0.0 . |
| 3.6.0.0 | Stored procedures | Adds preference/system-email/maintenance/subscription/account-tree helpers; refreshes core Enterprise procedures for dashboard, preferences, push/mobile, export dates, and maintenance customer status. |
| 3.6.0.0 | Functions | Rebuilds Util_AccountIDTree . |
Version 3.5.0.0
Major structural upgrade (detailed “Database Upgrade Notes” in Script2). No author/date stamp on the upgrade header.
| Version | Change | Description |
|---|---|---|
| 3.5.0.0 | DataMessage restructure | Adds DataMessageGUID and HasNote . Backfills uppercase GUIDs, migrates existing Note values into new DataMessageNote rows, sets HasNote , then drops Note and MessageID . Primary key becomes clustered (MessageDate, SensorID, DataMessageGUID) . |
| 3.5.0.0 | DataMessageNote (new table) | Stores multiple notes per data message (DataMessageNoteID , DataMessageGUID , CustomerID , NoteDate , Note , SensorID ) with primary key and foreign keys to Customer and Sensor . |
| 3.5.0.0 | GatewayMessage restructure | Adds GatewayMessageGUID , backfills GUIDs, drops GatewayMessageID , and changes the primary key to (ReceivedDate, GatewayID, GatewayMessageGUID) . |
| 3.5.0.0 | Sensor – last message & firmware fields | Adds LastDataMessageGUID (replacing MessageID-based last-message references). Also adds firmware/radio-related fields including SensorFirmwareID , SendFirmwareUpdate , GenerationType , StartDate , CrystalStartTime , DMExchangeDelayMultiple , SHID1 , SHID2 , CryptRequired , Pingtime , FirmwareUpdateInProgress , BSNUrgentDelay , UrgentRetries , ListenBeforeTalk , and related defaults. |
| 3.5.0.0 | Sensor – data type updates | SensorName → nvarchar(255) ; ReportInterval and ActiveStateInterval → decimal(18,4) . |
| 3.5.0.0 | Notification model expansion | Adds notification typing and linking columns (eNotificationType , CustomerToNotifyID , CanAutoAcknowledge , inactive device links, typed notification IDs, NotificationByTimeID ). Widens notification text fields for Unicode where applicable. New tables: NotificationTriggered , NotificationScheduleDisabled , NotificationByTime , ActionToExecute . |
| 3.5.0.0 | NotificationRecipient enhancements | Adds DelayMinutes , LastSentTime , and ActionToExecuteID (FK to ActionToExecute ) for delayed/action-based recipient behavior. |
| 3.5.0.0 | NotificationRecorded Unicode & delivery flags | Truncates content longer than 4000 characters, then changes NotificationContent from varchar(8000) to nvarchar(4000) so Unicode is supported (max length reduced). Adds local-alert style fields (LED , Buzzer , DisplayState ) plus retry fields (RetryCount , DoRetry ) and NotificationTriggeredID . |
| 3.5.0.0 | Gateway hardware / firmware columns | Adds Wi-Fi security mode, low-power force flag, housing, radio firmware update fields, and generation type. Interval columns moved to decimal(18,4) . |
| 3.5.0.0 | CSNet identity rebuild | Rebuilds CSNet so CSNetID is an identity column; adds ExternalAccessUntil and CreateDate . |
| 3.5.0.0 | SensorType & ReportParameterType rebuilds | Recreates these tables via temp tables so primary keys / identity behavior can be applied without discarding data. |
| 3.5.0.0 | MonnitApplication → Application rename | Renames MonnitApplication to Application and MonnitApplicationID to ApplicationID on Sensor, Notification, AccountThemeApplicationLink, SensorApplication, and related constraints—aligning naming with Enterprise themes. |
| 3.5.0.0 | Removed legacy features | Drops WeatherObservation , WeatherLocation , Language , StringTranslation , and Translation tables (and related procedures). Weather and the old translation stack are removed from the database. |
| 3.5.0.0 | AuditLog (new table) | Adds audit logging (AuditLogGUID , CustomerID , TimeStamp , ObjectID , AuditObject , AuditAction , Record ). |
| 3.5.0.0 | Account / AccountTheme / Customer | Account : AccountIDTree , IsCFRCompliant . AccountTheme : SMTP return path, subscription/maintenance/webhook notification toggles, password policy fields (MinPasswordLength , mixed/special/number requirements), DefaultPremiumDays , activity flags. Customer : SendSensorNotificationToCarrier . New AccountThemeContact table. |
| 3.5.0.0 | External data subscriptions | ExternalDataSubscription gains subscription type, HTTP POST flag, soft delete, and SendWithoutDataMessage . Attempts gain verb , message GUIDs, and body → varchar(max) . |
| 3.5.0.0 | Other schema adjustments | OutboundPacket : CSNetID , ProcessingTime . SensorGroup : CSNetID , ParentID . CustomerPermission : CanEdit . CreditSetting : CreditsAvailable . ReleaseNote : IsDeleted . AdvancedNotificationParameter : Units . GatewayType : PowerSourceID . Precision updates on map/location/power-source/exception-log columns. |
| 3.5.0.0 | AdvancedNotification SQL updates | In-place updates to advanced notification SQL scripts (IDs 1–10) so they use DataMessageGUID / sensor last-message joins instead of removed MessageID . |
| 3.5.0.0 | Trigger removed | Drops trigger AI_DataMessage before the DataMessage migration. |
| 3.5.0.0 | CustomerPermissionType inserts | Seeds permissions such as Unlock User, Sensor Group Edit, Notification Pause, Navigation View API, and Notification Can Acknowledge. |
| 3.5.0.0 | GatewayType inserts | Adds CGW3 cellular variants and USB Pro Service gateway types (IDs 22–28). |
| 3.5.0.0 | PowerSource updates/inserts | Renames and updates voltage curves; adds sources such as Ion CGWBattery, Lead Acid Cell, Local Alert, and Alta battery types; updates heartbeat minimums. |
| 3.5.0.0 | ScheduledTasks & ActionToExecute seed | Inserts subscription/maintenance/notification escalation/timed-notification tasks. Seeds ActionToExecute values: Acknowledge, Reset, Activate, Deactivate. |
| 3.5.0.0 | Application & SensorApplication inserts | Adds multiple application profiles (e.g. RPM, Control_2, Grid Eye, Thermostat, Resistance Delta, QTIP Temperature, and others) plus preset SensorApplication names. |
| 3.5.0.0 | TimeZone inserts | Adds additional Windows time zone rows for Europe, Asia, Americas, and Australia/Pacific. |
| 3.5.0.0 | ConfigData updates | Clears default firmware version keys; adds keys for external subscription threading, notification escalation, timed notifications, logging, BaseURL, MaxNetworkCount, etc. Note: Script3 sets DBVersion to 4.0.0.0 as written (likely a script quirk relative to the folder name 3.5.0.0). |
| 3.5.0.0 | Stored procedures – removed | Drops weather/translation procedures and performs a large drop/recreate across accounts, sensors, gateways, messages, notifications, subscriptions, and reporting. |
| 3.5.0.0 | Stored procedures – themes | Rewrites message/data procs for GUID keys; expands notification lifecycle (triggered/scheduled/recipient/retry); updates gateway/CSNet urgent traffic; updates external subscription and account/customer/reporting procs for the new schema. |
| 3.5.0.0 | Functions | Recreates helpers such as GetDatesByRange and account-tree utilities; adds split helpers; drops legacy MonnitIUtil_AccountIDTree . |
Appendix: Version folder → scripts
| Version | Scripts |
|---|---|
| 4.0.5.4 | Script1_TableInserts, Script2_StoreProcsFunctions |
| 4.0.5.3 | Script1_TableInserts, Script2_StoreProcsFunctions |
| 4.0.5.2 | Script1_TableInserts, Script2_StoreProcsFunctions |
| 4.0.5.0 | Script1_TableInserts, Script2_StoreProcsFunctions |
| 4.0.4.0 | Script1_TablesInserts |
| 4.0.3.4 | Script1_TablesInserts |
| 4.0.3.1 | Script1_TableInserts, Script2_StoreProcsFunctions |
| 4.0.3.0 | Script1_TablesInserts, Script2_StoreProcsFunctions |
| 4.0.2.1 | Script1_TablesInserts, Script2_StoreProcsFunctions |
| 4.0.2.0 | Script1_TablesInserts, Script2_StoreProcsFunctions |
| 4.0.1.6 | Script1_TablesInserts |
| 4.0.1.5 | Script1_TablesInserts, Script2_StoreProcsFunctions |
| 4.0.1.0 | Script1_TablesInserts, Script2_StoreProcsFunctions |
| 4.0.0.0 | Script1_TablesInserts, Script2_StoreProcsFunctions |
| 3.6.2.0 | Script2_Alter |
| 3.6.1.2 | Script2_Alter |
| 3.6.1.1 | Script2_Alter |
| 3.6.1.0 | Script2_Alter, Script3_Insert, Script4_StoredProcedure |
| 3.6.0.0 | Script2_Alter, Script3_Insert, Script4_StoredProcedure, Script5_Function |
| 3.5.0.0 | Script2_Alter, Script3_Insert, Script4_StoredProcedure, Script5_Functions |
Generated from Enterprise Configuration Utility upgrade installation SQL. For full install baseline schema, see ConfigData\Full Installation (4.0.5.4).