I am trying to display the username from the business transaction "login". I need the output as UserName but what I see is something like this - orgadmin;IE 10.0;192.168.71.0;Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0).
Can someone please tell me how to change this. I tried changing the splittings in my business transaction but that didn't seem to work.
Answer by PTC S. ·
That worked perfectly. Thanks a lot for the solution. The problem was I had not selected the option "no restriction"
I have one more question. Is there any way by which I can change the name of the column "splittings" to something else. The client got a littile confused with the column name splittings.
Answer by PTC S. ·
I am trying to display top 10 users from this BT which I have added in the dashlet filter. So my requirement is to see just the user name.
Then yes, please remove the other splittings, set splitting options to no restriction, and turn off the storage to the performance warehouse. Optionally just create a new BT as I describe, so you don't have the old data which includes the web request details, as this will still be there for the time before you change the configuration.
Hope that helps,
Rick B
Answer by Rick B. ·
Hi,
The string you have is the list of relevant splittings you've selected, semi-colon delimited. If you only want to see the username, take out the other splittings for Browser, Client IP, and Agent. Also please ensure that "splitting options" at the bottom of the screen is set to "no restriction" so the new entries don't go into the "<...> bucket instead of a meaningful splitting.
A very important change to make here is to turn off storage in the performance warehouse. This is because the number of unique logins will cause a lot of space and read/write operations, causing the DT database to slow down.
By the way, what are you trying to accomplish with this BT? A certain dashboard, or the search feature or something?
Rick B
JANUARY 15, 3:00 PM GMT / 10:00 AM ET