Welcome < Tools < Reports

Reports

The reports tool can be used to pull information from the database about Activity and Missing Audio. A Missing Audio report can also be performed from the log by right-clicking a location in the log and selecting Missing Audio Report.

Click any area in this image for help

Click any area in this image for help

The Reports window is divided into two panes. The left pane shows the type of reports and the filtering options. The right pane shows the data based on the filtering used for the report. These reports can then be printed to the default printer. The data for the reports can also be copied to Excel for data manipulation, simply highlight the data needed in the right pane using SHIFT or CTRL keys then press CTRL+C to copy.

In this Topic: show/hideshow/hide

Activity

The Activity Report is used to view a report of Activity in Zetta. The Activity Report settings are located at the top section of the left report pane.

The Activity Report can be customized with the following options:

Preset - A Preset is a set of saved settings for the report. The Preset Setting allows the user to Create, Select, Save, Modify, Copy or Delete a Preset. Presets can be Private, Public or Public - Read Only. Hovering the mouse over the selected Preset will show the access of the Preset (Private, Public or Public - Read Only). Preset changes are captured in the Activity Reports with additional detail such as the name of the Preset that was changed, the user that made the change and date/time of the change. The following Toolbar buttons can be used to select and configure a Preset.

• Use the Preset drop-down to select a previously created Preset. The Presets drop-down is divided into sections My Presets and Public Presets. Users with the 'View Configuration' Admin Right will see a user name next to the Preset Name.
• Use the Reapply Preset button to refresh the setting back to the saved settings for the selected preset.
• Use the Save Preset button to open the Save Preset window to create and Save a Preset.
• Use the Advanced button to Modify, Copy or Delete a Preset.

Note: The Supervisor User and any user who has the 'View Configuration' Admin Right can modify/delete other users read only presets. When an account is deleted, all the private presets owned by that user will be deleted. Any Public and Public-Read Only Presets will remain and [Account Deleted] will be shown in the Preset name.

Start Date – A report can be pulled for dates going back as far as is set in the Configuration | Scheduled Maintenance Utility.

End Date – A report can be run up to the current day.

Report details

Any combination of the following report details can be added to the report. These fields allow multiple values:

Stations – The Stations drop-down can be used to select any Station, Background Recorder or Virtual Station. Optionally, use the Station Group drop-down to select the (All Stations) to have all the stations in Zetta included in the report. Simply type in the field to quickly select any station.

Station Groups - The Station Groups drop-down can be used to select a group of stations instead of selecting individual stations from the Station drop-down. Optionally, use the Station Groups to select (All Stations).

Computers – Using the Computers drop-down, any or all the configured computers can be added to the report.

Users – Using the Users drop-down, any or all of the configured users can be added to the report.

Activity Locations – Using the Activity Locations drop-down, any or all of the following locations can be added to the report.

• All Activity Locations - The All option shows all the activity for the selected station for the selected date range.
• Clocks – The Clocks option displays changes made to a clock. Stations that are integrated with GSelector will not show any information.
• Configuration - The Configuration option will note that a change has been made to the selected configuration window. However for the System Configuration window, the granularity is at the tab level.
• GPIO - The GPIO option displays changes made by the configured GPIO device. The Capture GPIO Activity in Reports option must be enabled, for each Computer, to view the GPIO activity for the devices on the computer. GPIO for External Splits is shown in the GPIO History window.

Note: When GPIO is selected for an Activity Location select (All Computers) in the Computers field.

• GSelector Log Import - The GSelector Log Import option displays changes made to a log when a user Regenerates the log from GSelector.
• GSelector Media Import - The GSelector Media Import displays information about assets that were imported from GSelector.
• Hot Keys – The Hot Keys option displays changes made in a Hot Keys bank.
• Licensing - The Licensing location displays events that have occurred with the licensing of Zetta.
• Log Editor – The Log Editor option display changes made to a log using the logs module, such as adding or skipping events.
• Log Import – The Log Import location displays information about events that have been imported into the log through GSelector^® or Selector/MC 15 stations.
• Macro Editor - The Macro Editor option displays the changes made to a Macro.
• Media Import –The Media Import Location displays information about assets that have been imported.
• Media Library – The Media Library location displays events that affected the assets in the Media Library Module.
• MetaDataCard - The MetaDataCard option displays changes made to the MetaData Cards of the assets in the Library Module.
• Mini-Log Editor - The Mini-Log location displays changes made in the MetaData Mini-Log.
• NexGen Voice Track Auto Load - The NexGen Voice Track Auto Load option displays the activity for the Voice Tracks that are auto loaded using Content Ingest.
• On-Air - The On-Air option displays any interaction with the On-Air module.
• Segue Editor^® - The Segue Editor location displays events that have taken place within the Segue Editor
• Sequencer – The Sequencer location displays event that have occurred with the sequencing of the log, such as starting and stopping events in the log.
• Show Editor - The Show Editor option displays any activity in the Shows Metadata.
• Site Replication - The Site Replication option displays any activity in the Site Replication Manager window.
• Stacks - The Stacks option displays any activity in the Stacks Module.
• Startup Manager - Shows information about the Startup Manager
• Unknown – not currently used
• Zetta^® - The Zetta option displays information about any Script updates that have been run.
• Zetta2GO - The Zetta2GO options displays changes made in Zetta2GO.
• Z-Player – The Z-Player option displays changes made in the Z-Player.

