sharepoint 统计所有网站集中视频文件的总大小 c#

时间:2021-11-04 08:23:29

视频文件类型为:.avi .mov .rm .rmvb .wmv .asf .asx .mpg .mpeg .3gp .mp4 .flv .mkv .vob

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;
using System.IO;
using System.Web;
using System.Text.RegularExpressions;
using System.Data;


namespace GetVideoFiles
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("This tool is designed for find video fies in all Site collection.eg: .avi,.mov,.rm,.rmvb,.wmv,.asf,.asx,.mpg,.mpeg,.3gp,.mp4,.flv,.mkv,.vob");
            string pattern = @"(\.avi|\.mov|\.rm|\.rmvb|\.wmv|\.asf|\.asx|\.mpg|\.mpeg|\.3gp|\.mp4|\.flv|\.mkv|\.vob)$";
            Regex regex = new Regex(pattern, RegexOptions.IgnoreCase | RegexOptions.Compiled | RegexOptions.Singleline);

InitionFile();
            Console.WriteLine("Please input the web url:");
            String weburl = Console.ReadLine();
            Uri webAppUri = new Uri(weburl);
            SPWebApplication webApplication = SPWebApplication.Lookup(webAppUri);

Console.WriteLine("Name\tSize\tSizeOfVersions\tTotalSize\tWebUrl");
            writer.WriteLine("Name\tSize\tSizeOfVersions\tTotalSize\tWebUrl");


            Int64 allSitesSizes =0;
            Int64 allSitesHistorySizes = 0;
            Int64 allSitesTotalSizes = 0;
            foreach (SPSite site in webApplication.Sites)         
             {
                DataTable oDtRawData = null;
                oDtRawData = site.StorageManagementInformation(SPSite.StorageManagementInformationType.Document, SPSite.StorageManagementSortOrder.Decreasing, SPSite.StorageManagementSortedOn.Size,300000);
                /*  // if you wan to see column names, loop through all the columns and find out the names and grab the needed one.
                foreach (DataColumn oColumn in oDtRawData.Columns)
                        {
                             Console.WriteLine(oColumn.ColumnName);               
                          }
               */
                string siteUrl = site.Url;
                Int64 sizes = 0;
                Int64 historySizes = 0;
                Int64 totalSizes = 0;
                foreach (DataRow oRow in oDtRawData.Rows)
                 {                    
                    //Console.WriteLine("Processing......" + oRow["LeafName"].ToString());                                
                     if (regex.IsMatch(oRow["LeafName"].ToString()))
                     {
                         string size1 = oRow["Size"].ToString();
                         string historySize1 = oRow["SizeOfVersions"].ToString();
                         string totalSize1 = oRow["TotalSize"].ToString();
                         Int64 size = Convert.ToInt64(size1);
                         Int64 historySize = Convert.ToInt64(historySize1);
                         Int64 totalSize = Convert.ToInt64(totalSize1);
                         sizes = sizes + size;
                         historySizes = historySizes + historySize;
                         totalSizes = totalSizes + totalSize;
                        
                        // Console.WriteLine(oRow["LeafName"].ToString() + "\t" + oRow["Size"].ToString() + "\t" + oRow["SizeOfVersions"].ToString() + "\t" + oRow["TotalSize"].ToString() + "\t" + oRow["WebUrl"].ToString());
                         writer.WriteLine(oRow["LeafName"].ToString() + "\t" + oRow["Size"].ToString() + "\t" + oRow["SizeOfVersions"].ToString() + "\t" + oRow["TotalSize"].ToString() + "\t" + oRow["WebUrl"].ToString());
                        
                     }