DO $$
DECLARE
result CONSTANT refcursor:= 'result';
BEGIN
PERFORM RPA_HRMD_REGISTER (@UsrId@::INTEGER);
PERFORM RPA_HRMD_EMPLOYEE (@UsrId@::INTEGER);
OPEN result FOR
SELECT
PYR.PAYROLL_ID,
EMP.EMPLOYEE_ID,
REG.REGISTER_ID,
REG.REGISTER_CODE AS "SİCİL NO",
REG.REGISTER_NAME||' '||REG.REGISTER_SURNAME AS "ADI SOYADI",
REG.CITIZENSHIP_NO AS "TC KİMLİK NO",
PYR.AMT_NET AS "NET ÖDENEN"
FROM HRMT_PAYROLL PYR
INNER JOIN RP_HRMD_EMPLOYEE EMP ON PYR.EMPLOYEE_ID = EMP.EMPLOYEE_ID
INNER JOIN RP_HRMD_REGISTER REG ON REG.REGISTER_ID = EMP.REGISTER_ID
WHERE TO_CHAR(PYR.PAYROLL_YEAR) = TO_CHAR('@Year@')
AND TO_CHAR(PYR.PAYROLL_MONTH) = TO_CHAR('@Month@')
ORDER BY REG.REGISTER_CODE;
END
$$;
FETCH ALL FROM result;
Intelligence View
Dynamic List Data Authority
DO $$ DECLARE result CONSTANT refcursor:= 'result'; BEGIN PERFORM RPA_HRMD_REGISTER (@UsrId@::INTEGER); PERFORM RPA_HRMD_EMPLOYEE (@UsrId@::INTEGER); OPEN result FOR SELECT PYR.PAYROLL_ID, EMP.EMPLOYEE_ID,…
1. Sofort-Triage & Abwehrmaßnahmen
SOC Incident Playbook: Vulnerability Remediation & Verification
title: Detect Exploitation - Dynamic List Data Authority
id: 00610550-b96b-4f7c-8ca8-fca3255e8871
status: experimental
description: Automatisch generierte SIEM-Erkennungsregel basierend auf CTI Intelligence
references:
- https://tsecurity.de/
author: iShareStuff CTI Automated Detection Engine
date: 2026-09-26
logsource:
category: network_connection
product: any
detection:
selection:
CommandLine|contains:
- 'exploit'
condition: selection
falsepositives:
- Legitime administrative Zugriffe oder Penetrationstests
level: high
tags:
- attack.initial_accessrule CTI_Threat_Indicator {
meta:
author = "iShareStuff CTI Automated Detection Engine"
date = "2026-09-26"
description = "YARA Signature for "
strings:
$str = "Dynamic List Data Authority" ascii wide
condition:
any of them
}index=security sourcetype IN ("cisco:asa", "pan:traffic", "zeek_conn", "suricata", "WinEventLog:Security")
("Dynamic List Data Authority")
| stats count earliest(_time) as first_seen latest(_time) as last_seen by src_ip, dest_ip, dest_host, signature
| eval first_seen=strftime(first_seen, "%Y-%m-%d %H:%M:%S"), last_seen=strftime(last_seen, "%Y-%m-%d %H:%M:%S")
| sort - countmessage: "*Dynamic List Data Authority*"CommonSecurityLog
| where Message has "Dynamic List Data Authority"
| summarize EventCount = count(), FirstSeen = min(TimeGenerated), LastSeen = max(TimeGenerated) by SourceIP, DestinationIP, DestinationPort, Activity
| extend DetectionRule = "iShareStuff-CTI-Compiled"
| sort by EventCount desc2. Cyber Threat Intelligence & Forensik
MITRE ATT&CK Matrix Navigator 14 Taktiken
tsecurity.de Cognitive Threat RAG
Kognitive Analyse für identifizierte Bedrohung: Erhöhte Bedrohungslage im Bereich Dynamic List Data Authority.... Basierend auf 368k Vektor-Korrelationen werden sofortige Isolationsmaßnahmen für betroffene Endpunkte empfohlen.
Netzwerk/Remote-Zugriff ohne Vorauthentifizierung möglich.
- 1. Perimeter-Inspektion: Relevante Portfreigaben und exponierte Endpunkte unverzüglich scannen.
- 2. Patch-Applikation: Hersteller-Hotfix einspielen oder betroffene Daemons in isolierte DMZ-Segmente überführen.
- 3. Telemetrie & EDR-Alerts: Prozessaufrufe und Child-Processes auf anomale Shell-Spawns überwachen.