--Count of all sites in all farms
SELECT COUNT(*) AS SiteCount 
FROM   Schema.SiteInventory

--Count of all documents in all farms
SELECT COUNT(*) AS DocumentCount 
FROM   Schema.DocumentInventory

--Count of all sites by farm
SELECT   Farm
              ,COUNT(*) AS SiteCount
FROM     Schema.SiteInventory
GROUP BY Farm
ORDER BY COUNT(*) DESC

--Count of all documents by farm
SELECT   Farm
              ,COUNT(*) AS DocumentCount
FROM     Schema.vwDocumentInventory
GROUP BY Farm
ORDER BY COUNT(*) DESC

--Count of all reporting files
SELECT   FileExtension
              ,COUNT(*)
FROM     Schema.vwDocumentInventory
WHERE    FileExtension IN ('.xlsx','.rdl','.xls','.sql','.xsl','.rsd','.rsds','.csv','.data','.rds','.db','.rdlx','.odc','.database','.json','.txt','.map','.xml')
GROUP BY FileExtension
ORDER BY COUNT(*) DESC

--Count of all team collab files
SELECT   FileExtension
              ,COUNT(*)
FROM     Schema.vwDocumentInventory
WHERE    FileExtension IN ('.docx','.pdf','.pptx','.doc','.eml','.msg','.one','.vsd','.html','.htm','.zip','.ppt','.ics','.ico','.onebin')
GROUP BY FileExtension
ORDER BY COUNT(*) DESC

--Count of all media files
SELECT   FileExtension
              ,COUNT(*)
FROM     Schema.vwDocumentInventory
WHERE    FileExtension IN ('.png','.jpg','.gif','.wmv','.tif','.bmp','.mp4','.jpeg','.avi','.mov')
GROUP BY FileExtension
ORDER BY COUNT(*) DESC

--Count of all other files
SELECT   FileExtension
              ,COUNT(*)
FROM     Schema.vwDocumentInventory
WHERE    FileExtension NOT IN ('.png','.jpg','.gif','.wmv','.tif','.bmp','.mp4','.jpeg','.avi','.mov',
                                                   '.docx','.pdf','.pptx','.doc','.eml','.msg','.one','.vsd','.html','.htm','.zip','.ppt','.ics','.ico','.onebin',
                                                   '.xlsx','.rdl','.xls','.sql','.xsl','.rsd','.rsds','.csv','.data','.rds','.db','.rdlx','.odc','.database','.json','.txt','.map','.xml')
GROUP BY FileExtension
ORDER BY COUNT(*) DESC