SharePoint – All Users are logged in as System Account


Case : Users can authenticate, but all users were given System Account administrator access.

Solution :

In IIS:

1- Open Basic Settings for the SharePoint  Website.
2- Click on Connect As. Change the authentication to Pass-through Authentication.

Advertisements

Unable to load workflow actions from the server in SharePoint designer 2013


w2

Missing feature is the most common reason for this issue.you could use Fiddler to verify any missing feature.The Fiddler will capture the missing feature error as in the following screenshot. The action is to clean up the feature or add back the feature if needed.

w1

in order to clean up fault features you can use this tool:

https://featureadmin.codeplex.com/

 

Regards,

Ahmed Samir

 

Managed Metadata Column Vs Lookup Column in Content Type Hub!


If you start to apply the content type hub you must take in considerations some issues you will focus after the first time you will publish the first content type 🙂

about the creation of the hub and the steps in details i’ll make another post soon isA but today i’ll tell you the problem and how can i found a solution for it.

problems

The Problem Description:

After creating the hub and deploying the content types with lookup columns you will face the first problem.That you already create the lookup column and the list already exist on the web application that host the hub but not exists on the other web applications that the content type will be published on it.so what we can do now.don’t tell me to create the lists manually on all web applications 🙂 

 

A computers red solution key

Solution:

managed metadata navigation

we will make a managed meta data column instead of lookup.

What’s managed metadata column? a definition from Microsoft

A Managed Metadata column is a new column type that can be added to lists, libraries, or content types to enable site users to select values from a specific term set of managed terms and apply these values to their content. You can create and configure a Managed Metadata column to map to an existing term set or term, or you can create a new term set specifically for a Managed Metadata column.

 

If we create the column from this type we can alter the values without depending on a list existence like the lookup column.in this case all you need the Managed Metadata Service to be running and you have the permission to the Taxonomy terms store to enable you to add/edit/delete terms.also this solution solve another big issue it’s the Language of the values

if we used lookup column how you can change the values depending on the current culture in a multilingual portals?

taxonomy-in-term-store

our solution will deal with languages because the term store enable you to add language packs so you can add the value in Arabic then switch the language in the term store to English as another language and translate the word.

image_thumb[5]

when you open any page contains the field you will find the word in the current Language!

 

Thanks & Regards,

Ahmed Samir

 

Removing fault features from a content database in SharePoint 2013 using PowerShell


PowerShell logo

function Remove-SPFeatureFromContentDB($ContentDb, $FeatureId, [switch]$ReportOnly)
{
$db = Get-SPDatabase | where { $_.Name -eq $ContentDb }
[bool]$report = $false
if ($ReportOnly) { $report = $true }

$db.Sites | ForEach-Object {

Remove-SPFeature -obj $_ -objName “site collection” -featId $FeatureId -report $report

$_ | Get-SPWeb -Limit all | ForEach-Object {

Remove-SPFeature -obj $_ -objName “site” -featId $FeatureId -report $report
}
}
}

function Remove-SPFeature($obj, $objName, $featId, [bool]$report)
{
$feature = $obj.Features[$featId]

if ($feature -ne $null) {
if ($report) {
write-host “Feature found in” $objName “:” $obj.Url -foregroundcolor Red
}
else
{
try {
$obj.Features.Remove($feature.DefinitionId, $true)
write-host “Feature successfully removed from” $objName “:” $obj.Url -foregroundcolor Red
}
catch {
write-host “There has been an error trying to remove the feature:” $_
}
}
}
else {
write-host “Feature ID specified does not exist in” $objName “:” $obj.Url
}
}

Sample:

Remove-SPFeatureFromContentDB -ContentDB “WSS_Content_xxx” -FeatureId “Guid” –ReportOnly  just report if the feature exists or no
Remove-SPFeatureFromContentDB -ContentDB “WSS_Content_xxx” -FeatureId “Guid”  // delete the feature from the content database

All STSADM operations in MOSS 2007


