which country user step here?

Tag Cloud

MOSS (47) SharePoint 2007 (37) SharePoint 2013 (25) SharePoint 2010 (22) MOSS admin (17) PowerShell (17) admin (17) developer (16) List (15) WSS (14) sql query (14) MOSS SP2 (13) end user (11) scripting (11) wss V3 (11) Moss issue (8) search (8) permission (7) sql (7) Service Pack (6) database (6) reportadmin (6) workflow (6) Excel (5) RBS (5) client object model (5) CU (4) Client Code (4) Command (4) Cumulative Updates (4) Patch (4) SharePoint designer (4) stsadm (4) ASP.NET (3) Content Database (3) Groove (3) Host Named Site Collections (HNSC) (3) IIS (3) Tutorial (3) alert (3) batch file (3) codeplex (3) error (3) incomming email (3) restore (3) upload (3) user porfile (3) Caching (2) Folder (2) Index (2) Internet (2) My Site Cleanup Job (2) My Sites (2) News (2) People Picker (2) Share Document (2) View (2) Web Development with ASP.NET (2) add user (2) authentication (2) coding (2) column (2) deploy solution (2) domain (2) download (2) enumsites (2) exam (2) export (2) issue (2) june CU (2) mySites (2) network (2) office 365 (2) orphan site (2) performance (2) profile (2) project server (2) query (2) server admin (2) theme (2) timer job (2) training (2) web master (2) web.config (2) wsp (2) 70-346 (1) 70-630 (1) AAM (1) Anonymous (1) Approval (1) Cerificate (1) Consultants (1) Content Deployment (1) Content Type (1) DOS (1) Document Library (1) Drive Sapce (1) Excel Services (1) Export to Excel (1) Feature (1) GAC (1) Get-SPContentDatabase (1) Get-WmiObject (1) HTML calculated column (1) ISA2006 (1) IT Knowledge (1) ITIL (1) Install (1) Link (1) MCTS (1) Macro (1) Migration (1) NLBS (1) Nintex (1) Office (1) Open with Explorer (1) ROIScan.vbs (1) Reporting Services (1) SPDisposeCheck.exe (1) SQL Instance name (1) SSRS (1) SharePoint admin (1) SharePoint farm (1) Shared Services Administration (1) Site Collection Owner (1) Site template (1) Steelhead (1) URLSCAN (1) VLOOKUP (1) WSS SP2 (1) XCOPY (1) admi (1) app (1) application pool (1) aspx (1) audit (1) availabilty (1) backup (1) binding (1) blob (1) branding sharepoint (1) cache (1) calendar (1) connection (1) copy file (1) counter (1) crawl (1) custom list (1) event (1) excel 2013 (1) facebook (1) filter (1) fun (1) group (1) iis log (1) import (1) import list (1) improment (1) interview (1) keberos (1) load balance (1) log in (1) metada (1) migrate (1) mossrap (1) onedrive for business (1) operation (1) process (1) publishing feature (1) resource (1) security (1) send email (1) size (1) sps2003 (1) sql201 (1) sql2012 (1) sub sites (1) system (1) table (1) task list (1) today date (1) vbs (1) video (1) web part (1) widget (1) windows 2008 (1) windows 2012 R2 (1) windows Azura (1) windows account (1) windows2012 (1) wmi (1)

Friday, January 5, 2018

How to check the RBS folder location and name base on the content database name ?

try to run powers hell command to find out the RBS folder location and name is use by specify content database but unable to find the command.

the method i have is run SQL query on the server to get the information i needed :

SELECT
    db.name AS DBName,
    type_desc AS FileType,
    Physical_Name AS Location
FROM
    sys.master_files mf
INNER JOIN
    sys.databases db ON db.database_id = mf.database_id


check on the file type FILESTREAM under the content database you looking for then will know which RBS .

Wednesday, November 1, 2017

Manually remove user from Profiles Missing from Import

Due to some requirement we need to disable the My Site Cleanup Timer Job , then we need to do manually clean up for those user is leaving organization.

Below is the script we can remove the user from user Profile (Profiles Missing from Import).

The reasons we remove it because we don't want other user click on the user leaving organization rout to user profile , want it point to user table information at site collection database.

More detail here :

https://blogs.msdn.microsoft.com/kaevans/2012/06/25/inside-the-sharepoint-2010-my-site-cleanup-timer-job/

========================================================================

if ((Get-PSSnapin “Microsoft.SharePoint.PowerShell” -ErrorAction SilentlyContinue) -eq $null) {
    Add-PSSnapin “Microsoft.SharePoint.PowerShell”
}
$siteUrl = "xxxx"
$site = Get-SPSite $siteUrl
$context = Get-SPServiceContext($site)
$site.Dispose();
$pm = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context); 

$ProfileDB = Get-SPDatabase | ? { $_.Type -eq “Microsoft.Office.Server.Administration.ProfileDatabase”}
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = $ProfileDB.DatabaseConnectionString
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = 'select NTName,RecordId from UserProfile_Full where bDeleted=1'
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$SqlConnection.Close();
Write-host 'TotalCount: ', $DataSet.Tables[0].Rows.Count

Write-Host 'Following Inactive Accounts will be deleted !'
foreach($user in $DataSet.Tables[0].Rows)
{
   write-host 'Planning to delete :' $user['NTName'], ',', $user['RecordId'] -ForegroundColor Green
   $profile = $pm.GetProfile($user['RecordId'])
   write-host $profile.DisplayName;
    #To enable delete operation remove comment out for below line
    #$pm.RemoveProfile($profile)
    write-host $user['NTName'] is deleted!!! -ForegroundColor Red
}
write-host 'Operation Completed !'

========================================================================

Wednesday, August 2, 2017

How to find out which site collection is using RBS ?

$SPWebApp = Get-SPWebApplication https://abc.com

foreach ($SPSite in $SPWebApp.Sites)
{
    if ($SPSite -ne $null)
    {
        $site=Get-SPSite $SPSite
Ssite
$dbname = $site.ContentDatabase.name
$dbname
$rbss=$site.ContentDatabase.RemoteBlobStorageSettings
#$rbss
        $SPSite.Dispose()
    }

}

Monday, June 5, 2017

SQL script add user to all content database

SET NOCOUNT ON;

DECLARE @user_name    SYSNAME
        , @login_name SYSNAME;

SELECT @user_name = ‘Domain\Account’,
       @login_name = ‘Domain\Account’

SELECT '
    USE ' + QUOTENAME(NAME) + '
CREATE USER ' + QUOTENAME(@user_name)
       + '
    ALTER ROLE [db_owner] ADD MEMBER [Domain\Account]
    GO
 
'
FROM   sys.databases
WHERE  database_id > 4

       AND state_desc = 'ONLINE'

---------------------------------------------------------------------------------------------------

  • execute the results to text then can copy and paste to run it 
  • excluded the system database



Sunday, March 19, 2017

SharePoint 2013 security hotfix remove the application pool permission from RBS content database DB owner

Question :
we notice after the security hotfix patch, application pool account is remove from the content Database DB owner (this setting is for RBS) , this is known issues ?

Answer :
Yes, after security hotfix Patch or any patch update, application pool account will be removed from the content Database DB owner for RBS enabled databases. We would need to add the account back as DB owner.