@vi4m I turn mysql generallog on , and get a sql like this: SELECT cmdb_ci
.id
, cmdb_ci
.created
, cmdb_ci
.modified
, cmdb_ci
.cache_version
, cmdb_ci
.uid
, cmdb_ci
.name
, `cmdb
ci.
business_service,
cmdb_ci.
technical_service,
cmdb_ci.
pci_scope,
cmdb_ci.
barcode,
cmdb_ci.
content_type_id,
cmdb_ci.
object_id,
cmdb_ci.
stat
e,
cmdb_ci.
status,
cmdb_ci.
type_id,
cmdb_ci.
zabbix_id,
cmdb_ci.
added_manuallyFROM
cmdb_ciINNER JOIN
cmdb_citypeON (
cmdb_ci.
type_id=
cmdb
_citype.
id) WHERE (
cmdb_ci.
state= 1 AND
cmdb_citype.
name` = 'Environment' )