Closed efd6 closed 1 year ago
Pinging @elastic/security-external-integrations (Team:Security-External Integrations)
/cc @endorama for the script if you want to adapt it for your team.
Adding to the tools for this one. I have fields-yml-recommend that I sometimes use for finding duplicates or things that should be using an ECS definition.
$ go run github.com/andrewkroh/go-examples/fields-yml-recommend@main \
-f=list packages/auditd/data_stream/log/fields/*
packages/auditd/data_stream/log/fields/base-fields.yml:18 - @timestamp : [Use 'external: ecs' to import the ECS definition.]
...
packages/auditd/data_stream/log/fields/ecs.yml:75 - user.effective.name : [Duplicate field (2 times).]
packages/auditd/data_stream/log/fields/package-fields.yml:34 - user.effective.name : [Duplicate field (2 times).]
@efd6 , all PR's are merged, do we still need to do something for this issue?
obs-cloud-monitoring added aws to the list which they own. I think given that we have completed the list either it should be removed and placed in a new issue or they should take ownership of this issue (I'd prefer the former).
@vinit-chauhan you've linked https://github.com/elastic/integrations/pull/4604 to this issue, does this cover the list of duplicate fields for aws
in the description of the field? we are looking to close this issue on the security side
Hey @narph - As far as I remember, @kaiyan-sheng raised a PR to remove the duplicate fields. And all the duplicates were removed. Here's the PR for reference, #4657.
@efd6 would you mind updating the status for aws
?
While preparing packages for the ECS updates I found that duplicated field definitions now caused indeterminate outcomes from
elastic-package build
. This prevented tests from passing while doing the updates and so I fixed the packages that were failing making use of new elastic-package behaviour for vetting v2 packages for duplicate field definitions. At the time, elastic-package did not continue to vet packages beyond failures in the manifest checks, which meant that it was necessary to fix those before being able to investigate duplications.elastic-package now proceeds to check duplications even when there are manifest vet failures (here and here), and it has become clear that the packages that I found in the original pass based on test failures did not find all cases (for example google_workspace fixed here).
So here is a complete list of non-deprecated SEI packages that have duplicated field definitions found using the script at the footer of this issue. The script requires elastic-package v0.65.0 and was run on the tree at 28fecbd88c90b1e3ae92d50940fabc80b94ff2d7 from the packages directory.
client.geo.country_iso_code
ecs.yml, ecs.ymlauditd.log.a0
fields.yml, fields.yml "log":container.name
agent.yml, ecs.yml "log":host.architecture
agent.yml, ecs.yml "log":user.effective.group.id
ecs.yml, package-fields.yml "log":user.effective.group.name
ecs.yml, package-fields.yml "log":user.effective.id
ecs.yml, package-fields.yml "log":user.effective.name
ecs.yml, package-fields.ymlcloud.account.id
agent.yml, ecs.yml "billing":cloud.availability_zone
agent.yml, ecs.yml "billing":cloud.instance.id
agent.yml, ecs.yml "billing":cloud.machine.type
agent.yml, ecs.yml "billing":cloud.provider
agent.yml, ecs.yml "billing":cloud.region
agent.yml, ecs.yml "cloudtrail":cloud.account.id
agent.yml, ecs.yml "cloudtrail":cloud.region
agent.yml, ecs.yml "cloudwatch_metrics":aws.dimensions.*
fields.yml, package-fields.yml "cloudwatch_metrics":cloud.account.id
agent.yml, ecs.yml "cloudwatch_metrics":cloud.availability_zone
agent.yml, ecs.yml "cloudwatch_metrics":cloud.instance.id
agent.yml, ecs.yml "cloudwatch_metrics":cloud.machine.type
agent.yml, ecs.yml "cloudwatch_metrics":cloud.provider
agent.yml, ecs.yml "cloudwatch_metrics":cloud.region
agent.yml, ecs.yml "dynamodb":cloud.account.id
agent.yml, ecs.yml "dynamodb":cloud.availability_zone
agent.yml, ecs.yml "dynamodb":cloud.instance.id
agent.yml, ecs.yml "dynamodb":cloud.machine.type
agent.yml, ecs.yml "dynamodb":cloud.provider
agent.yml, ecs.yml "dynamodb":cloud.region
agent.yml, ecs.yml "ebs":cloud.account.id
agent.yml, ecs.yml "ebs":cloud.availability_zone
agent.yml, ecs.yml "ebs":cloud.instance.id
agent.yml, ecs.yml "ebs":cloud.machine.type
agent.yml, ecs.yml "ebs":cloud.provider
agent.yml, ecs.yml "ebs":cloud.region
agent.yml, ecs.yml "ecs_metrics":cloud.account.id
agent.yml, ecs.yml "ecs_metrics":cloud.availability_zone
agent.yml, ecs.yml "ecs_metrics":cloud.instance.id
agent.yml, ecs.yml "ecs_metrics":cloud.machine.type
agent.yml, ecs.yml "ecs_metrics":cloud.provider
agent.yml, ecs.yml "ecs_metrics":cloud.region
agent.yml, ecs.yml "elb_logs":cloud.provider
agent.yml, ecs.yml "elb_metrics":cloud.account.id
agent.yml, ecs.yml "elb_metrics":cloud.availability_zone
agent.yml, ecs.yml "elb_metrics":cloud.instance.id
agent.yml, ecs.yml "elb_metrics":cloud.machine.type
agent.yml, ecs.yml "elb_metrics":cloud.provider
agent.yml, ecs.yml "elb_metrics":cloud.region
agent.yml, ecs.yml "firewall_logs":cloud.account.id
agent.yml, ecs.yml "firewall_logs":cloud.region
agent.yml, ecs.yml "firewall_metrics":cloud.account.id
agent.yml, ecs.yml "firewall_metrics":cloud.availability_zone
agent.yml, ecs.yml "firewall_metrics":cloud.instance.id
agent.yml, ecs.yml "firewall_metrics":cloud.machine.type
agent.yml, ecs.yml "firewall_metrics":cloud.provider
agent.yml, ecs.yml "firewall_metrics":cloud.region
agent.yml, ecs.yml "lambda":cloud.account.id
agent.yml, ecs.yml "lambda":cloud.availability_zone
agent.yml, ecs.yml "lambda":cloud.instance.id
agent.yml, ecs.yml "lambda":cloud.machine.type
agent.yml, ecs.yml "lambda":cloud.provider
agent.yml, ecs.yml "lambda":cloud.region
agent.yml, ecs.yml "natgateway":cloud.account.id
agent.yml, ecs.yml "natgateway":cloud.availability_zone
agent.yml, ecs.yml "natgateway":cloud.instance.id
agent.yml, ecs.yml "natgateway":cloud.machine.type
agent.yml, ecs.yml "natgateway":cloud.provider
agent.yml, ecs.yml "natgateway":cloud.region
agent.yml, ecs.yml "rds":cloud.account.id
agent.yml, ecs.yml "rds":cloud.availability_zone
agent.yml, ecs.yml "rds":cloud.instance.id
agent.yml, ecs.yml "rds":cloud.machine.type
agent.yml, ecs.yml "rds":cloud.provider
agent.yml, ecs.yml "rds":cloud.region
agent.yml, ecs.yml "s3_daily_storage":cloud.account.id
agent.yml, ecs.yml "s3_daily_storage":cloud.availability_zone
agent.yml, ecs.yml "s3_daily_storage":cloud.instance.id
agent.yml, ecs.yml "s3_daily_storage":cloud.machine.type
agent.yml, ecs.yml "s3_daily_storage":cloud.provider
agent.yml, ecs.yml "s3_daily_storage":cloud.region
agent.yml, ecs.yml "s3_request":cloud.account.id
agent.yml, ecs.yml "s3_request":cloud.availability_zone
agent.yml, ecs.yml "s3_request":cloud.instance.id
agent.yml, ecs.yml "s3_request":cloud.machine.type
agent.yml, ecs.yml "s3_request":cloud.provider
agent.yml, ecs.yml "s3_request":cloud.region
agent.yml, ecs.yml "s3_storage_lens":cloud.account.id
agent.yml, ecs.yml "s3_storage_lens":cloud.availability_zone
agent.yml, ecs.yml "s3_storage_lens":cloud.instance.id
agent.yml, ecs.yml "s3_storage_lens":cloud.machine.type
agent.yml, ecs.yml "s3_storage_lens":cloud.provider
agent.yml, ecs.yml "s3_storage_lens":cloud.region
agent.yml, ecs.yml "s3access":cloud.provider
agent.yml, ecs.yml "sns":cloud.account.id
agent.yml, ecs.yml "sns":cloud.availability_zone
agent.yml, ecs.yml "sns":cloud.instance.id
agent.yml, ecs.yml "sns":cloud.machine.type
agent.yml, ecs.yml "sns":cloud.provider
agent.yml, ecs.yml "sns":cloud.region
agent.yml, ecs.yml "sqs":cloud.account.id
agent.yml, ecs.yml "sqs":cloud.availability_zone
agent.yml, ecs.yml "sqs":cloud.instance.id
agent.yml, ecs.yml "sqs":cloud.machine.type
agent.yml, ecs.yml "sqs":cloud.provider
agent.yml, ecs.yml "sqs":cloud.region
agent.yml, ecs.yml "transitgateway":cloud.account.id
agent.yml, ecs.yml "transitgateway":cloud.availability_zone
agent.yml, ecs.yml "transitgateway":cloud.instance.id
agent.yml, ecs.yml "transitgateway":cloud.machine.type
agent.yml, ecs.yml "transitgateway":cloud.provider
agent.yml, ecs.yml "transitgateway":cloud.region
agent.yml, ecs.yml "usage":cloud.account.id
agent.yml, ecs.yml "usage":cloud.availability_zone
agent.yml, ecs.yml "usage":cloud.instance.id
agent.yml, ecs.yml "usage":cloud.machine.type
agent.yml, ecs.yml "usage":cloud.provider
agent.yml, ecs.yml "usage":cloud.region
agent.yml, ecs.yml "vpcflow":cloud.account.id
agent.yml, ecs.yml "vpcflow":cloud.instance.id
agent.yml, ecs.yml "vpcflow":cloud.provider
agent.yml, ecs.yml "vpcflow":source.as.organization.name
ecs.yml, ecs.yml "vpn":cloud.account.id
agent.yml, ecs.yml "vpn":cloud.availability_zone
agent.yml, ecs.yml "vpn":cloud.instance.id
agent.yml, ecs.yml "vpn":cloud.machine.type
agent.yml, ecs.yml "vpn":cloud.provider
agent.yml, ecs.yml "vpn":cloud.region
agent.yml, ecs.yml "waf":cloud.provider
agent.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "spamfirewall":tags
base-fields.yml, ecs.yml "waf":@timestamp
base-fields.yml, ecs.yml "waf":tags
base-fields.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "director":tags
base-fields.yml, ecs.ymlbox.source.id
fields.yml, fields.ymlhost.hostname
agent.yml, ecs.yml "alert":host.id
agent.yml, ecs.yml "alert":host.ip
agent.yml, ecs.yml "alert":host.name
agent.yml, ecs.yml "alert":host.os.version
agent.yml, ecs.yml "asset_vulnerability_summary":host.hostname
agent.yml, ecs.yml "asset_vulnerability_summary":host.id
agent.yml, ecs.yml "asset_vulnerability_summary":host.name
agent.yml, ecs.yml "asset_vulnerability_summary":host.os.name
agent.yml, ecs.yml "asset_vulnerability_summary":host.os.version
agent.yml, ecs.yml "endpoint_event":host.hostname
agent.yml, ecs.yml "endpoint_event":host.id
agent.yml, ecs.yml "endpoint_event":host.ip
agent.yml, ecs.yml "endpoint_event":host.name
agent.yml, ecs.yml "endpoint_event":host.os.family
agent.yml, ecs.yml "endpoint_event":host.os.name
agent.yml, ecs.yml "watchlist_hit":host.hostname
agent.yml, ecs.yml "watchlist_hit":host.id
agent.yml, ecs.yml "watchlist_hit":host.ip
agent.yml, ecs.yml "watchlist_hit":host.name
agent.yml, ecs.ymlcef.extensions.deviceCustomIPv6Address2Label
fields.yml, fields.yml "log":cef.extensions.deviceCustomIPv6Address2
fields.yml, fields.yml "log":cef.extensions.deviceCustomIPv6Address3Label
fields.yml, fields.yml "log":cef.extensions.deviceCustomIPv6Address3
fields.yml, fields.ymlevent.created
ecs.yml, ecs.yml "log":server.domain
ecs.yml, ecs.ymlevent.created
ecs.yml, ecs.yml "log":server.domain
ecs.yml, ecs.ymlevent.created
ecs.yml, ecs.ymlcisco_ise.log.state
fields.yml, fields.yml "log":host.hostname
agent.yml, ecs.yml "log":host.ip
agent.yml, ecs.ymlcontainer.id
agent.yml, base-fields.yml "events":network.direction
ecs.yml, ecs.yml "events":network.protocol
ecs.yml, ecs.yml "log":container.id
agent.yml, base-fields.yml "log":network.direction
ecs.yml, ecs.yml "log":network.protocol
ecs.yml, ecs.ymlcontainer.id
agent.yml, base-fields.yml "log":tags
base-fields.yml, ecs.ymlinput.type
agent.yml, fields.ymlcontainer.id
agent.yml, base-fields.yml "event":event.code
ecs.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "log":event.created
ecs.yml, ecs.yml "log":server.domain
ecs.yml, ecs.ymlclient.geo.country_iso_code
ecs.yml, ecs.ymlcef.extensions.deviceCustomIPv6Address2Label
cef.yml, cef.yml "events":cef.extensions.deviceCustomIPv6Address2
cef.yml, cef.yml "events":cef.extensions.deviceCustomIPv6Address3Label
cef.yml, cef.yml "events":cef.extensions.deviceCustomIPv6Address3
cef.yml, cef.yml@timestamp
base-fields.yml, ecs.yml "protect":tags
base-fields.yml, ecs.ymlhost.hostname
agent.yml, ecs.yml "ai_analyst_alert":host.id
agent.yml, ecs.yml "ai_analyst_alert":host.ip
agent.yml, ecs.yml "ai_analyst_alert":host.name
agent.yml, ecs.yml "model_breach_alert":host.hostname
agent.yml, ecs.yml "model_breach_alert":host.id
agent.yml, ecs.yml "model_breach_alert":host.ip
agent.yml, ecs.yml "model_breach_alert":host.type
agent.yml, ecs.yml "system_status_alert":host.hostname
agent.yml, ecs.yml "system_status_alert":host.ip
agent.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "bigipafm":tags
base-fields.yml, ecs.yml "bigipapm":@timestamp
base-fields.yml, ecs.yml "bigipapm":tags
base-fields.yml, ecs.ymlcontainer.name
agent.yml, ecs.yml "event":host.architecture
agent.yml, ecs.ymldestination.port
ecs.yml, ecs.yml "nx":host.ip
agent.yml, ecs.ymlcontainer.id
agent.yml, base-fields.yml "log":tags
base-fields.yml, ecs.ymlcontainer.id
agent.yml, ecs.ymlcontainer.id
agent.yml, base-fields.yml "log":tags
base-fields.yml, ecs.ymlcontainer.id
agent.yml, base-fields.yml "log":tags
base-fields.yml, ecs.ymlcloud.account.id
agent.yml, ecs.yml "redis":cloud.availability_zone
agent.yml, ecs.yml "redis":cloud.instance.id
agent.yml, ecs.yml "redis":cloud.machine.type
agent.yml, ecs.yml "redis":cloud.provider
agent.yml, ecs.yml "redis":cloud.region
agent.yml, ecs.ymlcontainer.name
agent.yml, ecs.yml "drive":container.name
agent.yml, ecs.yml "groups":container.name
agent.yml, ecs.yml "login":container.name
agent.yml, ecs.yml "saml":container.name
agent.yml, ecs.yml "user_accounts":container.name
agent.yml, ecs.ymlevent.created
ecs.yml, ecs.yml "log":log.offset
agent.yml, base-fields.yml "log":server.domain
ecs.yml, ecs.yml "winlog":event.module
base-fields.yml, ecs.yml "winlog":host.name
agent.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "securesphere":tags
base-fields.yml, ecs.ymlhost.hostname
agent.yml, ecs.yml "dhcp_lease":host.name
agent.yml, ecs.ymlhost.ip
agent.yml, ecs.ymlcontainer.id
agent.yml, base-fields.yml "log":tags
base-fields.yml, ecs.ymlcontainer.id
agent.yml, base-fields.yml "log":tags
base-fields.yml, ecs.ymlcontainer.id
agent.yml, ecs.yml "log":container.image.name
agent.yml, ecs.yml "log":container.labels
agent.yml, ecs.yml "log":container.name
agent.yml, ecs.ymlurl.full
ecs.yml, ecs.ymlcontainer.id
agent.yml, ecs.yml "log":container.image.name
agent.yml, ecs.yml "log":container.labels
agent.yml, ecs.yml "log":container.name
agent.yml, ecs.ymlemail.attachments.file.name
ecs.yml, ecs.yml "siem_logs":event.action
ecs.yml, ecs.yml "ttp_ap_logs":email.attachments.file.mime_type
ecs.yml, ecs.yml "ttp_ap_logs":event.action
ecs.yml, ecs.yml "ttp_ip_logs":event.action
ecs.yml, ecs.yml "ttp_url_logs":event.action
ecs.yml, ecs.ymlhost.ip
agent.yml, ecs.ymlcontainer.id
agent.yml, ecs.yml "log":container.image.name
agent.yml, ecs.yml "log":container.labels
agent.yml, ecs.yml "log":container.name
agent.yml, ecs.yml "log":host.os.kernel
agent.yml, ecs.yml "log":host.os.platform
agent.yml, ecs.yml "log":host.os.version
agent.yml, ecs.yml "log":host.type
agent.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "sightline":tags
base-fields.yml, ecs.ymlcloud.account.id
agent.yml, ecs.yml "alerts":destination.ip
ecs.yml, ecs.yml "alerts":host.hostname
agent.yml, ecs.yml "alerts":host.os.name
agent.yml, ecs.yml "alerts":source.ip
ecs.yml, ecs.yml "events":client.bytes
ecs.yml, ecs.yml "events":client.packets
ecs.yml, ecs.yml "events":cloud.region
agent.yml, ecs.yml "events":host.hostname
agent.yml, ecs.ymlcontainer.id
agent.yml, ecs.yml "audit":host.id
agent.yml, ecs.yml "audit":host.name
agent.yml, ecs.ymlcontainer.id
agent.yml, ecs.ymlcontainer.id
agent.yml, ecs.yml "panos":host.id
agent.yml, ecs.yml "panos":host.ip
agent.yml, ecs.yml "panos":host.mac
agent.yml, ecs.yml "panos":host.name
agent.yml, ecs.yml "panos":host.os.family
agent.yml, ecs.yml "panos":source.user.name
ecs.yml, ecs.ymlhost.domain
agent.yml, ecs.yml "alerts":host.hostname
agent.yml, ecs.yml "alerts":host.id
agent.yml, ecs.yml "alerts":host.ip
agent.yml, ecs.yml "alerts":host.mac
agent.yml, ecs.yml "alerts":host.os.version
agent.yml, ecs.ymlsource.as.number
ecs.yml, ecs.yml "log":source.as.organization.name
ecs.yml, ecs.yml "log":source.geo.continent_name
ecs.yml, ecs.yml "log":source.geo.country_iso_code
ecs.yml, ecs.yml "log":source.geo.country_name
ecs.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "defensepro":tags
base-fields.yml, ecs.ymlevent.category
ecs.yml, ecs.yml "audit":slack.audit.entity.timestamp
fields.yml, fields.yml "audit":user_agent.device.name
ecs.yml, ecs.yml "audit":user_agent.name
ecs.yml, ecs.yml "audit":user_agent.original
ecs.yml, ecs.yml "audit":user_agent.os.name
ecs.yml, ecs.ymltags
base-fields.yml, ecs.yml "xg":sophos.xg.syslog_server_name
fields.yml, fields.yml@timestamp
base-fields.yml, ecs.yml "log":tags
base-fields.yml, ecs.yml "log":user_agent.original
ecs.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "eve":host.ip
agent.yml, ecs.ymlcontainer.id
agent.yml, ecs.ymlmessage
ecs.yml, ecs.ymlthreat.feed.name
base-fields.yml, ecs.yml@timestamp
base-fields.yml, ecs.yml "log":tags
ecs.yml, ecs.ymlhost.hostname
agent.yml, ecs.ymlclient.geo.country_iso_code
ecs.yml, ecs.yml