I’ve spent some time today improving “create K2 service memory dump script” (one which I already mentioned in “K2 MSMQ thread & MSMQ abort exception” blog post) and creating “collect dump support files”. Next step will be merging them into one and adding some nice to have things I have no time for right now. … Scripts for taking K2 service memory dumps
Often I need to test something and use SQL database table of particular size for my test, and sometimes it is easier to pick up some table of appropriate size (at least in terms of rows number) from what you already have. This is the case when this SQL script may come in handy: DROP … SQL Script: List all tables in DB with their row counts
The fastest way to do it is to use following PS script: Add-PSSnapin Microsoft.Sharepoint.Powershell$ListsInfo = @{}$TotalItems = 0$SiteCollection = Get-SPSite “http://sitecollection.domain.com/”ForEach ($Site in $SiteCollection.AllWebs){ForEach ($List in $Site.Lists){$ListsInfo.Add($Site.Url + ” – ” + $List.Title, $List.ItemCount)$TotalItems += $List.ItemCount}}$ListsInfo.GetEnumerator() | sort name | Format-Table -AutosizeWrite-Host “Total number of Lists: ” $ListsInfo.CountWrite-Host “Total number of ListItems: ” $TotalItems It … How to: get a number of lists and lists items for SharePoint site collection
