Powershell DSC and Sharepoint farm installation


…this post was published on 2016 December 28.

Starting from this post, I will try to fill the table bellow, with <<Step by Step>> about DSC and Sharepoint 2013 or 2016 on different Windows OSs

​​​ ​​ Sharepoint 2013​​ ​​Sharepoint 2016
2008​ 2008 R2​ 2012 ​ 2012 R2​ 2016​ 200​​​8​ 200​​​8 R2​ 2012​ 2012 R2​​ ​​2016
​Special Steps ​N/A​ Yes​*2
​​
N/A​​ Yes​*1 X​ X​ X​ N/A​​ N/A​​​ ​​N/A​​
​Prerequ​isites ​N/A​ link​​ N/A​​ link X​ X​ X​ N/A​​ N/A​​​ ​​N/A​​
​Setup N/A​​ link​​​ N/A​​ link X​ X​ X N/A​​ N/A​ ​​N/A​​
​… ​N/A​​ N/A​ N/A​​ N/A​​ X​ X​ X N/A​ N/A​ ​​N/A​​​​
​… ​N/A​​ N/A​​ N/A​​ N/A​​ X​ X​ X​ N/A​ N/A​​​ ​​N/A​​

 

*1 check  more details on Sharepoint Prerequisites 2013​ on Windows Server 2012 R2
*2
check  more details on Sharepoint Prerequisites 2013​ on​ Windows Server 2008 R2

Details about .NET Framework 4.6 and SharePoint installation

Posted in .NET, DSC, Powershell | Comments Off on Powershell DSC and Sharepoint farm installation

Powershell DSC to install Sharepoint 2013 Prerequisites in Windows 2012 R2 Server

…this post was published on 2016 December 28.

If you would like to install with zero ​touch on a target machine with 2012 R2 OS the prerequisites for Sharepoint server you can do it

First of all you need to setup  the target machine :
1. set the execution-policy to permit unsigned script to run
2. configure the group policy to permit .exe files to run without intervention
User Configuration/Administrative Templates/Attachment/Manager/Inclusion List for Low file types                          ( Edit/Enabled/Specify low risk: .exe / Apply )
3. uninstall if necesarry KB3102467 ( which installed .NET Framework 4.6 – incompatible with Sharepoint 2013 )

    ** in last tests, I can’t uninstall manually this feature, so the workaround is this link

 

On the main server, the push server​
 1. create a folder in which you’ll download the .zip file
,attached to this post. This file contain following files:
i. –   DownloadSP2013PreReqFiles.ps1 – this file will download from the Internet needed prerequisites files, except 2 of them
ii. –  KB2671763.exe
   iii. – and WcfDataServices56.exe
   iv. – DSC_SP2013Prerequisitesmain.ps1 – the main script
v. –  DSC_SP2013W2012Prerequisites.ps1 –  this file will create .mof files needed for DSC to configure LCM on target machine and to install features and packages as well , when the target machine is a Windows 2012 R2 Server
vi – DSC_SP2013W2008R2Prerequisites.ps1 – for the windows Server 2008 R2

  2. Unzip the zip file on the main/push server

   3. Run DSC_SP2013Prerequisitesmain.ps1 file.

    This script will:

 – create and configure locally a folder where all needed resources for the process will be stored ( you need to provide a name for prerequisites packages , but you can keep the default value c:\sp2013_prerequisites, if you push Enter )
you need to provide the target’s name server
– download from the net the needed files to that folder and will copy files ( ii and iii )
– will chek the operating system on the target machine and will select the specific file which will create mof files ( in our scenario, the target machine is with 2012R2 OS, and so the file it is: DSC_SP2013W2012Prerequisites.ps1
– finally will start the DSC process, will push the config to the target LCM
​​The target machine will reboot 3 times after it is ready to support SP2013 software setup process.

Here is the link to download the resource ​

For more explicit details watch this video

ERRATA

( until the next updates will come )

On line 38,39 please
replace sp2013 by your Domain name
replace “administrator” by a domain admin to permit rw to the shared folder

 

    New-SmbShare $folder_prerequisites -Path “c:\$folder_prerequisites” -ReadAccess “sp2013\$finalserver$” -Description “Sharepoint 2013 resources” -ErrorAction SilentlyContinue
    Grant-SmbShareAccess -Name $folder_prerequisites -AccountName “sp2013\administrator” -AccessRight Full  -Force

Posted in DSC, Powershell, Sharepoint 2013, YouTube | Comments Off on Powershell DSC to install Sharepoint 2013 Prerequisites in Windows 2012 R2 Server

Powershell 5.0 for DSC and LCM on Windows 2008 R2

…this post was published on 2016 December 25.

If you want to use DSC ( Desired State Configuration ) on a Server with 2008R2 OS ( as the bible 😉 say ) you should have at least Powershell v4 on remote machine

To check that, the easiest way in powershell console is :
$host.version

If you don’t have SP1 akready installed, it isn’t necesarry to check. The default version is 2.0
So, first step is to upgrade your server to 2008R  SP1, and after that you have to install  Microsoft .NET Framework 4.5.1 and Windows Management Framework 4.0  as well

A step by step doc is this one

So far so good, but this doesn’t mean you can set config using DSC on that remote 2008R2 server. You should enable winRM , in the command line:
winRM quickconfig

At this momment you installed owershell version 4.0 on remote server, you can access the server remotely, But what it doesn’t still work is LocalConfigurationManager ( which will manage for example rebooting preocess if necesarry when you install a program or a feature ).

Continue reading

Posted in DSC, Powershell | Comments Off on Powershell 5.0 for DSC and LCM on Windows 2008 R2

Save scripts as records in powershell

…this post was published on 2016 October 24.

would you like to save your work easy and also to keep your activy safe as a record?

First you should modify your profile, using following command
psedit $profile

and add following functions

i) Save your current file :

