Monthly Archives: April 2015

Get Querystring With jQuery – Darlesson Oliveira

Get Querystring With jQuery – Darlesson Oliveira.

Advertisements

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.

smsagent

Scripts, tools and tips, mostly around Microsoft SCCM and EMS

To The Point

Anything about Technology and Business

Brian's Power Windows Blog

Microsoft in the Enterprise. Windows, Hyper-V, Exchange, SQL, and more!

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?