Generate personal report
Hi, im trying to do the next report:
Attack Report for IP Spoofing
January 5000 attacks
February 6500 attacks
March 3200 attacks
I want to obtain this results from the attack year table, but.. i dont know the logical of each one because I imagine that after more than 500,000 records another table is created.
I will query something like this:
SELECT ATTACK, COUNT(*) AS CTN FROM attack_vs_cli_year WHERE ATTACK='"ip spoofing"' and hour between "2007-12-01 00:00:00" and "2008-01-01 00:00:00"
In which order should I query every table? and how is the name assigned.
Thanks
Attack Report for IP Spoofing
January 5000 attacks
February 6500 attacks
March 3200 attacks
I want to obtain this results from the attack year table, but.. i dont know the logical of each one because I imagine that after more than 500,000 records another table is created.
I will query something like this:
SELECT ATTACK, COUNT(*) AS CTN FROM attack_vs_cli_year WHERE ATTACK='"ip spoofing"' and hour between "2007-12-01 00:00:00" and "2008-01-01 00:00:00"
In which order should I query every table? and how is the name assigned.
Thanks
Topic Participants
hugo.huerta
support+user
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?