DNS

Public DNS Server

Secure DNS

DNSSEC No Logs
DOwn Resolver Mexico 01 - 201.131.126.212

Open DNS

208.67.222.222
208.67.220.220

Google

8.8.8.8
8.8.4.4

Security

Hack Fix – WIndows 8.1 10 2012 2012/R2 2016
https://www.bishopfox.com/blog/2017/10/a-bug-has-no-name-multiple-heap-buffer-overflows-in-the-windows-dns-client/

DNSCrypt - command line - Encrypts all DNS traffic between the user and OpenDNS, preventing any spying, spoofing or man-in-the-middle attacks
https://www.opendns.com/about/innovations/dnscrypt/

Simple DnsCrypt –GUI - Configure DNScrypt-proxy on Windows-based systems so that you can encrypt and secure your DNS traffic
https://github.com/bitbeans/SimpleDnsCrypt

Simple Approval Workflow Using 3 State Workflow

Student asked if you can use a 3 state workflow on a library and the answer is yes.  Create a simple choice column with three options and the wizard will do the rest.

Library Settings

More info

Here is where I would have you start ... http://thecloudengineer.blogspot.com/2011/06/sharepoint-workflows.html

GitHub Library

This is a roadmap of commonly requested GitHub repositories

General

Technical Community Content
https://github.com/Microsoft/TechnicalCommunityContent

Latest on GitHub
https://github.com/OfficeDev/PnP-Tools/pull/40

Topics and Products

Azure

Azure PowerShell
https://github.com/Azure/azure-powershell

Desired State Configuration

DSC
https://github.com/PowerShellOrg/DSC

DSC SharePoint
https://github.com/PowerShell/xSharePoint
https://github.com/PowerShell/SharePointDsc

MCT

https://github.com/MicrosoftLearning/
 

Office 365

Patterns and Practices
https://dev.office.com/patterns-and-practices

PowerShell Sessions

 

PowerShell Summit 2017

PowerShell GUI

https://github.com/PowerShell/Phosphor

Building a PowerShell Module
http://ramblingcookiemonster.github.io/Building-A-PowerShell-Module/

Lightning Talks
https://github.com/RamblingCookieMonster/CommunityLightningDemos2017

more from powershell 101
http://powershell101.blogspot.com/2017/04/powershell-summit.html

Security

p0wnedShell - PowerShell Runspace Post Exploitation Toolkit

https://github.com/Cn33liz/p0wnedShell

SharePoint

Microsoft SharePoint
https://github.com/SharePoint

Patterns and Practices
https://github.com/SharePoint/PnP-Tools/

Unoffical Scripts to Install 2016 (Dan is trustworthy source)
https://github.com/DanHolme/SP2016-Install

Windows

Make Your WIndows Do Awesome Stuff
https://github.com/hashhar/Windows-Hacks

SharePoint List Colors – Office 365 SharePoint 2013/2016

Color Status Indicator

Verified 2016

 http://christine-payton.com/color-coding-a-sharepoint-list/

Grade Example

Create Numerical Column named Score

Create Calculated Column named Grade

=IF([Score]>89,"A",IF([Score]>79,"B", IF([Score]>69,"C",IF([Score]>59,"D","F"))))

Create Calculated Column named Color … hidden in final view

=IF([Score]>89,"Green",IF([Score]>79,"Green", IF([Score]>69,"Yellow",IF([Score]>59,"Red","Red"))))

Create Calculated Column named Status … note must be numeric

=CONCATENATE("<div style=",CHAR(34),"height:20px;width:20px;border-radius:3px;background-color:",[Color],CHAR(34),">&nbsp;</div>")

UPDATE: border-radius:100% changes it to circle

More

My 'Title' field returns the following results:

ie: Gold.png

I want to remove '.png' and just leave the word 'Gold'

=REPLACE([Title],SEARCH(".png",[Title]),"4","")

References

https://blog.splibrarian.com/2012/06/06/using-calculated-columns-to-add-color-coding-to-your-sharepoint-lists/

https://support.office.com/en-us/article/IF-function-7025be14-5665-43d0-af20-8293d1fe9d3a

https://www.w3schools.com/tags/ref_colornames.asp

Calender

https://www.premierpointsolutions.com/training/help-and-how-to-articles/color-code-events-on-a-sharepoint-calendar/

https://www.degdigital.com/insights/four-easy-steps-to-customized-color-code-calendars-in-sharepoint/

http://eimagine.com/sharepoint-color-coding-your-calendar-by-category-tutorial/

Calendar - Office 365

https://stoneridgesoftware.com/creating-a-color-coded-calendar-in-sharepoint-online/

SharePoint Branding

2019

Branding guidance for SharePoint

Branding guidance for SharePoint Online portals
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/portal-branding

How to brand SharePoint and Office 365 Out of the Box
https://sharepointmaven.com/how-to-brand-sharepoint-and-office-365-out-of-the-box/

Branding for SharePoint sites in Office 365https://www.abelsolutions.com/branding-sharepoint-sites-office-365/