Activity Types –Using the Activity Types drop-down to select any or all of the following types can be added to the report

• All Activity Types - The All option shows all the activity types at the Activity Location for the selected station for the selected date range.
• AsBroadcast Activity – The As Broadcast activity are the events that played from the sequencer, Hot Keys, and stacks.
• Asset – The Asset Type report shows all the data that effects the changing or adding of assets in Zetta.
• General – General displays any event that does not fall under the following activity types, such as exception errors that may have occurred within Zetta.
• Log Event – The Log Event Type report show all the data that affects the events in the Log.
• Script Updates –The Script Updates Type displays the information about database scripts that have run during upgrades.
• Sequencer Activity – The Sequencer Activity Type displays any activity that affects only the sequencer, such as the sequencer role of changing from Idle to the Primary station sequencer.

Activity Sub Types - The Activity Sub Types displays what action happened in the Activity Type at the Activity Location.

Example: If a user adds an event to the Log using the On-Air module, the Activity Sub Type would be "LogEvent Added" with the Activity Type as "Log Event" in the Activity Location "On-Air".

Activity Report pane

After running a report, the following information is displayed in the top section of the right pane. These columns can be sorted, in ascending or descending order, by clicking the column heading. The columns can be remove and re-inserted as needed by right-clicking the heading and selecting the desired option. The following columns can be reorganized to fit the user’s needs and the data can be customized into a report using Custom Filtering and Grouping.

Date

Description

Changes

Activity Location

Activity Type

Activity Sub Type

Station

Computer

Username

Tracking ID

Device Name

Device Type

Event Name

Event Type

Signaling

The bottom section of the right pane of the activity report will show a full view of the changes information when an event is highlighted.

The report can then be printed to the default printer.

Pagination and Page Size Control

At the bottom of the results pane there is a Pagination control. There are three parts to this control which are described in separate sections below. The Records per page drop-down allows the user to control the number of rows of data that are displayed in the results. The default is 1000 rows of data. Use the drop-down to select from the possible options to increase or decrease the amount of data presented in the results pane. Optionally, select All to view all the results on one page. The Pagination provides a drop-down of the page numbers. The current page is indicated in the drop-down out of x number of pages. The arrows can be used to go to the Previous or Next page or the First and Last page. The results window will automatically refresh on selection of a new value. To the far right shows the record that is being viewed out of the total records for the page and the total records for the report.

Missing Audio Report

The Missing Audio Report will return assets that are missing the audio and assets with volume level set to 0%. The Missing Audio Report settings are in the middle section of the left report pane.

The Missing Audio Report can be customized with the following options:

Preset - A Preset is a set of saved settings for the report. The Preset Setting allows the user to Create, Select, Save, Modify, Copy or Delete a Preset. Presets can be Private, Public or Public - Read Only. Hovering the mouse over the selected Preset will show the access of the Preset (Private, Public or Public - Read Only). Preset changes are captured in the User Activity Reports with additional detail such as the name of the Preset that was changed, the user that made the change and date/time of the change. The following Toolbar buttons can be used to select and configure a Preset.

• Use the Preset drop-down to select a previously created Preset. The Presets drop-down is divided into sections My Presets and Public Presets. Users with the 'View Configuration' Admin Right will see a user name next to the Preset Name.
• Use the Reapply Preset button to refresh the setting back to the saved settings for the selected preset.
• Use the Save Preset button to open the Save Preset window to create and Save a Preset.
• Use the Advanced button to Modify, Copy or Delete a Preset.

Note: The Supervisor User and any user who has the 'View Configuration' Admin Right can modify/delete other users read only presets. When an account is deleted, all the private presets owned by that user will be deleted. Any Public and Public-Read Only Presets will remain and [Account Deleted] will be shown in the Preset name.

