Month: January 2019

Did you know … you can use Microsoft Teams outside of work too?

There are a lot of tools we use at work that are silly overkill in your personal life – I don’t want to open a Remedy ticket for every squeaky hinge! But some of our tools are quite helpful away from work too – making flyers in Word or using Excel to keep track of the softball league standings. “Is Teams useful in my personal life” seems like a purely hypothetical question – it’s not like I can invite the rest of the Parent Teacher Organization to join us here in Teams (and even if I could, that’s hardly an appropriate use of company resources!). But did you know Microsoft offers a free version of Teams?

Signing up for a free account, you don’t get access to all of the Teams features we’ve got here – you cannot schedule meetings, record meetings, there isn’t a Planner board, you don’t have access to the full suite of Office 365 applications. But you do have a Teams space, can use the integrated apps and connectors, have some file storage space, have persistent chats in channels, and can even have group audio/video calls.

To sign up for a free Teams account, visit https://products.office.com/en-us/microsoft-teams/free

Don’t use your company e-mail address to sign up – this will need to be your personal address.

If you don’t already have a Microsoft account associated with the e-mail address, you’ll be asked to create a new Microsoft account.

Otherwise you’ll be asked to sign in to your Microsoft account.

Supply your name, organization name, and country of origin. Read the terms of use and privacy statement. Assuming your use complies with the terms of use and the privacy policy is acceptable, click “Next”

It will take a few minutes for everything to be set up. Once your personal Teams organization is built, you can invite others to join. Click on your avatar in the upper right-hand corner of the screen and select “Manage org”

Click “Invite others to your org”

And enter their e-mail addresses

They will get an e-mail message inviting them to join your Teams org.

You’re ready to start using Teams – add tabs to websites your group commonly uses, set up connectors, create new channels, chat, video calls, share files. You can even add new Teams to your organization.

Everyone added to your org is automatically able to access the default Teams space (the one with the name of your org). Teams spaces you create can be private or public, just like at work – but you can also select “Org-wide” which automatically joins any newly-added individuals to the Teams space.

Did you know … you can search chats, files, and people in Microsoft Teams?

One drawback to retaining all of your chat and team discussion content is that there’s a LOT of content … which makes it challenging to find a specific discussion or comment. Luckily, Teams data is easily searched. At the top of your Teams application (or website), there is a long gray bar. Click in it and type a word or phrase to begin searching. Using multiple words will find conversations containing both words, to find a phrase place the phrase “in quotes”. Hit enter.

You’ll see messages that contain the words or phrase – notice this includes both chat messages and channel discussions. Each search result has a reference letting you know where the discussion is located, and you can click on the item to switch to the chat or channel discussion.

If your search returns too many results, click on the little funnel – you can refine your search results with a filter – a specific individual, a time frame.

In addition to searching chat messages, you can search files. Just click on “Files” and you’ll see files with names or content that contain your search terms. Again, you can see where the file is located, and you can click on the file to preview the file.

Click on “People” and you’ll find, well, people who work here. This is a name search – you cannot search for “stats” and see people with whom you’ve had discussions about statistics. Search for a last name, a first name, or a name in “last, first” format.

If you click on a person, you’ll see the conversations you have had with them, as well as any shared files, an org chart for their position in the company, and their channel posts for the past two weeks (‘Activity’).

If you haven’t chatted with them before, you can start a new conversation too.

Ugh! MFA

I am trying to use Microsoft Graph to read/write an Excel spreadsheet stored in SharePoint. It’s an ugly process to start with — they don’t exactly make it easy to find the right ID numbers so you can reference the spreadsheet in the first place, but I finally got the proper URL. And then I tried to do the password-based token authentication.

{“error”:”invalid_grant”,”error_description”:”AADSTS70002: Error validating credentials. AADSTS50126: Invalid username or password\r\nTrace ID: b43d1973-c253-4889-8756-354e5bd77200\r\nCorrelation ID: 9cf94602-9d72-4790-8dcc-6cf0471058f9\r\nTimestamp: 2019-01-08 00:01:47Z”,”error_codes”:[70002,50126],”timestamp”:”2019-01-08 00:01:47Z”,”trace_id”:”b43d1973-c253-4889-8756-354e5bd77200″,”correlation_id”:”9cf94602-9d72-4790-8dcc-6cf0471058f9″}

Hint: the password isn’t wrong. I’ve seen a lot of comments online about this meaning the secret is wrong — which seemed reasonable, since I’m not seeing any auth traffic against the user account. But if you put in a known bad secret, there is a different invalid secret error.

{“error”:”invalid_client”,”error_description”:”AADSTS70002: Error validating credentials. AADSTS50012: Invalid client secret is provided.\r\nTrace ID: 59f4c7c8-73ab-4adb-bf15-10250a190d00\r\nCorrelation ID: 0a95810c-19e2-4fc6-a7be-c0ca7235d824\r\nTimestamp: 2019-01-08 00:00:37Z”,”error_codes”:[70002,50012],”timestamp”:”2019-01-08 00:00:37Z”,”trace_id”:”59f4c7c8-73ab-4adb-bf15-10250a190d00″,”correlation_id”:”0a95810c-19e2-4fc6-a7be-c0ca7235d824″}

But we use MFA … and I’ve got no way to perform the MFA validation. Sigh!

Did you know … Microsoft Word can generate random text for you?

As I’ve been writing these “Did you know” blog posts, I’ve needed sample data to demonstrate how a function works. In Excel, that’s easy enough as there are RAND() and RANDBETWEEN(iLow,iHigh) functions. But how do you get sample text in Word? I used to just paste in part of a public domain work (as a cultural aside – the twenty years of copyright protection added under the Sonny Bono Copyright Term Extension Act are up this year, so the list of public domain works is expanding again). But what if you don’t have the original Anglo-Saxon Beowulf laying around?

