And just for bonus points, and cause I'm trying to get good with regular expressions...
if you go to CM's command line and type
sat>/home/youraccount/reg.txt
That will open a sat terminal and send the output to reg.txt. The screen will go blank because you're outputting it to a file, but if you then type
ossi <enter> (for terminal type)
clist reg <enter> t <enter>
wait a few seconds/minutes
clogoff <enter> t<enter> y <enter>
You should be back at the bash prompt with a file reg.txt listing out everything. And I whipped up this little regex in a few minutes to turn it to csv:
sed '1,11d' reg.txt|awk 'NR % 6 != 0'|awk 'NR % 5 != 0'|awk 'NR % 4 != 0'|awk 'NR % 3 != 0'|awk 'NR % 2 != 0'|sed 's/^.//'|tr "\\t" ","|head -n -3>reg.csv
It means delete the first 11 lines, then delete every 6th line, then every 5th line, then every 4th line then every 3rd line then every 2nd line then delete the first character (the 'd') of every line, then replace tabs with commas, then remove the last 3 lines of the file, then output to "reg.csv".
Find a way to embed that as a database function and build reporting out of it after, or script a cron job with expect in some other server to login to your CM and pull it and you're off to the races.
