which country user step here?

Tag Cloud

MOSS (47) SharePoint 2007 (37) SharePoint 2010 (22) SharePoint 2013 (22) MOSS admin (17) admin (17) PowerShell (16) developer (16) List (15) WSS (14) MOSS SP2 (13) sql query (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) client object model (5) CU (4) Client Code (4) Command (4) Cumulative Updates (4) SharePoint designer (4) stsadm (4) ASP.NET (3) Groove (3) Host Named Site Collections (HNSC) (3) IIS (3) Patch (3) Tutorial (3) alert (3) batch file (3) codeplex (3) error (3) incomming email (3) restore (3) upload (3) Caching (2) Content Database (2) Folder (2) Index (2) Internet (2) News (2) People Picker (2) RBS (2) Share Document (2) View (2) Web Development with ASP.NET (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) user porfile (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) My Site Cleanup Job (1) My Sites (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 farm (1) Shared Services Administration (1) Site Collection Owner (1) Site template (1) Steelhead (1) URLSCAN (1) VLOOKUP (1) WSS SP2 (1) XCOPY (1) add user (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) 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)

Thursday, February 23, 2017

RBS enable for sharepoint second content DB

1. add pool account to the dbowner content database


2.run sql script crease RBS group

USE WSS_Content_RBS
if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')
create master key encryption by password = N'Admin Key Password !2#4'

USE WSS_Content_RBS
if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')
alter database WSS_Content_RBS add filegroup RBSFilestreamProvider contains filestream

USE WSS_Content_RBS
alter database WSS_Content_RBS add file (name = RBSFilestreamFile, filename = 'F:\WSS_Content_staffhub_RBS_test') to filegroup RBSFilestreamProvider

 3.check blob folder created

4. Run at DB server for second content db

msiexec /lvx* WSS_Content_RBS.txt /i rbs.msi REMOTEBLOBENABLE=1 FILESTREAMPROVIDERENABLE=1 FILEGROUP=PRIMARY FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FileStreamProvider_1 ADDLOCAL=EnableRBS,FilestreamRunScript DBINSTANCE=

*use interface to setup
  
6.check will see rbs table

7.run powershell

$cdb = Get-SPContentDatabase WSS_Content_RBS
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])  #make sure is only one provider 
$rbss



8.upload file and check on RBS folder

Monday, July 25, 2016

Power Shell convert from excel to csv

 $excelFile = "D:\Test\excelfile\file.xlsx"
    $E = New-Object -ComObject Excel.Application
    $E.Visible = $false
    $E.DisplayAlerts = $false

 $wb = $E.Workbooks.Open($excelFile)
    foreach ($ws in $wb.Worksheets)
    {
        $n = $excelFileName + "_" + $ws.Name
    }

   
Function ExportWSToCSV ($excelFileName, $csvLoc)
{
    $excelFile = "D:\Test\excelfile\" + $excelFileName + ".xlsx"
    $E = New-Object -ComObject Excel.Application
    $E.Visible = $false
    $E.DisplayAlerts = $false
    $wb = $E.Workbooks.Open($excelFile)
    foreach ($ws in $wb.Worksheets)
    {
        $n = $excelFileName + "_" + $ws.Name
        $ws.SaveAs($csvLoc + $n + ".csv", 6)
    }
    $E.Quit()
}
ExportWSToCSV -excelFileName "file" -csvLoc "D:\Test\csv file\"

stop-process -processname EXCEL

$ens = Get-ChildItem "D:\Test\excelfile\" -filter *.xlsx
foreach($e in $ens)
{
    ExportWSToCSV -excelFileName $e.BaseName -csvLoc "D:\Test\csv file\"
}

Tuesday, July 19, 2016

powershell send sharepoint site report to email


$enddate = (Get-Date).tostring("yyyyMMdd")
$filename = 'D:\report\' + $enddate + '_staffdocs.xml'
stsadm.exe -o enumsites -url https://abc.com  > "$filename"

$From = "mysite_report@abc.com"
$To = "ng_sin_peow@abc.com"
$Cc = "YourBoss@abc.com"
$Attachment = "$filename"
$Subject = "My Site Report (One Drive) "
$Body = "Report for my site , please open with excel"
$SMTPServer = "smtp.abc.com"
$SMTPPort = "25"
Send-MailMessage -From $From -to $To -Subject $Subject -Body $Body -SmtpServer $SMTPServer -port $SMTPPort -Attachments $Attachment

Sunday, June 26, 2016

SharePoint Production farm shut down and boot up sequence


Shut down SharePoint server by following sequence
1.       Web front end server ( Can shut down all web front end server at the same time )
2.       Application Server ( Can shut down all application server at the same time )
3.       Database Server (Can shut down all database server  at the same time )

Boot up SharePoint server by following sequence
1.       Database Server (Can boot up all database server   at the same time)
2.       [ Need to wait all DB server completely up ] Application Server (Can boot up all application server at the same time)
3.       [ Need to wait all Application server completely up ] Web front end server ( Can boot up all web front end server at the same time )


Friday, June 10, 2016

About IM-8 Auditing ~ SSL RC4 Cipher Suites Supported

Recently we have some security audit is failed , so we need to fix something to pass the audit.  small part of the IM-8 we need to fix about the .

  SSL RC4 Cipher Suites Supported

 SSL Version 2 and 3 Protocol Detection


after ask around then found out need to change the server registry key to disable some other the RC4 , SSL V2 and V3 setting.

To make the task simple we have some simple tools for it :

first we need the scan tools , which is Nmap tools, you can download from internet.

after install and run following script :

nmap --script ssl-enum-ciphers 172.xx..yy.zz   -p 443

you will get the results look as following , as you see the SSlv3 is enable. 






































Dowload NARTAC Software here : https://www.nartac.com/Products/IISCrypto/Download

After install then you can choice the setting you want , click Apply then Restart . Done.