STSADM operations

  • stsadm -o activatefeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-url <url>] [-force]
  • stsadm -o activateformtemplate -url <URL to the site collection> [-formid <form template ID>] [-filename <path to form template file>]
  • stsadm -o addalternatedomain -url <protocol://existing.WebApplication.URLdomain> -incomingurl <protocol://incoming.url.domain> -urlzone <default, extranet, internet, intranet, custom> -resourcename <non-web application resource name>
  • stsadm -o addcontentdb -url <url> -databasename <database name> [-databaseserver <database server name>] [-databaseuser <database username>] [-databasepassword <database password>] [-sitewarning <site warning count>] [-sitemax <site max count>]
  • stsadm -o adddataconnectionfile -filename <path to file to add> [-webaccessible <bool>] [-overwrite <bool>] [-category <bool>]
  • stsadm -o add-ecsfiletrustedlocation -Ssp <SSP name> -Location <URL|UNC> -LocationType SharePoint|Unc|Http -IncludeChildren True|False [-SessionTimeout <time in seconds>] [-ShortSessionTimeout <time in seconds>] [-MaxRequestDuration <time in seconds>] [-MaxWorkbookSize <file size in Mbytes>] [-MaxChartSize <size in Mbytes>] [-VolatileFunctionCacheLifetime <time in seconds>] [-DefaultWorkbookCalcMode File|Manual|Auto|AutoDataTables] [-AllowExternalData None|Dcl|DclAndEmbedded] [-WarnOnDataRefresh True|False] [-StopOpenOnRefreshFailure True|False] [-PeriodicCacheLifetime <time in seconds>] [-ManualCacheLifetime <time in seconds>] [-MaxConcurrentRequestsPerSession <number of requests>] [-AllowUdfs True|False] [-Description <descriptive text>]
  • stsadm -o add-ecssafedataprovider -Ssp <SSP name> -ID <data provider id> -Type Oledb|Odbc|OdbcDsn [-Description <descriptive text>]
  • stsadm -o add-ecstrusteddataconnectionlibrary -Ssp <SSP name> -Location <URL> [-Description <descriptive text>]
  • stsadm -o add-ecsuserdefinedfunction -Ssp <SSP name> -Assembly <strong name|file path> -AssemblyLocation GAC|File [-Enable True|False] [-Description <descriptive text>]
  • stsadm -o addexemptuseragent -name <user-agent to receive InfoPath files instead of a Web page>
  • stsadm -o addpath -url <url> -type <explicitinclusion/wildcardinclusion>
  • stsadm -o addpermissionpolicy -url <url> -userlogin <login name> -permissionlevel <permission policy level> [-zone <URL zone>] [-username <display name>]
  • stsadm -o addsolution -filename <Solution filename> [-lcid <language>]
  • stsadm -o addtemplate -filename <template filename> -title <template title> [-description <template description>]
  • stsadm -o adduser -url <url> -userlogin <DOMAIN\user> -useremail <email address> -role <role name> / -group <group name> -username <display name> [-siteadmin]
  • stsadm -o addwppack  -filename <Web Part Package filename> [-lcid <language>] [-url <url>] [-globalinstall] [-force] [-nodeploy]
  • stsadm -o addwppack  -name <name of Web Part Package> [-lcid <language>] [-url <url>] [-globalinstall] [-force]
  • stsadm -o addzoneurl -url <protocol://existing.WebApplication.URLdomain> -urlzone <default, extranet, internet, intranet, custom> -zonemappedurl <protocol://outgoing.url.domain> -resourcename <non-web application resource name>
  • stsadm -o allowuserformwebserviceproxy -url <Url of the web application> -enable <true to enable, false to disable>
  • stsadm -o allowwebserviceproxy -url <Url of the web application> -enable <true to enable, false to disable>
  • stsadm -o associatewebapp -title <SSP name> [-default | -parent] -url <Web application 1 url,Web application 2 url> [-all]
  • stsadm -o authentication -url <url> -type <windows/forms/websso> [-usebasic (valid only in windows authentication mode)] [-usewindowsintegrated (valid only in windows authentication mode)] [-exclusivelyusentlm (valid only in windows authentication mode)] [-membershipprovider <membership provider name>] [-rolemanager <role manager name>] [-enableclientintegration] [-allowanonymous]
  • stsadm -o backup -url <url> -filename <filename> [-overwrite]
  • stsadm -o backup -directory <UNC path> -backupmethod <full | differential> [-item <created path from tree>] [-percentage <integer between 1 and 100>] [-backupthreads <integer between 1 and 10>] [-showtree] [-quiet]
  • stsadm -o backuphistory -directory <UNC path> [-backup] [-restore]
  • stsadm -o binddrservice -servicename <data retrieval service name> -setting <data retrieval services setting>
  • stsadm -o blockedfilelist -extension <extension> -add [-url <url>]
  • stsadm -o blockedfilelist -extension <extension> -delete [-url <url>]
  • stsadm -o canceldeployment -id <id>
  • stsadm -o changepermissionpolicy -url <url> -userlogin <DOMAIN\name> [-zone <URL zone>] [-username <display name>] [{ -add | -delete } -permissionlevel <permission policy level>]
  • stsadm -o copyappbincontent
  • stsadm -o createadminvs [-admapidname <app pool name>] [-admapidtype <configurableid/NetworkService>] [-admapidlogin <DOMAIN\name>] [-admapidpwd <app pool password>]
  • stsadm -o createcmsmigrationprofile -profilename <profile name> [-description <description>] [-connectionstring <connection string>] -databaseserver <server>  -databasename <name>  -databaseuser <username>  [-databasepassword <password>] [-auth windowsauth|sqlauth] -destination <url> [-rootchannel <channelname>] [-destinationlocale <LCID>] [-migrateresources onlyused|all] [-migrateacls yes|no] [-emailto <address1;address2>] [-emailon success|failure|none|both] [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no]
  • stsadm -o creategroup -url <url> -name <group name> -description <description> -ownerlogin <DOMAIN\name or group name> [-type member|visitor|owner]
  • stsadm -o createsite -url <url> -owneremail <email address> [-ownerlogin <DOMAIN\name>] [-ownername <display name>] [-secondaryemail <email address>] [-secondarylogin <DOMAIN\name>] [-secondaryname <display name>] [-lcid <language>] [-sitetemplate <site template>] [-title <site title>] [-description <site description>] [-hostheaderwebapplicationurl <web application url>] [-quota <quota template>]
  • stsadm -o createsiteinnewdb -url <url> -owneremail <email address> [-ownerlogin <DOMAIN\name>] [-ownername <display name>] [-secondaryemail <email address>] [-secondarylogin <DOMAIN\name>] [-secondaryname <display name>] [-lcid <language>] [-sitetemplate <site template>] [-title <site title>] [-description <site description>] [-hostheaderwebapplicationurl <web application url>] [-quota <quota template>] [-databaseuser <database username>] [-databasepassword <database password>] [-databaseserver <database server name>] [-databasename <database name>]
  • stsadm -o createssp -title <SSP name> -url <Web application url> -mysiteurl <MySite Web application url> -ssplogin <username> -indexserver <index server> -indexlocation <index file path> [-ssppassword <password>] [-sspdatabaseserver <SSP database server>] [-sspdatabasename <SSP database name>] [-sspsqlauthlogin <SQL username>] [-sspsqlauthpassword <SQL password>] [-searchdatabaseserver <search database server>] [-searchdatabasename <search database name>] [-searchsqlauthlogin <SQL username>] [-searchsqlauthpassword <SQL password>] [-ssl <yes|no>]
  • stsadm -o createweb -url <url> [-lcid <language>] [-sitetemplate <site template>] [-title <site title>] [-description <site description>] [-convert] [-unique]
  • stsadm -o databaserepair -url <url> -databasename <database name> [-deletecorruption]
  • stsadm -o deactivatefeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-url <url>] [-force]
  • stsadm -o deactivateformtemplate -url <URL to the site collection> [-formid <form template ID>] [-filename <path to form template file>]
  • stsadm -o deleteadminvs
  • stsadm -o deletealternatedomain -url <ignored> -incomingurl <protocol://incoming.url.domain>
  • stsadm -o deletecmsmigrationprofile -profilename <profile name>
  • stsadm -o deleteconfigdb
  • stsadm -o deletecontentdb -url <url> -databasename <database name> [-databaseserver <database server name>]
  • stsadm -o deletegroup -url <url> -name <group name>
  • stsadm -o deletepath -url <url>
  • stsadm -o deletepermissionpolicy -url <url> -userlogin <login name> [-zone <URL zone>]
  • stsadm -o deletesite -url <url> -deleteadaccounts <true/false>
  • stsadm -o deletesolution -name <Solution name> [-override] [-lcid <language>]
  • stsadm -o deletessp -title <SSP name> [-deletedatabases]
  • stsadm -o deletessptimerjob -title <SSP Name> -jobid <SSP Timer Job Id>
  • stsadm -o deletetemplate -title <template title> [-lcid <language>]
  • stsadm -o deleteuser -url <url> -userlogin <DOMAIN\name> [-group <group>]
  • stsadm -o deleteweb -url <url>
  • stsadm -o deletewppack -name <name of Web Part Package> [-lcid <language>] [-url <url>]
  • stsadm -o deletezoneurl -url <protocol://existing.WebApplication.URLdomain> -urlzone <default, extranet, internet, intranet, custom> -resourcename <non-web application resource name>
  • stsadm -o deploysolution -name <Solution name> [-url <virtual server url>] [-allcontenturls] [-time <time to deploy at>] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid <language>] [-force]
  • stsadm -o deploywppack -name <Web Part Package name> [-url <virtual server url>] [-time <time to deploy at>] [-immediate] [-local] [-lcid <language>] [-globalinstall] [-force]
  • stsadm -o disablessc -url <url>
  • stsadm -o displaysolution -name <Solution name>
  • stsadm -o editcmsmigrationprofile -profilename <profile name> [-description <description>] [-connectionstring <connection string>] [-databaseserver <server>] [-databasename <name>] [-databaseuser <username>] [-databasepassword <password>] [-auth sqlauth|windowsauth] [-emailto <address1;address2>] [-emailon success|failure|none|both] [-excludeschema ] [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no]
  • stsadm -o editcontentdeploymentpath -pathname <path name> [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no] [-enablecompression yes|no]
  • stsadm -o editssp -title <SSP name> [-newtitle <new SSP name>] [-sspadminsite <administration site url>] [-ssplogin <username>] [-ssppassword <password>] [-indexserver <index server>] [-indexlocation <index file path>] [-setaccounts <process accounts (domain\username)>] [-ssl <yes|no>]
  • stsadm -o email -outsmtpserver <SMTP server> -fromaddress <email address> -replytoaddress <email address> -codepage <codepage> [-url <url>]
  • stsadm -o enablecmsurlredirect -profilename <profile name> -off
  • stsadm -o enablessc -url <url> [-requiresecondarycontact]
  • stsadm -o enumalternatedomains -url <protocol://existing.WebApplication.URLdomain> -resourcename <non-web application resource name>
  • stsadm -o enumcontentdbs -url <url>
  • stsadm -o enumdataconnectionfiledependants -filename <filename for which to enumerate dependants>
  • stsadm -o enumdataconnectionfiles [-mode <a | u | all | unreferenced>]
  • stsadm -o enumdeployments
  • stsadm -o enumexemptuseragents
  • stsadm -o enumformtemplates
  • stsadm -o enumgroups -url <url>
  • stsadm -o enumroles -url <url>
  • stsadm -o enumservices
  • stsadm -o enumsites -url <virtual server url> -showlocks -redirectedsites
  • stsadm -o enumsolutions
  • stsadm -o enumssp -title <SSP name> [-default | -parent | -all]
  • stsadm -o enumssptimerjobs -title <SSP Name>
  • stsadm -o enumsubwebs -url <url>
  • stsadm -o enumtemplates [-lcid <language>]
  • stsadm -o enumusers -url <url>
  • stsadm -o enumwppacks [-name <name of Web Part Package>] [-url <virtual server url>] [-farm]
  • stsadm -o enumzoneurls -url <protocol://existing.WebApplication.URLdomain> -resourcename <non-web application resource name>
  • stsadm -o execadmsvcjobs
  • stsadm -o export -url <URL to be exported> -filename <export file name> [-overwrite] [-includeusersecurity] [-haltonwarning] [-haltonfatalerror] [-nologfile] [-versions <1-4> 1= Last major version for files and list items (default), 2= The current version, either the last major or the last minor, 3= Last major and last minor version for files and list items, 4= All versions for files and list items] [-cabsize <integer from 1-1024 megabytes> (default: 25)] [-nofilecompression] [-quiet]
  • stsadm -o extendvs -url <url> -ownerlogin <domain\name> -owneremail <email address> [-exclusivelyusentlm] [-ownername <display name>] [-databaseuser <database user>] [-databaseserver <database server>] [-databasename <database name>] [-databasepassword <database user password>] [-lcid <language>] [-sitetemplate <site template>] [-donotcreatesite] [-description <iis web site name>] [-sethostheader] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService>] [-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-allowanonymous]
  • stsadm -o extendvsinwebfarm -url <url> -vsname <web application name> [-exclusivelyusentlm] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService>] [-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-allowanonymous]
  • stsadm -o forcedeleteweb -url <url>
  • stsadm -o formtemplatequiescestatus [-formid <form template ID>] [-filename <path to form template file>]
  • stsadm -o getadminport
  • stsadm -o getdataconnectionfileproperty -filename <filename of the data connection file> -pn <property name>
  • stsadm -o getformsserviceproperty -pn <option name>
  • stsadm -o getformtemplateproperty [-formid <form template ID>] [-filename <path to form template file>] -pn <property name>
  • stsadm -o getproperty -propertyname <property name> [-url <url>] (SharePoint cluster properties: avallowdownload, avcleaningenabled, avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled, command-line-upgrade-running, database-command-timeout, database-connection-timeout, data-retrieval-services-enabled, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password, defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled, irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh, job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger, large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize, workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle, workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual server properties: alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled, change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration, job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup, job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover, max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains, peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection, peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled, recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period, second-stage-recycle-bin-quota, send-ad-email)
  • stsadm -o getsitedirectoryscanschedule
  • stsadm -o getsitelock -url <url>
  • stsadm -o getsiteuseraccountdirectorypath -url <url>
  • stsadm -o geturlzone -url <protocol://incoming.url.domain>
  • stsadm -o grantiis7permission
  • stsadm -o import -url <URL to import to> -filename <import file name> [-includeusersecurity] [-haltonwarning] [-haltonfatalerror] [-nologfile] [-updateversions <1-3> 1= Add new versions to the current file (default), 2= Overwrite the file and all its versions (delete then insert),3= Ignore the file if it exists on the destination] [-nofilecompression] [-quiet]
  • stsadm -o installfeature {-filename <relative path to Feature.xml from system feature directory> | -name <feature folder>} [-force]
  • stsadm -o listlogginglevels [-showhidden]
  • stsadm -o listregisteredsecuritytrimmers -ssp <ssp name>
  • stsadm -o localupgradestatus
  • stsadm -o managepermissionpolicylevel -url <url> -name <permission policy level name> [{ -add | -delete }] [-description <description>] [-siteadmin <true | false>] [-siteauditor <true | false>] [-grantpermissions <comma-separated list of permissions>] [-denypermissions <comma-separated list of permissions>]
  • stsadm -o mergecontentdbs -url <url> -sourcedatabasename <source database name> -destinationdatabasename <destination datbabase name> [-operation <1-3> 1 – Analyze (default) 2 – Full Database Merge 3 – Read from file] [-filename <file generated from stsadm -o enumsites>]
  • stsadm -o migrateuser -oldlogin <DOMAIN\name> -newlogin <DOMAIN\name> [-ignoresidhistory]
  • stsadm -o osearch [-action <list|start|stop>] required parameters for ‘start’ (if not already set): role, farmcontactemail, service credentials [-f (suppress prompts)] [-role <Index|Query|IndexQuery>] [-farmcontactemail <email>] [-farmperformancelevel <Reduced|PartlyReduced|Maximum>] [-farmserviceaccount <DOMAIN\name> (service credentials)] [-farmservicepassword <password>] [-defaultindexlocation <directory>] [-propagationlocation <directory>] [-cleansearchdatabase <true|false>] [-ssp <ssp name>] required parameter for ‘cleansearchdatabase’
  • stsadm -o osearchdiacriticsensitive -ssp <ssp name> [-setstatus <True|False>] [-noreset] [-force]
  • stsadm -o preparetomove {-ContentDB <DatabaseServer:DatabaseName> | -Site <URL>} [-OldContentDB <uniqueidentifier>] [-undo]
  • stsadm -o profilechangelog -title <SSP Name> -daysofhistory <number of days> -generateanniversaries
  • stsadm -o profiledeletehandler -type <Full Assembly Path>
  • stsadm -o provisionservice -action <start/stop> -servicetype <servicetype (namespace or assembly qualified name if not SharePoint service)> [-servicename <servicename>]
  • stsadm -o quiescefarm -maxduration <duration in minutes>
  • stsadm -o quiescefarmstatus
  • stsadm -o quiesceformtemplate [-formid <form template ID>] [-filename <path to form template file>] -maxduration <time in minutes>
  • stsadm -o reconvertallformtemplates
  • stsadm -o refreshdms -url <url>
  • stsadm -o refreshsitedms -url <url>
  • stsadm -o registersecuritytrimmer -ssp <ssp name> -id <0 – 2147483647> -typename <assembly qualified TypeName of ISecurityTrimmer implementation> -rulepath <crawl rule URL> [-configprops <name value pairs delimited by ‘~’>]
  • stsadm -o registerwsswriter
  • stsadm -o removedataconnectionfile -filename <filename to remove>
  • stsadm -o removedrservice -servicename <data retrieval service name> -setting <data retrieval services setting>
  • stsadm -o remove-ecsfiletrustedlocation -Ssp <SSP name> -Location <URL|UNC> -LocationType SharePoint|Unc|Http
  • stsadm -o remove-ecssafedataprovider -Ssp <SSP name> -ID <data provider id> -Type Oledb|Odbc|OdbcDsn
  • stsadm -o remove-ecstrusteddataconnectionlibrary -Ssp <SSP name> -Location <URL>
  • stsadm -o remove-ecsuserdefinedfunction -Ssp <SSP name> -Assembly <strong name|file path> -AssemblyLocation GAC|File
  • stsadm -o removeexemptuseragent -name <user-agent to receive InfoPath files instead of a Web page>
  • stsadm -o removeformtemplate [-formid <form template ID>] [-filename <path to form template file>]
  • stsadm -o removesolutiondeploymentlock [-server <server> [-allservers]
  • stsadm -o renameserver -oldservername <oldServerName> -newservername <newServerName>
  • stsadm -o renamesite -oldurl <oldUrl> -newurl <newUrl> 
  • stsadm -o renameweb -url <url> -newname <new subsite name>
  • stsadm -o restore -url <url> -filename <filename> [-hostheaderwebapplicationurl <web application url>] [-overwrite]
  • stsadm -o restore -directory <UNC path> -restoremethod <overwrite | new> [-backupid <Id from backuphistory, see stsadm -help backuphistory>] [-item <created path from tree>] [-percentage <integer between 1 and 100>] [-showtree] [-suppressprompt] [-username <username>] [-password <password>] [-newdatabaseserver <new database server name>] [-quiet]
  • stsadm -o restoressp -title <SSP name> -url <Web application url> -ssplogin <username> -mysiteurl <MySite Web application url> -indexserver <index server> -indexlocation <index file path> [-keepindex] -sspdatabaseserver <SSP database server> -sspdatabasename <SSP database name> [-ssppassword <password>] [-sspsqlauthlogin <SQL username>] [-sspsqlauthpassword <SQL password>] [-searchdatabaseserver <search database server>] [-searchdatabasename <search database name>] [-searchsqlauthlogin <SQL username>] [-searchsqlauthpassword <SQL password>] [-ssl <yes|no>]
  • stsadm -o retractsolution -name <Solution name> [-url <virtual server url>] [-allcontenturls] [-time <time to remove at>] [-immediate] [-local] [-lcid <language>]
  • stsadm -o retractwppack -name <Web Part Package name> [-url <virtual server url>] [-time <time to retract at>] [-immediate] [-local] [-lcid <language>]
  • stsadm -o runcmsmigrationprofile -profilename <profile name> [-skipanalyzer ] [-onlyanalyzer ] [-startover ] [-migratesincetime <DateTime string>] [-migrationfolder <path>] [-exportonly ] [-importonly ] [-htmldiff <path>]
  • stsadm -o runcontentdeploymentjob -jobname <name> [-wait yes|no] [-deploysincetime <datetime>] (<datetime> as “MM/DD/YY HH:MM:SS”)
  • stsadm -o scanforfeatures [-solutionid <Id of Solution>] [-displayonly]
  • stsadm -o setadminport -port <port> [-ssl] [-admapcreatenew] [-admapidname <app pool name>]
  • stsadm -o setapppassword -password <password>
  • stsadm -o setbulkworkflowtaskprocessingschedule -schedule <recurrence string>
  • stsadm -o setconfigdb [-connect] -databaseserver <database server> [-databaseuser <database user>] [-databasepassword <database user password>] [-databasename <database name>] [-exclusivelyusentlm] [-farmuser] [-farmpassword] [-adcreation] [-addomain <Active Directory domain>] [-adou <Active Directory OU>]
  • stsadm -o setcontentdeploymentjobschedule -jobname <name> -schedule <schedule> (Schedule Parameter Examples: “every 5 minutes between 0 and 59”, “hourly between 0 and 59”, “daily at 15:00:00”, “weekly between Fri 22:00:00 and Sun 06:00:00”, “monthly at 15 15:00:00”, “yearly at Jan 1 15:00:00”)
  • stsadm -o setdataconnectionfileproperty -filename <filename of the data connection file> -pn <property name> -pv <property value>
  • stsadm -o setdefaultssp -title <SSP name>
  • stsadm -o set-ecsexternaldata -Ssp <SSP name> [-ConnectionLifetime <time in seconds>] [-UnattendedServiceAccountName <account name>] [-UnattendedServiceAccountPassword <account password>]
  • stsadm -o set-ecsloadbalancing -Ssp <SSP name> [-Scheme WorkbookUrl|RoundRobin|Local] [-RetryInterval <time in seconds>]
  • stsadm -o set-ecsmemoryutilization -Ssp <SSP name> [-MaxPrivateBytes <memory in MBytes>] [-MemoryCacheThreshold <percentage>] [-MaxUnusedObjectAge <time in minutes>]
  • stsadm -o set-ecssecurity -Ssp <SSP name> [-FileAccessMethod UseImpersonation|UseFileAccessAccount] [-AccessModel Delegation|TrustedSubsystem] [-RequireEncryptedUserConnection False|True] [-AllowCrossDomainAccess True|False]
  • stsadm -o set-ecssessionmanagement -Ssp <SSP name> [-MaxSessionsPerUser <number of sessions>]
  • stsadm -o set-ecsworkbookcache -Ssp <SSP name> [-Location <local or UNC path>] [-MaxCacheSize <storage in Mbytes>] [-EnableCachingOfUnusedFiles True|False]
  • stsadm -o setformsserviceproperty -pn <option name> -pv <option value>
  • stsadm -o setformtemplateproperty [-formid <form template ID>] [-filename <path to form template file>] -pn <property name> -pv <property value>
  • stsadm -o setholdschedule -schedule <recurrence string>
  • stsadm -o setlogginglevel [-category < [CategoryName | Manager:CategoryName [;…]] >] {-default | -tracelevel  < None;  Unexpected; Monitorable; High; Medium; Verbose> [-windowslogginglevel < None;  ErrorServiceUnavailable;  ErrorSecurityBreach;  ErrorCritical;  Error;  Warning;  FailureAudit; SuccessAudit;  Information;  Success>] }
  • stsadm -o setpolicyschedule -schedule <recurrence string>
  • stsadm -o setproperty -propertyname <property name> -propertyvalue <property value> [-url <url>] (SharePoint cluster properties:, avallowdownload, avcleaningenabled, avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled, command-line-upgrade-running, database-command-timeout, database-connection-timeout, data-retrieval-services-enabled, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password, defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled, irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh, job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger, large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize, workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle, workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual server properties:, alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled, change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration, job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup, job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover, max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains, peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection, peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled, recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period, second-stage-recycle-bin-quota, send-ad-email)
  • stsadm -o setrecordsrepositoryschedule -schedule <recurrence string>
  • stsadm -o setsearchandprocessschedule -schedule <recurrence string>
  • stsadm -o setsharedwebserviceauthn -ntlm | -negotiate
  • stsadm -o setsitedirectoryscanschedule -schedule <recurrence string> (Schedule parameter examples: “every 5 minutes between 0 and 59”, “hourly between 0 and 59”, “daily at 15:00:00”, “weekly between Fri 22:00:00 and Sun 06:00:00”, “monthly at 15 15:00:00”, “yearly at Jan 1 15:00:00”)
  • stsadm -o setsitelock -url <url> -lock <none | noadditions | readonly | noaccess>
  • stsadm -o setsiteuseraccountdirectorypath -url <url> [-path <path>]
  • stsadm -o setsspport -httpport <HTTP port number> -httpsport <HTTPS port number>
  • stsadm -o setworkflowconfig -url <url> {-emailtonopermissionparticipants <enable|disable> | -externalparticipants <enable|disable> | -userdefinedworkflows <enable|disable>}
  • stsadm -o siteowner -url <url> [-ownerlogin <DOMAIN\name>] [-secondarylogin <DOMAIN\name>]
  • stsadm -o spsearch [-action <list | start | stop | attachcontentdatabase | detachcontentdatabase | fullcrawlstart | fullcrawlstop>] [-f (suppress prompts)] [-farmperformancelevel <Reduced | PartlyReduced | Maximum>] [-farmserviceaccount <DOMAIN\name> (service credentials)] [-farmservicepassword <password>] [-farmcontentaccessaccount <DOMAIN\name>] [-farmcontentaccesspassword <password>] [-indexlocation <new index location>] [-databaseserver <server\instance> (default: josebda-moss)] [-databasename <database name> (default: SharePoint_WSS_Search)] [-sqlauthlogin <SQL authenticated database user>] [-sqlauthpassword <password>] -action list -action stop [-f (suppress prompts)] -action start -farmserviceaccount <DOMAIN\name> (service credentials) [-farmservicepassword <password>] -action attachcontentdatabase [-databaseserver <server\instance> (default: josebda-moss)] -databasename <content database name> [-searchserver <search server name> (default: josebda-moss)] -action detachcontentdatabase [-databaseserver <server\instance> (default: josebda-moss)] -databasename <content database name> [-f (suppress prompts)] -action fullcrawlstart -action fullcrawlstop
  • stsadm -o spsearchdiacriticsensitive [-setstatus <True|False>] [-noreset] [-force]
  • stsadm -o sync {-ExcludeWebApps <web applications> | -SyncTiming <schedule(M/H/D:value)> | -SweepTiming <schedule(M/H/D:value)> | -ListOldDatabases <days> | -DeleteOldDatabases <days>}
  • stsadm -o syncsolution -name <Solution name>] [-lcid <language>] [-alllcids]
  • stsadm -o syncsolution -allsolutions
  • stsadm -o unextendvs -url <url> [-deletecontent] [-deleteiissites]
  • stsadm -o uninstallfeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-force]
  • stsadm -o unquiescefarm
  • stsadm -o unquiesceformtemplate [-formid <form template ID>] [-filename <path to form template file>]
  • stsadm -o unregistersecuritytrimmer -ssp <ssp name> -id <0 – 2147483647>
  • stsadm -o unregisterwsswriter
  • stsadm -o updateaccountpassword -userlogin <DOMAIN\name> -password <password> [-noadmin]
  • stsadm -o updatealerttemplates -url <url> [-filename <filename>] [-lcid <language>
  • stsadm -o updatefarmcredentials [-identitytype <configurableid/NetworkService>] [-userlogin <DOMAIN\name>] [-password <password>] [-local [-keyonly]]
  • stsadm -o upgrade {-inplace | -sidebyside} [-url <url>] [-forceupgrade] [-quiet] [-farmuser <farm user>] [-farmpassword <farm user password>] [-reghost] [-sitelistpath <sites xml file>]
  • stsadm -o upgradeformtemplate -filename <path to form template file> [-upgradetype <upgrade type>]
  • stsadm -o upgradesolution -name <Solution name> -filename <upgrade filename> [-time <time to upgrade at>] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid <language>]
  • stsadm -o upgradetargetwebapplication -url <URL to upgrade> -relocationurl <new URL for non-upgraded content> -apidname <new app pool name> [-apidtype <configurableid/NetworkService>] [-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-exclusivelyusentlm]
  • stsadm -o uploadformtemplate -filename <path to form template file>
  • stsadm -o userrole -url <url> -userlogin <DOMAIN\name> -role <role name> [-add] [-delete]
  • stsadm -o verifyformtemplate -filename <path to form template file>

