MusicBrainz server log analysis: Splunk queries

*** Top entities ***

http 200 | regex url="^(/ws/\d)?/artist/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}" | top mbid
http 200 | regex url="^(/ws/\d)?/release-group/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}" | top mbid
http 200 | regex url="^(/ws/\d)?/release/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}" | top mbid
http 200 | regex url="^(/ws/\d)?/(recording|track)/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}" | top mbid
http 200 | regex url="^(/ws/\d)?/work/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}" | top mbid
http 200 | regex url="^(/ws/\d)?/label/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}" | top mbid

*** Static pages ***

http 200 url="^/doc/About" | stats count AS "About"
http 200 url="^/doc/About/Sponsors" | stats count AS "Sponsors"
http 200 url="^/doc/About/Team" | stats count AS "Team"
http 200 url="^/doc/About/Data_License" | stats count AS "Data License"
http 200 url="^/doc/Social_Contract" | stats count AS "Social Contract"
http 200 url="^/doc/Code_of_Conduct" | stats count AS "Code of Conduct"
http 200 url="^/doc/About/Privacy_Policy" | stats count AS "Privacy Policy"
http 200 url="^/elections" | stats count AS "Auto-editor Elections"
http 200 url="^/privileged" | stats count AS "Privileged User Accounts"
http 200 url="^/statistics" | stats count AS "Statistics"
http 200 url="^/statistics/timeline" | stats count AS "Timeline Graph"

http 200 url="^/doc/Products" | stats count AS "Products"
http 200 url="^/doc/MusicBrainz_Picard" | stats count AS "MusicBrainz Picard"
http 200 url="^/doc/Jaikoz" | stats count AS "Jaikoz tagger"
http 200 url="^/doc/Magic_MP3_Tagger" | stats count AS "Magic MP3 Tagger"
http 200 url="^/doc/MusicBrainz_for_Android" | stats count AS "MusicBrainz for Android"
http 200 url="^/doc/MusicBrainz_Server" | stats count AS "MusicBrainz Server"
http 200 url="^/doc/MusicBrainz_Database" | stats count AS "Musicbrainz Database"
http 200 url="^/doc/Developer_Resources" | stats count AS "Developer Resources"
http 200 url="^/doc/XML_Web_Service" | stats count AS "XML Web Service"
http 200 url="^/doc/Live_Data_Feed" | stats count AS "Live Data Feed"
http 200 url="^/doc/FreeDB_Gateway" | stats count AS "FreeDB Gateway"

http 200 url="^/search" | stats count AS "Search"
http 200 url="^/search/edits" | stats count AS "Search Edits"
http 200 url="^/browse" | stats count AS "Browse"
http 200 url="^/tags" | stats count AS "Tags"
http 200 url="^/cdstub/browse" | stats count AS "Top CD Stubs"

http 200 url="^/doc/How_Editing_Works" | stats count AS "Editing"
http 200 url="^/artist/create" | stats count AS "Add Artist"
http 200 url="^/label/create" | stats count AS "Add Label"
http 200 url="^/release-group/create" | stats count AS "Add Release Group"
http 200 url="^/release/add" | stats count AS "Add Release"
http 200 url="^/release/add?artist=89ad4ac3-39f7-470e-963a-56509c546377" | stats count AS "Add Various Artists Release"
http 200 url="^/recording/create" | stats count AS "Add Standalone Recording"
http 200 url="^/work/create" | stats count AS "Add Work"
http 200 url="^/edit/open" | stats count AS "Vote on Edits"
http 200 url="^/reports" | stats count AS "Reports"

http 200 url="^/doc/MusicBrainz_Documentation" | stats count AS "Documentation"
http 200 url="^/doc/Beginners_Guide" | stats count AS "Beginners Guide"
http 200 url="^/doc/Style" | stats count AS "Style Guidelines"
http 200 url="^/doc/Frequently_Asked_Questions" | stats count AS "FAQs"
http 200 url="^/doc/Edit_Types" | stats count AS "Edit Types"
http 200 url="^/relationships" | stats count AS "Relationship Types"
http 200 url="^/relationship-attributes/instruments" | stats count AS "Instrument Tree"
http 200 url="^/doc/Development" | stats count AS "Development"

http 200 url="^/doc/Contact_Us" | stats count AS "Contact Us"
http 200 url="^/doc/Mailing_Lists" | stats count AS "Mailing Lists"
http 200 url="^/doc/Copyright_Violation_Notice" | stats count AS "Report a Copyright Violation"

*** Web service statistics ***

Top inc parameters:

http 200 url="^/ws/1/artist/" | top inc
http 200 url="^/ws/1/release-group/" | top inc
http 200 url="^/ws/1/release/" | top inc
http 200 url="^/ws/1/recording/" | top inc
http 200 url="^/ws/1/work/" | top inc
http 200 url="^/ws/1/label/" | top inc

http 200 url="^/ws/2/artist/" | top inc
http 200 url="^/ws/2/release-group/" | top inc
http 200 url="^/ws/2/release/" | top inc
http 200 url="^/ws/2/track/" | top inc
http 200 url="^/ws/2/work/" | top inc
http 200 url="^/ws/2/label/" | top inc

Entities searched:

http 200 url="^/ws/1/artist/" query="*" | stats count
http 200 url="^/ws/1/release-group/" query="*" | stats count
http 200 url="^/ws/1/release/" query="*" | stats count
http 200 url="^/ws/1/track/" query="*" | stats count
http 200 url="^/ws/1/work/" query="*" | stats count
http 200 url="^/ws/1/label/" query="*" | stats count

http 200 url="^/ws/2/artist/" query="*" | stats count
http 200 url="^/ws/2/release-group/" query="*" | stats count
http 200 url="^/ws/2/release/" query="*" | stats count
http 200 url="^/ws/2/recording/" query="*" | stats count
http 200 url="^/ws/2/work/" query="*" | stats count
http 200 url="^/ws/2/label/" query="*" | stats count