November 2015 – PhoeNIXBird Networks

[SPS] Export UPA User Properties values to text using PS

November 22, 2015 Andrei Rachita 0

#Add SPS Assemblies
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server")             
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server.UserProfiles")             
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")            
            
# Connect to CA site            
$site = new-object Microsoft.SharePoint.SPSite("http://yourCASite:9999");             
$ServiceContext = [Microsoft.SharePoint.SPServiceContext]::GetContext($site);                
$ProfileManager = new-object Microsoft.Office.Server.UserProfiles.UserProfileManager($ServiceContext)            
#Define output file and its headers          
$file = New-Object System.IO.StreamWriter "C:\temp\UserProfilestest2.txt";       
$file.WriteLine("AboutMe;NewBirthday;FirstNameAlpha;CellPhone;HomePhone;SPS-TimeZone;Innovation;SPS-Skills;FirmenichProjects;LastTraining;GenPubl;SPS-Responsibility;SPS-PastProjects;Language;Lang1;Lang1Level;Lang2;Lang2Level;Lang3;Lang3Level;Lang4;Lang4Level;propRoleMandate-IndAcc;propRoleMandate-keySharedAcc;propRoleMandate-DecRigOwn;propRoleMandate-DecRigInf;propRoleMandate-DecRigVal;propRoleMandate-ParaSucKeyMet;propRoleMandate-ParaSucTarMet;propRoleMandate-ParaSucOrg;SPS-Interests;PersoFlavor;PersoFragrance;PersoQuote;SPS-EmailOptin;FavouriteDivisions;FavouriteLinks");

#connect to user's profile and get properties

    $profile=$ProfileManager.GetUserProfile("domain\user")           
    
    $AboutMe=$profile["AboutMe"]
    $NewBirthday=$profile["NewBirthday"].value
    $FirstNameAlpha=$profile["FirstNameAlpha"]
    $CellPhone=$profile["CellPhone"]
    $HomePhone=$profile["HomePhone"]
    $SPSTimeZone=$profile["SPS-TimeZone"].value
    $Innovation=$profile["Innovation"]
    $SPSSkills=$profile["SPS-Skills"]
    $MyProjects=$profile["MyProjects"]
    $LastTraining=$profile["LastTraining"]
    $GenPubl=$profile["GenPubl"]
    $SPSResponsibility=$profile["SPS-Responsibility"]
    $SPSPastProjects=$profile["SPS-PastProjects"]
    $Language=$profile["Language"]
    $Lang1=$profile["Lang1"]
    $Lang1Level=$profile["Lang1Level"]
    $Lang2=$profile["Lang2"]
    $Lang2Level=$profile["Lang2Level"]
    $Lang3=$profile["Lang3"]
    $Lang3Level=$profile["Lang3Level"]
    $Lang4=$profile["Lang4"]
    $Lang4Level=$profile["Lang4Level"]
    $propRoleMandateIndAcc=$profile["propRoleMandate-IndAcc"]
    $propRoleMandatekeySharedAcc=$profile["propRoleMandate-keySharedAcc"]
    $propRoleMandateDecRigOwn=$profile["propRoleMandate-DecRigOwn"]
    $propRoleMandateDecRigInf=$profile["propRoleMandate-DecRigInf"]
    $propRoleMandateDecRigVal=$profile["propRoleMandate-DecRigVal"]
    $propRoleMandateParaSucKeyMet=$profile["propRoleMandate-ParaSucKeyMet"]
    $propRoleMandateParaSucTarMet=$profile["propRoleMandate-ParaSucTarMet"]
    $propRoleMandateParaSucOrg=$profile["propRoleMandate-ParaSucOrg"]
    $SPSInterests=$profile["SPS-Interests"]
    $PersoFlavor=$profile["PersoFlavor"]
    $PersoFragrance=$profile["PersoFragrance"]
    $PersoQuote=$profile["PersoQuote"]
    $SPSEmailOptin=$profile["SPS-EmailOptin"].value
    $FavouriteDivisions=$profile["FavouriteDivisions"]
    $FavouriteLinks=$profile["FavouriteLinks"]
    
    
