[Bug] attackToExcel.py KeyError: 'x-mitre-asset'

Expected Behavior

attackToExcel.py will output a STIX excel related to ics-attack.json

Actual Behavior

when I execute the attackToExcel.py tool, error occur as below,

>python3 attackToExcel.py -domain ics-attack -version v15.1

2024-05-09 11:38:26.967 | INFO     | __main__:get_stix_data:69 - Downloading ATT&CK data from github.com/mitre/cti
2024-05-09 11:38:27.800 | INFO     | __main__:export:315 - ************ Exporting ics-attack to Excel ************
parsing techniques: 100%|██████████████████████████████████████████| 83/83 [00:00<00:00, 63066.53it/s]
parsing relationships for type=technique:   0%|                              | 0/1350 [00:00<?, ?it/s]
Traceback (most recent call last):
  File "attackToExcel.py", line 367, in <module>
    main()
  File "attackToExcel.py", line 361, in main
    export(
  File "attackToExcel.py", line 318, in export
    dataframes = build_dataframes(src=mem_store, domain=domain)
  File "attackToExcel.py", line 99, in build_dataframes
    "techniques": stixToDf.techniquesToDf(src, domain),
  File "***/anaconda3/envs/hf/lib/python3.8/site-packages/mitreattack/attackToExcel/stixToDf.py", line 246, in techniquesToDf
    codex = relationshipsToDf(src, relatedType="technique")
  File "***/anaconda3/envs/hf/lib/python3.8/site-packages/mitreattack/attackToExcel/stixToDf.py", line 926, in relationshipsToDf
    add_side("target", target)
  File "***/anaconda3/envs/hf/lib/python3.8/site-packages/mitreattack/attackToExcel/stixToDf.py", line 922, in add_side
    row[f"{label} type"] = stixToAttackTerm[sdo["type"]]
KeyError: 'x-mitre-asset'

This is my conda environment:

Name Version Build Channel
_libgcc_mutex 0.1 main
_openmp_mutex 5.1 1_gnu
antlr4-python3-runtime 4.9.3 pypi_0 pypi
arrow 1.3.0 pypi_0 pypi
attrs 23.2.0 pypi_0 pypi
ca-certificates 2024.3.11 h06a4308_0
certifi 2024.2.2 pypi_0 pypi
charset-normalizer 3.3.2 pypi_0 pypi
click 8.1.7 pypi_0 pypi
colorama 0.4.6 pypi_0 pypi
colour 0.1.5 pypi_0 pypi
cpe 1.2.1 pypi_0 pypi
cybox 2.1.0.21 pypi_0 pypi
deepdiff 7.0.1 pypi_0 pypi
drawsvg 2.3.0 pypi_0 pypi
et-xmlfile 1.1.0 pypi_0 pypi
filelock 3.13.4 pypi_0 pypi
fqdn 1.5.1 pypi_0 pypi
fsspec 2024.3.1 pypi_0 pypi
huggingface-hub 0.22.2 pypi_0 pypi
idna 3.7 pypi_0 pypi
importlib-metadata 7.1.0 pypi_0 pypi
importlib-resources 5.13.0 pypi_0 pypi
isoduration 20.11.0 pypi_0 pypi
jsonpointer 2.4 pypi_0 pypi
jsonschema 4.22.0 pypi_0 pypi
jsonschema-specifications 2023.12.1 pypi_0 pypi
ld_impl_linux-64 2.38 h1181459_1
libffi 3.4.4 h6a678d5_0
libgcc-ng 11.2.0 h1234567_1
libgomp 11.2.0 h1234567_1
libstdcxx-ng 11.2.0 h1234567_1
loguru 0.7.2 pypi_0 pypi
lxml 5.2.1 pypi_0 pypi
maec 4.1.0.17 pypi_0 pypi
markdown 3.6 pypi_0 pypi
markdown-it-py 3.0.0 pypi_0 pypi
mdurl 0.1.2 pypi_0 pypi
mitreattack-python 2.0.14 pypi_0 pypi
mixbox 1.0.5 pypi_0 pypi
ncurses 6.4 h6a678d5_0
netaddr 1.2.1 pypi_0 pypi
numpy 1.24.4 pypi_0 pypi
openpyxl 3.1.2 pypi_0 pypi
openssl 3.0.13 h7f8727e_0
ordered-set 4.1.0 pypi_0 pypi
packaging 24.0 pypi_0 pypi
pandas 2.0.3 pypi_0 pypi
pillow 10.3.0 pypi_0 pypi
pip 23.3.1 py38h06a4308_0
pkgutil-resolve-name 1.3.10 pypi_0 pypi
platformdirs 4.2.1 pypi_0 pypi
pluralizer 1.2.0 pypi_0 pypi
pooch 1.8.1 pypi_0 pypi
pycountry 23.12.11 pypi_0 pypi
pygments 2.18.0 pypi_0 pypi
python 3.8.19 h955ad1f_0
python-dateutil 2.9.0.post0 pypi_0 pypi
pytz 2024.1 pypi_0 pypi
pyyaml 6.0.1 pypi_0 pypi
readline 8.2 h5eee18b_0
referencing 0.35.1 pypi_0 pypi
requests 2.31.0 pypi_0 pypi
rfc3339-validator 0.1.4 pypi_0 pypi
rfc3986-validator 0.1.1 pypi_0 pypi
rich 13.7.1 pypi_0 pypi
rpds-py 0.18.1 pypi_0 pypi
setuptools 68.2.2 py38h06a4308_0
shellingham 1.5.4 pypi_0 pypi
simplejson 3.19.2 pypi_0 pypi
six 1.16.0 pypi_0 pypi
sqlite 3.41.2 h5eee18b_0
stix 1.2.0.11 pypi_0 pypi
stix2 3.0.1 pypi_0 pypi
stix2-elevator 4.1.7 pypi_0 pypi
stix2-patterns 2.0.0 pypi_0 pypi
stix2-validator 3.2.0 pypi_0 pypi
stixmarx 1.0.8 pypi_0 pypi
tabulate 0.9.0 pypi_0 pypi
taxii2-client 2.3.0 pypi_0 pypi
tk 8.6.12 h1ccaba5_0
tqdm 4.66.2 pypi_0 pypi
typer 0.12.3 pypi_0 pypi
types-python-dateutil 2.9.0.20240316 pypi_0 pypi
typing-extensions 4.11.0 pypi_0 pypi
tzdata 2024.1 pypi_0 pypi
uri-template 1.3.0 pypi_0 pypi
urllib3 2.2.1 pypi_0 pypi
weakrefmethod 1.0.3 pypi_0 pypi
webcolors 1.13 pypi_0 pypi
wheel 0.41.2 py38h06a4308_0
xlsxwriter 3.2.0 pypi_0 pypi
xz 5.4.6 h5eee18b_0
zipp 3.18.1 pypi_0 pypi
zlib 1.2.13 h5eee18b_0

Inizia riproducendo python3 attackToExcel.py -domain ics-attack -version v15.1 e ispeziona attackToExcel.py intorno a build_dataframes, quindi segui il traceback fino a stixToDf.py, in relationshipsToDf e add_side. Il lavoro è completato quando i dati ICS ATT&CK vengono esportati in Excel senza il KeyError x-mitre-asset.