There are two SQL scripts included in the zip file. One allows you get a collection summary by PC and the other by GUID.
While this could be used directly from SQL or in an Altiris report the more likely use is when using the ASDK.
The ASDK does not include a function for getting this information directly. You can use this SQL code to run the ExecuteNSDatabaseQuery Method and get back the Collection summary by Collection Name or Guid.
Click to view.