This VBScript will return the table sizes sorted by [Total KB] and then populate an Excel spreadsheet with the results. It will first ask for the servername you wish to connect to. The query is from KB Article: Article ID: 21310.
You will need the ASDK Notification server component installed on both the server and the client.