执行下列SQL脚本就可以了
SELECT ywly_l.FNAME AS 业务领域,
ywly_l.FTOOLTIPS AS 业务领域描述,
zxt.FNUMBER AS 子系统编码,
zxt_l.FNAME AS 子系统名称,
zxt_l.FDESCRIPTION 子系统描述,
bb.FNUMBER AS 报表编码,
bb_l.FNAME AS 报表名称
FROM T_SEC_PERMISSIONOBJECT bb
LEFT JOIN T_SEC_PERMISSIONOBJECT_L bb_l ON bb_l.FITEMID = bb.FITEMID
LEFT JOIN T_META_SUBSYSTEM zxt ON zxt.FID = bb.FSUBSYSTEMID
LEFT JOIN T_META_SUBSYSTEM_L zxt_l ON zxt_l.FID = zxt.FID
AND zxt_l.FLOCALEID = 2052
LEFT JOIN T_META_TOPCLASS_L ywly_l ON ywly_l.FTOPCLASSID = zxt.FTOPCLASSID
AND ywly_l.FLOCALEID = 2052
WHERE bb.FISSYSPRESET = 0--0 为非系统预设如果要看系统预设请改为 1 ;
----------------------------------------------------------------------------------------------------------------------
注意:查出来的结果不只是报表,还包括其它业务对象(下图),我是导到EXCEL中筛选来得到自己想要的结果的。