Archive

Archive for the ‘Work’ Category

#ProjectServer and #SharePoint 2013 / 2016 October 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

October 19, 2017 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

The Office 2016 October 2017 updates and cumulative updates are now available – post a bit later than normal, please see the links below:

http://bit.ly/2zmnsO4

Project 2016 October 2017 update:
http://bit.ly/2zAllXK

SharePoint Server 2016 / Project Server 2016 October 2017 update: 
http://bit.ly/2zkZmmW & http://bit.ly/2zAlmeg

The Office 2013 October 2017 updates and cumulative updates are now available, please see the links below:

http://bit.ly/2zmnsO4

Project Server 2013 October 2017 CU Server Roll up package:
http://bit.ly/2zlsREV

Project Server 2013 October 2017 update:
http://bit.ly/2zBlQRE

Project 2013 October 2017 update:
http://bit.ly/2zmnupa

Also worth noting, if you haven’t done so already, install Service Pack 1 http://bit.ly/1uorn2C first if installing the October 2017 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

Advertisements
Categories: Paul Mather, Work Tags:

#ProjectOnline #PowerBI content pack 2 available #BI #Office365 #PPM update

October 19, 2017 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

Following on from my previous blog post regarding the updated Project Online Power BI content pack from Microsoft -  see below if you missed it:

http://bit.ly/2fpUUvh

That was shortly removed from the Power BI service and hasn’t been updated there yet but the template file has since been made available to download from GitHub:

http://bit.ly/2ilT3w5

You can now have the default reports provided here and extend to your own requirements for example a quick change would be to change the currency symbol used if you are not using US dollars:

image

Make the changes as required then publish to your own organisation.

Categories: Paul Mather, Work Tags:

#Microsoft #Ignite Day 2 summary #Azure #Office365 #MSIgnite #Microsoft365

October 5, 2017 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

******************** This is a guest blog post by Lee Mather ********************

Day Two

After recharging the batteries, we had another early start for day and had as many sessions packed in as possible. I will try to provide a summary of key takeaways for each session. Please let me know if you would like any further detail as I’m happy to discuss.

Session 1: Overview: Modern Windows 10 and Office ProPlus management with Enterprise Mobility + Security

This session focused on moving to a modern management for Windows and went into more detail than the session I attended on day 1. The main highlights were:

· Simplify deployment and device management with Intune and Windows Autopilot. Microsoft’s vision is for laptops and PCs to be as easy to setup as mobile phones. Microsoft 365 powered devices will benefit from the following

o Intelligent Security

o Easy deployment

o Always up to date

o Proactive insights with Windows Analytics

clip_image002

· A couple of slides which highlight the difference between traditional IT and modern IT

clip_image004

clip_image006

· There are a few paths to transition to modern management which has been expanded by the introduction of co-management. Co-management should be released by the end of the 2017 calendar year

clip_image008

Session 2: Simplify hybrid cloud protection with Microsoft Azure Security Centre

The second session of the day focused on hybrid cloud protection with Microsoft Azure Security Centre. As I mentioned this in the summary of day one, I will only highlight the features.

· Hybrid Cloud Support – This allows a unified security centre for Azure workloads as well as workloads running on-premises and in other clouds. Additional information can be found here http://bit.ly/2fT0ie3

· Just In Time Access – This allows administrators to lock down ports such as RDP and to allow access when required. Additional information can be found here http://bit.ly/2y2WgWH

· Adaptive Application Controls – This allows you to define a set of applications which can run on your VMs which helps in the fight against malware. Additional information can be found here http://bit.ly/2fVIjnb

· Azure Security Centre will soon include Windows Defender ATP detections. Additional information can be found here http://bit.ly/2fT0ie3

· An interactive threat intelligence map has been added to the Azure Security Centre for visualisations. Additional information can be found here http://bit.ly/2y2DU8g

· An investigation dashboard is currently in preview which will correlate all relevant data with any involved entities. You will be able to navigate between entities by clicking through the graph and providing information. Additional information is available here http://bit.ly/2fUzmdS

Session 3: What’s new with Microsoft Exchange Online Public Folders