SharePoint Site Theming
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-theming/sharepoint-site-theming-overview

Theme Generator
https://developer.microsoft.com/en-us/fabric#/styles/themegenerator

Branding SharePoint: The New Normal (M365)
https://blogs.msdn.microsoft.com/bobgerman/2018/09/04/branding-sharepoint-the-new-normal/
https://bob1german.com/2018/09/04/branding-sharepoint-the-new-normal/

Office 365

Branding SharePoint: The New Normal

https://bob1german.com/2018/09/04/branding-sharepoint-the-new-normal/
Repost
https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Branding-SharePoint-The-New-Normal/ba-p/241855

2013 / 2016

Composed Looks

Deploy a custom theme in SharePoint
https://docs.microsoft.com/en-us/sharepoint/dev/general-development/how-to-deploy-a-custom-theme-in-sharepoint

SharePoint 2013: Creating a Composed Look
https://social.technet.microsoft.com/wiki/contents/articles/30903.sharepoint-2013-creating-a-composed-look.aspx

Use composed looks to brand SharePoint sites
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/use-composed-looks-to-brand-sharepoint-sites

Step by Step: Create a SharePoint 2013 Composed Look
https://bniaulin.wordpress.com/2012/12/16/step-by-step-create-a-sharepoint-2013-composed-look/

Create a SharePoint 2013 Theme using Color Palette Tool
https://en.share-gate.com/blog/create-sharepoint2013-theme-using-color-palette-tool

Branding Links Recommended by Students (Thx Jon)

http://sharepoint.stackexchange.com/questions/84412/modifying-top-navigation-through-css

https://kogzee.wordpress.com/2013/08/07/style-sharepoint-2013-top-navigation-global-navigation-menu/

http://www.sharepointdiary.com/2014/11/sharepoint-2013-top-navigation-bar-branding-css.html

http://www.macaalay.com/2014/01/28/how-to-remove-sharepoint-2013-quick-launch-andor-top-link-bar/

https://discoveringsharepoint.wordpress.com/2013/03/19/programmatically-set-navigation-settings-in-sharepoint-2013/

https://chrisstahl.wordpress.com/2014/03/31/customizing-sharepoint-2013-global-navigation-with-css-and-jquery-part-5/

https://social.msdn.microsoft.com/Forums/en-US/eed6e044-3c14-43cd-9885-2490a0121e79/move-top-navigation-bar-in-sharepoint-2013?forum=sharepointcustomization

http://stackoverflow.com/questions/25036569/sharepoint-2013-css-move-around-global-navigation-elements

https://wordpress.org/support/topic/move-top-nav-bar-down

http://en.share-gate.com/blog/create-sharepoint2013-theme-using-color-palette-tool

https://msdn.microsoft.com/en-us/library/office/jj927175.aspx

Themes

Team Sites to inherit master page and theme
http://www.sharepointeurope.com/blog/2013/7/22/sharepoint-branding-team-sites,-inherit-theme-and-master-page-on-office-365

Change the default theme of a site collection and future subsites.
http://sharepoint.stackexchange.com/questions/79750/is-there-a-way-to-change-the-default-theme-of-a-site-collection-and-fututre-subs

Composed Looks - Use composed looks to brand SharePoint sites
https://msdn.microsoft.com/en-us/library/office/dn985875.aspx
http://sharepoint-community.net/profiles/blogs/creating-and-applying-a-composed-look-in-sharepoint-2013
https://bniaulin.wordpress.com/2012/12/16/step-by-step-create-a-sharepoint-2013-composed-look/

All you need to know about site logo size in SharePoint 2013
http://blog.incworx.com/blog/sharepoint-administrators-blog/all-you-need-to-know-about-site-logo-size-in-sharepoint-2013

Branding

SharePoint Branding - Themes, Master Pages, and Page Layouts
Excerpt below from above …

Theme:
     - we want our logo
     - we want our colors
     - we want our fonts
     - we want background image
Master Page:
     - we want site logo to link to start page, not to subsites
     - we want another navigation
     - we want links on the top
     - we want footer on every page
     - we want a big banner on the top
     - we want breadcrumb
Page Layouts:
     - we want more content zones on the page
     - we want a content zone on the right for related links and content
Styling
    - we want 20px or 30px margins
    - we want larger headings (H1,H2,H3..)
    - we want border around content

Guide to quick SharePoint 2013 branding
http://blog.blksthl.com/2013/02/26/a-guide-to-quick-sharepoint-2013-branding/

Step by Step
http://www.sharepointempower.com/Blog/Post/3/SharePoint-2013-branding-step-by-step

Start Master Pages
http://startermasterpages.codeplex.com/

How do I apply master page changes to all subsites in SharePoint 2013?
http://sharepoint.stackexchange.com/questions/61979/how-do-i-apply-master-page-changes-to-all-subsites-in-sharepoint-2013

Hide Recent
http://sharepoint.stackexchange.com/questions/61347/how-to-hide-recent-in-the-navigation

