How can I create a table with different fields from different events?
Naveen
After we process a client file, we get event in splunk as shown in below snapshot.
From these events I want to build a table something like below.
Can someone please help?
Naveen
I have used below query to generate expected dashboard.
source="sc-.log*" AND SMARTCONNECT_TRANSACTION_RESULT |stats values(CLIENT_ID) as "Client Name" values(ERP_WP_PAYSTATEMENTS) as "Paystatements from ERP" values(CDM_WP_PAYSTATEMENTS) as "Paystatements in CDM" values(CDM_EE_LIEN_COUNT) as "Liens in CDM" values(ARFF_WP_PAYSTATEMENTS) as "Paystatements Generated by ARFF" values(ARFF_EE_LIEN_COUNT) as "Liens generated by ARFF" by TransactionID
credits: Splunk team
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: String validation in CodeIgniter using callback rules
- Next: collaps and uncollaps is not working in my script
Related
Related Related
- 1
How can I create a record from different controllers in Rails?
- 2
How can I declare a variable to read from a different table column?
- 3
How can I select 2 different random rows from a table?
- 4
Can I use YoutubeAPI to create live events with different user
- 5
How do I create an Access Form for Table 1 where two Table 1 fields have different data from a single field in Table 2?
- 6
How can I Update two fields in same table with different conditions (SQL)?
- 7
How can I read from two different CSV files and create two different arrays without duplicating code?
- 8
How can I create different info Windows for different Markers?
- 9
How can I create different info Windows for different Markers?
- 10
How can I have different events for the same CustomInfoWindow
- 11
How can I have different type of events in Fullcalendar?
- 12
How can I arrange this code so I can get different entry from database for each table row
- 13
Can I create dynamic pivot query from key value table with different data types?
- 14
How can I render entries from one fields with different widget depending a column value?
- 15
How to select fields from other table based on different criteria
- 16
How can I geolocate if the address, zip and city are in different input fields
- 17
How can I turn comma separated fields into different rows?
- 18
How can I use the same fields for two different forms?
- 19
How can I alter a table in Oracle while adding a column, which is of the same type as a column from a different table
- 20
How can I ask for different permissions from facebook at different times?
- 21
How can I ask for different permissions from facebook at different times?
- 22
Select fields from same table with different conditions
- 23
How can I create an array from two models that have different keys in a Rails 3.2 app?
- 24
How can I create a json object from 3 different arrays in angularJS
- 25
In Java, how can I create a class property that selects from different enums?
- 26
How can I create an numpy array from two different numpy arrays?
- 27
How can I copy rows from one to another table with a different number of columns
- 28
How can I sum one column from the same table, to produce three different aggregates, using Sequel ORM?
- 29
How can I select * from table, but cast one of the columns to a different datatype?
Comments