Reports DRAFT
The report page provides Power BI based reporting dashboards that populate data related to the partner or reseller and to the resellers and customers they manage.
Viewing and analyzing the data on the reports assumes some familiarity with Power BI.
The following data and visualizations are available and examples of the dashboards are shown below:
- Screen version map
- Screen version detail
- Rooms
- Calendar services
- Users
- RFID
- Licenses
- Companies
- Customer room summary
- Activations
- Account dashboard
- oAuth migration
- Device auth history
- Device logs
Screen version map

The treemap chart can help to visualize the number of devices running specific firmware versions. The specific count data is displayed below the chart.
Screen version detail

The screen version detail report shows information for each Condeco device and can be filtered by device type and/or release channel, from the panel on the right of the page.
The following columns are displayed in the report:
- Accounts.CompanyName
- Rooms.Name
- Content.hardwaretype
- firmware
- application
- ReleaseChannel
- releasedVersion
- Heartbeat
- Calendar
- Content.dateofreport
- Devices.RoomId
- Content.deviceidentifier
Rooms

The following columns are displayed in the rooms report:
- Accounts.CompanyName
- OperatingMode
- Name
- Mailbox
- Status
- CalendarServices.Type
- ScreenSettings
- LicenceId
- Floors.Name
- Floors.Locations.LocationName
- Floors.Locations.Building
- Floors.Locations.Country:
- Floors.Locations.TownOrCity
- RoomId
Calendar services

The calendar services report can be filtered by the calendar service type and/or by company name.
The following columns are displayed in the report:
- Accounts.CompanyName
- OperatingMode
- CalendarServices.Type
- CalendarServiceId
- Count of RoomId
- CalendarServices.Settings.2
- CalendarServices.Settings.4
Users

The following columns are displayed in the users report:
- Accounts.CompanyName
- EmailAddress
- FirstName
- LastName
- Role
- Status
- UserPin
- IdentityProviderUuid
RFID

The following columns are displayed in the RFID report:
- RegisteredUsers.FirstName
- RegisteredUsers.LastName
- RegisteredUsers.EmailAddress
- RfidTag
- RegisteredUsers.Account_AccountId
Licenses

The following columns are displayed in the licenses report:
- Accounts.CompanyName
- LicenceId
- LicenceCount
- LicenceAvailable
- Year
- Quarter
- Month
- Day
- LicenceType
- Grace
- ExternalKeyMappings.ExternalKey
Companies

The following columns are displayed in the companies report:
- Account_AccountId
- Accounts.CompanyName
- Accounts.Status
- FirstName
- LastName
- JobTitle
- EmailAddress
- MobilePhoneNumber
- Addresses.Country
- Addresses.TownOrCity
Customer room summary

The following columns are displayed in the customer room summary report:
- AccountsCompanyName
- CalendarServices.Type
- OperatingMode
- Count of RoomId
Activations

The activations chart shows the number of devices activated each month by calendar service type.
Account dashboard

The following charts are displayed on the account dashboard:
- Devices by Release Channel
- Devices by Current Version
- Devices by Released Version
- Devices Responding
The following columns are displayed on the account dashboard:
- Company Name
- Room Name
- Device Type
- Channel
- Release Type
- Released Version
- Current Firmware
- Current Application
- Last Seen
- Date of Report
- DeviceId
- Room Id
oAuth migration

The following charts are displayed on the oAuth migration dashboard:
- Count of RoomId by Company
- Devices by AuthType
- Devices by AuthStatus
The following columns are displayed on the oAuth migration dashboard:
- CompanyName
- Room Name
- AuthType
- AuthStatus
- Last Seen
- CalendarLastSeen
- Date of Report
- LastInteractionTime
- Current Firmware
- CalendarServiceName
- ExchangeType
- Service Account
- ExchangeUrl
- RoomId
- DeviceId
Device auth history

The following columns are displayed in the device auth history report:
- RoomName
- TimeStamp
- PreviousAuthState
- CurrentAuthState
- PreviousAdditionalAuthData
- CurrentAdditionalAuthData
- DeviceId
Device logs

The following columns are displayed in the device logs report:
- DateTime
- LogLevel
- Room Name
- Log
- DeviceId
- Room Mailbox
- Firmware Version
- App Version