This was a 30-minute session to highlight some of the new features in Exchange Online Public folders. The main takeaway for me was the migration of public folders to Office 365 Groups. This migration approach is supported for Exchange 2010, 2013, 2016 and Exchange Online. Additional information can be found here http://bit.ly/2y2wbqJ

Session 4: Office 365 Security and Compliance Overview

The session focused on the following key areas of Office 365 security:

· Threat Protection

· Information Protection

· Security Management

· Compliance Management

clip_image010

The main takeaways and areas of interest for this session were:

· ATP has expanded to SharePoint, OneDrive for Business and Microsoft Teams

clip_image012

clip_image014

· Safe Links will now show the original URL when a user hovers over the link

· Safe Links will now apply to internal and external email

· Safe Attachments now have a preview feature enabled to allow a user to view a document online whilst it’s being scanned. Scanning time has also been greatly reduced over the last year

· SharePoint malware will be reported in the Threat Management portal

· New updates being rolled out to Office 365 Threat Intelligence

o Threat Tracker

o Threat Explorer

o Remediation capabilities

o Attack Simulator – Admins will have the ability to simulate different threat scenarios to gain an understanding of how users behave in the event of a real attack

clip_image016

clip_image018

· Single interface for creating protection labels is on the way

clip_image020

· New reporting capabilities being rolled out to the Office 365 Security and Compliance Centre

· New Compliance Manager should be in Public preview later this year. Additional information can be found here http://bit.ly/2fVIm2l

clip_image022

Additional information can be found here: http://bit.ly/2y2AimT

Session 5: Learn about the Microsoft global network and best practices for optimizing Office 365 connectivity

This was a great session that looked at the Microsoft network and as the title suggests, provided best practise tips. The main takeaways for the sessions were as follows:

· Avoid proxy servers when connecting to Office 365

· Review Office 365 IPs regularly and update firewalls if required

· Ensure your traffic is routing to the Microsoft network in as few hops as possible

clip_image024

· Network performance requirements for Skype for Business and how to test your network using the Skype for Business tool – http://bit.ly/2fVPzj0

clip_image026

clip_image028

· Skype for Business is the most sensitive to network performance and requires additional ports for best user experience

clip_image030

· Some interesting facts regarding the Microsoft network

clip_image032

Session 6: Yammer’s roadmap for enhanced integration, security and compliance

This was a breakout session that only last 45 minutes. The main takeaways were:

· Local data residency preview Q4 2017

o Existing customer H2 2018

· GDPR compliance by Q1 2018

· Yammer will soon be added to eDiscovery in the Office 365 Security and Compliance Centre

· DLP policy tips will be rolling out to Yammer in 2018

· SharePoint Group integration

clip_image034

That concluded another busy day at Ignite!

Categories: Paul Mather, Work Tags:

#Microsoft #Ignite Day 1 summary #Azure #Office365 #MSIgnite #Microsoft365

October 5, 2017 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

******************** This is a guest blog post by Lee Mather ********************

So, after an eventful week in Orlando at Microsoft Ignite I thought I would share with you a summary of my first day! With over 26,000 attendees it was always going to be a busy event with lots going on, we would need a team here to take in all of the information being presented to us. I am hoping to have a chance to share the other days ASAP.

Day One

During the first day I attended several sessions and would like to share the following takeaways.

Keynote

The mission statement from Microsoft is to “Empower every person and every organisation to achieve more

clip_image002

The keynote focused on digital transformation which is aligned to the four key areas below:

· Modern Workplace

· Business Applications

· Application & Infrastructure

· Data & AI

clip_image004

Following on from the keynote session, I had a day packed of sessions mainly focusing on creating a modern workplace.

Session 1: Create a modern workplace with Microsoft 365

The session focused on the following key areas:

· Flexibility to work on any device, anywhere

· Improvements to Office application including PowerPoint Designer using AI.

· Teamwork

o Microsoft Teams will be the hub for teamwork including chat, calls and meetings.

o Microsoft Teams will replace the Skype for Business client over the next year

