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
Get Updates on the Splunk Community!

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Dashboard Challenge and Watch the .conf24 Global Broadcast!

The Splunk Community Dashboard Challenge is still happening, and it's not too late to enter for the week of ...