Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bob3242
Starting Member
4 Posts |
 Posted - 2003-06-13 : 08:45:10
|
| I am creating reports from an internet scanner. There are many errors which I know are not security issues but still show up in my reports. I am trying to write code to edit these errors out of my reports. I do not know how to check that the error code and the IP Address of one record exactly matches that of the exceptions table.(ie. Vuln ID 1234 maybe ignored on IP 10.10.19.8 but not on all other machines)These are errors currently in the databaseAllVulnerabilities.[IP Address] and AllVulnerabilities.[Vuln ID]MachineExceptions is a table of IPs and Errors codes to be ignoredMachineExecptions.[IP Address] and MachineExceptions.[Vuln ID]Can anyone help?Bob |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-06-16 : 02:50:50
|
(From one Bob to another)Hi BobI'm not really sure exactly what you're asking, but it looks to me like you want something like this:--All Vulnerabilities which have no matches in MachineExceptionsselect * from AllVulnerabilities a where not exists (select * from MachineExceptions where IPAddress = a.IPAddress and VulnID = a.VulnID) Hope that helps (let me know if it doesn't)--I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 06/16/2003 02:53:56 |
 |
|
|
|
|
|
Tuple verification in SQL