viernes, 5 de agosto de 2016

The Complete SharePoint 2013/2010 Site Collection Permission Report using PowerShell

Read more: http://www.sharepointdiary.com/2016/02/sharepoint-site-collection-permission-report-powershell-script.html#ixzz4GVMF8WRh

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$HTMLTemplate=@"

<html>

<head>

<!-- Sal - Javascript Function to apply formatting -->

<script type="text/javascript">

function altRows(id){

 if(document.getElementsByTagName){    

  var table = document.getElementById(id); 

  var rows = table.getElementsByTagName("tr");    

  for(i = 0; i < rows.length; i++){         

   if(i % 2 == 0){

    rows[i].className = "evenrowcolor";

   }else{

    rows[i].className = "oddrowcolor";

   }     

  }

 }

}

window.onload=function(){

 altRows('alternatecolor');

}

</script>

<!-- CSS Styles for Table TH, TR and TD -->

<style type="text/css">

body{ font-family: Calibri; height: 12pt; }

table.altrowstable {

 border-collapse: collapse; font-family: verdana,arial,sans-serif;

 font-size:11px; color:#333333; border-width: 1px; border-color: #a9c6c9;

 border: b1a0c7 0.5pt solid; /*Sal Table format */ 

}

table.altrowstable th {

 border-width: 1px; padding: 5px; background-color:#8064a2;

 border: #b1a0c7 0.5pt solid; font-family: Calibri; height: 15pt;

 color: white;  font-size: 11pt;  font-weight: 700;  text-decoration: none;

}

table.altrowstable td {

 border: #b1a0c7 0.5pt solid; font-family: Calibri; height: 15pt; color: black;

 font-size: 11pt; font-weight: 400; text-decoration: none;

}

