Vista's Annual Required Data

Could you help me pull a quick metric for an internal request?

We need the total number of active customer users on the Resilinc portal as of Dec 31, 2025.

Please apply the following criteria when calculating the count:

Definition of Active Customer Users
• The customer organization must be active on the portal
• The user must be registered and the account must currently be active (inactive/disabled users should be excluded)
• The user must have logged in at least once during the customer’s tenure

For reference, using the same criteria, the count as of Dec 31, 2024 was 6,860 users.

Could you please pull the Dec 31, 2025 number using the same definition?

If possible, it would also be helpful to include:
• Total number of active customers
• Total active users
• Any notes on how the query was run, so we can reproduce it next year.

Let me know if anything is unclear. I need this for Vista’s annual data request.

Thanks.

=> Queries to be used:

select distinct up.id,up.tenant_id,up.user_anchor_id from user_private up join user_login_history uh 

on uh.user_anchor_id=up.user_anchor_id and up.tenant_id=uh.tenant_id

where up.registered=true and up.active=true and up.onboarding_date<='2025-12-31'

and up.tenant_id in (select tenant_id from msa where msa_end_date>=now() and is_demo=false)

and up.is_deleted=false and uh.is_deleted=false

and up.user_anchor_id in(select user_anchor_id from user_shareable where email not like '%%@resilinc.ai%%' and email not like '%%@resilinc.com%%') 

select msa.*,t.tenant_name from msa join tenant t on t.id=msa.tenant_id

where msa_end_date>=now() and msa.is_demo=false

(Removed Demo, Test, Internal Orgs)

select count(distinct user_anchor_id) from user_private where active=true and user_anchor_id in(select user_anchor_id from user_shareable where email not like '%%@resilinc.ai%%' and email not like '%%@resilinc.com%%') 

and is_deleted=false and tenant_id in (select tenant_id from msa where msa_end_date>=now() and is_demo=false)