Built a nice script to remove older files from IISLogs.
It has two retentionmodes. Either clear based on number of last changed files or for specific days.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Scenario:
Sharepoint 2016 needs workflow supports since 2010 workflows now seems dead.
This needs to be done offline
Overview of steps
Download all programs from internet-enabled client with getOfflinePackages
Install packages on server in correct order
Configure workflow manager
Register workflow service in sharepoint
Step 1 - Download necessary files for offlineinstallationen
On client with webaccess
Install WebPlattformInstaller
Download packages with getOfflinePackages.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Step 2 - Install packages on server in correct order
Install packages with InstallWFM.ps1 to get correct order
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Update wfmconfig.xml with credentials and databasename
Configure with configureWFM.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://blogs.msdn.microsoft.com/laleh/2014/09/03/sharepoint-2013-workflow-troublehsooting/ - troubleshooting workflow manager https://social.technet.microsoft.com/wiki/contents/articles/34407.sharepoint-2016-step-by-step-installation-of-workflow-manager.aspx - another installationguide
https://knowledge.zomers.eu/SharePoint/Pages/How-to-install-and-configure-Workflow-Manager-on-Windows-2012-R2.aspx - more updated information on how to configure worklow manager https://docs.microsoft.com/en-us/iis/install/web-platform-installer/web-platform-installer-direct-downloads - webplattforminstaller
So what happens when a column is created and then changed.
And then, possible, changed again in an alternate language?
First created, staticName is set and the cultured name
When names is changed, only the culturename is changed
When and alternate language is added, and copy of the culturename appears.
When name is changed again to doktor2, only the current language version is changed. Swedish 1053.
Now we have 3 version to manage.
When we choose overwrite language specific version the values dont change.
When we now change the column to Doktor3, only the 1053 version change when we’re using the alternate languagebrowser.
But if we change using the default language (1033) to doktor4, all local variants are overwritten
But then a local editor is at it again, setting doktor5 in swedish and the values are off.
But what happens if we now remove local variants? Then we're down to only the default columns
Changing from swedish gui to doktor6 and the english 1033 is changed.
But what happens if language is enabled again? Well, the old value is still there…
The lesson here?
Stay away from alternate languages!
And also a fun script for checking all the versions of a fields on a list.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Method for determining what happens with sharepoint alerts from the serverside.
To determined which server is sending the mail. (Note that this will be different for different webapps, so best is to monitor the whole farm with ULS) run Sysinternals procmon on all servers (usually only the frontends) monitor traffic for :25
Activate verbose logging for alerts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Monitor ULSViewer on specific member or the whole farm for events matching below Category contains "Alerts" AND Message contains "Alert for" OR Message contains "Successfully sent"
Now ULS messages will show successfull and failed (based on securityfiltering) sent emails.
Logon raspberry with
openhabian:openhabian using putty
Set new password with passwd
Set static ip
sudo nano /etc/dhcpcd.conf (insert your own ip) interface eth0 static ip_address=192.168.0.10/24 static routers=192.168.0.1 static domain_name_servers=192.168.0.1
Update software
sudo apt-get update
sudo apt-get upgrade
Goto yourip:8080 , and choose
standardpackage.
Start a new
sitemap.config for example default.sitemap in /etc/openhab2/sitemapsEasiest way to open explorer and go to \openhab-confsitemap
default1 label="Main menu" { Frame { Text
label="Information" { Text
item=Cpu_Load label="System
load" } Text
label="Inställningar" icon="office" { Switch
item=Scene5 } } } End
example
Patchning Sharepoint is not something to taken lightly.
It's a high risk not to patch but a guaranteed risk to apply the patches.
Last year I had a difficult experience when I patched a semilarge(7 members) farm for the first time with Cumulative Updates.
This had 5 webapplications and +200 databases. And it took some time. Like 30 hours, most of the time being lost when running psconfig on each host.
Supposedly, sharepoint should only upgrade the databases on the first member run, but something still takes a lot of time, even its only to check if upgrade is required.
So a more effective method was needed.
I looked into the impressive SPPatchify-project but found the results to be too inconsistent. Sometimes the script ran through it all and said everything was green, when actually two servers had failed psconfigs and a lot of other issues giving half-finished state.
So I deviced my own hybrid method using the best parts of the sppatchify-idea and russmax exe-installationscript.
The method took the installationwindow down to 4 hours in total, where only 2 hours was complete downtime.
Its a bit more manual than others, but therefore also gives more control.
The steps
Preperations
Take whole farm offline and take snapshots, or use regular backups. Whichever method you trust most.
Backup All databases
Installation
Stop all sharepointrelated-services
For AppServers 1. App-Prepatching
For Frontends 1. WFE-PrePatching
Run exe on all members
Start all services
For AppServers 2. App-PostPatching
For frontends 2. WFE-PostPatching
Export all databasinformation to file.
ExportAllDbs.ps1
Dismount all databases (after making sure you have all correct info on file from previousStep) This will take everything offline.
DismountAllDbs.ps1
Run psconfig on all members starting with AppServers
RunPSConfig.ps1 on each member
Mount all databases
MountAllDbs.ps1 - Update the filename to your exported databases
Upgrade databases in parallel. While each db is upgrading website on it will be unavailable. If you're sql supports it you can mitigate this using -usesnapshot How many concurrent jobs is depending on hardware. I found the sweetspot to be 4 concurrent jobs, after that it started taking longer time that running them in sequence. But this might vary.
UpgradeDatabasesFaster.ps1
Check on warnings in Health Analyzer, make repairs if needed.
Make sure User Profile Synchronizer service is running (if your using FIM-sync)
Below all relevant scripts. Use at your own risk.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
In this particular case a user decided to throw away the main webpart of the dispform.aspx. This caused all kinds of problems since it was a calenderlist. In this situationen it wasn’t possible to create a new list since a lot of coded things worked with listids. Theres no versioning of dispform. I first tried to use restore to sitedefinitions, but this kind of change didn’t qualify for making restore for some reason. So this what came instead.
1. Find a functioning “vanilla” dispform.aspx from a list of same type 2. Open Sharepoint Designer, goto website of above list, find list and copy ListID 3. Find dispform of functioning list and export to file. Save locally on computer 4. Open locally saved dispform with notepad. Find and replace listid of sourcelist with targetlist listID (in calenderar two matches) 5. Opensharepint Designer, goto website of broken list. 6. All Files>Lists><mylist> 7. Take a backup of dispform with export to file, just in case you mess up. 8. Import locally modified dispform 9. Changes take effect immediatly.