function Save-ISEScript {
  param(
 
  [Parameter(Mandatory=$True,Position=1)]
  [string]$nume,
  $path=’Your Powershell scripts path
    )
    $nume_complet = Join-Path  $path “$nume.ps1”
    $psise.CurrentFile.SaveAs($nume_complet, [System.Text.Encoding]::UTF8)
    }

Set your $path variable with your own path

To use the function, you will use
save-isescript yourfilename

ii) save ( backup ) current file as a record in separate place

-in a folder specified by you in $path variable, and a subfolder as your file name. The name will contain also the timestamp. Finally uit will set the record as Read-Only

function Save-AsRecord {
  param(
  $path=’Your Powershell scripts path\records\’
    )

    $nume_record = $path+(($psise.CurrentFile.DisplayName).Split(‘.’))[0]+’\’+(($psise.CurrentFile.DisplayName).Split(‘.’))[0]+’-‘+(get-date -Format ‘yyyymmddHHmmss’).tostring()+’.ps1′
    $nume_sursa = $psise.CurrentFile.FullPath

    $folder_complet =$path+(($psise.CurrentFile.DisplayName).Split(‘.’))[0]
            if(!(Test-Path -Path $folder_complet)){
                New-Item -ItemType directory -Path $folder_complet
            }

    copy $nume_sursa $nume_record
    (get-item $nume_record).Attributes =  “Archive”,”ReadOnly”
    Write-Host “A fost salvat ca record fisierul ‘$nume_record'” -ForegroundColor green -BackgroundColor gray
    }

To save the file as record, use:
Save-AsRecord

After you’ve modified your profile, restart your ISE session to use the functions.

Posted in Powershell | Comments Off on Save scripts as records in powershell

Cupon

…this post was published on 2016 September 28.

am primit in seara asta un email, si culmea, cica am castigat ceva gratuit. Cum nimic in viata asta nu e gratuit, m-a amuzat un pic.

Mailul cu pricina pe un telefon arata cam asa

respectiv pe PC, se pot vedea mai multe detalii

La prima vedere s-ar parea ca e de la eMAG. dar de la a doua

Continue reading

Posted in Alert, email, Virus | Comments Off on Cupon

Powershell and Sharepoint – Ep. 2 – Updating a picture library on O365 from Flickr site

…this post was published on 2016 July 24.

Hi

​bellow is the script ready to be used to update a picture library in Sharepoint Online with information from Flicrk.com

$results = @()
Import-Module MSOnline
$global:cred = Get-Credential
Connect-MsolService -Credential $global:cred

$url = “https://romeodonca-public.sharepoint.com”
$mylist =”pl_Wallpaper”
Add-Type -Path “your_path\Microsoft.SharePoint.Client.dll”
Add-Type -Path “your_path\Microsoft.SharePoint.Client.Runtime.dll”
$clientContext = New-Object Microsoft.SharePoint.Client.ClientContext($url)
$cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($cred.username, $cred.Password) 
$clientContext.Credentials = $cred
$query = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()
$web = $clientContext.Web
Posted in Office 365, Powershell, Sharepoint Online, YouTube | Comments Off on Powershell and Sharepoint – Ep. 2 – Updating a picture library on O365 from Flickr site

Sharepoint 2013 Licensing – Volume Licensing

…this post was published on 2016 July 24.

Let’s talk today about licensing, and in praticular about Sharepoint Licensing.
Based on business size, MS offer multiple Volume Licensing programs ​​

For Small business – fewer than 250 licenses
For Midsize and large business –  more than 250 licenses
For specialized organizations ( Government, Education, Health, Nonprofit )
–  this type of reprezentations is quite similar to Office 365 plans – For more details about Office 365 plans check this video ( in romanian )

