Splunk Enterprise Security

Enterprise Security: How to get a field break-down for a Web datamodel?

danielbb
Motivator

I'm looking at the Web datamodel and try to determine which fields are populated.

I can do :
| tstats dc(sourcetype) FROM datamodel=Web by sourcetype
and | tstats count(sourcetype)
FROM datamodel=Web by sourcetype
or
| tstats count(Web.status) FROM datamodel=Web by Web.status

but I like to see a breakdown of all the fields in this datamodel.

Is it possible?

0 Karma

ChrisG
Splunk Employee
Splunk Employee

You can refer to the Common Information Model documentation. See https://docs.splunk.com/Documentation/CIM/4.13.0/User/Web.

0 Karma

danielbb
Motivator

I know the field names @ChrisG, if this is what you meant, but I like to see a breakdown of the fields, since there are quite a bit of them.

0 Karma

ChrisG
Splunk Employee
Splunk Employee

I guess I'm not sure what you mean by "breakdown." The doc lists the field names, data type, description, and example values. Can you clarify your question, to help the community answer better?

0 Karma

danielbb
Motivator

Sure, I would like to see which fields are populated with which values across all the fields which are available in this datamodel, without examining each field individually. I hope it's clear.

0 Karma

danielbb
Motivator

I guess the pivot is a good place to explore the datamodel.

0 Karma
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...