Splunk Search

success vs failed graph

muzeebm
Explorer

Hi, 

Below is the information from one of my logs. 

"Information","ajp-nio-127.0.0.1-8016-exec-642","11/24/20","13:30:14","CLIENT_URL","samlServices.processRequest: stuUserReturn: {""update_user_details"":1,""processByCf"":true,""USER_LOGIN"":""[email protected]"",""userID"":""XXXXXXX"",""user_id"":XXXXX,""connection_name"":""XXXX"",""login"":""[email protected]"",""userAttributes"":{""group_name"":""HR"",""telephone"":"""",""country"":1,""preferredLanguage"":"""",""login"":"""",""organisation"":""XXXXX English"",""last_name"":""XXXXXX"",""email"":""[email protected]"",""first_name"":""XXXX"",""company"":""XXXXX English""},""saml_id"":1,""loginStatus"":""success""}"

 

The last bit loginStatus"":""success" will be  loginStatus"":""failed" in case of failure. 

 

I want to create create a chart/dashboard where I can get number of success requests compared to failures over a period of time. eg 30 days

 

Can someone please help me sort this out. Thanks. 

 

M

Labels (1)
Tags (1)
0 Karma
1 Solution

muzeebm
Explorer

Thanks, looks like it worked. 👍 @ITWhisperer 

View solution in original post

0 Karma

muzeebm
Explorer

Thanks, looks like it worked. 👍 @ITWhisperer 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try something like

| rex "loginStatus\"\":\"\"(?<loginstatus>[^\"]+)"
| timechart count by loginstatus
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

From Raw Data to Executive-Ready Stories, Faster

Build Data Stories for Every Audience  A dashboard is rarely just a dashboard. It might be the view an ...

Guided Onboarding with Auto-schema Is Now Generally Available

  We are excited to announce the General Availability of Guided Onboarding with Auto-Schematization ...

ATTENTION: We’re Moving! (AGAIN!)

The Splunk Community Slack is undergoing a system migration to keep our workspace secure and ...