1 2 3 4 5
| SELECT 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 ) )
GROUP BY NY_ISMSC_CLASSES.CLASS_NAME, NY_OPERATIONS.DESCRIPTIONS, NY_DATA_TYPES.DISPLAY_STRING, NY_HOSTS.HOST_NAME, NY_STATISTICS_AGG_DATA.INSTANCE
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