Ejemplo de consulta para agrupar información en logs | Operating systems, scripting, PowerShell and security

Logs, PHP, Seguridad, Servidores

Entradas repetidas en los log:

/phpmyadmin/main.php
/phpMyAdmin/main.php
/myadmin/main.php
/phpmyadmin2/main.php
/PMA/main.php
/mysql/main.php
/db/main.php

/phpmyadmin/main.php

/phpMyAdmin/main.php

/myadmin/main.php

/phpmyadmin2/main.php

/PMA/main.php

/mysql/main.php

/db/main.php

Consulta:

select cs-uri-stem, count (*) as a from 'W3SVC1W3SVC1*.*' group by cs-uri-stem order by a desc

1	select cs-uri-stem, count () as a from 'W3SVC1W3SVC1.*' group by cs-uri-stem order by a desc

Ejemplo de consulta para agrupar información en logs (Servidores, Seguridad, PHP, Logs)