SharePoint: How To Deal With People Picker Sharepoint Control into your Custom Asp.net Control


 

In Many Cases you need to make a control to pick up a user from your user management system – Active Directory – Database Membership and so on, PeopleEditor Control make this job.now you will say how to use it in my custom development,look

1)  Add Refernce to your HTML

<%@ Register Tagprefix=”SP” Namespace=”Microsoft.SharePoint.WebControlsAssembly=”Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” %>

2) Use it in the right position into your design

<SP:PeopleEditor
AllowEmpty=”false
ValidatorEnabled=”true
id=”Picker
runat=”server
ShowCreateButtonInActiveDirectoryAccountCreationMode=”true
SelectionSet=”User” />

3) Get Values from it into your code behind 

PickerEntity pe = (PickerEntity)userPicker.Entities[0];  //get the first user in list
string username = pe.Description; //get username of the selected user

string DisplayName = pe.DisplayText ; //get user display name first last….

Regards,

Sharepoint: How To Deal With Custom List [Add,Search]


Hi Guys, this article depends on your knowledge of what’s the concept of SharePoint List,so I already created a list called Employees under my subsite with the following columns:

FirstName

LastName

Age

Department

Salary

so the first task that we want to do is adding new list item to the Employees List,here is the Code for this target:

you will need the following namespace:

