Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries, should producers of soft ware based services such as ATMs be held liable for economic injuries suffered when their systems fail?, nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry

Links

XODOX
Impressum

#1: Query for details

Posted on 2008-04-25 06:31:15 by sivasakthi

--=-OwV9yavCetlfEPftdR3z
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi all,


I have one table as following

AccessDetails

Date Time UserName
SiteName Status Virus_Category

|2008-04-23 | 14:27:38 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:39 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:40 | 172.16.1.92 | www.google.com
| D | Internet |
| 2008-04-23 | 14:27:40 | 172.16.1.40 | en.wikipedia.org
| A | unclassified |
| 2008-04-23 | 14:27:41 | 172.16.1.40 |
en.wikipedia.org | O | Internet |
| 2008-04-23 | 14:27:42 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:42 | 172.16.1.40 |
en.wikipedia.org | O | unclassified |
| 2008-04-23 | 14:27:43 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:43 | 172.16.1.40 |
meta.wikimedia.org | A | unclassified |
| 2008-04-23 | 14:27:47 | 172.16.1.34 |
googletb.skype.com | D | unclassified |


from the above table , i need the details of , how many total users,
how total accessed sited,how many total denied sites ,how many total
overridden sites and how many total sites(accessed+denied+overridden)
for particular Virus_Category with Date and Time.

In above table the Status shows A for accessed sites, D for Denied
sites,O for Overridden sites..


how can i form the query??


Thanks,


--=-OwV9yavCetlfEPftdR3z--

Report this message