Is there any way to use wild characters in CEM Export tool?
Especially, we would like to use command number 5 to produce an output on business services used by ALL user groups.
You can do this indirectly (wildcards). What I used to do was build a Windows Bat or UNIX Shell file that would take command line arguments and pass to the export command line
Report Option 5 for all User Groups:
The Java code/SDK is available for you to modify as you see fit. Some customers have done this with great success.
Option 1 : Get all business process (business service) statistics data in a time range. is a rough equivalent of what you want.
You could submit an enhancement. But this has not been updated in 7 years. So unlikely to happen.
You may ask follow-up questions but that is the essential answer
Ordinarily I would say to escape the character, but not sure if it can use regex.
Adding Hallett_German and JMertin for more info
Instead of trying to re-write the CEM Export tool for this I just wrote a quick perl query as follow:
my $sth = $dbh->prepare("select b.ts_name, c.ts_name, a.ts_total_transactions, a.ts_bad_transactions FROM ts_st_tsgrp_usgrp_mly_20161201 a, ts_transet_groups b, ts_user_groups c WHERE (a.ts_transet_group_id = b.ts_trandef_group_id AND a.ts_usergroup_id = c.ts_id)");
It gave me the report I wanted....
Retrieving data ...