Month: June 2011

Location of saved file from attachment of outlook

Where file gets saved when we open attachment directly from mail of outlook and save it???
where Outlook saves temporary files??

For windows7 you can try:-
C:\Users\\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\ITLDT431

If above path wont work,Try:-

  • Open some attached .ppt file in outlook mail box(if not present send mail to yourself with .ppt file as attachment)
  • Change something in file
  • Try to save it
  • It will give you one message box with temporary file location…
  • type that file path in address bar (Note:- Don’t try to navigate manually)
  • You will find you file there.

Programatically adding column to sharepoint list, code to add column to list

Create new console application in VS and add following code in program.cs file. also add refrence to Microsoft.Sharepoint.dll

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
namespace AddColumntoList
{
    class Program
    {
        static void Main(string[] args)
        {
            do
            {
                try
                {
                    Console.WriteLine(“–Add Column to list–“);
                    Console.WriteLine(“Enter Site URL : “);
                    String str_siteurl = Console.ReadLine();
                    using (SPSite siteColl = new SPSite(str_siteurl))
                    {
                        Console.WriteLine(“Site Found”);
                        siteColl.AllowUnsafeUpdates = true;
                        using (SPWeb rootweb = siteColl.OpenWeb())
                        {
                            rootweb.AllowUnsafeUpdates = true;
                            //Console.WriteLine(“Site Found”);
                            Console.WriteLine(“Enter List Name: “);
                            string listName = Console.ReadLine();
                            SPList testList = rootweb.Lists[listName];
                            Console.WriteLine(“list Found”);
                            Console.WriteLine(“Enter Column Name: “);
                            String colName = Console.ReadLine();
                            Console.WriteLine(“Select Type Of Column:-“);
                            Console.WriteLine(“1. Single line Text”);
                            Console.WriteLine(“2. MultiLine Text”);
                            Console.WriteLine(“Enter Choice number:- “);

                            string typeChoice = Console.ReadLine();
                            switch (typeChoice)
                            {
                                case “1”:
                                    SPFieldText newcolumn = (SPFieldText)testList.Fields.CreateNewField(SPFieldType.Text.ToString(), colName);
                                    testList.Fields.Add(newcolumn);
                                    break;
                                case “2”:
                                    SPFieldMultiLineText newcolumnMul = (SPFieldMultiLineText)testList.Fields.CreateNewField(SPFieldType.Note.ToString(), colName);
                                    testList.Fields.Add(newcolumnMul);
                                    break;
                            }

                            //    newcolumn.Required = false;
                            //newcolumn.Description = “comma seperated value”;
                            //testList.Fields.Add(newcolumn);
                            testList.Update();
                            Console.WriteLine(“Column Created”);

                            Console.WriteLine(“Add Colum to Default View y/n??? :-“);
                            string defChoice = Console.ReadLine();
                            if (defChoice == “y” || defChoice == “Y”)
                            {
                                SPView defView = testList.DefaultView;
                                defView.ViewFields.Add(colName);
                                defView.Update();
                                Console.WriteLine(“Column added to default view”);
                            }
                            rootweb.AllowUnsafeUpdates = false;
                        }
                        siteColl.AllowUnsafeUpdates = false;
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(“ERROR : ” + ex.Message);
                    Console.WriteLine(“Press Enter to Continue and ESC to exit…”);
                }
            } while (Console.ReadKey(true).Key != ConsoleKey.Escape);
            Console.WriteLine(“Press Enter to Exit…”);
            Console.ReadLine();
        }
    }
}

javascript to move images on google

Very interesting…. magic of programming
Do try this once

1. Open Internet Explorer
2. Go to Google.com
3. Type “Flowers” or any other nice flower/animal word or anything which search pictures.
4. You will get a page which is having full of images
5. Then delete the URL from the address bar and paste the following script

javascript:R= 0; x1=.1; y1=.05; x2=.25; y2=.24; x3=1.6; y3=.24; x4=300; y4=200; x5=300; y5=200; DI= document.images; DIL=DI.length; function A(){for(i=0; i<DIL; i++){DIS=DI[ i ].style; DIS.position= 'absolute' ; DIS.left=Math. sin(R*x1+ i*x2+x3)* x4+x5; DIS.top=Math. cos(R*y1+ i*y2+y3)* y4+y5}R++ }setInterval( 'A()',5); void(0)

6. press enter
7. See the magic of programming

Google image search — New feature

Now you can search refrences for image you are having.
You just need to drag drop image in google search box… it will show all relevent link to you.

follow below steps to search image.

1. open http://www.google.com/ and click on image link at top

2. click on Camera button present in search box

3. click on upload an image

4. click on browse and upload image which you want to search

  

and google will search all refrences for that image.

How to see content of wsp file

For seeing content of wsp file follow below steps:-
1. Go to my computer>tools>Folder Option>View>and uncheck ‘hide extension for know file types’
2. now locate wsp file you are having
3. rename extension to .cab
4. double click on that file

now you can see content of wsp file

All stsadm commands syntax

1. stsadm -o activatefeature {-filename relative path to Feature.xml | -name feature folder | -id feature Id} [-url url] [-force]
2. stsadm -o activateformtemplate -url URL to the site collection [-formid form template ID] [-filename path to form template file]
3. 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
4. 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]
5. stsadm -o adddataconnectionfile -filename path to file to add [-webaccessible bool] [-overwrite bool] [-category bool]
6. 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]

