Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Report inventory › Drug and Weapon Violations - Agency I (2026 YTD)
Co

Drug and Weapon Violations - Agency I (2026 YTD)

ConsolidateCJI
IBM Cognos Analytics report  ·  /Public Folders/Agency I/Incidents/Drug and Weapon Violations - Agency I (2026 YTD)
Definition
Source
Cognos 11.2 (Regional)
Object
Report
Owner
Shared
Data access
SQL query
Layout
List
Parameters
None
Tables
incident
Columns
i.agency_id, i.beat, i.incident_id, i.occurred_date, i.offense_code
Complexity
Simple
Formatting
Standard
Usage (12 months)
Runs
33
Users
32
Last run
9/30/2026 11:12 AM
Failures
2
Migration
Family
F008 Drug and Weapon Violations
Target
Paginated report
Wave
Wave 1
Validation
Match
Connector notes
  • Native SQL query read from the report specification.