Microsoft Word has a rand() function too – type =rand(#Paragraphs,#Sentences)

The example here generates two paragraphs that are five sentences each.

Hit enter – the formula is replaced with random text.

(This works in PowerPoint too). If you want some different text, try the lorem(#) function — the number in the parenthesis is the number of paragraphs — that uses the lorem ipsum paragraph as the content source.

Preventing Unauthenticated Binds in Active Directory

There is finally a Windows server-side solution to prevent “unauthenticated bind” requests (detailed in LDAP RFC 4513 section 5.1.2 with a note regarding the subsequent security considerations in section 6.3.1) from allowing unauthorized users to successfully authenticate.

It has always been possible to handle in code (i.e. verify that username and password are both non-null prior to communicating with the directory server) and is my personal preference as a developer cannot predict how individual directory services will be configured.

But for the third-party apps that don’t prevent unauthenticated binds, a setting to disallow unauthenticated bind operations to Active Directory was added in Windows 2019 — in your Configuration partition, open the properties of CN=Directory Service, CN=Windows NT, CN=Services, CN=Configuration — find the msDS-Other-Settings attribute, and add a new entry DenyUnauthenticatedBind=1

Bigger Book Bag – Fabric Selection

Anya’s little owl bag is, well, small now that she’s in school school. They’ve got a folder that doesn’t quite fit, there’s no room for her lunch, and she’s a lot bigger than she was two and a half years ago. I’m making a bigger bag for her — using essentially the same pattern, but increasing the size a bit horizontally and a lot vertically.

The first decision — what do we want it to look like? She decided on a cat — a cat pocket, maybe cat charm on the zipper, and paw print fabric. I found a cute cat fabric for the lining, but I couldn’t find any paw print fabric that I liked. So I made my own on SpoonFlower. I had my design printed on their eco canvas — it is a stout fabric and black ink showed up well.

 

Did you know … you can name ranges in Excel to make formulae clearer?

Formulae in Excel aren’t always easy to decode – even a relatively simple formula, like the volume of a right rectangular pyramid below, can be a little cryptic with the A2 type cell identifiers.

You can name ranges and use range names to make a formula easier to understand. Highlight a data set – in this case, I am highlighting the “length” values – column A. On the “Formulas” ribbon bar, click on “Define Name” (you don’t need to hit the inverted caret on the right of the button – just click the ‘define name’ text).

Supply a name for the range – in this case, I am calling it “Base_Length” (range names need to start with a letter or underscore and cannot contain spaces). Click OK to save the range name. Repeat this operation with all of the other data groups – in my case, I named Column B “Base_Width” and Column C “Height”.

Use the name instead of the cell identifier – as you type your formula, the range names matching your typed text will appear.

It is now a lot clearer what this formula means – base length times base width time height all divided by three. Which is the formula to calculate the volume of a right rectangular pyramid.

The calculated answer is the same either way – but this makes it easier to figure out what exactly you were computing when you open the spreadsheet again in six months 😊 (Or share the spreadsheet with others).

Anya’s 6th Birthday Cake

This year, I made a really cool apple cake for Anya’s birthday. It’s about 80% apple — very thinly sliced.

It’s called Gateau Invisible

Ingredients

  • 1 pound Fuji apples
  • 2 eggs
  • 1/2 cup sugar
  • 1/2 cup milk
  • 1 tablespoons melted butter
  • 3/4 cup flour

Method:

  1. Preheat oven to 350 F
  2. Peel and core apples. Slice into very thin slices. Soak in lemon water.
  3. Wisk eggs until they are frothy and add sugar.
  4. Add milk and melted butter.
  5. Sift the flour into liquid mixture.
  6. Add sliced apples and stir gently to coat apple slices in batter.
  7. Pour the batter into a parchment lined bread loaf pan.
  8. Bake for 40 minutes, cover with foil, then bake for another 10 minutes.
  9. Remove from pan and allow to cool
  10. Pour caramel sauce over cake and serve.

Caramel Sauce

Ingredients:

  • 1/2 cup sugar
  • 1 tbsp butter
  • 1/2 cup heavy cream

Method:

  1. Melt butter in a small pan.
  2. Add sugar and heat until sugar turns a medium brown.
  3. Add heavy cream and wisk to combine.

Did you know … you can tell who is speaking during a Teams meeting?

There are times when it is easy to tell who is speaking – there aren’t a lot of women in my group, so “the female voice” is usually me. My friend Richard is generally the only person with a New Zealand accent on any call (although someone who didn’t grow up in a Commonwealth country may have trouble distinguishing him from the guy from Australia). And after you work with someone for a while, you learn the voice and lexical nuances of colleagues. The rest of the time? I end up pausing the conversation to check who it was that volunteered to serve as my tester and clarify who is going to be getting back to me next week. In a Teams meeting, though, you can quickly tell who is speaking – and respond with a much friendlier “thanks, Jim, for offering to help”.

When you join a Teams meeting, you’ll see up to four large tiles with meeting participants. If there are more than five participants (you don’t show up on your own view!), the remaining people will be represented by smaller images in the lower right-hand corner of the screen.

When someone is speaking, their tile will be highlighted in a purply-blue and a brighter highlight circumscribes their image.

The four large tiles represent the most recent speakers, so you will notice who is in these four tiles change throughout the call. And, yeah, it’s possible for more than one person to be talking at a time – you’ll have multiple highlighted tiles.

There is another place to view who is speaking. On the right-hand column, click to enter the participant pane.

The current speaker will be bolded.

Bonus Features: Sometimes I’ll start a large call and have trouble getting everyone’s attention to start the call. In the participant pane, you can click “Mute all” to mute all participants. N.B. Any participant can do this – so don’t test it in the middle of a real discussion!

And just like meetings through the PSTN system or other web-meeting platforms, you’ll get the occasional person typing without hitting mute. Or speaking to someone who popped into their office. Or experiencing feedback on the connection. In Teams, it’s easier to identify who is causing a disruption – they are going to be highlighted as speaking.

Once you’ve identified the source of the noise, click the not-quite-a-hamburger-button next to their name and select “Mute participant”.