1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SELECT DISTINCT
NY_HOSTS.HOST_NAME,
NY_ISMSC_CLASSES.CLASS_NAME,
NY_STATISTICS_AGG_DATA.INSTANCE,
NY_OPERATIONS.DESCRIPTIONS,
NY_DATA_TYPES.DISPLAY_STRING
FROM SM_STATISTICS.NY_DATA_TYPES NY_DATA_TYPES,
OMAP_CONFIG.NY_HOSTS NY_HOSTS,
OMAP_CONFIG.NY_ISMSC_CLASSES NY_ISMSC_CLASSES,
SM_STATISTICS.NY_OPERATIONS NY_OPERATIONS,
SM_STATISTICS.NY_STATISTICS_AGG_DATA NY_STATISTICS_AGG_DATA
WHERE ( ( NY_DATA_TYPES.TYPE_ID = NY_STATISTICS_AGG_DATA.DATA_TYPE_ID ) AND
( NY_HOSTS.HOST_ID = NY_STATISTICS_AGG_DATA.HOST_ID ) AND
( NY_ISMSC_CLASSES.CLASS_ID = NY_STATISTICS_AGG_DATA.CLASS_ID AND
NY_ISMSC_CLASSES.GROUP_ID = NY_STATISTICS_AGG_DATA.GROUP_ID ) AND
( NY_OPERATIONS.CLASS_ID = NY_DATA_TYPES.CLASS_ID AND
NY_OPERATIONS.OPERATION_ID = NY_DATA_TYPES.OPERATION_ID ) )
ORDER BY NY_HOSTS.HOST_NAME,
NY_ISMSC_CLASSES.CLASS_NAME,
NY_STATISTICS_AGG_DATA.INSTANCE,
NY_OPERATIONS.DESCRIPTIONS,
NY_DATA_TYPES.DISPLAY_STRING |
Partager