#write output to defined variable
$file.Writeline("$($AboutMe);$($NewBirthday);$($FirstNameAlpha);$($CellPhone);$($HomePhone);$($SPSTimeZone);$($Innovation);$($SPSSkills);$($MyProjects);$($LastTraining);$($GenPubl);$($SPSResponsibility);$($SPSPastProjects);$($Language);$($Lang1);$($Lang1Level);$($Lang2);$($Lang2Level);$($Lang3);$($Lang3Level);$($Lang4);$($Lang4Level);$($propRoleMandateIndAcc);$($propRoleMandatekeySharedAcc);$($propRoleMandateDecRigOwn);$($propRoleMandateDecRigInf);$($propRoleMandateDecRigVal);$($propRoleMandateParaSucKeyMet);$($propRoleMandateParaSucTarMet);$($propRoleMandateParaSucOrg);$($SPSInterests);$($PersoFlavor);$($PersoFragrance);$($PersoQuote);$($SPSEmailOptin);$($FavouriteDivisions);$($FavouriteLinks)");

#close filewrite stream         
$file.close();            
#dispose site            
$site.Dispose()

#Add SPS Assemblies

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server")

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server.UserProfiles")

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")

# Connect to CA site

$site = new-object Microsoft.SharePoint.SPSite("http://yourCASite:9999");

$ServiceContext = [Microsoft.SharePoint.SPServiceContext]::GetContext($site);

$ProfileManager = new-object Microsoft.Office.Server.UserProfiles.UserProfileManager($ServiceContext)

#Define output file and its headers

$file = New-Object System.IO.StreamWriter "C:\temp\UserProfilestest2.txt";

$file.WriteLine("AboutMe;NewBirthday;FirstNameAlpha;CellPhone;HomePhone;SPS-TimeZone;Innovation;SPS-Skills;FirmenichProjects;LastTraining;GenPubl;SPS-Responsibility;SPS-PastProjects;Language;Lang1;Lang1Level;Lang2;Lang2Level;Lang3;Lang3Level;Lang4;Lang4Level;propRoleMandate-IndAcc;propRoleMandate-keySharedAcc;propRoleMandate-DecRigOwn;propRoleMandate-DecRigInf;propRoleMandate-DecRigVal;propRoleMandate-ParaSucKeyMet;propRoleMandate-ParaSucTarMet;propRoleMandate-ParaSucOrg;SPS-Interests;PersoFlavor;PersoFragrance;PersoQuote;SPS-EmailOptin;FavouriteDivisions;FavouriteLinks");

#connect to user's profile and get properties

$profile=$ProfileManager.GetUserProfile("domain\user")

$AboutMe=$profile["AboutMe"]

$NewBirthday=$profile["NewBirthday"].value

$FirstNameAlpha=$profile["FirstNameAlpha"]

$CellPhone=$profile["CellPhone"]

$HomePhone=$profile["HomePhone"]

$SPSTimeZone=$profile["SPS-TimeZone"].value

$Innovation=$profile["Innovation"]

$SPSSkills=$profile["SPS-Skills"]

$MyProjects=$profile["MyProjects"]

$LastTraining=$profile["LastTraining"]

$GenPubl=$profile["GenPubl"]

$SPSResponsibility=$profile["SPS-Responsibility"]

$SPSPastProjects=$profile["SPS-PastProjects"]

$Language=$profile["Language"]

$Lang1=$profile["Lang1"]

$Lang1Level=$profile["Lang1Level"]

$Lang2=$profile["Lang2"]

$Lang2Level=$profile["Lang2Level"]

$Lang3=$profile["Lang3"]

$Lang3Level=$profile["Lang3Level"]

$Lang4=$profile["Lang4"]

$Lang4Level=$profile["Lang4Level"]

$propRoleMandateIndAcc=$profile["propRoleMandate-IndAcc"]

$propRoleMandatekeySharedAcc=$profile["propRoleMandate-keySharedAcc"]

$propRoleMandateDecRigOwn=$profile["propRoleMandate-DecRigOwn"]

$propRoleMandateDecRigInf=$profile["propRoleMandate-DecRigInf"]

$propRoleMandateDecRigVal=$profile["propRoleMandate-DecRigVal"]

