Going through the Installed Updates list to check for a specific update that might or might not mess things up can be tedious using appwiz.cpl
Introduced in Powershell version 4 we have a new cmdlet for this purpose that come in handy.
Show list of all installed hotfixes
/> get-hotfix
Show if a specific update is installed:
/>get-hotfix -id "kb2843630"
References:
http://technet.microsoft.com/en-us/library/hh849836.aspx – syntax
Overview:
Funny thing happend the other day…
Site migrated from sharepoint 2010 to 2013. Certain groups can’t create subsites using Publishing template. They really want to…
Owners and members of constructor group can work fine.
Groups are using custom permission level.
Symptoms:
- Creating subsite with publishing or publishing with approval workflow results in :
- EventID 4965 – Web Content Management – Couldt initate … properties
- Server Error in ‘/’ Application – Runtime error
- ULS throws errors when trying to create.
- Works for members of owner or constructor group.
- Works when creating a non-localized default format publishing site.
- Works when creating Team Site
Solution:
- Added Apply Themes and Border, Apply Style Sheets permission for the custom permission levels
- Added the relevant groups with read permissions for the /devicechannels list on each Site Collection.
Lessons learned:
- Devicechannels is a new feature of sp2013, permissions aren’t added automaticly if using custom groups, permissions levels and allowing for custom css.
References:
http://meandmysharepoint.blogspot.se/2014/03/runtime-error-when-creating-sharepoint.html -
Finally with Windows 8.1 and Server 2012 we have some new cmdlets that make managing firewall-rules much easier. Hopefully we can now put netsh to the everlasting rest.
Example script – blockapps.ps1
$rulename = "BlockSomething"
$appPath = "D:\temp\Myprogram.exe"
New-NetFirewallRule -displayname $rulename -Direction Outbound -Program $appPath -action Block
References:
http://technet.microsoft.com/en-us/library/jj554908.aspx – cmd syntax
----------------xmllooptest.ps1 ---------
$path = split-path -parent $MyInvocation.MyCommand.Definition
$inputfile = $path + "\myinputfile3.xml"
[xml]$xmlinput = (Get-Content $inputFile)
write-host $xmlinput.main.configuration.name" is my value"
write-host "Server is:"$xmlinput.main.configuration.server
write-host "Result : "$xmlinput.main.configuration.result
Write-host "Looping sites..."
$sites = $xmlinput.main.sites.site
foreach ($site in $sites)
{
write-host "-----"
write-host $site.name
write-host $site.property
if ($site.name -match "my site 2")
{
$site.property = "New property for site2"
}
write-host $site.property
}
$xmlinput.save($inputfile)
-----------------------eof-----------------
----------------- myInputfile3.xml------------
myserver
Wyoming
Testing
my site 1
My even newer property
my site 2
New property for site2
--------------------eof--------------
Some guiding documents that are enlightning
http://sharepoint.mindsharpblogs.com/Bill/archive/2010/04/02/Organizing-Information-in-SharePoint-Server-2010.aspx – Great post about the cost and putability of document management.
http://office.microsoft.com/en-us/sharepoint-server-help/governance-101-best-practices-for-creating-and-managing-team-sites-HA101847542.aspx – Governance and site-management
http://www.ietf.org/rfc/rfc5013.txt – The Dublin Core Metadata Element Set. A standard for tagging documents.
https://www.nothingbutsharepoint.com/sites/eusp/Pages/16-ways-to-get-your-users-actually-using-SharePoint-properly.aspx – 16 ways to get your users actually using sharepoint properly
To check version on farm, when fighting schema-issues while migrating
/>get-spfarm |select name,buildversion
To check correlation id when an unexpected error has occurred
/> get-splogevent | ?{$_.Correlation -eq "CORRELATION ID"} | select Area, Category, Level, EventID, Message |Format-List
To convert users from windows-based to claims-based on a migrated webapplication.
/>convert-SPWebApplication -Identity "https://portal:80 -To Claims –RetainPermissions
References:
http://ittechnotebook.blogspot.se/2013/07/how-to-find-real-error-in-sharepoint.html
http://www.wictorwilen.se/sharepoint-2013-claims-is-the-new-black
http://www.wictorwilen.se/Post/How-Claims-encoding-works-in-SharePoint-2010.aspx
To get a choice column with multiple selections to allow default values with multiple selections a calculated value is needed.
Note that this is mostly used in a Foundation environment where Terms are not allowed.
In the Default value field give formula: =";#Offer;#Deal;#" where Offer and Deal is valid column choices.
References:
A customer intranet died the other morning. The is what happend.
First user notifies of error while trying to access.
I start to look into it.
- First issue. Low/none diskspace. Frees up so its workable. This does nothing for the site. Tries restart to no avail.
- Checks all IIS-sites and Application Pools. A lot of pools are stopped. Starts these up, but not difference.
- Notices that patches been applied the previous night. Server starts warning for diskspace soon after. Ok so maybe a patch requires psconfig. Runs this but are greeted with error: Failed to initiate the upgrade sequence…. Method not found ‘void Microsoft.Sharepoint.WorkflowServices.Iworkflowservice.upgrade….
searching for this error doesn’t give much. Tries to uninstall the workflow manager services for this seems to related. the workflow 2013 mananger has given some ache in the past and isn’t used anyways. This gives nothing.
Tries to access Central Administration and curiously this works to certain degree. Until tries to access Service Application then it throws iWorkflowServices errors again.
Looks deeper into the logs and finds issues with the patches being applied.
Ok, so maybe a patch was trying to be applied but got stuck on the diskissue and landed in some unfinished state?
Tries to download the latest updates to see if this is an issue. There is some, but it takes alot of time.
Checks the size of the culprits Kb2863829. Turns out this mother is 827MB, no wonder it takes time. AND the patch requires and psconfig run after completion!
Let the update run through and then runs psconfig again. Though this failes on the Task 8 in the first run (Failed to create sample data) another run let it finishes.
Now everything works again!
What to take with us from this experience?
Always have 10-20GB free space on the sharepointserver!
References:
When transaction log has grown to size that is too big to take backup, or space just isn’t available AND the database just isn’t that important that it should drag all others to lag-hell this might be done to solve the issue.
Note that there is a point to transaction files. If the database is so important that you can’t loose a minuts worth of transactions its really a necessary feature. But if that need isn’t there, the recovery mode could easily be changed to Simple to avoid the risk of losing space on an old server and therefore halting critical applications.
But here it is anyways.
If the transaction logs grows, its usually because their isn’t a real backupsolution running for the database. Use maintenance jobs or stored procedures if a real one isn’t available.
For some security reason these are disabled on SQL Server 2008-2012 on some occasions. Might be a servicepack disables it. But maintenance plans are a nice tier 2 security precaution.
Get thrown this error when trying to create a maintenance plan
Ran following query on victimserver to solve it.
Microsoft, in all their wisdom, have removed the Manage my wireless network option that was available on the wireles interface in Windows 7 and earlier. So, how to we manage it now?
See stored wireless profiles
/> netsh wlan show profiles
Delete a profile
/> nets wlan delete profile name=mynetwork
To show saved information, including key
/> netsh wlan show profiles name=mynetwork key=clear
Or to use the gui-way
Charms>PC Settings>Networks>Connections>WiFi>Manage known networks
But only thing you can do from here is see the name and forget the network, so learn the cli way.
References:
I made a customer installation of Sharepoint Foundation 2013 recently. Naturally I used the latest Slipstreamed Microsoft package with Service Pack 1.
Sure everything looks fine at first, but after first site collection is up and running I notice that the searchbox is missing. Sure, maybe a glitch, runs new full crawl, but nothing changes. Tries to create a new search center site, site creator throws a sorry my way.
Tries to create my own custom page and add the search webpart and get another fun message “Common Language Runtime detected an invalid progam”.
Ok, maybe language is an issue, installs localization pack for swedish and creates new site collection. Same error.
After searching for information on the issue someone makes me aware of the fineprint of Slipstreampackaged Foundation downloadpage
First time that field contained any relevant information!
Searching on forums shows a few MS-cases that all indicates that this is an issue which will be fixed in the April CU. So we have to wait I tell the customer, looking like a noob cause they don’t want to put in the extra time for a reinstallation sans SP1.
But today I found an update that solved the issue! Curiously not by googling but in my rssfeeds…
Hero of the day is: KB2760625 March 2014 PU for SharePoint Foundation 2013
Note the package is claiming to aimed at Sharepoint Enterprise Server but it worked nicely on my Foundation.
References:
http://support.microsoft.com/kb/2760625
http://www.microsoft.com/en-us/download/details.aspx?id=42268
In Exchange 2013 with Outlook 2010 client, mail sent dont land in the corresponding sent folder.
For example, If John has access to shared mailbox Info@contoso.com, mail he sends with info as sender will land in his personal sent folder. This makes John and John collegues confused.
Solution:
Key: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Preferences
Name: DelegateSentItemsStyle
Type: DWORD
Value: 1
Or run FixIt on https://support.microsoft.com/kb/2181579
References:
Ever gazed upon the startpage of a Sharepoint Team Site and wondered how you could make your own Get Started panel?
Its simpler than it looks.
<style>
.ms-core-pageTitle{Display:none !Important;}
</style>
<style>
#pageContentTitle {
display: none !important;
}
</style>
Create Sharepoint Workflow 2010
1. Create 2 variables, wholedate and year
2. Define functions
Set Variable:wholedate to currentitem:start time (return field as ISOFormatted)
then copy 4 characters from start of variable:wholedate(output to:variable:year)
then log variable:year to the workflow history list
References:
Java keeps blocking my stuff.
Figure that Procurve switches doesn’t come with signed applets.
Nothing worked while trying to access a procurveswitch after latest Java-update. Wouldn’t even get the option of running anyways.
To get it running:
Java Control Panel > Advanced> Security > Mixed Code > Disable Verification
Now its only one warning about unsigned stuff, haven’t managed to kill this one yet.
I usually prefer to avoid java on my machines, but when it comes to Procurve-switches its unfortunately required.
What happend with Low?
References:
http://gdgtry.com/2010/05/disable-javas-new-security-warning/
http://jaxenter.com/unsigned-java-applets-hit-by-security-update-46755.html
To deploy msi package to from GPO.
1. Create GPO DeployPackage
a. User Configuration>Policies>Software Settings>Software Installation
b. Create new package, choose msi to deploy. Must be located on a shared folder that has read permissions for authenticated users (to include all domain computers).
c. Choose Published
d. Choose newly created package, Change Deployment>Deployment Type to Assigned and Check Deployment options>Install this application at logon
2. Deploy this GPO to an OU where the User object is located.
3. GPUpdate /force on both server and client.
4. If all works, the client will notice the policy and request a restart.
5. Package should deploy as soon as logged in.
A handy feature to use when bulk-uploading documents to Sharepoint is the “Default Column Value”. This feature shines when using folders.
For example, say $user wants to upload 2000 images to an assetlibrary and wants to tag these with managed metadata values, 3 of them for a third of the lot and something else for the rest. Managed metavalues can’t be edited in datasheet view when using multiple values so this might take some time for $user.
In this case $user could create three folders in the assetlibrary and from Library Settings>Column Default Values > Folder change the values as $user wants.
Now all documents copied to this folder, even from ExplorerView, will get these default values. Unless manually specifying something else.
The cool thing is that when the values have been set, $user can copy the images elsewhere in the documentlibrary and the metadata will still be attached. So folders can be used as a transitstation for settings metavalues. Or just be presented with a flat structure in the view.
References:
Nuisance mayor.
A client had an issue with alerts not working for some users.
Sorry something went wrong. The following users do not have an e-maildress specified:
Turned out email issues overall for these users.
Tried did not succed.
Success:
Tried running />get-spuser –web http://myserv | select userlogin,displayname,email
Noted that email was missing for the difficult users. Now why is that?
Verifed that Replicable was activated on the User Profile Properties settings for the emailfield. All looked good.
Fixed it by running :
/>$myuser = get-spuser –web http://myserv |?{$_.displayname –like “*myuser*”}
/> set-spuser –identity $myuser –web http://myserv –SyncFromAD
To identify accounts with no email
/> get-spuser –web http://myserv | where {-Not $_.email} |select userlogin,email
To output add |export-csv myusers.txt
Conclusions:
External client weren’t so interrested in putting in more time to figure out exactly what was wrong in the first place. New users for example are adding their email field from the AD without any issues. The problem users were added to the site prior to defining the email attribut in the AD so that may have been an issue aswell. Im still fidning it odd that the email were looking like they should in the User profile Services but not when using powershell. might be that the user profile service is making a lookup in the AD when browsing the profiles, but can’t be sure .
Solution found. Cause unknown. ill revisit this later.
References:
http://patrikluca.blogspot.se/2008/06/alerts-not-working-for-some-users-on.html
http://www.stuartroberts.net/index.php/2013/07/10/user_profile_sync/#more-1488 – email not available efter moving user
http://sharepointpratik.blogspot.se/2013/03/the-following-users-do-not-have-email.html
http://blogs.technet.com/b/harikumh/archive/2008/05/25/troubleshooting-alerts.aspx
http://social.technet.microsoft.com/Forums/sharepoint/en-US/b671a6c8-3065-4299-b7be-d40e9c5d982b/alert-me-error?forum=sharepointgenerallegacy Tells us email must be added prior to adding user to sp.
When certain task has run, its nice to be notified. since email function is deprecated in taskscheduler we have to pull out powershell.
1. Create the script
-------sendmail.ps1-----
param([string]$task)
$psemailserver = "smtp.mycompany.com"
$receiver = john.doe@company.com
$from = task@company.com
$subject = "Task has run"
$body = "Scheduled task $task has run. "
send-mailmessage -to $receiver -from $from -subject $subject -body $body
write-host "Mail sent for $task"
write-eventlog -logname Application -source "my script" -entrytype information -eventid 1 -message "$task has run"
------eof----
2. Create the call using Task Scheduler “powershell –file “c:\myfile\sendmail.ps1” “helloworld”
What the script does is take an input variable and sending an email using defined smtpserver in the script. When mail is sent, it also logs en event in the application eventlog with source “my script”. The param is optional, but helpful if you want more reusability.
The source needs to created the first time manually, or use an already existing source.
Create source “my script” in application
/>New-eventlog –logname application –source ”my script”
References:
Sharepoint isn’t very flexible when it comes to email server.
Enter the local smtpserver.
It should work immediatly. No need to reset IIS or restart the smtpserver.
Sometimes youre mailing servers you cant verify settings on. Then Gmail can be used to verify the mailflow.
For google
To check email flow on local server, drive:\inetpub\mailroot\queue folder can be monitored. When mail is sent from sharepoint ,it lands in this folder while contacting the smtpserver. When there’s a problem, the mail will be stuck here. In some situations it might be needed to empty this folder, then content in this folder can be deleted if the iisadmin service first is stopped.
/>stop-service iisadmin
/>start-service iisadmin
/>start-service smtpsvc
References:
Useful excelformula that is hidden from the common gui, but present in all version of excel.
To compare a date to today
=DATEDIF(A1,TODAY(),"d")Outputs difference in days. Can also return in complete months, years and then some.| D | Number of days |
| M | Number of complete months |
| Y | Number of complete years |
| YD | Number of days excluding years |
| MD | Number of days excluding months and years |
| YM | Number of months excluding years |
Note that on Swedish systems formulas look like this instead:
Comma is replaced by semicolon for some reason.
References:
While trying to copy files to my Lumia 520, my windows didn’t show the phone in my computer.
To solve this
1. Install Window Phone App
http://www.windowsphone.com/en-au/how-to/wp8/windows-phone-app-for-desktop
Why? I don’t know, this is supposed to work out of the box. But it might be an issue since Lumia 520 is a pretty cheap issue.
Or the issue might be that Metro-phone app stole the attention.
This is how its supposed to look: 
Now we can copy files like an usual folder.
Now, how do we do this wirelessly?
Was working from sharepointblogs.com instructions trying to get Thumbnails from an Assetlibrary to be displayed in an Searchresultspage, but couldnt get the thumbs to stick.
Finally I tried removing “contentypeforsearch.=’image’ frome the xsl-customizations and it started working right away. Somehow the images in my results wasn’t interpreted as images. Maybe the .jpg filetype needs to added manually or something.
In this case, its a Imagesearch result page so the results are always images.
It works, im happy. customer happy. Done.
Before:
<xsl:when test="contenttypeforsearch[. = 'Image'] and contentclass[. = 'STS_ListItem_851']">
After:
<xsl:when test="contentclass[. = 'STS_ListItem_851']">
References:
http://www.sharepointblog.com/2010/11/image-content-type-thumbnails-in-2010.html – the moneyshot
http://www.ableblue.com/blog/archive/2008/08/30/sharepoint-image-search-part-2/ – a bit old, still generally informational.
http://www.novolocus.com/2008/05/22/showing-thumbnails-in-search/
http://blogs.technet.com/b/anneste/archive/2008/11/25/mystery-solved-crawled-properties-in-sharepoint-part-5.aspx – details regarding how the crawling properties works.
For a case im using a link-list on a startpage. Reasons include making it easier for endusers to manage their own used applications, without rummaging around with tables etc.
For this reason the boxed view style served me well.
The box-borders gave an ugly look. To remove these, add content Editor webpart and insert
<style>
TD.ms-stylebox {
BORDER:0 !important;
}</style>
Effect should be immediate.
While doing labs, applying snapshots and whatnot the licensekey sometimes disappears or you just dont wanna waste an activation on a testmachine.
To re-arm a Server triallicense
Elevated Cmd-prompt
Check current licenselevel
/>slmgr.vbs –dli
Extend the evalution period with another 60 days
/>slmgr.vbs –rearm
Server can be rearmed up to 3 times giving you a total of 240 days.
References:
To create a shared folder using powershell
New-SmbShare –Name ShareName –Path C:\LocalFolder
To get permissions on existing
Get-SmbShareAccess –Name ShareName
References:
För en lokaliserad version av Sharepoint 2010 så används även svenska på de logiska funktionerna. Det är väl ok, när man kommer till ro med att det går att använda åäö på funktioner “Date=Datum,Year=År,Month=Månad etc”. Det som är knepigare att få grep och är varför de bytt ut skiljetecknen!
För att få fram en första dagen i en månad baserat på ett datumfält så funkar i Engelsk version denna:
=DATE(YEAR([Due Date]), MONTH([Due Date]), 1)
Motsvarande funktion på Svensk version:
=DATUM(ÅR(visning);Månad(visning);1)
Notera att “,” är utbytt emot “;” på svensk version.
Så för att filtrera en listvy baserad på vilken månad som är angivet i ett fält kan följande metod användas.
![image[6]](http://lh3.ggpht.com/-11yds0XTmOQ/UtfUqLlPzKI/AAAAAAAAEQI/xnnD-4VlnI0/s1600-h/image%25255B6%25255D%25255B2%25255D.png "image[6]")
References:
http://iwillsharemypoint.blogspot.in/2012/03/sharepoint-list-view-of-current-month.html
http://kalsing.blogspot.in/2006/02/sharepoint-list-group-by-month.html
http://blog.pentalogic.net/2009/11/howto-filter-items-current-calendar-month-view-sharepoint/
