ET INFO MSSQL SELECT SPID Query Observed

Query · suricata

flow:established,to_server;
content:"S|00|E|00|L|00|E|00|C|00|T|00 20 00 40 00 40 00|S|00|P|00|I|00|D|00 3b 00|"; nocase; fast_pattern; endswith;
Raw source ET INFO MSSQL SELECT SPID Query Observed · Suricata
Esc
Published by Emerging Threats Open ↗, licensed under BSD 3-Clause ↗. Line breaks added for readability; the rule is otherwise unchanged. 
alert tcp any any -> [$HOME_NET,$SQL_SERVERS] 1433 (
    msg:"ET INFO MSSQL SELECT SPID Query Observed";
    flow:established,to_server;
    content:"S|00|E|00|L|00|E|00|C|00|T|00 20 00 40 00 40 00|S|00|P|00|I|00|D|00 3b 00|"; nocase; fast_pattern; endswith;
    reference:url,learn.microsoft.com/en-us/sql/t-sql/functions/spid-transact-sql?view=sql-server-ver16;
    classtype:misc-activity;
    sid:2039181; rev:1;
    metadata:affected_product Microsoft_SQL_Server, attack_target SQL_Server, created_at 2022_10_12, deployment Perimeter, deployment Internal, deployment Datacenter, performance_impact Low, confidence High, signature_severity Informational, tag Description_Generated_By_Proofpoint_Nexus, updated_at 2022_10_12;
)

Detection rules belong to the projects that publish them and remain under their own licenses. This site indexes and links to them; it claims no rights in them.