Monthly Archives: April 2015

Get Querystring With jQuery – Darlesson Oliveira

Get Querystring With jQuery – Darlesson Oliveira.

Understanding the AD Account attributes – LastLogon, LastLogonTimeStamp and LastLogonDate – TechNet Articles – United States (English) – TechNet Wiki

Understanding the AD Account attributes – LastLogon, LastLogonTimeStamp and LastLogonDate – TechNet Articles – United States (English) – TechNet Wiki.

Validate Asset number using Sharepoint column validation

In our organization asset numbers are printed in these formats:
03 XXXX
03 XXXXX
77 XXXX
77 XXXXX

A need arised to fill those numbers into sharepoint (printer toner consumption app), but without the space at the 3 place.

This is the validation formula for that:

=KDYŽ((JE.CHYBHODN(NAJÍT(” “;[Výdej pro HIM]))); KDYŽ(DÉLKA([Výdej pro HIM])>5; KDYŽ(JE.ČISLO([Výdej pro HIM]+0); KDYŽ(ZLEVA([Výdej pro HIM];2)=”03″; 1; ZLEVA([Výdej pro HIM];2)=”77”) ;0) ;0) ;0)

which translates into:


if input does not contain space then
if length of input is > 5 then
if input IsNumber then
if two leftmost charecters="03" then
return true
else
if two leftmost charecters="77"
return true
else
return false
else return false
else return false
else return false

How to Use ‘OR’ Type Options in SharePoint 2010 Column Validation | PremierPoint Solutions

IF(ISERROR( ((LEN([ZIP Code])=5) +(CODE(MID([ZIP Code],1,1))>47) +(CODE(MID([ZIP Code],1,1))47) +(CODE(MID([ZIP Code],2,1))47) +(CODE(MID([ZIP Code],3,1))47) +(CODE(MID([ZIP Code],4,1))47) +(CODE(MID([ZIP Code],5,1))47) +(CODE(MID([ZIP Code],1,1))47) +(CODE(MID([ZIP Code],2,1))<58)

via How to Use ‘OR’ Type Options in SharePoint 2010 Column Validation | PremierPoint Solutions.

Powercli – How to get Vmware tools version | Virtual Me

get-vm | where {$_.powerstate -ne “PoweredOff” } | where {$_.Guest.ToolsVersionStatus -ne “guestToolsCurrent”} | % { get-view $_.id } | select Name, @{ Name=”ToolsVersion”; Expression={$_.config.tools.toolsVersion}}, @{ Name=”ToolStatus”; Expression={$_.Guest.ToolsVersionStatus}}

via Powercli – How to get Vmware tools version | Virtual Me.

To The Point

Anything about Technology and Business

PowerScripting Podcast

Shownotes and links for the PowerScripting Podcast, a podcast to help people learn Windows Powershell

Learn Powershell | Achieve More

What is this Powershell of which you speak?