​If you would like to maximize the value of your Licence agreement, you can adopt Software Assurance
Regarding Sharepoint, the general remarks before values, It’s important to know the server version, the number of servers, and the numbers of users or devices.
So, you should pay a license for each machine with Sharepoint server software installed – no matter of the role of that machine in the farm ) and also the license for the OS for that server.
Because excepting a testing env with Sharepoint Foundation – which contain already the SQL server express version –  you need also to pay licences for  your SQL installed servers + OS server license.
Regarding the CALs, you could use a user CAL or a device CAL depending on your organisation. The price is not necesarry the same for user CAL or device CAL
The price for enterprise CAL should be used in addition to standard CAL – so, if a user need a enterprise licence, you should buy a standard CAL plus the enterprise one
You can use a greater CAL version for accesing a lower version SP server  but not vice-versa.
For example, if you have more farms in your business, one with Server 2013 and one with 2016, to acces one of the these farm or both, the user will need only one CAL.
If it will use a 2013 SP CAL, it will can access only the Sharepoint 2013 farm, but if you buy a 2016 CAL for the user, it will can access both farms: 2013 and 2016 as well
Regarding the users – are 2 types of users:
Internal Users: Users who are the licensee’s or its affiliates’ employees and on-site agents and contractors.
External Users: Users who are not the licensee’s or its affiliates’ employees or on-site agents or contractors.
Regarding sites: are 3 types:
Intranet: Website hosting content, information, or software that is accessible inside the firewall to internal users only.
Extranet: Website hosting content, information, or software that is accessible inside the firewall to internal users and named external users only.
Internet: Website hosting content, information, or software that is publicly accessible to all users (internal and external).
For External users who access Extranet and/or  Internet sites no CALs are required. Click  here ​for more details
Regarding the prices, obtained from Softwaremedia, for Sharpeoint 2010 you have also the option for FastSearch, which is included in SP 2013 and 2016 and you don’t have to pay for it
Sharepoint 2010​ ​Sharepoint 2013 ​Sharepoint 2016
SP Server​ 6281 USD​ 6330 USD​
SP Server & SA​ 9712 USD​ 9712 USD 9712 USD​ (10197  MS source)
SP Standard Device CAL ​92 USD 87 USD
SP Standard Device CAL & SA​ 129 USD 129 USD​ 129 USD​
​SP Standard User CAL 112 USD​ 113 USD​
SP Standard User CAL & SA​ 167 USD 167 USD​ 167 USD​
SP Enterprise User CAL​ 108 USD​ 100 USD​
SP Enterprise User CAL & SA ​ 150 USD ​ ​​150 USD 150 USD​
SP Enterprise Device CAL 80 USD​ 77 USD​
SP Enterprise Device CAL & SA​ 115 USD​ 115 USD​ 115 USD​

A brief description about licensing scenarios in Sharepoint 2013 in the attached pdf file

20160724-Sharepoint-2013-Licensing-Volume-Licensing

For the official prices , directly from MS site, click this here – i recommend you to use keyborad to fill the form
Posted in License, Sharepoint 2013 | Comments Off on Sharepoint 2013 Licensing – Volume Licensing

Stream and Planner – are there

  …this post was published on 2016 July 19.

Yesss…
Stream and Planner apps are already there in Office365 portal –  for EE  tenants
Try them and​ enjoy!

For Stream, watch following presentation ( in Romanian )

Posted in Office 365, YouTube | Comments Off on Stream and Planner – are there

  Tutoriale Office 365 – Ep. 9 – Microsoft Stream

  …this post was published on 2016 July 19.

Episodul 9 | Microsoft Stream
Nivel: 2- Mediu

Noul serviciu de video sharing, anuntat astazi 18 iulie de catre Microsft prin ​James Philips, vine in intampinarea clientilor business din Office 365 pentru partajarea resurselor video de informare in cadrul companiei. Documentul de prezentare Stream poate fi gasit in original aici.
Partajarea resurselor se poate face diferent​iat fir intregii societatii, fie doar celui care publica, sau anumitor grupuri de lucru din companie.Asadar, este o modalitate excelenta, in ajutorul departamentelor HR, marketing, pentru popularizarea anumitor filme de prezentare produse interne sau sensibilizare privind anumite probleme/incidente/evenimente din cadrul companiei
​Din curiozitate, pentru mine si din dorinta de a va impartasi experienta acestui nou produs, am intregistrat cateva minute de <<Step by Step>> In speranta ca v-am starnit interesul, va invit sa urmariti prezentarea de mai jos:

Posted in Office 365, YouTube | Comments Off on   Tutoriale Office 365 – Ep. 9 – Microsoft Stream

Tutoriale Office 365 – Ep. 8 – Planurile Office365

  …this post was published on 2016 July 5.

Episodul 8 | Planurile Office365
Nivel: 1- Înce​pător

Microsoft ofera spre abonare pe langa serviciile individuale gen Exchange Online, Sharepoint Online, planurile compuse dedicate anumitor grupuri tinta
Aceste planuri prestabilite sunt in numar de 5
– Home Personal​
– Afaceri – Business si Enterprise
– Educatie
– Guvernamant
– Non-Profit
Fiecare dintre ele, contine mai multe planuri, cu optiuni si facilitati diferite, cu tarifare diferita in functie de specificatii. Unele dintre ele ofera versiunea de trial , pentru 30 de zile, caz in care veti subscrie automat pentru o perioada de 1 an la acel serviciu. In mod explicit puteti sa renuntati la subscriptia platita, daca in intervalul de incercare/test de 30 zile solicitati expres acest lucru.
Mai multe detalii prinvind planurie de servicii din Office 365 in prezentarea de mai jos.

Posted in Office 365, YouTube | Comments Off on Tutoriale Office 365 – Ep. 8 – Planurile Office365