a
    ð(öjüa  ã                )   @   sÖ  d Z ddlZddlZddlZddlmZ ddlmZ dZdZ	g d¢Z
dd	gZg d
¢ZeZeg d¢g d¢eddgg d¢d�edgg d¢eg d¢g d¢d�eg d¢g d¢eg d¢g d¢d�eg g d¢eddgg d¢d�eg g d¢g d¢dd gg d!¢d�eg g d"¢eg d#¢g d$¢d�eg g d%¢ed&d'gg d(¢d�eg g d)¢dd	gg d*¢g d+¢d�eg g d,¢ed-d.gg d/¢d�eg g d0¢ed1d2gg d3¢d�eg g d4¢g d¢d5d6gg d7¢d�eg g d8¢g d¢g d9¢g d:¢d�eg d;¢g d<¢eg d=¢g d>¢d�eg g d?¢g d¢g d@¢g dA¢d�eg dB¢g dC¢edDdEgg dF¢d�dGœZeg edH dI dJ�Zedgg dK¢dJ�edgg dL¢dJ�eg dM¢dNdOgdJ�eg dM¢dNdOgdJ�eg dP¢g dQ¢dJ�eg dR¢g dS¢edT�eg dU¢edV�eg dW�edXdYgg dZ¢dJ�ed[gdd	gdV�eg dW�eg d\¢dd	gdV�ed]gg d^¢dJ�eg d_¢g d`¢da�eg g db¢g d¢dT�eg dc¢dddegedT�edfdggg dh¢dJ�eƒ eg di¢dd	gdV�eg dj¢dkdlgdJ�eg dm¢g d¢dV�edngg do¢edT�eg dp¢g dq¢edT�eg dr¢dd	gdV�eg ds¢dd	gdV�edgdtgg du¢edT�eg dv¢dwdxgedT�edygg dz¢edT�eg g d{¢dd	gdT�eg d|¢g d}¢edT�ed~dygg d¢edT�eg d€¢g edT�edggg d�¢edT�ef i e¤d‚ei¤Žedtdggg dƒ¢edT�ed„gg d…¢g d_¢dT�eg g d†¢dd	gdT�d‡œ%ZdˆD ]ZeeedW�ee< �qÌd‰D ]Zedd	gdW�ee< �qèeg dŠ¢dd	gdV�ed‹< eg dŒ¢g d¢dV�ed�< eg dŽ¢dd	gdV�ed�< eg d�¢dd	gdV�ed‘< eg d’¢dd	gdV�ed“< eg d”¢g d¢dV�ed•< d–d—„ Zd˜d™„ Zdšd›„ Zdœd�„ ZdždŸ„ Zd d¡„ Zed¢k�rÒeƒ  dS )£aÅ  
build_register.py - spreadsheet -> threat register JSON

Reads the Common Risk Assessment workbook (ILT / RDI / RDW / I&W) and writes:
  data/threads_register.json

The output contains:
  * the 57 workshop threats (T-001..T-057)
  * optionally the 12 threats added by RDW (T-058..T-069)
  * category profiles for CVE, paper, repository and signal evidence
  * resolved matching rules per threat

Usage:
  python3 build_register.py [workbook.xlsx] [--include-rdw]

