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