TransactionalUserInfos
Get Transactional user info.
Table Specific Information
Only SELECT is supported for TransactionalUserInfos.
Select
There are filters supported server side for this view. This view will provide the details of current user.
SELECT * FROM TransactionalUserInfos
Columns
| Name | Type | Description |
| UserName | String | The username of the user (used for SMTP authentication). |
| CreatedAt | Datetime | The date and time that the user's Mandrill account was created as a UTC string in YYYY-MM-DD HH:MM:SS format. |
| PublicId | String | A unique, permanent identifier for this user. |
| Reputation | Integer | The reputation of the user on a scale from 0 to 100. |
| HourlyQuota | Integer | The maximum number of emails Mandrill will deliver for this user each hour. |
| Backlog | Integer | The number of emails that are queued for delivery due to exceeding your monthly or hourly quotas. |
| StatsTodaySent | Integer | The number of emails sent so far today. |
| StatsTodayHardBounces | Integer | The number of emails that hard bounced so far today. |
| StatsTodaySoftBounces | Integer | The number of emails that soft bounced so far today. |
| StatsTodayRejects | Integer | The number of emails rejected for sending so far today. |
| StatsTodayComplaints | Integer | The number of spam complaints received so far today. |
| StatsTodayUnsubs | Integer | The number of unsubscribes received so far today. |
| StatsTodayOpens | Integer | The number of times emails have been opened so far today. |
| StatsTodayClicks | Integer | The number of URLs that have been clicked so far today. |
| StatsTodayUniqueOpens | Integer | The number of unique opens so far today. |
| StatsTodayUniqueClicks | Integer | The number of unique clicks so far today. |
| StatsLast7DaysSent | Integer | The number of emails sent in the last 7 days. |
| StatsLast7DaysHardBounces | Integer | The number of hard bounces in the last 7 days. |
| StatsLast7DaysSoftBounces | Integer | The number of soft bounces in the last 7 days. |
| StatsLast7DaysRejects | Integer | The number of rejected emails in the last 7 days. |
| StatsLast7DaysComplaints | Integer | The number of spam complaints in the last 7 days. |
| StatsLast7DaysUnsubs | Integer | The number of unsubscribes in the last 7 days. |
| StatsLast7DaysOpens | Integer | The number of opens in the last 7 days. |
| StatsLast7DaysClicks | Integer | The number of clicks in the last 7 days. |
| StatsLast7DaysUniqueOpens | Integer | The number of unique opens in the last 7 days. |
| StatsLast7DaysUniqueClicks | Integer | The number of unique clicks in the last 7 days. |
| StatsLast30DaysSent | Integer | The number of emails sent in the last 30 days. |
| StatsLast30DaysHardBounces | Integer | The number of hard bounces in the last 30 days. |
| StatsLast30DaysSoftBounces | Integer | The number of soft bounces in the last 30 days. |
| StatsLast30DaysRejects | Integer | The number of rejected emails in the last 30 days. |
| StatsLast30DaysComplaints | Integer | The number of spam complaints in the last 30 days. |
| StatsLast30DaysUnsubs | Integer | The number of unsubscribes in the last 30 days. |
| StatsLast30DaysOpens | Integer | The number of times emails have been opened in the last 30 days. |
| StatsLast30DaysClicks | Integer | The number of URLs that have been clicked in the last 30 days. |
| StatsLast30DaysUniqueOpens | Integer | The number of unique opens in the last 30 days. |
| StatsLast30DaysUniqueClicks | Integer | The number of unique clicks in the last 30 days. |
| StatsLast60DaysSent | Integer | The number of emails sent in the last 60 days. |
| StatsLast60DaysHardBounces | Integer | The number of hard bounces in the last 60 days. |
| StatsLast60DaysSoftBounces | Integer | The number of soft bounces in the last 60 days. |
| StatsLast60DaysRejects | Integer | The number of rejected emails in the last 60 days. |
| StatsLast60DaysComplaints | Integer | The number of spam complaints in the last 60 days. |
| StatsLast60DaysUnsubs | Integer | The number of unsubscribes in the last 60 days. |
| StatsLast60DaysOpens | Integer | The number of times emails have been opened in the last 60 days. |
| StatsLast60DaysClicks | Integer | The number of URLs that have been clicked in the last 60 days. |
| StatsLast60DaysUniqueOpens | Integer | The number of unique opens in the last 60 days. |
| StatsLast60DaysUniqueClicks | Integer | The number of unique clicks in the last 60 days. |
| StatsLast90DaysSent | Integer | The number of emails sent in the last 90 days. |
| StatsLast90DaysHardBounces | Integer | The number of hard bounces in the last 90 days. |
| StatsLast90DaysSoftBounces | Integer | The number of soft bounces in the last 90 days. |
| StatsLast90DaysRejects | Integer | The number of rejected emails in the last 90 days. |
| StatsLast90DaysComplaints | Integer | The number of spam complaints in the last 90 days. |
| StatsLast90DaysUnsubs | Integer | The number of unsubscribes in the last 90 days. |
| StatsLast90DaysOpens | Integer | The number of times emails have been opened in the last 90 days. |
| StatsLast90DaysClicks | Integer | The number of URLs that have been clicked in the last 90 days. |
| StatsLast90DaysUniqueOpens | Integer | The number of unique opens in the last 90 days. |
| StatsLast90DaysUniqueClicks | Integer | The number of unique clicks in the last 90 days. |
| StatsLastAllTimeDaysSent | Integer | The total number of emails sent through the account. |
| StatsLastAllTimeDaysHardBounces | Integer | The total number of hard bounces for the account. |
| StatsLastAllTimeDaysSoftBounces | Integer | The total number of soft bounces for the account. |
| StatsLastAllTimeDaysRejects | Integer | The total number of rejected emails for the account. |
| StatsLastAllTimeDaysComplaints | Integer | The total number of spam complaints for the account. |
| StatsLastAllTimeDaysUnsubs | Integer | The total number of unsubscribes for the account. |
| StatsLastAllTimeDaysOpens | Integer | The total number of times emails have been opened for the account. |
| StatsLastAllTimeDaysClicks | Integer | The total number of URLs that have been clicked for the account. |
| StatsLastAllTimeDaysUniqueOpens | Integer | The total number of unique opens for the account. |
| StatsLastAllTimeDaysUniqueClicks | Integer | The total number of unique clicks for the account. |