The matching rules below are judgement-based and should be reviewed. Signals are
external observations, incidents, reporting and strategic developments. A signal
can support or contextualise a threat, but does not by itself prove exploitation.
é    N)ÚPath)Úload_workbookz2Common_Risk_Assessment_ILT_RDI_RDW_IenW_v0.65.xlsxzdata/threats_register.json)ÚcveÚpaperÚrepor   Úsignal©r   r   r   r   )Ú
TelematicsúBackend / CloudúOTA / Firmware)Úfleetzfleet managementzmobility servicezvehicle cloudzback endZ	cascadingz;fleet cyberattack connected vehicles large scale disruptionz'vehicle backend cloud outage resilience)zconnected fleet disruptionzmobility service outagezvehicle backend incidentz'large scale automotive cyber disruption©ÚsurfacesÚtermsÚtypesÚpaper_queriesÚsignal_querieszEV Charging)Úv2gúvehicle to gridú	iso 15118úcharging stationÚocppZevsezsmart chargingú
power grid)z5electric vehicle charging infrastructure cyber attackzvehicle-to-grid securityzISO 15118 security charging)zEV charging cyber incidentz"charging infrastructure disruptionzV2G security developmentzOCPP vulnerability incident)úCAN BusÚECUúUDS DiagnosticsÚInfotainmentÚGatewayÚOBD)úremote controlúremote commandzvehicle takeoverúremote code execution)z*vehicle remote control manipulation attackz$infotainment attack vehicle takeoverz!remote lock unlock vehicle attack)zvehicle remote control incidentz automotive function manipulationz!connected vehicle takeover report)zcritical infrastructureznational securityÚ	satelliteÚsovereigntyZ
resiliencez<connected vehicles critical infrastructure national securityz)satellite communication vehicles security)z)automotive critical infrastructure threatz$connected vehicles national securityz,transportation infrastructure cyber campaignz*satellite vehicle communication disruption)zsecure developmentzsecure bootútype approvalúpenetration testingÚfuzzingúsecurity testingZ	lifecycle)r   r   r   z'automotive secure development lifecyclez+vehicle type approval cybersecurity testing)z2automotive type approval cybersecurity developmentz vehicle lifecycle security issuez)automotive testing capability development)	zautonomous vehiclezautonomous vehicleszautonomous drivingZadaszself drivingZ
perceptionZlidarZadversarialzsensor spoofing)z&autonomous vehicle cyber attack safetyz0adversarial attack autonomous driving perceptionz$sensor spoofing lidar camera vehicle)z$autonomous vehicle security incidentzADAS manipulation reportz vehicle sensor spoofing incidentz$autonomous driving cyber development)úsupply chainÚsupplierúthird partyÚ
dependencyútier 1úend of lifeúend of supportÚgeopoliticalz%automotive supply chain cybersecurityz-OEM supplier dependency vehicle cybersecurity)z"automotive supplier cyber incidentz(vehicle software supply chain compromisez%OEM third party dependency disruptionz"automotive geopolitical dependency)	Úprivacyúpersonal datazlocation dataZtrackingZgdprzdriver monitoringZoccupantzdata leakageÚsurveillance)z#connected car privacy personal dataz!vehicle location tracking privacyz driver monitoring camera privacy)z"connected vehicle privacy incidentz!automotive personal data exposurez vehicle location tracking reportz*driver monitoring surveillance development)Z	espionager2   Z
microphoneZcamerazsensor dataZexfiltrationz&vehicle espionage surveillance sensorsz!connected car data foreign access)zvehicle espionage campaignz%connected car intelligence collectionz#automotive sensor data exfiltrationzvehicle surveillance concern)z
unece r155Úr156ú	iso 21434úcyber resilience actZ
regulationr$   Z
compliancez/UNECE R155 R156 cybersecurity management systemzcyber resilience act automotive)z/automotive cybersecurity regulation developmentzUNECE R155 enforcementzvehicle type approval oversightzautomotive compliance gap)Úsbomzsoftware bill of materialsZfirmwarezreverse engineeringZarchitectureZvariantsúasset inventoryz*automotive SBOM software bill of materialsz/vehicle software transparency firmware analysis)zautomotive SBOM developmentz#vehicle firmware transparency issuezautomotive asset inventory gap)zintrusion detectionzanomaly detectionzsecurity operations centerZvsoczincident responseZloggingZ	telemetryZsiem)z"vehicle security operations centerz/automotive intrusion detection fleet monitoringz+vehicle incident response logging forensics)z(automotive incident response developmentz!vehicle SOC monitoring capabilityz"fleet intrusion detection incidentz automotive forensics development)ÚGNSSÚ	BluetoothúWi-FiÚV2X)ÚgnssÚgpsÚjammingÚspoofingÚsdrúsoftware defined radioÚwireless)zGNSS spoofing jamming vehiclesz%software defined radio vehicle attackzV2X wireless attack)z$GNSS jamming transportation incidentzvehicle wireless attack reportzV2X security incidentzautomotive radio interference)Úllmúlarge language modelúmachine learningÚaiúsoftware supply chainúopen sourcer+   Úcloud)z(large language model automotive securityz AI software supply chain vehiclez#cloud AI services connected vehicle)z"automotive AI security developmentzvehicle cloud service incidentz#AI software supply chain compromisez-connected vehicle external service disruption)úKeyless / Hardwarer   r   )úrelay attackzcan injectionzkey fobZkeylessÚimmobilizerzvehicle theftz	car theftz(relay attack keyless entry vehicle theftzCAN injection vehicle theft)zdigital vehicle theft campaignzkeyless relay theft incidentzCAN injection theft reportzautomotive crime tooling)z-Mobility Services and Large-Scale Disruptionsz(Energy, Charging, and V2G Infrastructurez)Vehicle Control and Function Manipulationz-Critical Infrastructure and National Securityz/Development, Approval, and Lifecycle Managementú#Road Safety and Autonomous Vehiclesz1Vehicle Ecosystem, Supply Chain, and Dependenciesz(Privacy, Personal Data, and Surveillancez$Espionage and Intelligence Gatheringz%Governance, Regulation, and Oversightz1Software, Hardware, and Architecture Transparencyz,Detection, Monitoring, and Incident Responsez/Communication, Navigation, and Wireless Attacksz1AI, Software Supply Chains, and External ServiceszVehicle Theft and Digital CrimerM   r   )r   r   )r   Zgridr   r   )r   r   r   )r   r   r	   r   r   Zsabotage)r   r	   r   )zremote disablerL   zkill switch)r	   r   r
   r:   r9   )ZbotnetZddosr!   )r   r   r   )r/   r#   Zforeignztrusted supplierzexport control)r   r   )r   r   r   )z	head unitZinfotainmentZivir5   )r-   r.   Zpatchingzsoftware updateszlong term supportr8   )r<   r=   zgps spoofingr>   r?   )r   r   r   )zinformation disclosurezsensitive informationr1   r0   )r   r   )rC   rD   rE   zvulnerability discoveryr&   zautomated exploit)r   r   r   Úusbzphysical accessrJ   r
   )zremote lockzcentral lockingzremote unlock)zfactory resetzdata deletionzsecond handzused vehicleZdisposal)r   r
   r	   r   Zmanipulationr    )rI   zvoice assistantzai assistantZedgezexternal serviceÚbackendr   )ZaftermarketÚdonglez
