I need to figure out how many of our 500+ lists are set up as discussion lists v. announcement/marketing lists.
Has anybody done this via MSSQL?
Most SQL queries I've seen are centered on members of a list, but I need to retrieve lists of a site/instance.
Any help is appreciated in advance.
Retrieving data ...