Start Date – A report can be pulled for dates going back as far as is set in the Configuration | Scheduled Maintenance Utility.

End Date – A report can be run up to the current day.

Report Details

Any combination of the following report details can be added to the report. These fields allow multiple values:

Stations – The Stations drop-down can be used to select any Station, Background Recorder or Virtual Station. Optionally, use the Station Group drop-down to select (All Stations) to have all the stations in Zetta included in the report. Simply type in the field to quickly select a station.

Station groups - The Station groups drop-down can be used to run the missing audio report for all stations in any Station Group.

Asset Types - Use the Asset Types drop-down to filter any asset type.

The missing Audio Report will display the following information in columns in the right pane, allowing the user to determine what day and hour of the log and asset was missing audio:

Date

Hour

Title

Artist

Type

External ID

Error

Simply double-click the asset in the right pane of the report to display the MetaData Card for the asset. These columns can be sorted, in ascending or descending order, by clicking the column heading and the Columns can be reorganized to fit the user’s needs. The data can be customized into a report using Custom Filtering and Grouping. The columns can be remove and re-inserted as needed by right-clicking the heading and selecting the desired option. The report can then be printed to the default printer.

Duplicate External IDs Report

The Duplicate External IDs Report can be run to look for duplicate ID's per Asset Type or Globally. The Duplicate External IDs Report will display the following information in columns in the right pane, allowing the user to determine which asset to edit and which asset will retain the current ID:

External ID

Title

Cut Name

Artist

Type

Simply double-click the asset in the right pane of the report that has the duplicate ID that needs changed, select the Extra tab in the metadata card and change the External ID to something unique. The columns can be removed and re-inserted as needed by right-clicking the heading and selecting the desired option. The columns can be reorganized to fit the user’s needs and the data can be customized into a report using Custom Filtering and Grouping.

Working in the Reports window

The following sections contain step-by-step instructions on how to use the Reports window.

In this Section: show/hideshow/hide

Create a Preset

1. Select Reports from the Tools menu.
2. Select the Save button from the Activity Report or Missing Audio Report Preset toolbar to open the Save Preset window.
   
3. Enter a Name
4. Select the Access to use (Private, Public or Public - Read Only).
5. Click the OK button to Create the Preset.
6. Select the Settings to use for the Report.
7. Click the Save button in the Preset Toolbar again.

Modify a Preset

1. Select Reports from the Tools menu.
2. Select an existing Preset from the Activity Report or Missing Audio Report.
3. Select the Modify Preset option in the Advanced button.
   
4. Change the Name
5. Change the selected the Access to (Private, Public or Public - Read Only).
6. Click the OK button to close the Modify Preset window.
7. Select the Settings to use for the Report.
8. Click the Save button in the Preset Toolbar.

Copy a Preset

1. Select Reports from the Tools menu.
2. Select an existing Preset from the Activity Report or Missing Audio Report.
3. Select the Copy Preset option in the Advanced button.
   
4. Change the Name
5. Change the selected the Access to (Private, Public or Public - Read Only).
6. Click the OK button to close the Copy Preset window.
7. Select the Settings to use for the Report.
8. Click the Save button in the Preset Toolbar.

Delete a Preset

1. Select Reports from the Tools menu.
2. Select an existing Preset from the Activity Report or Missing Audio Report.
3. Select the Delete Preset option in the Advanced button.
   
4. Click the OK button to close the Delete Preset confirmation window.

Create an Activity Report

1. Select Reports from the Tools menu.
2. Optionally, select an existing Preset from the Activity Report or Missing Audio Report.
3. Select the Start Date for the report.
4. Select an End Date.
5. Select the Station(s) to include in the report.
6. Optionally, select the Station Groups to include in the report.
7. Select the Computer(s) to include in the report.
8. Select the User(s) to include in the report.
9. Using the Activity Location drop-down select the locations for the report.
10. Using the Activity Type drop-down select the Activity Type to include in the report.
11. Using the Activity Sub Type drop-down select the Activity Sub Type to include in the report.
12. Click the Run Report button.

Create a Missing Audio Report

1. Select Reports from the Tools menu.
2. Optionally, select an existing Preset from the Activity Report or Missing Audio Report.
3. Select the Start Date for the report.
4. Select an End Date.
5. Select the Station(s) to include in the report.
6. Optionally, select the Station Groups to include in the report.
7. Using the Asset Type drop-down select the Assets to include in the report.
8. Click the Run Report button.

Run a Duplicate External IDs Report

1. Select Reports from the Tools menu.
2. Select Per Asset Type or Globally for the report.
3. Click the Run Report button.

Welcome < Tools < Reports