using Microsoft.SharePoint;

//to open the site 

using (SPSite site = new SPSite(SPContext.Current.Site.Url))
                {
                    if (site != null)
                    {

                                                       //to open the site ….. assuming that the list will be in the same subsite

                        using (SPWeb web = site.OpenWeb(SPContext.Current.Web.ServerRelativeUrl))
                        {
                            SPList list = web.Lists["Employees"];
                            if (list != null)
                            {
 //Create New Empty List Item
                                    SPListItem itemNew = list.Items.Add();
 //Filling it's fields
                                    itemNew["FirstName"] = txtFirstName.Text;
                                    itemNew["LastName"] = txtLastName.Text;
                                    itemNew["Age"] = txtAge.Text;
                                    itemNew["Department"] = ddlDepartments.SelectedItem.Text;
                                    itemNew["Salary"] = txtSalary.Text;

 // to enable you to update the list
                                    web.AllowUnsafeUpdates = true;
 //Updating......
                                    itemNew.Update();
                            }
                        }

                    }
                }
the second Task we need now to search and navigate between the list items, so how in your opinions, I'll say it now
look, this search will work with CAML Queries we will Create template for every search Criteria ie. in our screen we will search 
by FirstName and LastName as ex, so look at this code:

string FirstNameTemplate = string.Format("<Contains>" +
                                         "<FieldRef Name=\"FirstName\" />" +
                                          "<Value Type=\"Text\">{0}</Value>" +
                                       "</Contains>", txtFirstName.Text);

string LastNameTemplate = string.Format("<Contains>" +
 "<FieldRef Name=\"LastName\" />" +
 "<Value Type=\"Text\">{0}</Value>" +
 "</Contains>", txtLastName.Text);

string TrueCondition = "<Neq>" +
 "<FieldRef Name=\"FirstName\" />" +
 "<Value Type=\"Text\">asamir226644</Value>" + //Dummy Data
 "</Neq>";

string FirstName = txtFirstName.Text != string.Empty ? FullNameTemplate : TrueCondition;
string LastName = txtLastName.Text != string.Empty ? LastNameTemplate : TrueCondition;

string CAMLQueryemplate = string.Format("<Where>" +
 "<And>" +
 "{0}" + //FirstName
 "{1}" + //LastName
 "</And>" +
 "</Where>", FirstName, LastName);

using (SPSite site = new SPSite(SPContext.Current.Site.Url))
                {
                    if (site != null)
                    {
                        using (SPWeb web = site.OpenWeb(SPContext.Current.Web.ServerRelativeUrl))
                        {
                            SPList list = web.Lists["Employees"];
                            if (list != null)
                            {
                                SPQuery query = new SPQuery();
                                string str = string.Format(CAMLQueryemplate);
                                query.Query = str;
                                DataTable dataTable = list.GetItems(query).GetDataTable();
                                gvEmployees.DataSource = dataTable;
                                gvEmployees.DataBind();
                            }
                        }
                    }
                }