Bluecoat access log search

[mikeyswizz]

I am trying to create a search that will give me the following information

I need all unique URLs, with their category and results.

Something all these lines: | table url category result

and get results as shown below. But i ONLY want unique URLs with their corresponding information. Any advise?

foxnews.com NEWS Observed

xgambling.com GAMBLING Observed

[gkanapathy]

perhaps you want the dedup or stats list(*) by url commands.