The ramblings of a computer geek
It is possible to create a lookup from one workbook to another. Let’s say you have a list on one workbook and you want this to appear as a list on a second workbook, here’s how you can do it. Get the List from the Source Workbook Firstly get the ID section of the URL … Read more
So, finally BT Openreach had got round to installing fibre optic cabling to the local area to provide fibre optic based Internet. If you’re interested to know if you can get (or if not register your interest) by using the https://www.openreach.com/fibre-broadband site. You might ask, what do you mean fibre Internet? I already have fibre … Read more
Nissan don’t make it that obvious but the Nissan LEAF 2022 should use the “Nissan Connect” app and not the “Nissan Connect EV” app. It turns out that the “Nissan Connect EV” app only works with pre-2019 Nissan LEAF and Nissan NV200 Vans, if you have a later version of these vehicles you’ll need to … Read more
In this scenario I had a pair of Palo Alto Firewalls that were providing firewall services as a perimeter pair of firewalls acting in an active/passive cluster. Due to our internal network configuration, use of OSPF etc. the interfaces (ports) on the passive firewall were set to be down/disabled when that firewall was not active. … Read more
I’m currently in the process of moving from FTTC broadband to FTTP broadband, as part of this there is no copper telephone line because its fully fibre optic based. At the time of writing my ISP (plus.net) did not offer their own VOIP telephone service you could port your telephone number to, meaning in the … Read more
The Microsoft Exchange 2016 ESE database engine manages the database engine and database files that make up the Mailbox Databases on the Microsoft Exchange server; it reads and writes data to and from the database and manages the database files through background management tasks. The Exchange databases are based on the JET database engine and … Read more
To find gMSA (Group Managed Service) Accounts i.e. group managed accounts and if your ADUC doesn’t have this as an option you can use a “Custom Search” and click “Advanced”, then use the following string in the “Enter LDAP query:” https://www.mssqltips.com/sqlservertip/5340/using-group-managed-service-accounts-with-sql-server/
Just a quick one, let’s say you need to tunnel some traffic over an SSH tunnel, its pretty simple to setup, in this example I’m wanting a local port 3128 on my local machine to be tunnelled over the SSH session to a remote server via another server (i.e. an SSH gateway). Okay, let’s break … Read more
Kerberos is an authentication technology, if you’ve used Microsoft Windows and Active Directory (AD) you will have heard of Kerberos as its the authentication method used to secure an AD Domain and any hosts and devices that are joined to it. I’d like to provide a fairly high-level run through of how Kerberos works, so … Read more
The HPE Nimble Storage array can be managed via a Web Interface, SSH Console or API, you can Active Directory (or LDAP in later NimbleOS version) integrate the array for management access. At the time of writing MFA or 2FA is not natively supported, however I believe it is on their roadmap to add SAML … Read more