Tag Archive


admin ASCII Automation Bitlocker Calculated Field Caluculated CAML Chrome Clean Up Codeplex CSS Customizing Database Documents Features Get-SPDatabase Get-SPWebTemplate IE Import JSON Lists Look and Feel New-SPSite Page Tempates permissions PowerShell Reporting Script Scripts Settings Sharepoint stsadm ULViewer Users v4 Views XML XSL

PowerShell to get totals of Excel SpreadSheet Column and Post to Sharepoint List

This is a simple little script that I added on to a previous script to get Computer Bitlocker Report and Post the totals to Sharepoint 2010 List # Check if the Sharepoint Snapin is loaded already, and load if not if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) { Add-PSSnapin Microsoft.SharePoint.PowerShell } $reportcsv […]

Damn I am so lazy – Default Value Calculated Fields in a List

I know even as I was doing it that I was just being lazy. The issue was that each day I run a bitlocker script to update a chart of bitlockered machines on our intranet. The hard part (..right) was that I needed to manually create an Item in a Summary Graph so the numbers […]

Using Sharepoint Calculated Columns to Display Current Month List Items

How To: Using SharePoint Calculated Columns to Display Current Month List Items 1. create two computed columns (both calculated columns return Date Only values):       a. Created First Day Of Month             i. =DATE(YEAR([Created]),MONTH([Created]),1)       b. Created Last Day Of Month             i. =DATE(YEAR([Created]),MONTH([Created])+1,1)-1 I then added the below filters to view: