How to use basic electrical template features is visio 2016?

I’m working on an old file created in previous version of Visio. I’d like to open it and/or copy so I can use the basic electrical features of Visio, for example making a 3-way connection. Does anyone know how I can do this? As far as I can tell they are the same filename (*.vsdx) but I cannot get a 3-way connection to work in the old diagram.

Sharepoint 2016 Custom List create “Direct Dial” column hyperlink

I was wondering if anyone has step by step instructions with regards how to do the below. I have found a few things online but nothing worked yet.

SharePoint 2016 – An employee directory – custom list – I want to make phone numbers clickable on so that users can browse on their mobiles for a persons number and direct dial them by clicking on number on phone.

2016 – Add Host to Service Bus Farm’ Failed & Service Bus Message Broker Service stuck on Starting mode

when I install & Configure WF Farm in one of SP 2016 APP Server I am facing issue, I created new Farm and WF Manager Configuration wizard fails at ‘Add Host to Service Bus Farm’
I enabled TlS 1.0,1.1,1.2 already before starting the wizard.
and Service Bus Message Broker Service in Starting state.

enter image description here

In Event Viewer below errors:

Faulting application name: Microsoft.ServiceBus.MessageBroker.exe, version: 2.0.50926.9, time stamp: 0x5a0a1de1
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0x80131623
Fault offset: 0x00007ff955393102
Faulting process id: 0x2074
Faulting application start time: 0x01d7815c0d76f752
Faulting application path: C:Program FilesService Bus1.1Microsoft.ServiceBus.MessageBroker.exe
Faulting module path: unknown
Report Id: 16a5f355-4152-4727-8e9a-29f4498210e6
Faulting package full name:
Faulting package-relative application ID:

Application: Microsoft.ServiceBus.MessageBroker.exe
Framework Version: v4.0.30319
Description: The application requested process termination through System.Environment.FailFast(string message).
Message: Failed to start Service Bus Broker Service.
Stack:
at System.Environment.FailFast(System.String, System.Exception)
at Microsoft.ServiceBus.MessageBroker.Backend.OnStart(System.String())
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()

SharePoint 2016 There is no file with URL ‘_catalogs/wp/DocumentSetProperties.dwp’ in this Web

I have a new installation of SharePoint server 2016, I have setup a new web application and now trying to create a new site collection and I am getting the error :

There is no file with URL ‘_catalogs/wp/DocumentSetProperties.dwp’ in
this Web.

I redid the web application a few times without any success.
thanks for any help

Edit: With poweershell I get the error

New-SPSite -Url $Site -OwnerAlias $Owner -Template STS#2

New-SPSite : There is no file with URL
‘_catalogs/masterpage/v4.master’ in this Web

Here is the full powershell script:

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
$siteURL = "http://somewebapp.com/sites/test2"
$sitePrimaryOwner = "domainsecretusername"
$siteSecondaryOwner = "domainsecretusername"
$siteName = "Test Site"
$siteTemplate = "STS#0"
$siteDescription = "This is a test site"

New-SPSite -Url $siteURL -OwnerAlias $sitePrimaryOwner -SecondaryOwnerAlias 
$siteSecondaryOwner -Name $siteName -Template $siteTemplate -Description 
$siteDescription

Exchange 2010 to 2016 (Multi Site)

My scenario:

Datacenter #1 – AD Site “A”

-4 ISP internet connections. (Outbound independently)
-2 DCs GC (FSMO) Internal DNS

-2 DNS Servers – External DNS hosted into a DMZ (SPF / MX / PTR records pointing to Site A
(mailflow))

-1 Exchange 2010 SP3 UR30 with EDGE subscriptions.

-2 Exchange EDGE Servers in DMZ.

-500 users

DNS Namespace: Outbounded model

Mail services (DNS): webmail.company.com / autodiscover.company.com
MX´s: 2 mail.company.com | 2 mail2.company.com (2 on 1 ISP and 2 on another ISP for redundancy)

Datacenter #2 – AD Site “B”

-2 ISP Internet connections (Outbound independently)

-2 DCs GC

-1 Exchange 2016 (Not yet installed)

-100 users

Connections: 1 VPN and 1 MPLS connecting Site A to Site B.

I need to install firts Exchange 2016 as part of an Exchange Upgrade, and i need to install it directly on Site B (Not the main Site A) because it has more hardware resources and more employee´s. Can i do it ?

Questions :

1 – Can I install Exchange 2016 directly in Site B without migrate any user mailbox and while Exchange 2010 SP3 still reside in a main site A, without changing, affecting or disrupting mail flow or needed to pointing the DNS records to Site B ? (ignoring the fact of the previous and immediate Schema/Ad/Domain updates from remote share in FSMO DC, and configuration of the SCP, the services and the SSL certificate)

2 – What´s happens to the actual mail flow, regarding on that exchange 2010 cannot do proxy up to exchange 2016 ?

I need to change all my internal and external DNS records (SPF / MX / ISP´s PTR records) to point to the second datacenter in Site B (Exchange 2016) for don’t break mail flow, even though no mailboxes have yet been migrated ?

3 – If I’m wrong, I need to firstly install Exchange 2016 directly in Site A where Exchange 2010 reside and change the firewall port rule to point to Exchange 2016 ?

4 – What about the 2 EDGE servers that already have a subscription to Exchange 2010 in Site A, if newly Exchange 2016 is in onther AD site (Another Datacenter??)

Can i remove the existing EDGE subscription to Exchange 2010 in Site A and recreae de EDGE 2010 subscrition to Exchange 2016 in remote Site B ?

