The JasperServer thinks SRM Multitenancy is enabled, hence it is adding the following in the MySQL query: m.tenant_id=NULL
select distinct gc.gc_rec_ID, gc.gc_name from globalcollection gc inner join model m on m.mtype_h=66676 and m.model_name=gc.gc_name and m.tenant_id=NULL ORDER BY gc_rec_ID DESC;
SELECT
outagetype.outage_desc,
entity.entity_id,
entity.entity_name,
outagetype.outage_type as Outage_outage_type,
devicemodel.IP,
vendor.vendor_name,
devicemodel.device_type,
modeloutage.end_time,
modeloutage.start_time,
modeloutage_notes.notes,
modeloutage.outage_type as ModelOutage_outage_type,
devicemodel.model_h
FROM reporting.entity entity INNER JOIN reporting.devicemodel devicemodel ON entity.current_model_key=devicemodel.model_key and tenant_id=null AND entity_id IN ('25121') LEFT OUTER JOIN reporting.modeloutage modeloutage ON entity.current_model_key=modeloutage.model_key AND ((modeloutage.start_time IS NULL ) OR (modeloutage.outage_type=0) OR (modeloutage.start_time<'2019-03-01 00:00:00' AND ((modeloutage.end_time IS NULL ) OR (modeloutage.end_time>'2019-03-07 10:48:59.236000'))) OR ((modeloutage.start_time>='2019-03-01 00:00:00' AND modeloutage.start_time<'2019-03-07 10:48:59.236000')) OR ((modeloutage.end_time>='2019-03-01 00:00:00' AND modeloutage.end_time<'2019-03-07 10:48:59.236000'))) INNER JOIN reporting.vendor vendor ON devicemodel.vendor=vendor.vendor
LEFT OUTER JOIN reporting.outagetype outagetype ON modeloutage.outage_type=outagetype.outage_type LEFT OUTER JOIN reporting.modeloutage_notes modeloutage_notes ON modeloutage.model_outage_ID=modeloutage_notes.model_outage_ID
ORDER BY entity.entity_id, modeloutage.start_time;