Windows 2012 and Exchange 2013, Sharepoint 2013 and Lync 2013 Install

-
I decided it's about time to get a lab built on my new server and play around with the new toys Microsoft have to offer, mainly Exchange, Lync and SharePoint. My previous blog describes some of the issues I had installing SharePoint 2013 and configuring it as a development rig.

Now for Exchange and Lync

Exchange went on reasonably OK until I came to sorting out the certificates, turns out installing the AD CA role isn’t quite the same on Windows 2012, fortunately I found this excellent guide:

http://www.virtual-big-bang.co.uk/windows-2012-certificate-services/cerficate-services-2012-part1/

Interestingly when I went to assign the created certificate Exchange would keep coming back with “Not Valid” in the status. I left it overnight and came back the next day to find that it had changed to Valid. I read that apparently after creating the AD CA roles it’s a good idea to reboot anything reliant on it, so they recognise the authority on the domain.

Lync 2013 was also more complex than I anticipated but turns out that all the effort I put in sorting out the certificates meant I could get that bit sorted a breeze. I followed this guide to help me out which I found very useful:

http://y0av.wordpress.com/2012/07/31/lync-2013-prerequisites

Lots of thanks to the guide creators, they got me out a lot of trouble!

Comments

Post a Comment

Popular posts from this blog

Use Power Automate to create a Document Set – The easy way!

-
Image
NOTE: This makes a “pseudo” document set, use the VTI bin method to create a full blown document set, however perhaps some of the steps could be useful to you. I’ve recently been working with improving some workflows which use Document Sets and stumbled into a problem. Online when you search for “Document Sets using Power Automate” you get posts such as:  https://karinebosch.wordpress.com/2018/11/08/microsoft-flow-create-a-document-set/ https://knowhere365.space/microsoft-flow-sharepoint-document-set-creation/ Now these posts have helped a lot of people but there is one drawback to them and most of the others I can find online. They rely on the use of _vti_bin (sometimes referred to as SP 2010 REST API) If you don’t know much about the history of VTI go check this out: https://www.spjeff.com/2009/03/13/history-of-_vti_bin/ It’s pretty vintage now. The customer I’ve been working with has a handful of SharePoint 2010 workflows we discovered using the SharePoint Modernisation Scanner  
Read more

Power Automate - Get SharePoint items using Created By/Modified By

-
Image
Recently I had an interesting request where someone was trying to filter items based on the Created By field in SharePoint using Power Automate. I thought, that should be pretty straight forward, make a claim or something similar and I headed to Google. Surprisingly there's not actually that many hits and it took quite a bit of digging. The answer once you realise is pretty straight forward. SharePoint holds a hidden(ish) list, the "User Information List" you can view it by adding the following to a Site Collections URL:  /_catalogs/users/simple.aspx This list holds all the "Ensured Users" on the site - you can google that one if you want to find out more. It also holds the information on which you can use in the filters for People Fields. Here are all the useful filters you can use: "ItemInternalId":"11", "ID":11, "Title":"Martin Pyman", "Name":"i:0#.f|membership|martin@marnotechnology.com",
Read more

Handling British Summer time when querying SharePoint from Power Automate

-
Image
This also applies to other TimeZones. When you query SharePoint in Power Automate using steps like "Get Items" the raw information that is returned when you are working with dates and currently inside British Summer Time will be out by an hour. Below I've created a step which runs Get Items and I add a compose to check the Created date: Going into SharePoint you can see the date time returned is an hour out (I'm currently inside British Summer Time and my laptops date/time is set as such). Whenever you are handling dates from SharePoint in Power Automate you have to remember that the original value stored in SharePoint for date/time is the UTC value. Depending on your regional settings the value is converted for you when it's rendered. Fear not! Power Automate has conversions, here's one way: In the example above I'm taking the source Created date/time which is in UTC and converting it to my location - Dublin, Edinburgh, Lisbon, London. The expected Create
Read more