Sorry If I’m wrong with all my questions, can u help me anyway for free with an orientation ?
Any additional comments about my inquiries or the steps necessary to not cause any interruption are welcome.
Thanks.

audit – How can I use macros for revision tracking in Access 2016?

When a field is updated, I want a macro to add information about that change to an audit table. All I need is what changed (table, record, field), the old and new values, and the date/time of the change.

I’ve tried updating via form vs table, changing data types, creating named macros rather than using After Update, and a bunch of other tweaks, and I’ve referenced various official and unofficial documentation/forums/tutorials (including ScottGem’s “Audit Trail using Data Macros”, Access programming articles at the Microsoft support site, and several entries at databasedev.co.uk).

I’m troubleshooting this issue by using simplified data in a new, blank database to avoid leftovers from previous attempts:
tblAudit has one manually-entered record with fields for ChangeID (AutoNumber PK) and TableChanged, RecordChanged, FieldChanged, OldValue, NewValue (all Short Text), and ChangeDate (Date/Time).
tblVendors has two records of sample data over three fields (VendorID as AutoNumber PK, plus VendorName and Phone as Short Text). I added an After Update macro through the Table tab’s After Events section (below). This time around, I haven’t changed anything else.

When I change the first record’s VendorName field, I expect the macro to create a corresponding record in tblAudit, but I don’t see any changes. What am I missing?

Code formatted for legibility:

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
    <DataMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application">
        <DataMacro Event="AfterUpdate">
            <Statements>
                <ConditionalBlock>
                    <If>                    
                        <Condition>
                            Updated("VendorName")
                        </Condition>                        
                        <Statements>                        
                            <CreateRecord>                          
                                <Data>                              
                                    <Reference>
                                        tblRevisionLog
                                    </Reference>                                    
                                </Data>                             
                                <Statements>                                
                                    <Action Name="SetField">                                    
                                        <Argument Name="Field">
                                            tblRevisionLog.TableChanged
                                        </Argument>
                                        <Argument Name="Value">
                                            "tblVendors"
                                        </Argument>                                     
                                    </Action>                                   
                                    <Action Name="SetField">
                                        <Argument Name="Field">
                                            tblRevisionLog.RecordID
                                        </Argument>
                                        <Argument Name="Value">
                                            (tblVendors).(VendorID)
                                        </Argument>
                                    </Action>
                                    <Action Name="SetField">
                                        <Argument Name="Field">
                                            tblRevisionLog.FieldChanged
                                        </Argument>
                                        <Argument Name="Value">
                                            "VendorName"
                                        </Argument>
                                    </Action>
                                    <Action Name="SetField">
                                        <Argument Name="Field">
                                            tblRevisionLog.OldValue
                                        </Argument>
                                        <Argument Name="Value">
                                            (Old).(VendorName)
                                        </Argument>
                                    </Action>
                                    <Action Name="SetField">
                                        <Argument Name="Field">
                                            tblRevisionLog.NewValue
                                        </Argument>
                                        <Argument Name="Value">
                                            (tblVendors).(VendorName)
                                        </Argument>
                                    </Action>
                                    <Action Name="SetField">
                                        <Argument Name="Field">
                                            tblRevisionLog.ChangeDate
                                        </Argument>
                                        <Argument Name="Value">
                                            Now()
                                        </Argument>
                                    </Action>
                                </Statements>
                            </CreateRecord>
                        </Statements>
                    </If>
                </ConditionalBlock>
            </Statements>
        </DataMacro>
    </DataMacros>

SFTP on windows server 2016 with share folders unable to get the information stored on the share folder

OS:-Windows 2016
Install:- OpenSSH-Win32

Installed SFTP using this.

I have installed SFTP using different share folders which has to be mounted on this SFTP server.
using Active Directory integrated.

now i am unable to authenticating with AD.

sql server 2016 – Automatically expiring records in a temporal table?

I have a need to store some results that are only valid for a rolling 5 day window. An application will insert or update records and the results should be viewable for the 5 day window. However, there potentially is a need to look at how the results were for prior periods. A temporal table sounded great for this as historical I can just use the SYSTEM_TIME between clause to look up historical records, and to look at the current 5 day window, I would just leave off the clause.
However, there is a problem let say that some record I, was valid last week, but is no longer in the current dataset. Without me adding a step to delete old results I will still be in the resulting set as it’s row end column will always have 9999-12-31, until it is updated or deleted.
How can I set it to dateadd(d,5,sysutcdatetime())? Setting a default does not seem to work, and I cannot explicitly insert a value either.

Cannot insert an explicit value into a GENERATED ALWAYS column in table ‘my.table’.
Use INSERT with a column list to exclude the GENERATED ALWAYS column,
or insert a DEFAULT into GENERATED ALWAYS column.

Note that the hint lies. The default seems to not be used.

Here is a fiddle presenting the problem.

Search list (Find an item) SP 2016

Tell me if there is any rule in the Search that can be used when finding all elements that match the value expression, i.e. if you wrote the word "Test", then the list item "Test1", "Test2" would also be shown?

enter image description here

Only "Test", not "Test1" and "Test2"

enter image description here

failovercluster – Windows 2016 cluster validation test fails – Why isn’t my server listening on UDP Port 3343

Getting a failure message similar to this

Network interfaces s-test-01.assemblyni.gov.uk - LOM1Port1_Mgmt and s-test-02.assemblyni.gov.uk - LOM1Port 1_Mgmt are on the same cluster network, yet address 10.63.35.30 is not reachable from 10.63.35.31 using UDP on port 3343.

A “netstat -a -p udp” shows that both servers are not listening on Port 3343

Since the servers themselves are not listening on this UDP port, then it can’t be a firewall or network problem, correct?

Thanks for help