7. stsadm -o add-ecssafedataprovider -Ssp SSP name -ID data provider id -Type Oledb|Odbc|OdbcDsn [-Description descriptive text]
8. stsadm -o add-ecstrusteddataconnectionlibrary -Ssp SSP name -Location URL [-Description descriptive text]
9. stsadm -o add-ecsuserdefinedfunction -Ssp SSP name -Assembly strong name|file path -AssemblyLocation GAC|File [-Enable True|False] [-Description descriptive text]
10. stsadm -o addexemptuseragent -name user-agent to receive InfoPath files instead of a Web page
11. stsadm -o addpath -url url -type explicitinclusion/wildcardinclusion
12. stsadm -o addpermissionpolicy -url url -userlogin login name -permissionlevel permission policy level [-zone URL zone] [-username display name]
13. stsadm -o addsolution -filename Solution filename [-lcid language]
14. stsadm -o addtemplate -filename template filename -title template title [-description template description]
15. stsadm -o adduser -url url -userlogin DOMAIN\user -useremail email address -role role name / -group group name -username display name [-siteadmin]
16. stsadm -o addwppack -filename Web Part Package filename [-lcid language] [-url url] [-globalinstall] [-force] [-nodeploy]
17. stsadm -o addwppack -name name of Web Part Package [-lcid language] [-url url] [-globalinstall] [-force]
18. 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
19. stsadm -o allowuserformwebserviceproxy -url Url of the web application -enable true to enable, false to disable
20. stsadm -o allowwebserviceproxy -url Url of the web application -enable true to enable, false to disable
21. stsadm -o associatewebapp -title SSP name [-default | -parent] -url Web application 1 url,Web application 2 url [-all]
22. 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]
23. stsadm -o backup -url url -filename filename [-overwrite]
24. 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]
25. stsadm -o backuphistory -directory UNC path [-backup] [-restore]
26. stsadm -o binddrservice -servicename data retrieval service name -setting data retrieval services setting