Tips on Team Site
Recent Heading – current navigation (five most recent appear)
http://blogs.office.com/b/sharepoint/archive/2012/07/25/the-new-team-site.aspx

SharePoint 2013 Design Manager
http://sharepointfordeveloper.blogspot.com/2013/06/sharepoint-2013-design-manager.html
MSDN - Overview of Design Manager in SharePoint 2013
https://msdn.microsoft.com/en-us/library/office/jj822363.aspx

2010

Basics
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Hack-SharePoint-Master-Pages-Introduction.aspx

Navigation
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Brand-SharePoint-Global-Navigation-The-Journey-Begins.aspx

Mega Menu

http://www.nothingbutbranding.com/blog/2012/august/mega-menu-dropdown-sharepoint

Move Quick Launch – to the Right Side

http://www.nothingbutbranding.com/blog/2012/august/move-sharepoint-quicklaunch-to-the-right

Heather Solomon - great presentations on branding in 2007 and is now working on 2010
http://www.heathersolomon.com/blog/

SharePoint Deletion Log

SharePoint has a powerful report for file deletion in SharePoint 2016 / 2013.

Under Site Collection Administration > Site Collection Audit Settings
Turn on all events needed for audit, but remember this will significatly increase the size of your content database.

So consider turning on Audit Log Trimming which is end of the month by default
https://support.office.com/en-US/article/Configure-audit-settings-for-a-site-collection-F5A346D0-EE0F-4412-A5E6-D9B5ABAA1012



Next, lets create some activity using built-in document library.

Add and delete document.

Back to Site Collection Administration > Audit Log Reports > Deletion
 Save report (Suggestion: Create a new document library for audting)

Open Report using Excel or Excel Web App

Auditing in SharePoint

Articles

SharePoint 2016

Excel Import Permissions
http://www.sharepointdiary.com/2015/05/export-sharepoint-users-and-group-permissions-to-excel.html
Audit Specific Event ID Function
https://howtodowithsharepoint.wordpress.com/2016/11/26/sharepoint-20162013-event-log-monitoring-by-automation/

Configure audit settings for a site collection (2016)
https://support.office.com/en-us/article/Configure-audit-settings-for-a-site-collection-A9920C97-38C0-44F2-8BCB-4CF1E2AE22D2
More from The Cloud EngineerSharepoint Deletion Log
http://thecloudengineer.blogspot.com/2016/03/sharepoint-deletion-log.html

Office 365

Office 365 Audit Logging
https://www.petri.com/office-365-audit-logging-generates-data

SharePoint Legacy

SharePoint 2013

Enables auditing of how site collections, sites, lists, folders, and list items are accessed, changed, and used
https://msdn.microsoft.com/en-us/library/ms441917.aspx

SharePoint Server 2013 custom audit log report - PowerShell script
https://gallery.technet.microsoft.com/office/SharePoint-Server-2013-9657c24e
Using PowerShell Scripts to Implement SharePoint Audit Logging (part 1 and part 2)
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-1/
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-2/
View and configure usage analytics reports in SharePoint Server 2013
https://blogs.technet.microsoft.com/tothesharepoint/2014/01/23/view-and-configure-usage-analytics-reports-in-sharepoint-server-2013/
Auditing - A Built-in Feature of SharePoint 2010
https://www.codeproject.com/articles/431342/auditing-a-built-in-feature-of-sharepoint

More Tools

SharePoint Audit Logging

https://support.office.com/en-us/article/Configure-audit-settings-for-a-site-collection-A9920C97-38C0-44F2-8BCB-4CF1E2AE22D2

https://www.ultimatewindowssecurity.com/sharepoint/default.aspx

SharePoint Deletion Log Report

http://thecloudengineer.blogspot.com/2016/03/sharepoint-deletion-log.html

SharePoint Permissions Analyzer

TechNet - SharePoint PowerShell: Get list of all users present in a site under different SharePoint Groups
http://social.technet.microsoft.com/wiki/contents/articles/31301.sharepoint-powershell-get-list-of-all-users-present-in-a-site-under-different-sharepoint-groups.aspx
https://sppermissionanalyzer.codeplex.com/

Simple SharePoint Permissions Auditing – OOTB

The question is how do I view permissions and perform a site auditing using out of the box tools.  Using PowerShell script found from fellow Buckeye SPUG member Brian Jackett, I was able to create an excel report below.
https://briantjackett.com/2013/07/01/powershell-script-to-enumerate-sharepoint-2010-or-2013-permissions-and-active-directory-group-membership/
First I needed to add the policy at the web application level.
Second I ran the script and dumped out an xml file.
Finally results displayed by using Excel import from the XML file for a small lab setup.

Displaying XML in SharePoint

http://thecloudengineer.blogspot.com/2015/11/displaying-xml-in-sharepoint.html

Auditing - A Built-in Feature of SharePoint

http://www.codeproject.com/Articles/431342/Auditing-A-Built-in-Feature-of-SharePoint

SharePoint Foundation

http://auditlogsp.codeplex.com/
2010

• SharePoint 2010 Audit Configuration
• SharePoint 2010 View Audit Log Reports