Other worthwhile mentions from the session included Cortana Calendars. Cortana Calendars is a new feature that is currently in “Exclusive” preview but essentially this service will help intelligently schedule meetings on your behalf, simply by adding Cortana in the CC field. The service will support Office 365, Outlook.com or Google calendar. Additional information can be found here http://bit.ly/2fVrysp

“With the speed of artificial intelligence and the personal touch of a human assistant, Calendar.help takes care of business.”

The session also focused on the modern device management and deployment. Windows Autopilot will allow new device deployment in a few simple steps, straight from the vendor to your desk without involving IT. Working with Windows Autopilot and a device management solution such as Intune, the device will be deployed, Azure AD joined or Offline domain join to Active Directory, configured with all policies defined by IT and app deployment. More on this over the coming days.

Device Co-Management was also announced as a new feature, this is the “Hybrid” device management that will support a transition from System Centre Configuration Manager (SCCM) to Intune. Co-Management will allow a device to be managed by both SCCM and Intune allowing a gradual migration to modern management whilst supporting legacy devices and applications.

clip_image006

Finally, a couple of new offerings from Microsoft, Microsoft 365 Education and Microsoft 365 F1. Additional details can be found here http://bit.ly/2y2QWTh and http://bit.ly/2fUOZSz

Session 2: Use MDM migration tools to accelerate move from GPO to MDM

This session focused on accelerating a move to MDM and moving away from GPO to MDM policies. GPO has been around for years with many legacy policies in the workplace that may or may not be required today. Microsoft are continually releasing new device configuration policies to Intune. To support the migration away from GPO to MDM, the following PowerShell script can be executed that will output a report. http://bit.ly/2y2nYTy

The tool is being regularly updated to align with new features available in Intune.

clip_image008

Session 3: Cloud infrastructure: Enabling new possibilities together

The Cloud Infrastructure session focused on using Azure for all workloads, big and small.

clip_image010

The session explained how you can setup a SAP HANA platform in minutes using Azure instead of weeks using on-premises hardware. Microsoft are continually providing more options for scaling in Azure, currently offering up to 20TB RAM for large SAP HANA deployments.

clip_image012

It was also recommended to use the DevTest labs to reduce costs for non-production workloads. For more information on DevTest lab please take a look here http://bit.ly/2fUG4kb

The Azure Security Centre is now Hybrid too, allowing for non-Azure machines to be onboarded to take full advantage of the security monitoring and recommendations built into Azure.

clip_image014

This is a great additional to Azure Security Centre for a single unified view of your servers, either on-premises or running in Azure.

Currently Azure have 42 regions with 100’s of data centres, 4500+ peering locations and 130+ edge sites making the Azure network one of the largest in the world.

clip_image016

Microsoft, in conjunction with Facebook, also completed the first transatlantic cable which is approx. 4000 miles long and can support 160TB/sec of data.

clip_image018

Other worthy mentions would include:

· Additional Express Route partners

clip_image020

· Azure Distributed Denial of Service (DDos) Protection has just been released to preview. Additional information on the DDos service from Microsoft can be found here http://bit.ly/2y2waDb

clip_image022

· Azure Data Box has been released in preview and would be used to support customer with large data imports to Azure. The device supports 100 TB and a customer can have multiple devices. Additional information can be found here http://bit.ly/2fUrrxq

clip_image024

· Azure File Sync is another new preview release that allows Azure File Share to sync with on-premises file servers. Cloud tiering is implemented that allows storing a certain amount of data locally and store a larger amount of data in the cloud. Azure File Sync is also integrated into Azure Backup. Additional information can be found here http://bit.ly/2y2UgxX

clip_image026

I could go on all day about updates from Ignite so will provide links to everything else announced during the session!

· Azure Policy – http://bit.ly/2fUrt8w

· Azure Migrate – http://bit.ly/2y2UgOt

· FastTrack for Azure – http://bit.ly/2fUrtp2

· Cloudyn – (Cost Management for Azure) http://bit.ly/2y2Uh4Z

Session 4: What’s new and upcoming in AD FS to securely sign-in your users to Office 365 and other applications