27. stsadm -o blockedfilelist -extension extension -add [-url url]
28. stsadm -o blockedfilelist -extension extension -delete [-url url]
29. stsadm -o canceldeployment -id id
30. stsadm -o changepermissionpolicy -url url -userlogin DOMAIN\name [-zone URL zone] [-username display name] [{ -add | -delete } -permissionlevel permission policy level]
31. stsadm -o copyappbincontent
32. stsadm -o createadminvs [-admapidname app pool name] [-admapidtype configurableid/NetworkService] [-admapidlogin DOMAIN\name] [-admapidpwd app pool password]
33. 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]
34. stsadm -o creategroup -url url -name group name -description description -ownerlogin DOMAIN\name or group name [-type member|visitor|owner]
35. 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]
36. 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]
37. 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]
38. stsadm -o createweb -url url [-lcid language] [-sitetemplate site template] [-title site title] [-description site description] [-convert] [-unique]
39. stsadm -o databaserepair -url url -databasename database name [-deletecorruption]
40. stsadm -o deactivatefeature {-filename relative path to Feature.xml | -name feature folder | -id feature Id} [-url url] [-force]
41. stsadm -o deactivateformtemplate -url URL to the site collection [-formid form template ID] [-filename path to form template file]
42. stsadm -o deleteadminvs
43. stsadm -o deletealternatedomain -url ignored -incomingurl protocol://incoming.url.domain
44. stsadm -o deletecmsmigrationprofile -profilename profile name
45. stsadm -o deleteconfigdb
46. stsadm -o deletecontentdb -url url -databasename database name [-databaseserver database server name]
47. stsadm -o deletegroup -url url -name group name
48. stsadm -o deletepath -url url
49. stsadm -o deletepermissionpolicy -url url -userlogin login name [-zone URL zone]
50. stsadm -o deletesite -url url -deleteadaccounts true/false
51. stsadm -o deletesolution -name Solution name [-override] [-lcid language]
52. stsadm -o deletessp -title SSP name [-deletedatabases]
53. stsadm -o deletessptimerjob -title SSP Name -jobid SSP Timer Job Id
54. stsadm -o deletetemplate -title template title [-lcid language]
55. stsadm -o deleteuser -url url -userlogin DOMAIN\name [-group group]
56. stsadm -o deleteweb -url url
57. stsadm -o deletewppack -name name of Web Part Package [-lcid language] [-url url]
58. stsadm -o deletezoneurl -url protocol://existing.WebApplication.URLdomain -urlzone default, extranet, internet, intranet, custom -resourcename non-web application resource name
59. stsadm -o deploysolution -name Solution name [-url virtual server url] [-allcontenturls] [-time time to deploy at] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid language] [-force]
60. stsadm -o deploywppack -name Web Part Package name [-url virtual server url] [-time time to deploy at] [-immediate] [-local] [-lcid language] [-globalinstall] [-force]
61. stsadm -o disablessc -url url
62. stsadm -o displaysolution -name Solution name
63. 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]
64. stsadm -o editcontentdeploymentpath -pathname path name [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no] [-enablecompression yes|no]
65. 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]
66. stsadm -o email -outsmtpserver SMTP server -fromaddress email address -replytoaddress email address -codepage codepage [-url url]
67. stsadm -o enablecmsurlredirect -profilename profile name -off
68. stsadm -o enablessc -url url [-requiresecondarycontact]
69. stsadm -o enumalternatedomains -url protocol://existing.WebApplication.URLdomain -resourcename non-web application resource name
70. stsadm -o enumcontentdbs -url url
71. stsadm -o enumdataconnectionfiledependants -filename filename for which to enumerate dependants
72. stsadm -o enumdataconnectionfiles [-mode a | u | all | unreferenced]
73. stsadm -o enumdeployments
74. stsadm -o enumexemptuseragents
75. stsadm -o enumformtemplates
76. stsadm -o enumgroups -url url
77. stsadm -o enumroles -url url
78. stsadm -o enumservices
79. stsadm -o enumsites -url virtual server url -showlocks -redirectedsites
80. stsadm -o enumsolutions
81. stsadm -o enumssp -title SSP name [-default | -parent | -all]
82. stsadm -o enumssptimerjobs -title SSP Name
83. stsadm -o enumsubwebs -url url
84. stsadm -o enumtemplates [-lcid language]
85. stsadm -o enumusers -url url
86. stsadm -o enumwppacks [-name name of Web Part Package] [-url virtual server url] [-farm]
87. stsadm -o enumzoneurls -url protocol://existing.WebApplication.URLdomain -resourcename non-web application resource name
88. stsadm -o execadmsvcjobs
89. 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]
90. 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]
91. 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]
92. stsadm -o forcedeleteweb -url url
93. stsadm -o formtemplatequiescestatus [-formid form template ID] [-filename path to form template file]
94. stsadm -o getadminport
95. stsadm -o getdataconnectionfileproperty -filename filename of the data connection file -pn property name
96. stsadm -o getformsserviceproperty -pn option name
97. stsadm -o getformtemplateproperty [-formid form template ID] [-filename path to form template file] -pn property name
98. 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)
99. stsadm -o getsitedirectoryscanschedule
100. stsadm -o getsitelock -url url
101. stsadm -o getsiteuseraccountdirectorypath -url url
102. stsadm -o geturlzone -url protocol://incoming.url.domain
103. stsadm -o grantiis7permission
104. 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]
105. stsadm -o installfeature {-filename relative path to Feature.xml from system feature directory | -name feature folder} [-force]
106. stsadm -o listlogginglevels [-showhidden]
107. stsadm -o listregisteredsecuritytrimmers -ssp ssp name
108. stsadm -o localupgradestatus
109. 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]
110. 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]
111. stsadm -o migrateuser -oldlogin DOMAIN\name -newlogin DOMAIN\name [-ignoresidhistory]
112. 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’
113. stsadm -o osearchdiacriticsensitive -ssp ssp name [-setstatus True|False] [-noreset] [-force]
114. stsadm -o preparetomove {-ContentDB DatabaseServer:DatabaseName | -Site URL} [-OldContentDB uniqueidentifier] [-undo]
115. stsadm -o profilechangelog -title SSP Name -daysofhistory number of days -generateanniversaries
116. stsadm -o profiledeletehandler -type Full Assembly Path
117. stsadm -o provisionservice -action start/stop -servicetype servicetype (namespace or assembly qualified name if not SharePoint service) [-servicename servicename]
118. stsadm -o quiescefarm -maxduration duration in minutes
119. stsadm -o quiescefarmstatus
120. stsadm -o quiesceformtemplate [-formid form template ID] [-filename path to form template file] -maxduration time in minutes
121. stsadm -o reconvertallformtemplates
122. stsadm -o refreshdms -url url
123. stsadm -o refreshsitedms -url url
124. 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 ‘~’]
125. stsadm -o registerwsswriter
126. stsadm -o removedataconnectionfile -filename filename to remove
127. stsadm -o removedrservice -servicename data retrieval service name -setting data retrieval services setting
128. stsadm -o remove-ecsfiletrustedlocation -Ssp SSP name -Location URL|UNC -LocationType SharePoint|Unc|Http
129. stsadm -o remove-ecssafedataprovider -Ssp SSP name -ID data provider id -Type Oledb|Odbc|OdbcDsn
130. stsadm -o remove-ecstrusteddataconnectionlibrary -Ssp SSP name -Location URL
131. stsadm -o remove-ecsuserdefinedfunction -Ssp SSP name -Assembly strong name|file path -AssemblyLocation GAC|File
132. stsadm -o removeexemptuseragent -name user-agent to receive InfoPath files instead of a Web page
133. stsadm -o removeformtemplate [-formid form template ID] [-filename path to form template file]
134. stsadm -o removesolutiondeploymentlock [-server server [-allservers]
135. stsadm -o renameserver -oldservername oldServerName -newservername newServerName
136. stsadm -o renamesite -oldurl oldUrl -newurl newUrl
137. stsadm -o renameweb -url url -newname new subsite name
138. stsadm -o restore -url url -filename filename [-hostheaderwebapplicationurl web application url] [-overwrite]
139. 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]
140. 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]
141. stsadm -o retractsolution -name Solution name [-url virtual server url] [-allcontenturls] [-time time to remove at] [-immediate] [-local] [-lcid language]
142. stsadm -o retractwppack -name Web Part Package name [-url virtual server url] [-time time to retract at] [-immediate] [-local] [-lcid language]
143. stsadm -o runcmsmigrationprofile -profilename profile name [-skipanalyzer ] [-onlyanalyzer ] [-startover ] [-migratesincetime DateTime string] [-migrationfolder path] [-exportonly ] [-importonly ] [-htmldiff path]
144. stsadm -o runcontentdeploymentjob -jobname name [-wait yes|no] [-deploysincetime datetime] (datetime as “MM/DD/YY HH:MM:SS”)
145. stsadm -o scanforfeatures [-solutionid Id of Solution] [-displayonly]
146. stsadm -o setadminport -port port [-ssl] [-admapcreatenew] [-admapidname app pool name]
147. stsadm -o setapppassword -password password
148. stsadm -o setbulkworkflowtaskprocessingschedule -schedule recurrence string
149. 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]
150. 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”)
151. stsadm -o setdataconnectionfileproperty -filename filename of the data connection file -pn property name -pv property value
152. stsadm -o setdefaultssp -title SSP name
153. stsadm -o set-ecsexternaldata -Ssp SSP name [-ConnectionLifetime time in seconds] [-UnattendedServiceAccountName account name] [-UnattendedServiceAccountPassword account password]
154. stsadm -o set-ecsloadbalancing -Ssp SSP name [-Scheme WorkbookUrl|RoundRobin|Local] [-RetryInterval time in seconds]
155. stsadm -o set-ecsmemoryutilization -Ssp SSP name [-MaxPrivateBytes memory in MBytes] [-MemoryCacheThreshold percentage] [-MaxUnusedObjectAge time in minutes]
156. stsadm -o set-ecssecurity -Ssp SSP name [-FileAccessMethod UseImpersonation|UseFileAccessAccount] [-AccessModel Delegation|TrustedSubsystem] [-RequireEncryptedUserConnection False|True] [-AllowCrossDomainAccess True|False]
157. stsadm -o set-ecssessionmanagement -Ssp SSP name [-MaxSessionsPerUser number of sessions]
158. stsadm -o set-ecsworkbookcache -Ssp SSP name [-Location local or UNC path] [-MaxCacheSize storage in Mbytes] [-EnableCachingOfUnusedFiles True|False]
159. stsadm -o setformsserviceproperty -pn option name -pv option value
160. stsadm -o setformtemplateproperty [-formid form template ID] [-filename path to form template file] -pn property name -pv property value
161. stsadm -o setholdschedule -schedule recurrence string
162. 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] }
163. stsadm -o setpolicyschedule -schedule recurrence string
164. 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)
165. stsadm -o setrecordsrepositoryschedule -schedule recurrence string
166. stsadm -o setsearchandprocessschedule -schedule recurrence string
167. stsadm -o setsharedwebserviceauthn -ntlm | -negotiate
168. 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”)
169. stsadm -o setsitelock -url url -lock none | noadditions | readonly | noaccess
170. stsadm -o setsiteuseraccountdirectorypath -url url [-path path]
171. stsadm -o setsspport -httpport HTTP port number -httpsport HTTPS port number
172. stsadm -o setworkflowconfig -url url {-emailtonopermissionparticipants enable|disable | -externalparticipants enable|disable | -userdefinedworkflows enable|disable}
173. stsadm -o siteowner -url url [-ownerlogin DOMAIN\name] [-secondarylogin DOMAIN\name]
174. 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
175. stsadm -o spsearchdiacriticsensitive [-setstatus True|False] [-noreset] [-force]
176. stsadm -o sync {-ExcludeWebApps web applications | -SyncTiming schedule(M/H/D:value) | -SweepTiming schedule(M/H/D:value) | -ListOldDatabases days | -DeleteOldDatabases days}
177. stsadm -o syncsolution -name Solution name] [-lcid language] [-alllcids]
178. stsadm -o syncsolution -allsolutions
179. stsadm -o unextendvs -url url [-deletecontent] [-deleteiissites]
180. stsadm -o uninstallfeature {-filename relative path to Feature.xml | -name feature folder | -id feature Id} [-force]
181. stsadm -o unquiescefarm
182. stsadm -o unquiesceformtemplate [-formid form template ID] [-filename path to form template file]
183. stsadm -o unregistersecuritytrimmer -ssp ssp name -id 0 – 2147483647
184. stsadm -o unregisterwsswriter
185. stsadm -o updateaccountpassword -userlogin DOMAIN\name -password password [-noadmin]
186. stsadm -o updatealerttemplates -url url [-filename filename] [-lcid language
187. stsadm -o updatefarmcredentials [-identitytype configurableid/NetworkService] [-userlogin DOMAIN\name] [-password password] [-local [-keyonly]]
188. stsadm -o upgrade {-inplace | -sidebyside} [-url url] [-forceupgrade] [-quiet] [-farmuser farm user] [-farmpassword farm user password] [-reghost] [-sitelistpath sites xml file]
189. stsadm -o upgradeformtemplate -filename path to form template file [-upgradetype upgrade type]
190. stsadm -o upgradesolution -name Solution name -filename upgrade filename [-time time to upgrade at] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid language]
191. 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]
192. stsadm -o uploadformtemplate -filename path to form template file
193. stsadm -o userrole -url url -userlogin DOMAIN\name -role role name [-add] [-delete]
194. stsadm -o verifyformtemplate -filename path to form template file