$propRoleMandateParaSucKeyMet=$profile["propRoleMandate-ParaSucKeyMet"]

$propRoleMandateParaSucTarMet=$profile["propRoleMandate-ParaSucTarMet"]

$propRoleMandateParaSucOrg=$profile["propRoleMandate-ParaSucOrg"]

$SPSInterests=$profile["SPS-Interests"]

$PersoFlavor=$profile["PersoFlavor"]

$PersoFragrance=$profile["PersoFragrance"]

$PersoQuote=$profile["PersoQuote"]

$SPSEmailOptin=$profile["SPS-EmailOptin"].value

$FavouriteDivisions=$profile["FavouriteDivisions"]

$FavouriteLinks=$profile["FavouriteLinks"]

#write output to defined variable

$file.Writeline("$($AboutMe);$($NewBirthday);$($FirstNameAlpha);$($CellPhone);$($HomePhone);$($SPSTimeZone);$($Innovation);$($SPSSkills);$($MyProjects);$($LastTraining);$($GenPubl);$($SPSResponsibility);$($SPSPastProjects);$($Language);$($Lang1);$($Lang1Level);$($Lang2);$($Lang2Level);$($Lang3);$($Lang3Level);$($Lang4);$($Lang4Level);$($propRoleMandateIndAcc);$($propRoleMandatekeySharedAcc);$($propRoleMandateDecRigOwn);$($propRoleMandateDecRigInf);$($propRoleMandateDecRigVal);$($propRoleMandateParaSucKeyMet);$($propRoleMandateParaSucTarMet);$($propRoleMandateParaSucOrg);$($SPSInterests);$($PersoFlavor);$($PersoFragrance);$($PersoQuote);$($SPSEmailOptin);$($FavouriteDivisions);$($FavouriteLinks)");

#close filewrite stream

$file.close();

#dispose site

$site.Dispose()

[SPS] Delete list items after a certain date using CAML

November 22, 2015 Andrei Rachita 0

If ((Get-PSSnapIn -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null )
{ Add-PSSnapIn -Name Microsoft.SharePoint.PowerShell } 
$web = Get-SPWeb -Identity "http://intranet.pbnet.pbnet.local/test" 
$list = $web.Lists["Test list"] 
$caml='<Where> 
<Geq> 
<FieldRef Name="Created" /> 
<Value IncludeTimeValue="TRUE" Type="DateTime">2013-01-01T00:00:00Z</Value> 
</Geq> 
</Where>' 
$query = New-Object Microsoft.SharePoint.SPQuery
$query.Query=$caml | Write-Output
$items=$list.GetItems($query) 
$listItemsTotal = $items.Count; 
for($x=$listItemsTotal-1;$x -ge 0; $x--)
{
$items[$x].Delete()
}

$web.Dispose()

If ((Get-PSSnapIn -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null )

{ Add-PSSnapIn -Name Microsoft.SharePoint.PowerShell }

$web = Get-SPWeb -Identity "http://intranet.pbnet.pbnet.local/test"

$list = $web.Lists["Test list"]

$caml='<Where>

<Geq>

</Geq>

</Where>'

$query = New-Object Microsoft.SharePoint.SPQuery

$query.Query=$caml | Write-Output

$items=$list.GetItems($query)

$listItemsTotal = $items.Count;

for($x=$listItemsTotal-1;$x -ge 0; $x--)

{

$items[$x].Delete()

}

$web.Dispose()

if you want to delete items before a certain date, just replace: <Leq> <FieldRef Name=”Created” /> <Value IncludeTimeValue=”TRUE” Type=”DateTime”>2013-01-01T00:00:00Z</Value> </Leq>

[O365] Connect to all online services using PowerShell

November 15, 2015 Andrei Rachita 0

First, you will need: http://www.microsoft.com/en-us/download/details.aspx?id=41950 –> Microsoft Online Services Sign-In Assistant for IT Professionals RTW https://msdn.microsoft.com/en-us/library/azure/jj151815.aspx#bkmk_installmodule –> Azure AD PowerShell http://www.microsoft.com/en-us/download/details.aspx?id=35588 –> SPO Management Shell […]