Neoview Repository User Guide (R2.4 SP1)

count(*) as query_count
from NEO.HP_METRICS.QUERY_STATS_VW1
where query_status = 'COMPLETED'
group by datasource, client_name
order by datasource, client_name;
DATASOURCE
CLIENT_NAME QUERY_COUNT
--------------------------------------------------------------------------------------------------------------------------------
----------------- --------------------
RIBE_FIN
NWESTABX-DC76C 1
RR
FENSTERM-DC76C 6593
RR
fensterm-dc76c 1476
JDI_REPOS
TXNROGERSOJ-P2 59
Smart_JLverne
TXNJLVERNE1 2
TDM_Default_DataSource
REVSTADTBR 2629
TDM_Default_DataSource
REVKAZUKO 16
TDM_Default_DataSource
TXNLAZLON-DC76 86
TDM_Default_DataSource
FENSTERM-DC76C 20121
TDM_Default_DataSource
golden.fargo.c 20
TDM_Default_DataSource
chiarp-d530u 27
TDM_Default_DataSource
vleemgar-dc76 2548
TDM_Default_DataSource
vleemgar-dc76c 9
TDM_Default_DataSource
nwestabx-dc76c 186
TDM_Default_DataSource
pdict 3
TDM_Default_DataSource
watanabe.fargo. 9994
TDM_Default_DataSource
rstein-xp 31
TDM_Default_DataSource
saxonyw-dc76c 102
TDM_Default_DataSource
tanakas.fargo.c 825
TDM_Default_DataSource
darius-d530 22
smart_msaccess
REVSTADTBR 98
Minor formatting of the columns can yield a more readable result:
select [first 10]
left (datasource, 25) as datasource1,
client_name,
count(*) as query_count
from NEO.HP_METRICS.QUERY_STATS_VW1
where query_status = 'INIT'
group by 1, client_name
order by 1, client_name;
DATASOURCE1 CLIENT_NAME QUERY_COUNT
------------------------- ----------- ---- --------------------
RIBE_FIN NWESTABX-DC76C 1
RR FENSTERM-DC76C 6607
RR fensterm-dc76c 1476
JDI_REPOS TXNROGERSOJ-P2 61
Smart_JLverne TXNJLVERNE1 2
TDM_Default_DataSource REVSTADTBR 2629
TDM_Default_DataSource REVKAZUKO 16
TDM_Default_DataSource TXNLAZLON-DC76 86
TDM_Default_DataSource FENSTERM-DC76C 20121
TDM_Default_DataSource golden.fargo.c 20
TDM_Default_DataSource chiarp-d530u 27
TDM_Default_DataSource vleemgar-dc76 2548
TDM_Default_DataSource vleemgar-dc76c 9
TDM_Default_DataSource nwestabx-dc76c 186
TDM_Default_DataSource pdict 3
Formatting Techniques to Enhance Readability of Query Output 85