.oddrowcolor{ background-color: #e4dfec; }

.evenrowcolor{ background-color:#FFFFFF; }

</style>

</head>

<body>

"@

#Function to get permissions of an object Sal. Such as: Web, List, Folder, ListItem

Function Get-Permissions([Microsoft.SharePoint.SPRoleAssignmentCollection]$RoleAssignmentsCollection, $OutputReport)

{

   foreach($RoleAssignment in $RoleAssignmentsCollection)

    {

        #Get the Permissions assigned to Group/User

        $UserPermissions=@()

        foreach ($RoleDefinition in $RoleAssignment.RoleDefinitionBindings)

        {

            #Exclude "Limited Access" - We don't need it sal.

            if($RoleDefinition.Name -ne "Limited Access")

            {

                $UserPermissions += $RoleDefinition.Name +";"

            }   

        }

        if($UserPermissions)

        {

            #*** Get  User/Group Name *****#

            $UserGroupName=$RoleAssignment.Member.Name

            $UserName=$RoleAssignment.Member.LoginName 

            #**** Get User/Group Type ***** Is it a User or Group (SharePoint/AD)?

            #Is it a AD Domain Group?

            If($RoleAssignment.Member.IsDomainGroup)

                {

                   $Type="Domain Group"

                }

            #Is it a SharePoint Group?           

            Elseif($RoleAssignment.Member.GetType() -eq [Microsoft.SharePoint.SPGroup])

            {

                 $Type="SharePoint Group"

            }

            #it a SharePoint User Account

            else

            {

                   $Type="User"

            }

            #Send the Data to Report

            " <tr> <td> $($UserGroupName) </td><td> $($Type) </td><td> $($UserName) </td><td>  $($UserPermissions)</td></tr>" >> $OutputReport

        }

    }

}

Function Generate-PermissionRpt()

{

    Param([Parameter(Mandatory=$true)] [string]$SiteCollectionURL,

          [Parameter(Mandatory=$true)] [string]$OutputReport,

          [Parameter(Mandatory=$true)] [bool]$ScanFolders,

          [Parameter(Mandatory=$true)] [bool]$ScanItemLevel)

    #Try to Get the site collection 

    try

    {

        $Site = Get-SPSite $SiteCollectionURL -ErrorAction SilentlyContinue

    }

    catch

    {

        write-host Site Collection with URL:$SiteCollectionURL Does not Exists!

        return

    }  

    #Append the HTML File with CSS into the Output report

    $Content = $HTMLTemplate > $OutputReport

    "<h2> Site Collection Permission Report: $($Site.RootWeb.Title) </h2>" >> $OutputReport

    #Table of Contents

    "<h3> List of Sites</h3> <table class='altrowstable' id='alternatecolor' cellpadding='5px'><tr><th>Site Name </th><th> URL </th><th> Permission Setup </th></tr>" >> $OutputReport

    #Get Users of All Webs : Loop throuh all Sub Sites

    foreach($Web in $Site.AllWebs)

    {

        if($Web.HasUniqueRoleAssignments -eq $true)

        {

            $PermissionSetup ="Unique Permissions"

        }

        else

        {

            $PermissionSetup="Inheriting from Parent"

        }

        "<tr> <td> <a href='#$($web.Title.ToLower())'>$($web.Title)</a> </td><td> $($web.URL)</td> <td> $($PermissionSetup)</td></tr>" >> $OutputReport

    }

    #Site Collection Administrators Heading

    "</table><br/><b>Site Collection Administrators</b>" >> $OutputReport

     "<table class='altrowstable' id='alternatecolor' cellpadding='5px'><tr>" >> $OutputReport

    #Write Table Header

    "<th>User Account ID </th> <th>User Name </th></tr>" >> $OutputReport

    #Get All Site Collection Administrators

    $Site.RootWeb.SiteAdministrators | sort $_.Name | ForEach-Object { 

    "<tr><td> $($_.LoginName) </td> <td> $($_.Name)</td></tr> " >> $OutputReport

    }

    $Counter=0;

    #Get Users of All Webs : Loop throuh all Sub Sites

    foreach($Web in $Site.AllWebs)

    {

        Write-Progress -Activity "Collecting permissions data. Please wait..." -status "Processing Web: $($Web.URL)" -percentComplete ($Counter/$Site.AllWebs.count*100)

        #Check if site is using Unique Permissions or Inheriting from its Parent Site!

        if($Web.HasUniqueRoleAssignments -eq $true)

        {

            "</table><br/><hr> <h3>Site: <a name='$($Web.Title.ToLower())' href='$($web.URL)' target='_blank'>$($Web.Title)</a> is using Unique Permissions. </h3>" >> $OutputReport

        }

        else

        {

            "</table><br/><hr> <h3>Site: <a name='$($Web.Title.ToLower())' href='$($web.URL)' target='_blank'>$($Web.Title)</a> is Inheriting Permissions from its Parent Site.</h3>" >> $OutputReport

        }

        #Get the Users & Groups from site which has unique permissions - TOP sites always with Unique Permissions

        if($Web.HasUniqueRoleAssignments -eq $True)

        {       

            Write-host Processing Web $Web.URL

            #*** Get all the users granted permissions DIRECTLY to the site ***

            "<b>Site Permissions</b><table class='altrowstable' id='alternatecolor' cellpadding='5px'><tr>" >> $OutputReport

            "<th>Users/Groups </th> <th> Type </th><th> User Name </th> <th>Permissions</th></tr>" >> $OutputReport

            #Call the function to get Permissions Applied

            Get-Permissions $Web.RoleAssignments $OutputReport

            #****** Get Members of Each Group at Web Level *********#

            "</table></br> " >>$OutputReport

            #Check if any SharePoint Groups Exists, if yes, Get members of it

            $WebGroupRoleAssignments = $Web.RoleAssignments | Where { $_.Member.GetType() -eq [Microsoft.SharePoint.SPGroup]}

            if($WebGroupRoleAssignments)

            {

                "<b>Group Users</b><table class='altrowstable' id='alternatecolor' cellpadding='5px'><tr>" >>$OutputReport

                foreach($WebRoleAssignment in $WebGroupRoleAssignments)

                {

                    "<th colspan='3'><b>Group:</b> $($WebRoleAssignment.Member.Name)</th></tr> " >> $OutputReport

                    foreach($user in $WebRoleAssignment.member.users)

                    {

                        #Send the Data to Log file

                        " <tr> <td> $($user.Name) </td><td> $($user.LoginName) </td><td> $($user.Email)</td><tr>" >> $OutputReport

                    }

                }

            }

        } #Web.HasUniqueRoleAssignments Over     

     #********  Check All List's Permissions ********/

        foreach($List in $Web.lists)

        {

            #Skip the Hidden Lists

            if( ($List.HasUniqueRoleAssignments -eq $True) -and  ($List.Hidden -eq $false))

            {

                "</table><br/><b>List: [ $($List.Title) ] at <a href='$($List.ParentWeb.Url)/$($List.RootFolder.Url)'>$($List.ParentWeb.Url)/$($List.RootFolder.Url)</a> is using Unique Permissions.</b><table class='altrowstable' id='alternatecolor' cellpadding='5px'><tr>" >> $OutputReport

                "<th>Users/Groups </th><th> Type </th><th> User Name </th><th> Permissions</th></tr>" >> $OutputReport

                #Call the function to get Permissions Applied

                Get-Permissions $List.RoleAssignments $OutputReport

            }

            "</table>" >>$OutputReport

            #********  Check Folders with Unique Permissions ********/

            if($ScanFolders -eq $True)

            {

                $UniqueFolders = $List.Folders | where { $_.HasUniqueRoleAssignments -eq $True }    

                #Check if any folder has Unique Permission

                if($UniqueFolders)

                {

                    #Get Folder permissions

                    foreach($folder in $UniqueFolders)

                    {

                        #Write Table Headers

                        $FolderURL=$folder.ParentList.ParentWeb.URL/$folder.Url

                        "<br/><b>Folder: <a href='$($FolderURL)' target='_blank'>$($Folder.Title)</a> is using Unique Permissions.</b><table class='altrowstable' id='alternatecolor' cellpadding='5px'><tr>" >> $OutputReport

                        "<th>Users/Groups </th><th> Type </th><th> User Name </th><th> Permissions</th></tr>" >> $OutputReport

                        #Call the function to get Permissions Applied

                        Get-Permissions $folder.RoleAssignments $OutputReport

                        "</table>" >>$OutputReport

                    }

                }

            }

            #********  Check Items with Unique Permissions ********/

            if($ScanItemLevel -eq $True)

            {

                $UniqueItems = $List.Items  | where { $_.HasUniqueRoleAssignments -eq $True }    

                #Check if any Item has Unique Permission Sal

                if($UniqueItems)

                {

                    #Get Folder permissions

                    foreach($Item in $UniqueItems)

                    {

                        #Get Item's Name if Title is NULL

                        if($Item.Title -ne $null) {$ItemTitle = $Item.Title } else {$ItemTitle= $Item["Name"] }

                        #Write Table Headers

                        $ItemURL= $item.ParentList.ParentWeb.Site.MakeFullUrl($item.ParentList.DefaultDisplayFormUrl)

                        "<br/><b>Item: <a target='_blank' href='$($ItemURL)?ID=$($Item.ID)'>$($ItemTitle)</a> in list/library <a href='$($List.ParentWeb.Url)/$($List.RootFolder.Url)'>$($List.Title) </a> is using Unique Permissions.</b><table class='altrowstable' id='alternatecolor' cellpadding='5px'><tr>" >> $OutputReport

                        "<th>Users/Groups </th><th> Type </th><th> User Name </th><th> Permissions</th></tr>" >> $OutputReport

                        #Call the function to get Permissions Applied

                        Get-Permissions $Item.RoleAssignments $OutputReport

                        "</table>" >>$OutputReport

                    }

                }

            }

        } #List

    $Counter=$Counter+1;       

    } #Web

"</body></html>" >>$OutputReport

Write-host "`n Permission report generated successfully at "$OutputReport

}

#**********Configuration Variables************

$OutputReport = "C:\PermissionRpt.htm"

$SiteCollURL="http://portal.crescent.com"

$ScanFolders=$False

$ScanItemLevel=$False

#Call the function to Get Permissions Report

Generate-PermissionRpt $SiteCollURL $OutputReport $ScanFolders $ScanItemLevel

Read more: http://www.sharepointdiary.com/2016/02/sharepoint-site-collection-permission-report-powershell-script.html#ixzz4GVMa7S5b

jueves, 28 de julio de 2016

How To Repair A Suspect Database In MSSQL

Issue
You have a database in MS SQL that is tagged as (suspect) and you are unable to connect to the database.

Possible Causes

The database could have become corrupted.
There is not enough space available for the SQL Server to recover the database during startup.
The database cannot be opened due to inaccessible files or insufficient memory or disk space.
The database files are being held by operating system, third party backup software etc.
There was an unexpected SQL Server Shutdown, power failure or a hardware failure.

Resolution
These steps require you to have Microsoft SQL Server Management Studio installed on your computer. If you do not have this installed please follow the steps outlined in the following article: How To Connect To Your MS SQL Database

Open Microsoft SQL Server Management Studio and connect to your database
Click the New Query button
Paste the following SQL script into your New Query page replacing [YourDatabase] with the name of your database.

EXEC sp_resetstatus [YourDatabase];

ALTER DATABASE [YourDatabase] SET EMERGENCY

DBCC checkdb([YourDatabase])

ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [YourDatabase] SET MULTI_USER
Click Execute

Your database should no longer be tagged as (suspect) and you should be able to access it.

miércoles, 27 de julio de 2016

Powershell: List all IIS WebApplications (.net version, state, identity)

try{
Import-Module WebAdministration
Get-WebApplication

$webapps = Get-WebApplication
$list = @()
foreach ($webapp in get-childitem IIS:\AppPools\)
{
$name = "IIS:\AppPools\" + $webapp.name
$item = @{}

$item.WebAppName = $webapp.name
$item.Version = (Get-ItemProperty $name managedRuntimeVersion).Value
$item.State = (Get-WebAppPoolState -Name $webapp.name).Value
$item.UserIdentityType = $webapp.processModel.identityType
$item.Username = $webapp.processModel.userName
$item.Password = $webapp.processModel.password

$obj = New-Object PSObject -Property $item
$list += $obj
}

$list | Format-Table -a -Property "WebAppName", "Version", "State", "UserIdentityType", "Username", "Password"

}catch
{
$ExceptionMessage = "Error in Line: " + $_.Exception.Line + ". " + $_.Exception.GetType().FullName + ": " + $_.Exception.Message + " Stacktrace: " + $_.Exception.StackTrace
$ExceptionMessage
}

martes, 19 de julio de 2016

SQL Server Scripts

http://www.techbrothersit.com/search/label/SQL%20Server%20Scripts

Migración de dominio para SQL Server

Can I move SQL Server to another domain?

https://blogs.technet.microsoft.com/mdegre/2011/06/24/can-i-move-sql-server-to-another-domain/

Migrating SQL Server to New domain

http://social.technet.microsoft.com/wiki/contents/articles/24960.migrating-sql-server-to-new-domain.aspx

Migrating a SQL Cluster across Domains

https://blogs.technet.microsoft.com/bpaulblog/2013/01/27/migrating-a-sql-cluster-across-domains/

jueves, 23 de junio de 2016

Get-HyperVInventory: Create inventory reports of Hyper-V environments

PowerShell Tool Inventory Cluster

https://gallery.technet.microsoft.com/Get-HyperVInventory-Create-2c368c50

SharePoint \ SQL Server