HP Neoview Release 2.4 Software - Manual (Page 72)

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_id,
count(*) as query_count
from NEO.HP_METRICS.ODBC_QUERY_STATS_V1
where statement_status = 'START'
group by 1, client_id
order by 1, client_id;
DATASOURCE1 CLIENT_ID 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
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
72 Examples and Guidelines for Creating Repository Queries