Web analytics SP2013 vs SP2010

Reminder Web site analytics of SP2010 is accessible via Central Administration, but in SP2013 it is on each site administration level

https://blogs.msdn.microsoft.com/chandru/2013/08/31/sharepoint-2013-web-analytics-report-where-is-it/

SQL alias for SharePoint Database

Few words about creating SQL Alias for SharePoint - imagine you want to move SharePoint DB to another server, if you hardcode it as FQDN you will need to manage it on DNS level and point to another server. But you can also use SQL aliases and define them locally to point to SQL server by alias thather than FQDN:



https://sqlandme.com/2011/05/05/create-sql-server-alias-cliconfg-exe/

Check Skype for Business or Lync or OCS presence in SQL

User strored procedure

dbo.DiagShowPublisherPresence
in RTCLOCAL SQL copy on each FrontEnd (not SBA)

http://mikestacy.typepad.com/mike-stacys-blog/sql/

Skype for Business Hybrid one way

We have a problem of one way presence in hybrid deployment. From one Prems, we can not see online users in the same domain. Here is subscribe ok we get on onprem side:


TL_INFO(TF_PROTOCOL) [EDGE01\EDGE01]0E00.1480::05/25/2018-19:37:29.817.0000BB79 (SIPStack,SIPAdminLog::ProtocolRecord::Flush:ProtocolRecord.cpp(261)) [2044151173] Trace-Correlation-Id: 2044151173
Instance-Id: F3
Direction: incoming;source="external edge";destination="internal edge"
Peer: sipfed.online.lync.com:5061
Message-Type: response
Start-Line: SIP/2.0 200 OK
From: "Test Skype1";tag=b8040a09ec;epid=ff13667dd7
To: ;tag=5C4D0080
Call-ID: f7f33e99902d45488e4b2c76924d00a5
CSeq: 1 SUBSCRIBE
Contact:
Via: SIP/2.0/TLS 10.100.1.41:49186;branch=z9hG4bK9FE0F169.F3E35464A2AA98C9;branched=FALSE;ms-internal-info="aaDSMbd_7l0a4U9R6npyIrDBxYlV2GUNocfizAJ2ScR15kVOPzyc4VHQAA";received=52.112.132.124;ms-received-port=49186;ms-received-cid=B6C95E00
Via: SIP/2.0/TLS 10.20.1.36:61901;branch=z9hG4bKB46E0708.870D177F11B578C8;branched=FALSE;ms-received-port=61901;ms-received-cid=300
Via: SIP/2.0/TLS 10.20.1.9:49176;branch=z9hG4bK7D7D836D.E605002CA2AA98C9;branched=FALSE;ms-received-port=49176;ms-received-cid=4DBD00
Via: SIP/2.0/TLS 192.168.168.244:55348;received=84.75.200.148;ms-received-port=55348;ms-received-cid=1400
Record-Route:
Record-Route: ;tag=6B374769C547A54AF3927B7A63EC325B
Content-Length: 470
Content-Type: multipart/related; type="application/rlmi+xml";start=resourceList; boundary=1550b37c575843dbb98e18be4e840f3d
ms-split-domain-info: ms-traffic-type=SplitIntra
ms-telemetry-id: D31CB29B-EEE7-56FB-A1C5-7F04353D74C3
Expires: 0
Require: eventlist
Event: presence
subscription-state: terminated;expires=0
ms-piggyback-cseq: 1
Supported: ms-piggyback-first-notify
Message-Body:
--1550b37c575843dbb98e18be4e840f3dContent-Transfer-Encoding: binaryContent-ID: resourceListContent-Type: application/rlmi+xml--1550b37c575843dbb98e18be4e840f3d--

Solution, refresh directory schema in AADconnect.

How to check user attributes in Azure AD

Open https://graphexplorer.azurewebsites.net/#

login with a user who has access to Azure AD

then type url:

https://graph.windows.net/myorganization/users/tskype1@domain.com

Windows 7 WebDAV client requires SHA protocol

If you have a Sharepoint site that provides Open with explorer functionality make sure you do not disable SHA (hash) protocol on your server.  Otherwise some clients with Windows 7 will not be able to open shares in Explorer.

Microsoft 365 Attack simulator

https://blogs.technet.microsoft.com/cloudready/2018/04/30/phishing-examples-for-the-microsoft-office-365-attack-simulator-part-one/