Query measure data from performace warehouse
Hi Team,
We are developing a report for SLA measurement.
We have developed a measure to capture response time based on starting page and ending page.
We are able to capture response time , but its getting aggregated and we also want to capture following data for each transaction :
- Date and Time
- Bytes transferred
- HTTP status code
- Response time
- Starting URL and Ending URL
- Button name
Hence could you please let us know if we can extract these data from performace warehouse?
We are using postgreSQL 9.3 as performance warehouse.
Thanks,
Ashwin
Hi. We dont store that data in the performance warehouse. we only store time series data but no button names.
Also - if your requirement is to report on every single individual User Action you will not be happy with our 10s aggregate. In this case you have two options
a) query the raw User Actions on a regular interval through our Reporting REST Interface
b) PREFERRED OPTION: use our Real Time Business Transactions Feed. With this you can define a BT that includes all the information you need - including the Button Name as a Split Value. This BT will be configured to not store data in the performance warehouse - BUT - push out details for every User Action to an external data source, e.g: Splunk or other BI Tools
Andi
Hi Andreas,
Thanks for the options.
can we write data into a excel or csv file through Real time business transactions feed.
That would solve our problem. Please suggest.
Thanks,
Ashwin
