Active users last month
SQL query for Zenvoices
Count the number of active users in the last month.
SELECT COUNT(*) FROM user_details WHERE last_login_date >= DATE_SUB(NOW(), INTERVAL 1 MONTH)
Zenvoices data model
Administrations
Administration Details
Financial Transactions
Financial Transaction Details
Users
User Details
Available Accountingsystem Connectors
Webhook Subscriptions
Available Webhooks
Purchaseorders
Products
Employees
Fiscalperiods
Paymentconditions
Commitments
Projects
Projectitems
Projectstages
Taxcodes
Taxscenarios
Currencies
Costunits
Costcentres
Allocationcodes
Ledgeraccounts
Accounts
Country
Inbox
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed