1 Year Logs | Main | Dashboard | Grid | Ledger |   |

FrontierDataWarehouse  ACORN Script

IF EXISTS ( SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%')) SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%') ORDER BY dmria.PushAlerts DESC, dmria.Priority DESC, dmria.TenantName ASC ELSE SELECT 0 AS Total_Rows

1 Record. View by Lookup

990100017161 10232810 ❖  Mono Rama.. 0

Alive

Total Recharge

Averages

Replacement Tokens

Last Recharge

DLM

Hist

FBU

More

Updated

Risk

Alert

Priority

Flow

Events

Logs

Coms

Commands

Balances

Mths

Days

Units

Qty

Value

Amt

Daily Units

Freq

Monthly

Units

Qty

Value

Date

Days Since

Closing Mths

3

0

??

0

0

0

0

0

0.00

0

0

0.00

0

0

0

1900-01-01

46111

2026-03-31

0

ID 367672 BillingType 1 StockID 4889300 MeterSerialNumber 990100017161 MeterKey 4811057 TenantID 527819 TenantNumber 10232810 TenantName Mono Rama ShowIt True Priority 0 PremisesDescription House Upscale SizeSquareMeters 85 Rooms 6 Occupants 7 AmpsRating 100 DistributionBoard Outside InstallationType Standard ReplacedMeterNumber SiteRank_COT CCC DemographicComment Respected family TenantTel1 999 888 7777 TenantTel2 TenantTel3 TenanteMail monorama@msn.com HigherPrincipalName Mono Test P1 HigherPrincipalNumber 77001774 HigherPrincipalID 540957 Sector IP TenantJoinedDate 2020-12-10 MeterAllocationDate 2020-12-10 UtilityType Electricity ContractorInstalled ContractorCurrent MeterModel Enertrak Three phase ModelClass Three Phase ReportsConsumption 1 DateLastInspected 1900-01-01 DateInspectionDue 1900-01-01 DaysMeterActive 0 MonthsMeterActive 0 MonthsTenantActive 64 BenchmarkProfile 2 AlertScore 3 PushAlerts False PushAlertsText PushAlertSource 0 LastClosingMonth 2026-03-31 LastClosingMonthHeader 2026-03-31 LastFBUunits 0 LastFBUValue 0.00 LastFBUDate 1900-01-01 ThirtyFBUunits 0 ThirtyFBUValue 0.00 SixtyFBUunits 0 SixtyFBUValue 0.00 NinetyFBUValue 0.00 AveUnitsPerDay 0 AvgHRechargeAmount 0.00 AvgHRechargeFrequency 0 AvgHRechargeMonthly 0.00 StDevHRechargeAmount 0 StDevHRechargeFrequency 0 StDevHRechargeMonthly 0 TwelveMonthHigh 0.00 TwelveMonthLow 0.00 TradingRange 0 DaysActiveLessTradingRange 1938 LastUpdated 4/1/2026 3:57:52 AM CurrentRechargeUnits 0 CurrentRechargeQty 0 CurrentRechargeValue 0 CurrentRechargeAvgHDaily 0 CurrentRechargeAvgHMonthly 0 ThirtyRechargeUnits 0 ThirtyRechargeQty 0 ThirtyRechargeValue 0 ThirtyRechargeAvgHDaily 0 ThirtyRechargeAvgHMonthly 0 SixtyRechargeUnits 0 SixtyRechargeQty 0 SixtyRechargeValue 0 SixtyRechargeAvgHDaily 0 SixtyRechargeAvgHMonthly 0 NinetyRechargeUnits 0 NinetyRechargeQty 0 NinetyRechargeValue 0 NinetyRechargeAvgHDaily 0 NinetyRechargeAvgHMonthly 0 OneTwentyRechargeUnits 0 OneTwentyRechargeQty 0 OneTwentyRechargeValue 0 OneTwentyRechargeAvgHDaily 0 OneTwentyRechargeAvgHMonthly 0 OneFiftyRechargeUnits 0 OneFiftyRechargeQty 0 OneFiftyRechargeValue 0 OneFiftyRechargeAvgHDaily 0 OneFiftyRechargeAvgHMonthly 0 OneEightyRechargeUnits 0 OneEightyRechargeQty 0 OneEightyRechargeValue 0 OneEightyRechargeAvgHDaily 0 OneEightyRechargeAvgHMonthly 0 BMDiffRechargeUpValue 0 BMDiffRechargeDownValue 0 BMDiffMonthlyUpValue 0 BMDiffMonthlyDownValue 0 BMMonthlyHighValue 0 BMMonthlyLowValue 0 BMDiffRechargeUpScore 0 BMDiffRechargeDownScore 0 BMDiffMonthlyUpScore 0 BMDiffMonthlyDownScore 0 BMMonthlyHighScore 0 BMMonthlyLowScore 3 BMStDevHRechargeAmountScore 0 BMStDevHRechargeFrequencyScore 0 BMStDevHRechargeMonthlyScore 0 BMNonRechargeDaysScore 0 BMNonRechargeDaysValue 0 BMCommunicationAbsence False BMAveUnitsPerday 0 LastOpenLog 243856 FrequencyAUpdated Apr 1 2026 3:57AM FrequencyANextUpdate Apr 2 2026 3:57AM FrequencyMUpdated FrequencyMNextUpdate LastContactDate 1900-01-01 CommunicationAbsenceDays 46111 TenantOccupied 1 TenantEntryDate 2020-12-10 TenantExitDate 1900-01-01 TenantKey 534629 MeterBalance MeterBalanceUnits Killowatts MeterBalanceType 1 MeterBalanceDate 4/1/2026 3:48:45 AM AccountBalance 0 AccountBalanceDate 4/1/2026 3:48:45 AM TimezoneUTCOffset 2 Flow 1 MeterCommandSubmissionEntry MeterCommandLastStatus 0 TotalRechargeUnits 0 TotalRechargeQty 0 TotalRechargeValue 0 ReplacementTokenUnits 0 ReplacementTokenQty 0 ReplacementTokenValue 0 DifferenceFromLastMonth 0 MeterFirstRechargeDate 1900-01-01 MeterLastRechargeDate 1900-01-01 TenantFirstRechargeDate 1900-01-01 TenantLastRechargeDate 1900-01-01 DaysSinceLastRecharge 46111 LastRechargeUnits 0 LastRechargeValue 0.00 Notes Lowered historical monthly usage TamperEventSnooze 1900-01-01 TamperEventAwake TamperEventSeverity Negligible TamperEventDate TamperEventCount 0 TamperEventOffset 0 TamperEventOffsetDate TamperEventNet 0 CreditEventSnooze 1900-01-01 CreditEventAwake CreditEventSeverity Negligible CreditEventDate CreditEventCount 0 CreditEventOffset 0 CreditEventOffsetDate CreditEventNet 0 GridEventSnooze 1900-01-01 GridEventAwake GridEventSeverity Negligible GridEventDate GridEventCount 0 GridEventOffset 0 GridEventOffsetDate GridEventNet 0 MeterEventSnooze 1900-01-01 MeterEventAwake MeterEventSeverity Negligible MeterEventDate MeterEventCount 0 MeterEventOffset 0 MeterEventOffsetDate MeterEventNet 0 LoadEventSnooze 1900-01-01 LoadEventAwake LoadEventSeverity Negligible LoadEventDate LoadEventCount 0 LoadEventOffset 0 LoadEventOffsetDate LoadEventNet 0 BreakerEventSnooze 1900-01-01 BreakerEventAwake BreakerEventSeverity Negligible BreakerEventDate BreakerEventCount 0 BreakerEventOffset 0 BreakerEventOffsetDate BreakerEventNet 0

 

IF EXISTS ( SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%')) SELECT COUNT(*) OVER () AS Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey = dbo.FN_MerchantKey('99887775') AND (dmria.MeterSerialNumber LIKE '%10232810%' OR dmria.TenantNumber LIKE '%10232810%' OR dmria.TenantName LIKE '%10232810%' OR dmria.HigherPrincipalName LIKE '%10232810%') ORDER BY dmria.PushAlerts DESC, dmria.Priority DESC, dmria.TenantName ASC ELSE SELECT 0 AS Total_Rows