which country user step here?

Tag Cloud

MOSS (47) SharePoint 2007 (37) SharePoint 2010 (22) SharePoint 2013 (19) MOSS admin (17) admin (17) developer (16) List (15) PowerShell (14) WSS (14) MOSS SP2 (13) sql query (13) end user (11) wss V3 (11) scripting (10) Moss issue (8) search (8) permission (7) sql (7) Service Pack (6) database (6) reportadmin (6) workflow (6) client object model (5) CU (4) Client Code (4) Command (4) Cumulative Updates (4) Excel (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) 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) RBS (1) ROIScan.vbs (1) Reporting Services (1) SPDisposeCheck.exe (1) SQL Instance name (1) SSRS (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) 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) publishing feature (1) resource (1) security (1) size (1) sps2003 (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)

Monday, May 23, 2016

OneDrive For Business ( On Premies ) issues

OneDrive For Business issues
  • Unable to run SYNC with OneDrive client 
  • Unable to Open With Explorer
  • Unable to Edit Microsoft file with client office
All the standard checking at client and server for SharePoint setting is done but still unable to resolve the issues .  web client service ,  IE setting [Trusted site] and so on ...all checked.

Lastly find out is because of the  : ISAPI Filters  at IIS  have the URLSCAN cause it unable to open with explorer and edit document
Resolution : remove URLSCAN from ISAPI Filters  at IIS 




Sunday, May 22, 2016

Install Solution powershell script

using powershell ISE need to run as Administrator
=====================================


if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
    Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}
$WEB_APP = "http://xxxx"
$SITE_URL = "http://xxxx/sca"
$SolutionPath = "D:\Sharepoint Applications\xxxsca.wsp"
$Features = @("xxxsca")

Write-Host "Adding solution:" $SolutionPath
Add-SPSolution -LiteralPath $SolutionPath | Out-Null
Write-Host "Solution added successfully."
Write-Host

$SolutionPackage = Get-Item -LiteralPath $SolutionPath
Write-Host "Deploying solution:" $SolutionPackage.Name
Install-SPSolution -Identity $SolutionPackage.Name -GACDeployment -WebApplication $WEB_APP

$Solution = Get-SPSolution -Identity $SolutionPackage.Name
while ($Solution.JobExists) {
        Start-Sleep -Seconds 10
}

Write-Host "Solution deployed successfully."
Write-Host

foreach ($featureName in $Features)
{
        Write-Host "Enabling feature:" $featureName
        Enable-SPFeature -Identity $featureName -Url $SITE_URL
        Write-Host "Feature enabled successfully."
        Write-Host
}

Read-Host "Finished. Press Enter to exit"

Saturday, May 7, 2016

SQL query : Shrink SQL log file

use content_database_name
ALTER DATABASE content_database_name SET RECOVERY SIMPLE
DBCC SHRINKFILE(content_database_name_log )

ALTER DATABASE content_database_name SET RECOVERY FULL

Sql query check instance name and sever name

SELECT @@servicename AS Servicename --returns instance name, even if this is the default (MSSQLSERVER)
SELECT SERVERPROPERTY ('InstanceName') AS InstanceName --null mean is defalut

select @@SERVERNAME AS SQLclusterName
SELECT   CONVERT(char(20), SERVERPROPERTY('servername'))AS WindowsClusterName --use this name to connect to db

SELECT @@SERVERNAME  AS pre_change_name, --returns servername\instance as far as this is not the default instance

 Serverproperty('Servername') AS current_server_name 

Tuesday, April 26, 2016

Put the today date to powershell for file name

https://social.technet.microsoft.com/Forums/scriptcenter/en-US/01085081-bbea-4cc1-b957-cb99c7f4fe4a/powershell-saving-a-file-with-the-date-in-the-filename?forum=ITCG

$enddate = (Get-Date).tostring("yyyyMMdd")

$filename = 'C:\Documents and Settings\User\Desktop\' + $enddate + '_VMReport.doc'
$filename