obd dongleZtuningZretrofit)zSDR / RadiorJ   r9   r:   r;   )r@   rA   z	gnu radiorK   zreplay attack)r"   ZsatcomZstarlink)Z
bankruptcyr.   Z	financialr	   )rO   rI   Zapi)r9   r:   r;   r	   zcommunication channelrB   r   )Zotazsoftware updater3   )zsocial engineeringZphishingZinsider)r   r9   r:   r   )rN   ZobdrP   r   )Zcredentialszfirmware extractionzkey extraction)r   r   r   r   )ZcertificateZpkizcryptographic keyzkey managementr   )ZteleoperationÚdispatchr   r;   )ztraffic managementztraffic lightzroadside unitZrsuzintelligent transportation)zsingle point of failurezshared dependencyr(   )%zT-003zT-004zT-005zT-007zT-008zT-009zT-014zT-019zT-023zT-028zT-029zT-030zT-035zT-036zT-037zT-042zT-043zT-044zT-045zT-047zT-052zT-053zT-054zT-055zT-056zT-058zT-059zT-060zT-061zT-062zT-063zT-064zT-065zT-066zT-067zT-068zT-069)zT-010zT-012zT-013)zT-017zT-018)Zsafetyz	iso 26262Zsotifr4   zT-024)r%   r&   r'   r$   zT-025)zvehicle identificationzfleet inventoryr7   zT-027)r(   r)   r,   zT-031)zsupply chain attackr*   r+   zT-033)r6   rG   rH   r+   rC   rF   zT-038c                 C   s"   | d u rdS t  ddt| ƒ¡ ¡ S )NÚ z[ \t]+ú )ÚreÚsubÚstrÚstrip©Úv© rZ   úbuild_register.pyÚcleanZ  s    r\   c                 C   s   dd„ t  dt| ƒ¡D ƒS )Nc                 S   s   g | ]}|  ¡ r|  ¡ ‘qS rZ   )rW   )Ú.0ÚxrZ   rZ   r[   Ú
<listcomp>a  ó    zsplit_list.<locals>.<listcomp>z[;,])rT   Úsplitr\   rX   rZ   rZ   r[   Ú
split_list`  s    rb   c                 C   s”   | d u st | ƒdkrdS t| tƒr&| S t| tƒr4| S t| tƒrR|  ¡ rNt| ƒS | S t | ƒ}zt|ƒ}| ¡ rtt|ƒn|W S  tyŽ   | Y S 0 d S )NrR   )r\   Ú
isinstanceÚboolÚintÚfloatÚ
is_integerÚ
ValueError)rY   ÚtextZnumberrZ   rZ   r[   Ú	as_numberd  s    


rj   c              &      sp  t | jdd�ƒ}|stdƒ‚dd„ |d D ƒ}dd„ t|ƒD ƒ‰ h d	£}t|tˆ ƒ ƒ}|rntd
d |¡ ƒ‚‡ fdd„}g }tƒ }|dd … D �]È}t||dƒƒ}	t 	d|	¡s²q�|	|v rÈtd|	› �ƒ‚| 
|	¡ t||dƒƒ}
t||dƒƒ}g }|
g|¢D ]}|rü||vrü| |¡ qü| |	t||dƒƒddt||dƒƒt||dƒƒ||
|dt||dƒƒt||dƒƒt||dƒƒt||dƒƒt||dƒƒt||dƒƒt||dƒƒt||dƒƒt||d ƒƒt||d!ƒƒt||d"ƒƒt||d#ƒƒt||d$ƒƒt||d%ƒƒt||d&ƒƒt||d'ƒƒ�pt||d(ƒƒdg t||d)ƒƒt||d)ƒƒt||d*ƒƒt||d(ƒƒd+œ ¡ q�|jd,d-„ d.� |S )/NT©Zvalues_onlyz-Worksheet 'Collated Threat Taxonomy' is emptyc                 S   s   g | ]}t |ƒ‘qS rZ   )r\   )r]   ÚhrZ   rZ   r[   r_   y  r`   z!read_collated.<locals>.<listcomp>r   c                 S   s   i | ]\}}|r||“qS rZ   rZ   )r]   Úirl   rZ   rZ   r[   Ú
<dictcomp>z  r`   z!read_collated.<locals>.<dictcomp>>   úSecondary domain(s)úPrimary domainúPrimary categoryúThreat Sourceú	Threat IDúAnalysis/DescriptionúThreat titlez6Missing required columns in Collated Threat Taxonomy: z, c                    s*   ˆ   |¡}|d ur&|t| ƒk r&| | S d S )N)ÚgetÚlen)ÚrowÚnameÚidx©ÚcolrZ   r[   Úcell€  s    
zread_collated.<locals>.cellé   rs   úT-\d{3}zDuplicate threat ID: rp   ro   ru   rR   rr   rq   rt   zImpact (based on older scale)z%Impact Rationale (based on new scale)z'Impact Explanations/Comments/RationaleszPhysical Safety ImpactzEconomic/Financial Impactz"Social, Political & Privacy ImpactzTerritorial Security ImpactzCombined impact classzImpact scorez!Likelihood (based on older scale)zLikelihood rationalezCombined likelihood classzLikelihood scorezCombined risk scorezCombined ratingz"Risk rating (based on older scale)zAdditional commentsz!Risk score (based on older scale)) ÚidÚtitleZtitle_nlZ
title_noteÚsourceÚcategoryÚaffectsZprimary_domainZsecondary_domainsZdomain_rationaleZdescriptionZimpactZimpact_rationaleZimpact_explanationZphysical_safety_impactZeconomic_financial_impactZsocial_political_privacy_impactZterritorial_security_impactZimpact_classZimpact_scoreZprobabilityZlikelihood_rationaleZlikelihood_classZlikelihood_scoreZ
risk_scoreZriskZpriorityZtagsZrisk_rationaleZadditional_commentsZlegacy_risk_scoreZlegacy_risk_ratingc                 S   s   | d S )Nr€   rZ   )ÚitemrZ   rZ   r[   Ú<lambda>µ  r`   zread_collated.<locals>.<lambda>)Úkey)ÚlistÚ	iter_rowsrh   Ú	enumerateÚsortedÚsetÚjoinr\   rT   Ú	fullmatchÚaddrb   Úappendrj   Úsort)ÚwsZrowsÚheadZrequiredZmissingr}   ÚoutÚseenrx   ÚtidZprimaryZ	secondaryr„   ZdomainrZ   r{   r[   Úread_collatedu  sz    
à
"r—   c                 C   sv   i }t | jdd�ƒdd … D ]T}tt|ƒdkr6|d nd ƒ}tt|ƒdkrR|d nd ƒ}t d|¡r|r|||< q|S )NTrk   r~   r   é   r   )rˆ   r‰   r\   rw   rT   rŽ   )r’   Zareasrx   r–   ÚarearZ   rZ   r[   Úread_annex5_areas¹  s    
rš   c                  C   s`  dd„ t jdd … D ƒ} | r$| d nt}t|ƒ ¡ sTtdƒt }| ¡ rPt|ƒn|}t|ddd�}d}d	}||jvr‚td
|› �ƒ‚||jvrštd
|› �ƒ‚t	|| ƒ}t
|| ƒ}|D ]}| |d ¡}	|	r¶|	|d< q¶dt jvrètdƒ dd„ |D ƒttƒ }
|
�rtd|
ƒ |D ]¢}tt |d tg g tg g d�¡ƒ}| t |d i ¡¡ t| dg ¡ƒ|d< t| dg ¡ƒ|d< t| dg ¡ƒ|d< t| dg ¡ƒ|d< t| dg ¡ƒ|d< �qddd	dd	dddddœt|d œ}ttƒ}|jjddd!� |jtj|d"d#d$�d%d&� td'd(„ |D ƒƒ}td)d(„ |D ƒƒ}td*t› d+t|ƒ› d,ttƒ› d-|› d.|› d/�ƒ d S )0Nc                 S   s   g | ]}|  d ¡s|‘qS )z--)Ú
startswith)r]   ÚarZ   rZ   r[   r_   Ä  r`   zmain.<locals>.<listcomp>r~   r   z/mnt/user-data/uploadsT)Z	read_onlyZ	data_onlyzCollated Threat TaxonomyzAdditional Risks added by RDW zRequired worksheet not found: r€   Zannex5_areaz--include-rdwzXNote: --include-rdw is retained for compatibility; all 69 collated threats are included.c                 S   s   h | ]}|d  ’qS )rƒ   rZ   )r]   ÚtrZ   rZ   r[   Ú	<setcomp>Þ  r`   zmain.<locals>.<setcomp>z$WARNING: categories without profile:rƒ   r   r   r   r   Úevidence_typesr   r   aw  Generated by build_register.py from the workbook. 'surfaces', 'terms' and 'evidence_types' decide which evidence may be correlated to a threat. Supported types are cve, paper, repo and signal. evidence_types [] means that no directly correlated external evidence is expected. Signal evidence provides contextual or strategic support and does not by itself prove exploitation.zNKnown vulnerability evidence associated with a technical component or surface.z;Academic or technical research supporting the threat model.zCPublic tooling, proof-of-concept, detection or mitigation research.ziIncident reporting, public reporting or strategic development that supports or contextualises the threat.r   )Z_commentÚsource_worksheetÚannex5_enrichment_worksheetr    r¡   Zevidence_type_definitionsZ
categoriesÚthreats)ÚparentsÚexist_okr˜   F)ÚindentZensure_asciizutf-8)Úencodingc                 s   s"   | ]}d |  dg ¡v rdV  qdS )r   rŸ   r~   N©rv   ©r]   ÚthreatrZ   rZ   r[   Ú	<genexpr>  s   ÿzmain.<locals>.<genexpr>c                 s   s   | ]}|  d ¡sdV  qdS )rŸ   r~   Nr§   r¨   rZ   rZ   r[   rª     s   
ÿzWrote z: z
 threats, z categories, z signal-enabled threats, z organisational threats)ÚsysÚargvÚDEFAULT_XLSXr   ÚexistsrV   r   Z
sheetnamesrh   r—   rš   rv   ÚprintrŒ   Ú
CATEGORIESÚdictÚALLÚupdateÚ	OVERRIDESrˆ   ÚOUTÚparentÚmkdirZ
write_textÚjsonÚdumpsÚsumrw   )ÚargsZxlsxZaltÚwbZcollated_sheetZannex_sheetr¢   Zannex5_areasr©   r™   ÚunknownZprofileÚdataZoutput_pathZsignal_enabledZorganisationalrZ   rZ   r[   ÚmainÃ  s”    




ûþÿüìþÿÿÿÿÿr¿   Ú__main__)Ú__doc__r¸   rT   r«   Úpathlibr   Zopenpyxlr   r­   rµ   Z	TECHNICALZ	STRATEGICZTECHNICAL_WITH_SIGNALSr²   r±   r°   ZAVr´   r–   r\   rb   rj   r—   rš   r¿   Ú__name__rZ   rZ   rZ   r[   Ú<module>   s€  þø÷÷þøþø÷þø÷þøþøþø÷÷÷þø€ © mÚ)D
a
