tag:blogger.com,1999:blog-57215862024-02-21T06:11:51.613+00:00Mark Iwaszko's technical blogTech. reference and notes discovered whilst thrashing Microsoft SharePoint, SQL, BI, KM, Security and Windows ServersMark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.comBlogger249125tag:blogger.com,1999:blog-5721586.post-42784816895581386032020-05-20T10:49:00.003+00:002020-05-20T10:49:33.673+00:00MS Teams - Open Files in Desktop Apps
Its really annoying to have to open a file in Teams and the click again on Open in Desktop App
Below is a workaround that works very well.
When you are in teams right click the 3 dots next to General and click "open in sharepoint"
When in Sharepoint online click on the gear next to your picture or initials (in the top right of the screen)
Click on Library settings
Select Advanced Settings Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-11822471756134420752020-05-19T08:13:00.002+00:002020-05-19T08:13:29.250+00:00MS Teams chat and meetings now support popout windows https://office365itpros.com/2020/04/10/teams-pop-out-windows-chats-meetings/Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-26188223951128948712020-04-25T04:52:00.001+00:002020-04-25T04:52:48.265+00:00How To Automatically Run Excel VBA Macros Daily April 29, 2019 Chris Newman
It is a great shame that PowerApps can run excel macros yet....
Here is a work around
utilize the Windows Task Scheduler application (don’t worry, this comes installed with most Windows PCs) to automatically open an Excel file, run it’s VBA code, save the file, and finally close the Excel file. With this solution, you will be able to customize the frequency and exact time(s) this automation Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-25426434596186339662020-04-15T22:34:00.001+00:002020-04-27T15:45:45.254+00:00How to Customize Your Background in Microsoft Teams Video CallsLink https://lifehacker.com/how-to-customize-your-background-in-microsoft-teams-vid-1842838567Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-80792693638789114752020-04-11T23:23:00.001+00:002020-04-11T23:23:47.873+00:00Find a spoken word or phrase in Microsoft Stream videosUsing MS Stream you can search transcript text in one video, or across multiple videos. See this page for more infoAdditionally if you type time codes into the description then you can create your own table of contents which can be clicked on to go directly to that sectionEg 02:26 end of intro03:45 Joe's presentation...Ths works alongside "Generate automatic captions and a transcript for Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-91725417609624344232020-04-11T23:12:00.001+00:002020-05-04T13:35:33.205+00:00VTT video transcript files
Microsoft Stream can automatically generates a WebVTT (text) file from what was spoken in a video and uses it for a video's transcript and closed captions.
You can download this file as the owner of the video.
As well as the transcript text, a VTT file contains time codes, metadata and confidence levels, which makes getting the text transcript out into word or other editor painful
Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com1tag:blogger.com,1999:blog-5721586.post-26756536935049348782020-01-11T18:52:00.003+00:002020-01-11T18:52:41.401+00:00Hyper-V Gen2 SCSI boot issues with legacy IDE converted machines
I was converting a Windows 2012R2 server from a VMDK to a VHDX, creating a new Hyper-V Gen2 host and struggling to get it to boot. I could mount the drive, read from it from a safe CMD prompt, tried to make sure the correct partition was active using DISKPART, even used BOOTBCD to try but with no luck.
I eventually found that the issue was because I was creating Gen2 Hyper-V Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-71378920057957165392016-02-18T10:27:00.001+00:002016-02-18T10:58:30.067+00:00Managing Office 365 Groups With Remote PowerShell – C7 SolutionsO365 groups info and latest update on features from MS
https://blogs.office.com/2016/02/17/updates-to-office-365-groups/
is the latest update to features here.
Managing Office 365 Groups With Remote PowerShell – C7 Solutions:
To add email aliases to O365 groups use...
Set-UnifiedGroup
name -EmailAddresses @{Add="name@domain.com"}
Although a central group creation policy for a prefix orMark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-58272620764776198462015-08-19T16:25:00.000+00:002015-08-19T16:30:50.721+00:00Post Windows 10 upgrade - remove Windows.Old another other files
After a Windows Upgrade, by default, a scheduled task is created and will run after four weeks to delete the Windows.Old directory. But if you wish, you can also remove the Windows.old folder manually earlier. If you find that you no longer have any use for it, you may safely go ahead and delete it as follows:
Delete Windows.old folder using Disk Cleanup
Open Disk Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-62297251926866753202015-04-02T08:17:00.001+00:002015-04-02T08:17:31.355+00:00Invoking a PowerShell script from cmd.exe (or Start | Run) or shortcutWith the move to Office 365 we need to use powershell more and more - so a shortcut to invoke a script and keep the shell open is really useful.
Invoking a PowerShell script from cmd.exe (or Start | Run) | Poshoholic:
Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-51848302203431274732015-01-27T10:21:00.001+00:002015-01-27T10:21:02.546+00:00SharePoint 2013 - Change URL of document library - SharePoint Stack ExchangeSharePoint 2013 - Change URL of document library - SharePoint Stack Exchange: "When you create a document library, it ask you the name for the DL. Once you give it, it will create library with same name and URL. You can change the name of the library any time but cannot change the url. Here are the things i followed to create url accroding to my needs:
Just go to a library trough 'Site Content'
Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-2186398648244590212013-10-04T20:22:00.001+00:002013-10-04T20:22:53.904+00:00Automatic Site Coverage in Active Directory Domain Services - John Policelli's BlogWe have a number of locations without a domain controller. For these locations we just grouped their IP addresses into the same site as the Hub site and pointed their local DNS to that Hub Site.
After doing some more research this is clearly not best practice for either AD or DFSR. The following article gives an excellent workflow of how a DC works out whether to act for a site. &Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-31870347924349140292013-09-29T22:01:00.001+00:002013-09-29T22:01:59.300+00:00Ahsay OBS getting stuck on reindexingOur backup store filled up whilst a backup was running. Its since been enlarged, however OBS kept getting stuck either on an XML error, or running extremely slowly.
The artlicle below show how do delete the index.bdb files from the backup server and then use the OBS Server admin web management page to rebuild (File Validate) the index. It seemed to work for us.
Ahsay Discussion Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-4747458223827592352013-09-26T07:40:00.001+00:002013-09-26T07:40:19.766+00:00Windows Server 2012: Does ReFS replace NTFS? When should I use it? -Having a lot of problems with DFSR between 2008R2 and 2012 windows machines, I was migrating to new Windows 2012 servers and tripped over this new files system type called ReFS which replaces NTFS.
The article link at the end of this post gives an excellent summary of all of its advantages and issues and like most MS new products it doesn't seem quite complete yet - such as lacking data Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-53471719856915041092013-09-22T15:29:00.001+00:002013-09-22T15:29:39.032+00:00JDiskReport for Mac gives TreeSize Pro for PC similar functionalityFor the PC I really like Jam Softwares TreeSize Pro which gives a report on how the hard drives are being used for space.
I have converted from PC to a MacBook and am a bit lost with Finder. My hard disk is nearly full and I found the following program to show me where the disk has gone. JDiskReport Downloads | JGoodies:
'via Blog this'Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-47160721161772558592013-08-11T20:29:00.001+00:002013-08-11T20:30:28.661+00:00Sharepoint prompting credentials for Explorer mapped drivesI have lived with the sharepoint explorer link prompting for many years, but found the solution below. Oh joy.....
Windows 7 | The SharePoint Project: "1. Click Start, type REGEDIT in the Start Search box, and then press ENTER.
2. Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters"
make Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-7230891107895708992013-07-31T13:28:00.001+00:002013-07-31T13:28:40.636+00:00Doug Hemminger's SharePoint Musings: Instruction Guide for Installing SQL Server 2012 SP1 for SharePoint 2013Useful simple start guide to setting up SQL 2012 for Sharepoint 2013 use
Doug Hemminger's SharePoint Musings: Instruction Guide for Installing SQL Server 2012 SP1 for SharePoint 2013:
'via Blog this'Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-48111461527487227902013-05-29T09:02:00.000+00:002013-05-29T09:02:04.946+00:00Mimecast outbound connector on new Office 365 portal
Microsoft have changed their interface for Office 365 admin and the Mimecast details have not been updated
Firstly logon to the Office 365 EAC by typing in https://podXXXX.outlook.com/ecp/ where XXXX is your OWA pod number for Office 365.
Click on mailflow and then Connectors from the mid top menu.
Add a new Outbound connector and give it a name
Tick Connector type Partner
Use Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-62439297534955734352013-05-28T12:44:00.003+00:002013-05-29T08:49:39.483+00:00office 365 - Exchange admin pathMicrosoft have hidden the Exchange admin tasks from the main admin screen which is bizarre. You can find it again by adding /ecp to the end of your outlook owa path as below. Replace xxxx with your OWA pod number.
https://podxxxx.outlook.com/ecp/
Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-1961751885375754472013-03-20T15:37:00.000+00:002013-03-20T16:58:51.610+00:00Sharepoint 2010 Hide “All Site Content”Not blogged for a while..., however back to SharePoint and I wanted to hide the All Site Content shortcuts for read only users. This keeps things tidy rather than securing areas.
This link is a very concise note on how to hide the "All Site Content" shortcut
Also to hide the Search bar - update the Master Page v4.Master and add the style below in red.
….class="s4-search s4-rp Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-7775977507397402002013-01-04T17:56:00.003+00:002013-01-15T15:43:20.693+00:00Set Up an Office 365 Shared MailboxMicrosoft have a training video on the right way to setup an office 365 mailbox here
Altnerate reference here: Set Up a Shared Mailbox
Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-90132034005958208572013-01-04T17:43:00.003+00:002013-01-04T17:43:41.943+00:00Outlook folder Automapping
If you assign permissions to a an exchange user or folder using Powershell to a folder you can define if that Folder should be automatically displayed (or auto-mapped) when Outlook next starts. . If a user is granted Full Access permissions to another user's mailbox or to a shared mailbox, Outlook, through Autodiscover, automatically loads all mailboxes to which the user has full access.&Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-70738263435097536362013-01-04T17:37:00.001+00:002013-01-04T17:38:57.850+00:00 Office 365 script for giving (or recinding) send-as permissions
param($mailboxname,$user)$mailbox = get-mailbox $mailboxname
#Give user full mailbox rights
Add-MailboxPermission -Identity $mailbox -User $user -AccessRights 'FullAccess'
#Give user send-as rights to mailboxAdd-ADPermission -Identity $mailbox.DisplayName -User $user -ExtendedRights 'Send-as'
--------------
param($mailboxname,$user)
$mailbox = get-mailbox $mailboxname
#Remove user Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-61026919674394284692013-01-04T17:33:00.000+00:002013-01-04T17:33:06.053+00:00Office 365 mailbox and folder permissions (with powershell)The number of e-mail folder and mailbox permissions possible with Office 365 can be very confusing... Below are some powershell tips on how to display the permissions followed by some tips on how to add permissions.
Viewing permissions
Using a Powershell linked session (see this post for more info) you can retrieve the permissions set at one of the following three possible Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0tag:blogger.com,1999:blog-5721586.post-66580271378226025322012-12-09T17:11:00.002+00:002012-12-09T17:11:52.355+00:00Windows 8 Enterprise activation DNS errorWindows 8 Enterprise defaults to using a corporate Volume License activation on a business network. This is supposed to provide a simplified end-user activation experience focused on using the KMS server, however i fyou want to use a MAK key then you are in trouble. This is because Windows 8 Enterprise PC cannot find the appropriate DNS records to determine how to automatically Mark Iwaszkohttp://www.blogger.com/profile/06906535219516005762noreply@blogger.com0