Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- About JyotiP
JyotiP
Path Finder
Member since:
08-23-2017
07-30-2021
Community Statistics
| Posts | 50 |
| Solutions | 0 |
| Karma Given | 4 |
| Karma Received | 3 |
| Member Since | 08-23-2017 |
Activity Feed
- Karma Re: Count the three different value from one response message for Adrian_ftx. 06-05-2020 12:50 AM
- Karma Re: Count the three different value from one response message for jpolvino. 06-05-2020 12:50 AM
- Karma Re: How to select particular path using `where` ? for kamlesh_vaghela. 06-05-2020 12:50 AM
- Karma Re: Regex to remove all the special charater from date and convert it as a string for harsmarvania57. 06-05-2020 12:50 AM
- Got Karma for Re: How to count the number of request hitting server ?. 06-05-2020 12:49 AM
- Got Karma for Re: How to create a graph or table for the following query according to the Status Code ?? Please refer the result below.. 06-05-2020 12:49 AM
- Got Karma for Re: What syntax can I use to run a search that sorts varying runtimes?. 06-05-2020 12:49 AM
- Posted Re: How to select particular path using `where` ? on Splunk Search. 11-05-2019 05:22 AM
- Posted How to select particular path using `where` ? on Splunk Search. 11-05-2019 04:38 AM
- Posted Re: How to change the row value to column value ? on Splunk Search. 10-16-2019 12:15 AM
- Posted How to change the row value to column value ? on Splunk Search. 10-15-2019 11:10 PM
- Posted How to resolve the below issue ? on Splunk Search. 10-15-2019 06:22 AM
- Posted Re: Count the number of api occurrence in 10 second on Splunk Search. 09-27-2019 02:13 AM
- Posted Count the number of api occurrence in 10 second on Splunk Search. 09-27-2019 01:40 AM
- Posted Re: Regex to remove all the special charater from date and convert it as a string on Splunk Dev. 09-23-2019 05:57 AM
- Posted Regex to remove all the special charater from date and convert it as a string on Splunk Dev. 09-23-2019 05:47 AM
- Posted Pass a run time variable in spunk on Dashboards & Visualizations. 09-23-2019 03:55 AM
- Tagged Pass a run time variable in spunk on Dashboards & Visualizations. 09-23-2019 03:55 AM
- Posted Re: Retrive only the key object from the json output on Getting Data In. 09-19-2019 03:47 AM
- Posted Re: Retrive only the key object from the json output on Getting Data In. 09-18-2019 05:57 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
07-23-2019
01:56 AM
Oh got it, make sense as well.
... View more
07-23-2019
01:45 AM
@vnravikumar why .+ why not ',' ?
... View more
07-22-2019
04:41 AM
I have the following log output and I want to extract "component", "environment" & "component type" and their corresponding value in table format.
Level="INFO", Date="2019-07-22 08:43:44,141", Message="{"Protocol":"https","Path":"/api/infrastructure/qualitygate/v1/qualityGateStatus","Verb":"GET","QueryParams":{"component":"help-website-stack","version":"1.0.291","environment":"testenvironment","componentType":"stack"},"body":{},"StatusCode":200,"Details":{"component":"help-website-stack","version":"1.0.291","sonarStatus":true,"integrationTestStatus":true,"status":true,"message":"","coverage":"0.0","newCoverage":"0.0"}}
... View more
- Tags:
- splunk-enterprise
03-26-2019
12:46 AM
Wanted to retrieve the transaction id from the given string
Level="ERROR", Date="2019-03-25 23:02:59,600", Message="Recevied terminaion signal from client. Closing connection.", JobType="Request", TimeSpan="50012", URL="http://test:8001/api/test/v2/placeorder", ActivityId="067725a6-e17a-4f86-8e14-a1e55c44148e", Header="{"Authorization":"*****","TransactionId":"6d80741d-d07d-4313-acf5-569d6ebec3c6","X-Request-Id":"067725a6-e17a-4f86-8e14-a1e55c44148e"}", Product="TestOrderData", Stack="Order-data", Service="Test", AppDomain="Order-data_Test"
tried with
rex field=Header Transaction=("TransactionId":"*) | table Transaction
rex field=Header "TransactionId\":\"(?<TransactionId>\w+)\"" | table TransactionId
But none of them are working
... View more
04-11-2018
02:46 AM
Completed executing query test_proc_SelectLatest_PricesBySecurity which took 1 milliseconds.
Completed executing query test_proc_Select_ForCloseouts which took 42 milliseconds.
Completed executing query test_proc_Insert which took 12 milliseconds.
Completed executing query test_UnprocessedLot_Select which took 142 milliseconds.
... View more
- Tags:
- splunk-enterprise
12-12-2017
02:21 AM
Query :
"POST" "200" "api/platform/v1/Session" FirmName
Output:
Level="INFO", Date="2017-12-12 04:06:26,200", Message="GET session API complete.", JobType="GetSession", TimeSpan="14ms", URL="http://test:8080/v1/session", ActivityId="70a51b98-365f-4882-94c7-9563d465b211", Header="{"Authorization":"**","UserSession":{"FirmId":10017,"UserId":20,"FirmName":" Test2","UserName":"AutomationTests","UserSessionToken":"**","FirmAuthToken":"T4QV4","EnvironmentName":"AWSPROD"},"TransactionId":"7c257e48-3816-48bc-a717-fe96f5c33271","X-Request-Id":"70a51b98-365f-4882-94c7-9563d465b211","X-Operation":"{\"OperationId\":\"fa255617-2fae-44d7-9b16-8813f35d12a3\",\"OperationName\":\"Post to IBOR\"}","X-Trace":"0"}", OperationId="fa255617-2fae-44d7-9b16-8813f35d12a3", OperationName="Post to IBOR", Product="CoreData", Stack="core-data", Service="graphql", AppDomain="core-data_graphql"
I just want to fetch the FirmName value then what would be the regext for it.Basically I want to fetch "Test2" in output. How would I do it ?
... View more
- Tags:
- splunk-enterprise
10-18-2017
05:12 AM
host=test01 index="perfmon" collection="CPU" counter="% Processor Time" | bucket _time span=15m | stats avg(Value) as avg_CPU by _time | where avg_CPU>=60
The above query is giving me the CPU utilization above 60% with the span of 15 minute. But I have 9 host like aeperf01,aeperf02,aeperf03 and so on. I want to calculate per host how can I do it ??
... View more
- Tags:
- cpu
- splunk-enterprise
10-16-2017
11:47 PM
For the query :
host=aeperf01api02 Level="INFO" | stats count by AppDomain
I have following output
Web 4504
WebApi 180240
ComplianceWeb 9384
ReportingWeb 34152
ReferenceDataWeb 161710
SecurityMasterWeb 78878
Login 38514
I have 6 host like above, how to sort them in one query where I can present these output in rows and hosts in the column so that I can check what is the number of services hit by the particular host.
... View more
10-09-2017
06:24 AM
@harsmarvania this worked. Thank You
... View more
10-09-2017
06:23 AM
1 Karma
@garethatiag this worked. Thank You
... View more
10-09-2017
06:12 AM
For the query : sourcetype="docker" AppDomain=Eos Level=INFO Message="Eos request calculated" I have the following output: host = aecas01ran05.aws.cloud.com source = http:docker sourcetype = docker And I have various host for my application. How to calculate the number of request that is hitting different server irrespective of failure or success and present them in a table. Idea is to check the servers are hitting with the same number of request or not ?? I have series of server as follows : aecas01ran04, aecas01ran03, aecas01ran05,aeperf01cmb01
... View more
Labels
- Labels:
-
host
09-13-2017
02:03 AM
I have the following query : sourcetype="docker" AppDomain=Eos Level=INFO Message="Eos request calculated" | eval Val_Request_Data_Fetch_RefData=Round((Eos_Request_Data_Fetch_MarketData/1000),1)
Which have 3 host like perf, castle, local.
I want to use the above query bust excluding host like castle and local
sourcetype="docker" AppDomain=Eos Level=INFO Message="Eos request calculated" | eval Val_Request_Data_Fetch_RefData=Round((Eos_Request_Data_Fetch_MarketData/1000),1) | where host NOT like 'castle' AND 'local' ?? Will it work
... View more
Labels
- Labels:
-
other
09-06-2017
03:20 AM
{"StatusCode":204,"ReasonPhrase":"No Content","Method":"GET","PathAndQuery":"/api/ibor/v2/positionValuations?businessDate=2017-09-04\u0026closeoutSchemeId=1\u0026expand=*\u0026logicalTimeId=150\u0026positionStateId=40","MessageType":"Response"}
The highlighted value (\u0026expand=*\u0026logicalTimeId=150\u0026) are unique every time I hit it will change, and for different query the values are different but the
businessDate=2017-09-04
closeoutSchemeId=1
positionStateId=40
will be as it is. So I want to capture only above 3 value irrespective of the values followed by the above values.
... View more
09-06-2017
03:07 AM
@cusello,
tried but given the a pattern error please refer the following
https://regex101.com/r/USbhRP/1 and please select javascript.
... View more
09-06-2017
03:04 AM
Hi Giuseppe,
It is not working because "\" is not supporting.
... View more
09-06-2017
12:01 AM
Output table should contain the values as follows :
businessDate=2017-09-04,
positionStateId=40,
closeoutSchemeId=1
... View more
09-05-2017
11:53 PM
I have a query :
host=*perf* bf19f0c3-2f10-4db2-b33f-efb946b0ee24 {"StatusCode":204* | table Message
Out put of the above query is as follows :
{"StatusCode":204,"ReasonPhrase":"No Content","Method":"GET","PathAndQuery":"/api/ibor/v2/positionValuations?businessDate=2017-09-04\u0026closeoutSchemeId=1\u0026expand=*\u0026logicalTimeId=150\u0026positionStateId=40","MessageType":"Response"}
I want to take out the following value :
1. businessDate
2. positionStateId
3. closeoutSchemeId
and put them in a table in which the basic value should be businessDate=2017-09-04, positionStateId=40,closeoutSchemeId=1
... View more
08-29-2017
07:16 AM
@niketnilay, thanks for the update, will try the above.
... View more
08-29-2017
07:13 AM
1 Karma
@DalJeanis, thanks for the update, will try the above two.
... View more
08-29-2017
06:31 AM
@niketnilay, these are separate events.
... View more
08-29-2017
02:29 AM
{"StatusCode":200,"ReasonPhrase":"OK","Method":"POST","PathAndQuery":"}
{"StatusCode":404,"ReasonPhrase":"Not Found","Method":"GET","PathAndQuery":"}
{"Message":"Completed request to Create Position Events.","}.
For the above I have three categorize like status code 200, 400 and NONE. So I want to create a graph or count on the basis of Status Code. How to do it ??
... View more
08-29-2017
02:09 AM
@DalJeanis can create a pi chart or graph for the above query ??
... View more
08-23-2017
08:42 AM
1 Karma
@DalJeanis, thanks for the update, let me try and will post my result
... View more
08-23-2017
06:09 AM
Currently I have separate query as follows :
query 1 : where Val_value>=0 AND Val_value<=3 | stats count
query 2 : where Val_value>=3.1 AND Val_value<=4 | stats count
query 3 : where Val_value>=4.1 AND Val_value<=5 | stats count
query 4 : where Val_value>=5.1 AND Val_value<=6 | stats count
So I want to merge the above request into 1 query. How to do it ?
... View more
08-23-2017
05:53 AM
I have data for 1 day where I want to sort it with activity like following manner, total number of records took 0-3 sec , total number of records took 3-4 and goes on. Want to present it in one query.
... View more
- « Previous
-
- 1
- 2
- Next »
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-30-2021
06:52 AM
|