Adding solution to the solution store
Prerequisite: None
stsadm stsadm -o addsolution -filename SampleSolution.wsp

PowerShell add-spsolution -literalpath c:\solutions\SampleSolution.wsp

Because of the way PowerShell handles file path, the cmdlet’s -literalpath switch only accepts a full path to the WSP file. Using a relative path will result in a File Not Found error.
Deploying solution
Prerequisite: The solution has been added to the solution store.
stsadm stsadm -o deploysolution -name SampleSolution.wsp -url http://server -allowGacDeployment -force -immediate

stsadm -o execadmsvcjobs

PowerShell install-spsolution -identity SampleSolution.wsp -webapplication http://server -gacdeployment -force

This solution contains an assembly which must be registered in Web.config (as a SafeControl), so I use the -url switch with stsadm to specify the location of the desired Web application (to which Web.config belongs); alternatively, I could also use the -allcontenturls switch to deploy to all non-administrative web applications. With PowerShell, the -webapplication switch performs the same purpose.
With stsadm it’s also a good idea to run execadmsvcjobs to ensure that the operation is performed immediately. The cmdlet performs this step automatically.
Upgrading solution
Prerequisite: The solution is currently deployed.
stsadm stsadm -o upgradesolution -name SampleSolution.wsp -filename SampleSolution.wsp -immediate -allowgacdeployment
stsadm -o execadmsvcjobs

PowerShell update-spsolution -identity SampleSolution.wsp -literalpath c:\solutions\SampleSolution.wsp -gacdeployment

Again, note that the cmdlet’s -literalpath switch requires a full path to the WSP file.
Retracting solution
Prerequisite: The solution is currently deployed.
stsadm stsadm -o retractsolution -name SampleSolution.wsp -immediate
stsadm -o execadmsvcjobs

PowerShell uninstall-spsolution -identity SampleSolution.wsp -webapplication http://server -confirm:$false

As mentioned in the section Deploying solution, the solution requires modification to Web.config. With PowerShell, you must specify with the -webapplication switch the Web application from which the solution is to be retracted. Failure to do so will result in the following error:
Uninstall-SPSolution : This solution contains resources scoped for a Web application and must be retracted from one or more Web applications.
The cmdlet asks you to confirm the operation before proceeding. For a completely automated operation, you can turn off the confirmation with the -confirm switch.
Removing solution from solution store
Prerequisite: The solution has been retracted.
stsadm stsadm -o deletesolution -name SampleSolution.wsp -override

PowerShell remove-spsolution -identity SampleSolution.wsp -confirm:$false