The ADFS session focused on what’s new and what’s coming in the future for ADFS for Office 365. As this was a shorter session I would highlight the key takeaways only.

· Passwords could soon be a thing of the past. Password less options for ADFS 2016

clip_image028

· How to get to password less authentication

clip_image030

· Extranet lockout for ADFS with known locations is coming soon. This feature will help user accounts from being locked out from failed external logon attempts.

clip_image032

· Resolve ADFS authentication issues faster using the help site – http://bit.ly/2fUrvNG

· ADFS Rapid Restore tool – http://bit.ly/2y3nQDn

That was enough for one day and it was time to leave the convention centre and head back to the hotel.

Categories: Paul Mather, Work Tags:

#SharePoint item count from all lists on all sub webs in SharePoint / #ProjectOnline #PPM #PowerShell

September 28, 2017 1 comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

This is a supporting blog post for an example PowerShell script I quickly wrote for Microsoft’s Office 365 SharePoint Online. It was created after a query was posted on the Project Online TechNet forums asking how to easily check what sub sites were being used in PWA.

The code sample can be downloaded from here: http://bit.ly/2wltpK7

To get the script to work, there will need to be some environment variables set and a DLL available, these are detailed below.

Update the environment details:

image

Add the SharePoint Online / PWA URL, username and password for an account that is a site collection admin on the target site collection.

To get the script to work you will need to reference the DLL as seen in the image below:

image

This can be installed from the SharePoint Online Client components / management shell. I used the dll from the SharePoint Online Management Shell in this example.

Below you can see the output from the PowerShell ISE when running against my test SharePoint / Project Online site collection:

SNAGHTML9ae65556

There are probably easier ways to view this information but I thought I would just try with a simple PowerShell script.

Categories: Paul Mather, Work Tags:

#ProjectOnline #PowerBI content pack 2 available #BI #Office365 #PPM

September 26, 2017 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

2 years ago Microsoft released the first Project Online Power BI Content Pack, this week they have released another updated Project Online content pack! This is available now. For details on how to get the content pack see my original post below:

http://bit.ly/211vwx4

The steps are the same to get the new Project Online Content pack. This is version 2.3 as seen below:

image

Once the data is imported access the Report and Dashboard from the Power BI App > My Workspace navigation. I have set this up against our sales demo instance for Project Online. There are default reports for:

Portfolio Dashboard:image

Portfolio Timeline:image

Portfolio Costs:image

Portfolio Milestones:image

Portfolio Risks:image

Portfolio Issues:image

Resource Availability:image

Resource Overview:image

Resource Assignments:image

Resource Details – you will need to select a resource from the Resource Name filter:image

Resource Demand Forecast:image

Project Status – you will need to select a project from the Project filter:image

Project Risks & Issues – you will need to select a resource from the Project filter:image

Report Dashboard:image

Together with this content pack and the example report pack I built earlier this year, there are plenty of examples of reports to make Project Online reporting a simple task! A link to my report pack can be seen below:

http://bit.ly/2ivjxct

Categories: Paul Mather, Work Tags:

#ProjectServer and #SharePoint 2013 / 2016 September 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

September 13, 2017 Leave a comment
Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

The Office 2016 September 2017 updates and cumulative updates are now available, please see the links below:

http://bit.ly/2w9R0kI

Project 2016 September 2017 update:
http://bit.ly/2x0P637

SharePoint Server 2016 / Project Server 2016 September 2017 update: 
http://bit.ly/2w97nxV & http://bit.ly/2x1bYPU

The Office 2013 September 2017 updates and cumulative updates are now available, please see the links below:

http://bit.ly/2w9R0kI

Project Server 2013 September 2017 CU Server Roll up package:
http://bit.ly/2w9R1VO

Project Server 2013 September 2017 update:
http://bit.ly/2x0fkmp

Project 2013 September 2017 update:
http://bit.ly/2w9R2Jm

Also worth noting, if you haven’t done so already, install Service Pack 1 http://bit.ly/1uorn2C first if installing the September 2017 CU for 2013.

As always, fully test these updates on a replica test environment before deploying to production.

Categories: Paul Mather, Work Tags:
%d bloggers like this: