Category: Microsoft
Category Archives: Microsoft
APA 7 MICROSOFT 365 PERSONAL
No es posible instalar APA 7 Style en la aplicación Word con una suscripción a Microsoft 365. Después de más de 1 hora hablando con agentes de nivel 1 y 2 han descubierto que es un error de diseño.
No es posible instalar APA 7 Style en la aplicación Word con una suscripción a Microsoft 365. Después de más de 1 hora hablando con agentes de nivel 1 y 2 han descubierto que es un error de diseño. Read More
email is going to the junk folder
Hello
Please i need your help on this issue.
Email is going to the junk folder and they are unable to retrieve it.
Hello Please i need your help on this issue. Email is going to the junk folder and they are unable to retrieve it. Read More
Не работают максросы и надстройки в файле excel на MAC
Добрый день! Проверьте пожалуйста работу макросов и надстроек в Excel на Mac последних версий sonoma 14.2.1 (23C71), они не работают. Раньше год или полтора тому назад все работало. На компьютере Windows все работает и надстройки есть и добавляются новые строки в таблицу. Также данный файл не получается сохранить после открытия и внесения изменений. Данная проблема у всех пользователей компьютеров Mac. Хотя все макросы включены. На windows данный файл работает и надстройки добавляют нужные строки во вкладке отчет в таблицу о переводе денег. IT специалисты национального банка сказали что они ничего не меняли в фаиле и это проблема excel. Пожалуйста устраните эти проблемы это очень важна для пользователей из Казахстана для сдачи отчета! Могу выслать Вам скрины ошибок и сам файл для проверки. Также могу выслать тот же файл полностью заполненный на компьютере с Windows. Напишите на какую почту отправить. Мой e-mail email address removed for privacy reasons
Добрый день! Проверьте пожалуйста работу макросов и надстроек в Excel на Mac последних версий sonoma 14.2.1 (23C71), они не работают. Раньше год или полтора тому назад все работало. На компьютере Windows все работает и надстройки есть и добавляются новые строки в таблицу. Также данный файл не получается сохранить после открытия и внесения изменений. Данная проблема у всех пользователей компьютеров Mac. Хотя все макросы включены. На windows данный файл работает и надстройки добавляют нужные строки во вкладке отчет в таблицу о переводе денег. IT специалисты национального банка сказали что они ничего не меняли в фаиле и это проблема excel. Пожалуйста устраните эти проблемы это очень важна для пользователей из Казахстана для сдачи отчета! Могу выслать Вам скрины ошибок и сам файл для проверки. Также могу выслать тот же файл полностью заполненный на компьютере с Windows. Напишите на какую почту отправить. Мой e-mail email address removed for privacy reasons Read More
PowerShell cmdlets not available within a script unless it is run as administrator
Connect-IPPSSession
Get-Command Get-DlpCompliancePolicy
Connect-ExchangeOnline
Get-Command Get-Mailbox
If I run Get-ConnectionInformation in the script I can see the two connections are there –
ConnectionId : 745f6176-5d1f-46ec-a786-b8e84f273791
State : Connected
Id : 1
Name : ExchangeOnlineProtection_1
UserPrincipalName : *********
ConnectionUri : https://eur01b.ps.compliance.protection.outlook.com
AzureAdAuthorizationEndpointUri : https://login.microsoftonline.com/organizations
TokenExpiryTimeUTC : 20/04/2024 10:01:24 +00:00
CertificateAuthentication : False
ModuleName : C:Users*******AppDataLocalTemptmpEXO_5lnrtren.etr
ModulePrefix :
Organization :
DelegatedOrganization :
AppId :
PageSize : 1000
TenantID : 081cc50b-e5a5-4e76-b6b7-d7c274899193
TokenStatus : Active
ConnectionUsedForInbuiltCmdlets : False
IsEopSession : True
ConnectionId : 3d3547ec-f35e-4dc3-ba50-ed2f93ef0c35
State : Connected
Id : 2
Name : ExchangeOnline_2
UserPrincipalName : *******
ConnectionUri : https://outlook.office365.com
AzureAdAuthorizationEndpointUri : https://login.microsoftonline.com/organizations
TokenExpiryTimeUTC : 20/04/2024 11:50:29 +00:00
CertificateAuthentication : False
ModuleName : C:Users*******AppDataLocalTemptmpEXO_a2axh3gk.iwh
ModulePrefix :
Organization :
DelegatedOrganization :
AppId :
PageSize : 1000
TenantID : 081cc50b-e5a5-4e76-b6b7-d7c274899193
TokenStatus : Active
ConnectionUsedForInbuiltCmdlets : True
IsEopSession : False
If I run Get-Module I can see the modules I understand are necessary –
Name : ExchangeOnlineManagement
Path : C:Program FilesWindowsPowerShellModulesExchangeOnlineManagement3.4.0netFrameworkExchangeOnli
neManagement.psm1
Description : This is a General Availability (GA) release of the Exchange Online Powershell V3 module. Exchange
Online cmdlets in this module are REST-backed and do not require Basic Authentication to be
enabled in WinRM. REST-based connections in Windows require the PowerShellGet module, and by
dependency, the PackageManagement module.
Please check the documentation here – https://aka.ms/exov3-module.
For issues related to the module, contact Microsoft support.
Guid : b5eced50-afa4-455b-847a-d8fb64140a22
Version : 3.4.0
ModuleBase : C:Program FilesWindowsPowerShellModulesExchangeOnlineManagement3.4.0
ModuleType : Script
PrivateData : {PSData}
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {[Add-VivaModuleFeaturePolicy, Add-VivaModuleFeaturePolicy], [Get-ConnectionInformation,
Get-ConnectionInformation], [Get-DefaultTenantBriefingConfig, Get-DefaultTenantBriefingConfig],
[Get-DefaultTenantMyAnalyticsFeatureConfig, Get-DefaultTenantMyAnalyticsFeatureConfig]…}
ExportedFunctions : {[Connect-ExchangeOnline, Connect-ExchangeOnline], [Connect-IPPSSession, Connect-IPPSSession],
[Disconnect-ExchangeOnline, Disconnect-ExchangeOnline]}
ExportedVariables : {}
NestedModules : {Microsoft.Exchange.Management.RestApiClient,
Microsoft.Exchange.Management.ExoPowershellGalleryModule}
Name : Microsoft.PowerShell.Management
Path : C:WINDOWSsystem32WindowsPowerShellv1.0ModulesMicrosoft.PowerShell.ManagementMicrosoft.PowerS
hell.Management.psd1
Description :
Guid : eefcb906-b326-4e99-9f54-8b4bb6ef3c6d
Version : 3.1.0.0
ModuleBase : C:WindowsSystem32WindowsPowerShellv1.0
ModuleType : Manifest
PrivateData :
AccessMode : ReadWrite
ExportedAliases : {[gcb, gcb], [gin, gin], [gtz, gtz], [scb, scb]…}
ExportedCmdlets : {[Add-Computer, Add-Computer], [Add-Content, Add-Content], [Checkpoint-Computer,
Checkpoint-Computer], [Clear-Content, Clear-Content]…}
ExportedFunctions : {}
ExportedVariables : {}
NestedModules : {Microsoft.PowerShell.Commands.Management.dll}
Name : Microsoft.PowerShell.Utility
Path : C:WINDOWSsystem32WindowsPowerShellv1.0ModulesMicrosoft.PowerShell.UtilityMicrosoft.PowerShel
l.Utility.psd1
Description :
Guid : 1da87e53-152b-403e-98dc-74d7b4d63d59
Version : 3.1.0.0
ModuleBase : C:WindowsSystem32WindowsPowerShellv1.0
ModuleType : Manifest
PrivateData :
AccessMode : ReadWrite
ExportedAliases : {[CFS, CFS], [fhx, fhx]}
ExportedCmdlets : {[Add-Member, Add-Member], [Add-Type, Add-Type], [Clear-Variable, Clear-Variable],
[Compare-Object, Compare-Object]…}
ExportedFunctions : {[ConvertFrom-SddlString, ConvertFrom-SddlString], [Format-Hex, Format-Hex], [Get-FileHash,
Get-FileHash], [Import-PowerShellDataFile, Import-PowerShellDataFile]…}
ExportedVariables : {}
NestedModules : {Microsoft.PowerShell.Commands.Utility.dll, Microsoft.PowerShell.Utility}
Name : PSReadLine
Path : C:Program FilesWindowsPowerShellModulesPSReadLine2.0.0PSReadLine.psm1
Description : Great command line editing in the PowerShell console host
Guid : 5714753b-2afd-4492-a5fd-01d9e2cff8b5
Version : 2.0.0
ModuleBase : C:Program FilesWindowsPowerShellModulesPSReadLine2.0.0
ModuleType : Script
PrivateData :
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {[Get-PSReadLineKeyHandler, Get-PSReadLineKeyHandler], [Get-PSReadLineOption,
Get-PSReadLineOption], [Remove-PSReadLineKeyHandler, Remove-PSReadLineKeyHandler],
[Set-PSReadLineKeyHandler, Set-PSReadLineKeyHandler]…}
ExportedFunctions : {[PSConsoleHostReadLine, PSConsoleHostReadLine]}
ExportedVariables : {}
NestedModules : {Microsoft.PowerShell.PSReadLine}
Name : tmpEXO_5lnrtren.etr
Path : C:Users******AppDataLocalTemptmpEXO_5lnrtren.etrtmpEXO_5lnrtren.etr.psm1
Description : This is a Powershell module generated by using the AutoGEN infra.
Guid : 2c604488-886e-4090-ac70-2b9a3130c449
Version : 1.0
ModuleBase : C:Users********AppDataLocalTemptmpEXO_5lnrtren.etr
ModuleType : Script
PrivateData : {PSData}
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {}
ExportedFunctions : {[Add-ComplianceCaseMember, Add-ComplianceCaseMember], [Add-eDiscoveryCaseAdmin,
Add-eDiscoveryCaseAdmin], [Add-RoleGroupMember, Add-RoleGroupMember], [Cancel-DlpEdmSession,
Cancel-DlpEdmSession]…}
ExportedVariables : {[HelpFileNames, System.Management.Automation.PSVariable]}
NestedModules : {}
Name : tmpEXO_a2axh3gk.iwh
Path : C:Users*******AppDataLocalTemptmpEXO_a2axh3gk.iwhtmpEXO_a2axh3gk.iwh.psm1
Description : This is a Powershell module generated by using the AutoGEN infra.
Guid : e84305bc-e9b9-45bd-bb9f-d38a411419b2
Version : 1.0
ModuleBase : C:Users********AppDataLocalTemptmpEXO_a2axh3gk.iwh
ModuleType : Script
PrivateData : {PSData}
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {}
ExportedFunctions : {[Add-AvailabilityAddressSpace, Add-AvailabilityAddressSpace], [Add-DistributionGroupMember,
Add-DistributionGroupMember], [Add-MailboxFolderPermission, Add-MailboxFolderPermission],
[Add-MailboxLocation, Add-MailboxLocation]…}
ExportedVariables : {[HelpFileNames, System.Management.Automation.PSVariable]}
NestedModules : {}
And once the script exits, I can then do ‘Get-Command Get-Mailbox’ and get a good response. So the connection is clearly working, the script just cannot seem to access the functions/cmdlets while it is running. This is Twilight Zone stuff right!?
I do not know if it’s relevant, but we use AppLocker. So in my unelevated PS session I am in ConstrainedLanguage mode, but the script is excluded from AppLocker so executes in FullLanguage mode.
I feel like I’m missing something fundamental about how PS sessions or scopes operate within a script run as admin vs a regular user, or is there a bug in Connect-ExchangeOnline, but no amount of Google searching has saved my mind yet!
Thanks
I wonder if somebody can help with this issue. Essentially I want to be able to connect to Exchange Online and the Security and Compliance PowerShell from within a script run as a regular user, not administrator.If I drop these commands into my un-elevated PS window they will connect successfully and give me back some info on the two commands. If I drop the same commands into a PS1 file and execute it in an elevated PS console they also run successfully. Connect-IPPSSession
Get-Command Get-DlpCompliancePolicy
Connect-ExchangeOnline
Get-Command Get-Mailbox If I run Get-ConnectionInformation in the script I can see the two connections are there – ConnectionId : 745f6176-5d1f-46ec-a786-b8e84f273791
State : Connected
Id : 1
Name : ExchangeOnlineProtection_1
UserPrincipalName : *********
ConnectionUri : https://eur01b.ps.compliance.protection.outlook.com
AzureAdAuthorizationEndpointUri : https://login.microsoftonline.com/organizations
TokenExpiryTimeUTC : 20/04/2024 10:01:24 +00:00
CertificateAuthentication : False
ModuleName : C:Users*******AppDataLocalTemptmpEXO_5lnrtren.etr
ModulePrefix :
Organization :
DelegatedOrganization :
AppId :
PageSize : 1000
TenantID : 081cc50b-e5a5-4e76-b6b7-d7c274899193
TokenStatus : Active
ConnectionUsedForInbuiltCmdlets : False
IsEopSession : True
ConnectionId : 3d3547ec-f35e-4dc3-ba50-ed2f93ef0c35
State : Connected
Id : 2
Name : ExchangeOnline_2
UserPrincipalName : *******
ConnectionUri : https://outlook.office365.com
AzureAdAuthorizationEndpointUri : https://login.microsoftonline.com/organizations
TokenExpiryTimeUTC : 20/04/2024 11:50:29 +00:00
CertificateAuthentication : False
ModuleName : C:Users*******AppDataLocalTemptmpEXO_a2axh3gk.iwh
ModulePrefix :
Organization :
DelegatedOrganization :
AppId :
PageSize : 1000
TenantID : 081cc50b-e5a5-4e76-b6b7-d7c274899193
TokenStatus : Active
ConnectionUsedForInbuiltCmdlets : True
IsEopSession : False If I run Get-Module I can see the modules I understand are necessary – Name : ExchangeOnlineManagement
Path : C:Program FilesWindowsPowerShellModulesExchangeOnlineManagement3.4.0netFrameworkExchangeOnli
neManagement.psm1
Description : This is a General Availability (GA) release of the Exchange Online Powershell V3 module. Exchange
Online cmdlets in this module are REST-backed and do not require Basic Authentication to be
enabled in WinRM. REST-based connections in Windows require the PowerShellGet module, and by
dependency, the PackageManagement module.
Please check the documentation here – https://aka.ms/exov3-module.
For issues related to the module, contact Microsoft support.
Guid : b5eced50-afa4-455b-847a-d8fb64140a22
Version : 3.4.0
ModuleBase : C:Program FilesWindowsPowerShellModulesExchangeOnlineManagement3.4.0
ModuleType : Script
PrivateData : {PSData}
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {[Add-VivaModuleFeaturePolicy, Add-VivaModuleFeaturePolicy], [Get-ConnectionInformation,
Get-ConnectionInformation], [Get-DefaultTenantBriefingConfig, Get-DefaultTenantBriefingConfig],
[Get-DefaultTenantMyAnalyticsFeatureConfig, Get-DefaultTenantMyAnalyticsFeatureConfig]…}
ExportedFunctions : {[Connect-ExchangeOnline, Connect-ExchangeOnline], [Connect-IPPSSession, Connect-IPPSSession],
[Disconnect-ExchangeOnline, Disconnect-ExchangeOnline]}
ExportedVariables : {}
NestedModules : {Microsoft.Exchange.Management.RestApiClient,
Microsoft.Exchange.Management.ExoPowershellGalleryModule}
Name : Microsoft.PowerShell.Management
Path : C:WINDOWSsystem32WindowsPowerShellv1.0ModulesMicrosoft.PowerShell.ManagementMicrosoft.PowerS
hell.Management.psd1
Description :
Guid : eefcb906-b326-4e99-9f54-8b4bb6ef3c6d
Version : 3.1.0.0
ModuleBase : C:WindowsSystem32WindowsPowerShellv1.0
ModuleType : Manifest
PrivateData :
AccessMode : ReadWrite
ExportedAliases : {[gcb, gcb], [gin, gin], [gtz, gtz], [scb, scb]…}
ExportedCmdlets : {[Add-Computer, Add-Computer], [Add-Content, Add-Content], [Checkpoint-Computer,
Checkpoint-Computer], [Clear-Content, Clear-Content]…}
ExportedFunctions : {}
ExportedVariables : {}
NestedModules : {Microsoft.PowerShell.Commands.Management.dll}
Name : Microsoft.PowerShell.Utility
Path : C:WINDOWSsystem32WindowsPowerShellv1.0ModulesMicrosoft.PowerShell.UtilityMicrosoft.PowerShel
l.Utility.psd1
Description :
Guid : 1da87e53-152b-403e-98dc-74d7b4d63d59
Version : 3.1.0.0
ModuleBase : C:WindowsSystem32WindowsPowerShellv1.0
ModuleType : Manifest
PrivateData :
AccessMode : ReadWrite
ExportedAliases : {[CFS, CFS], [fhx, fhx]}
ExportedCmdlets : {[Add-Member, Add-Member], [Add-Type, Add-Type], [Clear-Variable, Clear-Variable],
[Compare-Object, Compare-Object]…}
ExportedFunctions : {[ConvertFrom-SddlString, ConvertFrom-SddlString], [Format-Hex, Format-Hex], [Get-FileHash,
Get-FileHash], [Import-PowerShellDataFile, Import-PowerShellDataFile]…}
ExportedVariables : {}
NestedModules : {Microsoft.PowerShell.Commands.Utility.dll, Microsoft.PowerShell.Utility}
Name : PSReadLine
Path : C:Program FilesWindowsPowerShellModulesPSReadLine2.0.0PSReadLine.psm1
Description : Great command line editing in the PowerShell console host
Guid : 5714753b-2afd-4492-a5fd-01d9e2cff8b5
Version : 2.0.0
ModuleBase : C:Program FilesWindowsPowerShellModulesPSReadLine2.0.0
ModuleType : Script
PrivateData :
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {[Get-PSReadLineKeyHandler, Get-PSReadLineKeyHandler], [Get-PSReadLineOption,
Get-PSReadLineOption], [Remove-PSReadLineKeyHandler, Remove-PSReadLineKeyHandler],
[Set-PSReadLineKeyHandler, Set-PSReadLineKeyHandler]…}
ExportedFunctions : {[PSConsoleHostReadLine, PSConsoleHostReadLine]}
ExportedVariables : {}
NestedModules : {Microsoft.PowerShell.PSReadLine}
Name : tmpEXO_5lnrtren.etr
Path : C:Users******AppDataLocalTemptmpEXO_5lnrtren.etrtmpEXO_5lnrtren.etr.psm1
Description : This is a Powershell module generated by using the AutoGEN infra.
Guid : 2c604488-886e-4090-ac70-2b9a3130c449
Version : 1.0
ModuleBase : C:Users********AppDataLocalTemptmpEXO_5lnrtren.etr
ModuleType : Script
PrivateData : {PSData}
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {}
ExportedFunctions : {[Add-ComplianceCaseMember, Add-ComplianceCaseMember], [Add-eDiscoveryCaseAdmin,
Add-eDiscoveryCaseAdmin], [Add-RoleGroupMember, Add-RoleGroupMember], [Cancel-DlpEdmSession,
Cancel-DlpEdmSession]…}
ExportedVariables : {[HelpFileNames, System.Management.Automation.PSVariable]}
NestedModules : {}
Name : tmpEXO_a2axh3gk.iwh
Path : C:Users*******AppDataLocalTemptmpEXO_a2axh3gk.iwhtmpEXO_a2axh3gk.iwh.psm1
Description : This is a Powershell module generated by using the AutoGEN infra.
Guid : e84305bc-e9b9-45bd-bb9f-d38a411419b2
Version : 1.0
ModuleBase : C:Users********AppDataLocalTemptmpEXO_a2axh3gk.iwh
ModuleType : Script
PrivateData : {PSData}
AccessMode : ReadWrite
ExportedAliases : {}
ExportedCmdlets : {}
ExportedFunctions : {[Add-AvailabilityAddressSpace, Add-AvailabilityAddressSpace], [Add-DistributionGroupMember,
Add-DistributionGroupMember], [Add-MailboxFolderPermission, Add-MailboxFolderPermission],
[Add-MailboxLocation, Add-MailboxLocation]…}
ExportedVariables : {[HelpFileNames, System.Management.Automation.PSVariable]}
NestedModules : {} And once the script exits, I can then do ‘Get-Command Get-Mailbox’ and get a good response. So the connection is clearly working, the script just cannot seem to access the functions/cmdlets while it is running. This is Twilight Zone stuff right!? I do not know if it’s relevant, but we use AppLocker. So in my unelevated PS session I am in ConstrainedLanguage mode, but the script is excluded from AppLocker so executes in FullLanguage mode. I feel like I’m missing something fundamental about how PS sessions or scopes operate within a script run as admin vs a regular user, or is there a bug in Connect-ExchangeOnline, but no amount of Google searching has saved my mind yet! Thanks Read More
Fully Managed – KIOSK Mode – Discover and install great apps
Hi All,
When enrolling a fully managed (KIOSK) device, is there away to block/remove/hide the screen that pop’s up on Samsung mobiles titled “Discover and install great apps” ?
It then try’s to install apps/games like Monopoly go etc
Fingers Crossed
Hi All, When enrolling a fully managed (KIOSK) device, is there away to block/remove/hide the screen that pop’s up on Samsung mobiles titled “Discover and install great apps” ? It then try’s to install apps/games like Monopoly go etc Fingers Crossed Read More
PIs/scripting functionality to get an app and install it on the machine?
Can we automatically get and install the app under the covers if there is eligibility(like user paid for the App). Do we have APIs/scripting functionality to get an app and install it on the machine?
Can we automatically get and install the app under the covers if there is eligibility(like user paid for the App). Do we have APIs/scripting functionality to get an app and install it on the machine? Read More
Extracting common data into columns
Hi,
I wonder if anyone can help explain how I can create an alternative view for a big data set I have.
For the sake of this question, I have created an illustration of what I am trying to achieve.
There are two columns (Category & Value) in a data set that I need to appear on a separate sheet, but instead the Category needs to be the column title and the values that fall within this category listed below it – is this possible please?
Hi, I wonder if anyone can help explain how I can create an alternative view for a big data set I have. For the sake of this question, I have created an illustration of what I am trying to achieve. There are two columns (Category & Value) in a data set that I need to appear on a separate sheet, but instead the Category needs to be the column title and the values that fall within this category listed below it – is this possible please? Read More
Microsoft Commercial Marketplace – Customer Office Hours
The Microsoft Commercial Marketplace Customer Office Hours are a golden opportunity to understand the marketplace from a customer’s perspective.
These events feature 30-minute presentations on topics like procurement optimization, private offers, and getting started in the marketplace, followed by Q&A sessions.
Especially for new ISVs, these insights are crucial for tailoring your offerings and navigating the ecosystem effectively. Don’t miss out on these sessions to enhance your strategy and connect with your audience more deeply.
Here’s the link: https://microsoftcloudpartner.eventbuilder.com/CustomerQ&A
The Microsoft Commercial Marketplace Customer Office Hours are a golden opportunity to understand the marketplace from a customer’s perspective.These events feature 30-minute presentations on topics like procurement optimization, private offers, and getting started in the marketplace, followed by Q&A sessions.Especially for new ISVs, these insights are crucial for tailoring your offerings and navigating the ecosystem effectively. Don’t miss out on these sessions to enhance your strategy and connect with your audience more deeply.Here’s the link: https://microsoftcloudpartner.eventbuilder.com/CustomerQ&A Read More
Unified Sentinel and playbooks
Hi all
It’s been a few weeks now since the unified Sentinel experience dropper publicly and I’ve been running that since then. It was alot of bells, whistles and hype build since the Ignite event but I feel like…meh, now what.
What happened to playbooks? What happened to all the automations we had that enriched events into the the audit logs in Sentinel for correlation?
These are either gone or not working as intended anymore. Before the “unification” we had an incident come in from our firewalls with a blocked URL which was enriched from externa threat intelligence sources and could be closed within minutes by an operator after scrolling the audit log. Now it seems the idea is for the operator to click around in the Defender portal and view the different pages for similar information, not to mentioning the seemingly nesessity for the Microsoft Intelligence platform, before the operator can determine the posture of an incident. It feels like we took a step back.
Peace
/Fredrik
Hi allIt’s been a few weeks now since the unified Sentinel experience dropper publicly and I’ve been running that since then. It was alot of bells, whistles and hype build since the Ignite event but I feel like…meh, now what.What happened to playbooks? What happened to all the automations we had that enriched events into the the audit logs in Sentinel for correlation?These are either gone or not working as intended anymore. Before the “unification” we had an incident come in from our firewalls with a blocked URL which was enriched from externa threat intelligence sources and could be closed within minutes by an operator after scrolling the audit log. Now it seems the idea is for the operator to click around in the Defender portal and view the different pages for similar information, not to mentioning the seemingly nesessity for the Microsoft Intelligence platform, before the operator can determine the posture of an incident. It feels like we took a step back. Peace/Fredrik Read More
Disappointing Session Schedule for M365 Conference
The M365 Conference takes place in Orlando, FL from April 28 to May 2, 2024. I have two sessions, but my attempts to find sessions that cover all of Microsoft 365 failed because there’s no coverage of Entra ID and Exchange Online. Instead, the Microsoft priorities like Copilot, Viva, and SharePoint take front and center stage. I think that’s a pity, but maybe the reason is because speakers don’t submit sessions covering Entra ID and Exchange Online topics?
https://office365itpros.com/2024/04/22/m365-conference-2024/
The M365 Conference takes place in Orlando, FL from April 28 to May 2, 2024. I have two sessions, but my attempts to find sessions that cover all of Microsoft 365 failed because there’s no coverage of Entra ID and Exchange Online. Instead, the Microsoft priorities like Copilot, Viva, and SharePoint take front and center stage. I think that’s a pity, but maybe the reason is because speakers don’t submit sessions covering Entra ID and Exchange Online topics?
https://office365itpros.com/2024/04/22/m365-conference-2024/
Read More
Upcoming Microsoft 365 Product Connect for CSPs Q4 | Live Webinar
Don’t miss our upcoming Live Webinar | Microsoft 365 Product Connect for CSPs on May 16, 2024. Our quarterly live webinar series shares the most relevant and important product news for CSP partners.
Modern Work product experts will cover new and upcoming product news, promotions, and program announcements that include Microsoft 365, Copilot for Microsoft 365, Microsoft Teams, Security, Windows 365, and more!
Date: May 16, 2024
Americas/EMEA: 8:00 AM-9:00 AM PT
APAC: 5:00 PM-6:00 PM PT
If you have Modern Work product questions, please submit in advance by May 2nd using the Microsoft 365 CSP Partner Connect questionnaire. Questions will be reviewed and answered during this session. Our goal is to answer as many as possible during the live event!
Don’t miss our upcoming Live Webinar | Microsoft 365 Product Connect for CSPs on May 16, 2024. Our quarterly live webinar series shares the most relevant and important product news for CSP partners. Modern Work product experts will cover new and upcoming product news, promotions, and program announcements that include Microsoft 365, Copilot for Microsoft 365, Microsoft Teams, Security, Windows 365, and more! Date: May 16, 2024Americas/EMEA: 8:00 AM-9:00 AM PT APAC: 5:00 PM-6:00 PM PT
If you have Modern Work product questions, please submit in advance by May 2nd using the Microsoft 365 CSP Partner Connect questionnaire. Questions will be reviewed and answered during this session. Our goal is to answer as many as possible during the live event! Read More
SQL MI Restore with valid SAS key failing with Operating System Error 86
On a recent case, a customer was trying to restore a database from a storage account using a SAS token when they received the below error.
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Additional information:
Cannot open backup device
‘https://storage.blob.core.windows.net/container/dbbackup_2024_03_21_121901.bak‘
Operating system error 86(The specified network password is not correct.).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
To ensure that the SQL Managed Instance could successfully connect to the storage account, we checked that it was not behind a firewall in Azure.
We also used a SQL Agent job to check connectivity was successful using this blog post.
After confirming connectivity was successful, the final check was to test the SAS token.
To do this, we used the SSMS restore GUI to connect to the storage account using the same token, which was successful and allowed us to browse and select a backup file.
Despite everything looking well, the restore was still failing.
In the end, we dropped and recreated the credential, which solved the issue.
DROP CREDENTIAL [https://storageaccount.blob.core.windows.net/container]
GO
CREATE CREDENTIAL [https://storageaccount.blob.core.windows.net/container]
WITH IDENTITY = N’SHARED ACCESS SIGNATURE’,
SECRET = N’SAS_TOKEN’
GO
Disclaimer
Please note that products and options presented in this article are subject to change. This article reflects the behaviour from April 2024.
I hope this article was helpful for you, please feel free to share your feedback in the comments section.
Microsoft Tech Community – Latest Blogs –Read More
Tracking a file using its Hash Value
Hi, I want to track files based on the SHA256 generated hash value. And while I am aware of the n number of tables in Log Analytics, it there any other way to accomplish this?
For example if I want to track a file going out to an external email address, I want to be notified. I thought of transport rules but those don’t seem to be useful for this use case. However I did find some records through Advanced Hunting, but it tracks only files identified as spam/phish/malware etc.
Is there any way to track ALL files without Defender for Endpoint Solutions?
Thanks in advance!
Hi, I want to track files based on the SHA256 generated hash value. And while I am aware of the n number of tables in Log Analytics, it there any other way to accomplish this?For example if I want to track a file going out to an external email address, I want to be notified. I thought of transport rules but those don’t seem to be useful for this use case. However I did find some records through Advanced Hunting, but it tracks only files identified as spam/phish/malware etc.Is there any way to track ALL files without Defender for Endpoint Solutions? Thanks in advance! Read More
iFrame Microsoft bookings, “grey” part too big
Hi
I want to embed a bookings page with iFrame. Sadly the “grey” part is using a lot of space and the “main” part of bookings page is way too small. Even if it is not embedded, the “grey” part uses a lot of space. Is there a way to reduce/remove that?
greetings
Hi I want to embed a bookings page with iFrame. Sadly the “grey” part is using a lot of space and the “main” part of bookings page is way too small. Even if it is not embedded, the “grey” part uses a lot of space. Is there a way to reduce/remove that? greetings Read More
Unable to set TeamsFilePolicy
Hi,
I’m trying to update a policy value from teams, the ‘CsTeamsFilePolicy’. All the documentation redirects to use powershell.
Documentation – Teams native file upload policy
Documentation – Turn off teams native file upload policy
Every time I try to update this value or create a new CsTeamsFilesPolicy the error ‘DefaultFileUploadAppId must be a GUID value’ appears:
I don’t see this property in the cmdlet, either reported anywhere.I have tried with 3 different tenants and all raise the same errorI don’t see this configuration in the graph API, so I can’t manipulate elsewhereI tried to downgrade the module versionI don’t see any changes to this cmdlet in the releases page
So don’t really know if I’m doing something wrong or if the cmdlet it’s broken.
Thanks
Hi, I’m trying to update a policy value from teams, the ‘CsTeamsFilePolicy’. All the documentation redirects to use powershell. Documentation – Teams native file upload policy Documentation – Turn off teams native file upload policy Every time I try to update this value or create a new CsTeamsFilesPolicy the error ‘DefaultFileUploadAppId must be a GUID value’ appears: I don’t see this property in the cmdlet, either reported anywhere.I have tried with 3 different tenants and all raise the same errorI don’t see this configuration in the graph API, so I can’t manipulate elsewhereI tried to downgrade the module versionI don’t see any changes to this cmdlet in the releases page So don’t really know if I’m doing something wrong or if the cmdlet it’s broken. Thanks Read More
Guest access to plans in Planner – Do they need to switch organisations to see the plans?
Hi Planner team
With guest access set up for plans in planner, will the guest be able to view the plan in their own user? Or will they still be required to change organisations?
We see this a quite a barrier to collaboration across external partners and therefore are wondering if at all possible?
Many thanks!
Khanya
Hi Planner team With guest access set up for plans in planner, will the guest be able to view the plan in their own user? Or will they still be required to change organisations? We see this a quite a barrier to collaboration across external partners and therefore are wondering if at all possible? Many thanks!Khanya Read More
archived Teams or Channels: still sychronised in Windows Explorer and files still writeable?
Hi everybody,
i am struggling with the concept of archiving teams and channels, after a project is finished i want to archive (not delete) the teams/channels. i am testing this and noticed a few things:
archived teams and channels are still synchronized with my windows explorer, can i control this behaviour? i want archived channels to Desynchronise in windows Explorer, is this possible?when teams are synchronized i can not edit files in Teams but files are still editable in Windows exploer. So i could edit a Word File in Windows Explorer, save the file and it will be synchronized via One Drive in Teams. why is that? does not really make any sense. when i archive a teams i want to freeze all the files in it and not just the ones opened in teams, how do i change this?
Hi everybody,i am struggling with the concept of archiving teams and channels, after a project is finished i want to archive (not delete) the teams/channels. i am testing this and noticed a few things:archived teams and channels are still synchronized with my windows explorer, can i control this behaviour? i want archived channels to Desynchronise in windows Explorer, is this possible?when teams are synchronized i can not edit files in Teams but files are still editable in Windows exploer. So i could edit a Word File in Windows Explorer, save the file and it will be synchronized via One Drive in Teams. why is that? does not really make any sense. when i archive a teams i want to freeze all the files in it and not just the ones opened in teams, how do i change this? Read More
Azure Data Factory Synapse Analytics: Validate FileFolder before using!
In real time, every project would deal with Azure storage or Azure SQL Database. It can be blobs, folders/directories, files. It becomes a crucial step to validate the filefoldertable before actually using them.
Few usecases:
Suppose we have to load a file named SalesData.csv from a folder that gets created everyday in the format yyyy/MM/dd. Before we use this file in a copy data activity or a data flow activity, we have to first validate, if the folder exists or not.
If the folder exists, we might want to validate the size of the file. This is important, because, sometimes the files bring no data, i.e. a 0 kb file.
Another usecase would be to validate a table structure or file structure and make sure it is compliant with what we expect.
In ADFSynapse, we can use Validation activity andor getmetadata activity to validate files, folders and tables.
Validation Activity Settings & short description follows:
In the above image, we have a referenced a dataset called DelimitedText2, which would point to either a folder or file in azure blob storage or a table in a Azure SQL DB. Timeout property holds the time afterwhich the activity would timeout (note that, it wont fail). For instance, if the validation activity is meant to validate the presence of a filefoldertable, and it doesn’t find the corresponding item, after the timeout time, the activity execution stops and timesout. Next, we have the sleep property which makes the validation activity wait for certain number of seconds before revalidation or timeout. Minimum size property is used to mention the minimum size of a file in bytes (not applicable to table based dataset).
When the validation activity completes execution or times out, we can access the output json of the validation activity to know about the validation results.
Let us look at the GetMetadata activity and its settings.
Like validation activity, we have few properties that would help us validate the filefoldertable in a GetMetadata activity in ADFSynapse. Depending on whether the dataset points to a folderfiletable, the properties (field list) would differ.
The above image depicts the field list corresponding to a folder in ADLS. When we make the dataset point to a file, it would be as below.
So, if the dataset points to a file or table, we see couple of additional properties like Column Count, Size, Structure.
Having seen about the individual properties field list of both the activities, its time to compare and know the similarities and differences.
The below table compares the capabilities of Validation activity & Get metadata activity.
Validation Activity
Get metadata activity
Property Used
Validate File
Yes
Yes
Exists (returns boolean)
Validate Folder
Yes
Yes
Exists (returns boolean)
Validate File Size
Yes
Yes
Get Metadata Activity: Use Size property in field list
Validation Activity: Use Minimum size field in Settings tab
Validate File Structure
No
Yes
Get Metadata:
Use the Field List: Structure.
Then, Use another activity like If condition to validate the structure against the expected.
Validate File Column Count
No
Yes
Get Metadata:
Use the Field List: Column Count.
Then, Use another activity like If condition to validate the count against the expected.
In a nutshell, ADFSynapse comes with a variety of activities, sometimes with similar characteristics or capabilities. When it comes to validation, it is based on the use case, we decide to use either Validation activity or Get Metadata activity or both.
Microsoft Tech Community – Latest Blogs –Read More
Change Microsoft Logo to Company Logo
How to change the Microsoft Logo to a preferred company Logo? Where is that setting located in the admin center?
See sample here
How to change the Microsoft Logo to a preferred company Logo? Where is that setting located in the admin center? See sample here Read More
display Versionnumber in Files (Word …)
Hello everyone, I hope someone can help me with my problem.
I have been given the task of displaying the version number in Word documents. Without Powershell this works without any problems.
Activated the Library and Folder Based Retention Site Collection feature
Checked “Enable Labels” in the Information Management Policy Settings for the Document Content Type, and entered “{Version}” into the Label format field
Created a Word document in my library
Opened the document in Word, and inserted a Quick Part (Document Property > Label)
But I have to roll it out to all SharePoint sites in the tenant, so I have to implement it programmatically somehow.
Does anyone have any idea how I can do it with Powershell, unfortunately I can’t find anything on the internet after a long search.
Hello everyone, I hope someone can help me with my problem. I have been given the task of displaying the version number in Word documents. Without Powershell this works without any problems.Activated the Library and Folder Based Retention Site Collection featureChecked “Enable Labels” in the Information Management Policy Settings for the Document Content Type, and entered “{Version}” into the Label format fieldCreated a Word document in my libraryOpened the document in Word, and inserted a Quick Part (Document Property > Label) But I have to roll it out to all SharePoint sites in the tenant, so I have to implement it programmatically somehow. Does anyone have any idea how I can do it with Powershell, unfortunately I can’t find anything on the internet after a long search. Read More