Ultimi 20 accessi:

SELECT TOP 20 * from LogAccessi ORDER BY DataOraAccesso DESC

IPData/oraPaginaNominativoLiv.Browser
37.163.174.611/02/2025 17:28:48/appunti/web_latoserver/asp_sampleg/logindb/riservSechi Marco R Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36
37.163.174.611/02/2025 17:28:41/appunti/web_latoserver/asp_sampleg/logindb/riservSechi Marco R Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36
37.163.174.611/02/2025 17:27:47/appunti/web_latoserver/asp_sampleg/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36
37.163.174.611/02/2025 17:27:29/appunti/web_latoserver/asp_sampleg/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36
93.43.60.23024/10/2024 16:31:42/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36
93.43.60.23024/10/2024 16:31:31/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36
213.209.199.24829/04/2023 19:02:15/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0
213.209.199.24829/04/2023 19:02:08/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0
213.209.199.24829/04/2023 19:01:51/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0
213.209.199.24829/04/2023 19:01:43/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0
37.182.195.10606/06/2022 10:29:22/appunti/web_latoserver/asp_sampleG/logindb/riserv  Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36
37.182.195.10601/06/2022 17:40:04/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36
37.182.195.10601/06/2022 17:40:00/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36
37.182.195.10625/03/2022 16:31:58/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36
37.182.195.10625/03/2022 16:31:54/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36
37.182.195.10625/03/2022 14:15:08/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36
37.182.195.10625/03/2022 14:15:02/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36
87.17.81.13422/12/2018 14:59:37/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
87.17.81.13422/12/2018 14:59:24/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
79.52.101.23025/11/2016 17:53:09/appunti/web_latoserver/asp_sampleG/logindb/riservAmministratore W Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko

Statistiche per pagina:

SELECT NomePagina, Count(*) AS Nr, Max(DATAORAACCESSO) AS UltimoAccesso, Min(DATAORAACCESSO) AS PrimoAccesso FROM LOGACCESSI GROUP BY NomePagina

PaginaNr. accessiPrimo accessoUltimo accesso
/appunti/web_latoserver/asp_sampleG/logindb/riserv4911/02/2025 17:28:4811/10/2010 08:45:41
/corsi/asp_sampleG/logindb/riservata1.asp1428/01/2009 16:01:2228/06/2006 19:14:58
/corsi/asp_sampleG/logindb/riservata2.asp806/05/2008 17:26:0728/06/2006 19:15:32
/logindb/riservata1.asp302/06/2006 14:38:2002/06/2006 14:24:13
/logindb/riservata2.asp202/06/2006 14:38:1802/06/2006 14:38:04

Statistiche per Utente:

SELECT iif(isnull(Nominativo) or Nominativo='','Non Autorizzati',Nominativo) AS NOMIN, Count(*) AS Nr, Max(DATAORAACCESSO) AS UltimoAccesso, Min(DATAORAACCESSO) AS PrimoAccesso FROM LOGACCESSI GROUP BY iif(isnull(Nominativo)or Nominativo='','Non Autorizzati',Nominativo)

PaginaNr. accessiPrimo accessoUltimo accesso
Amministratore5611/02/2025 17:27:4702/06/2006 14:38:01
Non Autorizzati306/06/2022 10:29:2202/06/2006 14:24:13
Ospite129/11/2006 18:52:3229/11/2006 18:52:32
Sechi Marco1611/02/2025 17:28:4802/06/2006 14:38:18

Statistiche incrociata Pagina\User:

TRANSFORM IIf(IsNull(Count(*)),0,Count(*)) AS NrAccessi SELECT LOGACCESSI.NomePagina FROM LOGACCESSI GROUP BY LOGACCESSI.NomePagina PIVOT IIf(IsNull([Nominativo]) Or [Nominativo]='','Non Autorizzati',[Nominativo]);

Pagina\User AmministratoreNon AutorizzatiOspiteSechi Marco
/appunti/web_latoserver/asp_sampleG/logindb/riserv41107
/corsi/asp_sampleG/logindb/riservata1.asp9014
/corsi/asp_sampleG/logindb/riservata2.asp4103
/logindb/riservata1.asp1101
/logindb/riservata2.asp1001