Tag Archives: microsoft
Issue with Vulnerability Management for Microsoft Defender for Endpoint on Rocky 9
We are experiencing an issue with the Vulnerability Management feature for Microsoft Defender for Endpoint on Rocky 9 Linux. The system is not showing any data for software packages or discovering vulnerable ones. Despite the presence of a vulnerability for OpenSSH, it was not reported by the system.
Thanks
We are experiencing an issue with the Vulnerability Management feature for Microsoft Defender for Endpoint on Rocky 9 Linux. The system is not showing any data for software packages or discovering vulnerable ones. Despite the presence of a vulnerability for OpenSSH, it was not reported by the system. Thanks Read More
Error in Manager data synchronization via SCIM
Hello!
My name is Alex Moiseev, and I am experiencing an issue with user synchronization via SCIM with Azure Active Directory. Well, actually with manager synchronization.
As far as I understand, the approach of provisioning of the user is the following.
Step 1. Provisioner tries to get info about the user by id with GET User resource request.
Step 2. Based on information received, Provisioner decides should the whole information about the user be sent or there is a need only to update certain fields.
Step 3. Provisioner send POST or PUT/PATCH request with user details to create/update user on the receiver side.
And everything works more or less ok, but the managers.
In user data to provide there is one field, which is used for manager info:
urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager
When there is no manager on consumer side assigned to the user, everything works perfectly.
The provisioner sends manager info in both cases – with existing and with non-existing user.
If the manager is changed on Azure AD side, we still receive manager data in the field mentioned in PATCH request in order to overwrite stored manager.
But when the manager is removed on Azure AD side, we didn’t receive any information about it – urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager field doesn’t exist in PATCH request.
We thought, that may be because we didn’t add manager information in GET User resource response.
We tried to add manager information there according to the documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) by adding
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},
We use “0” in order to make the provisioner to send us information about the manager in each request.
But we’ve got an error there:
Error message
We are not able to deserialize the resource received from your SCIM endpoint because your SCIM endpoint is not fully compatible with the Azure Active Directory SCIM client. Here is the resource we received from your SCIM endpoint:
{
“schemas”: [
“urn:ietf:params:scim:schemas:core:2.0:User”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”
],
“externalId”: “Worker”,
“id”: “1548197”,
“userName”: “email address removed for privacy reasons”,
“name”: {
“familyName”: “Ker”,
“givenName”: “Wor”
},
“emails”: [
{
“value”: “email address removed for privacy reasons”,
“type”: “work”,
“primary”: true
}
],
“title”: “Developer”,
“locale”: “nl”,
“timezone”: “CEST”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},
“active”: true,
“displayName”: “Wor Ker”
}
Please refer to the Azure Active Directory SCIM provisioning documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) and adapt the SCIM endpoint to be able to process provisioning requests from Azure Active Directory.
We have reviewed the documentation referenced, and the format for specifying the manager is exactly as indicated in the documentation.
If the “manager” field is removed from the data, the error does not occur.
So, the questions are:
1. How should we provide manager information in the response of GET User resource call?
2. How should we catch the removing of the manager in Azure in a proper way?
I would appreciate your assistance in resolving this issue.
I’d like to know what is causing the error and how to correctly transmit manager information via SCIM.
Thank you in advance for your attention and help!
Yours sincerely,
Alex Moiseev
Hello!My name is Alex Moiseev, and I am experiencing an issue with user synchronization via SCIM with Azure Active Directory. Well, actually with manager synchronization. As far as I understand, the approach of provisioning of the user is the following.Step 1. Provisioner tries to get info about the user by id with GET User resource request.Step 2. Based on information received, Provisioner decides should the whole information about the user be sent or there is a need only to update certain fields.Step 3. Provisioner send POST or PUT/PATCH request with user details to create/update user on the receiver side.And everything works more or less ok, but the managers. In user data to provide there is one field, which is used for manager info:urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager When there is no manager on consumer side assigned to the user, everything works perfectly.The provisioner sends manager info in both cases – with existing and with non-existing user.If the manager is changed on Azure AD side, we still receive manager data in the field mentioned in PATCH request in order to overwrite stored manager.But when the manager is removed on Azure AD side, we didn’t receive any information about it – urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager field doesn’t exist in PATCH request. We thought, that may be because we didn’t add manager information in GET User resource response.We tried to add manager information there according to the documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) by adding “urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},We use “0” in order to make the provisioner to send us information about the manager in each request.But we’ve got an error there: Error message
We are not able to deserialize the resource received from your SCIM endpoint because your SCIM endpoint is not fully compatible with the Azure Active Directory SCIM client. Here is the resource we received from your SCIM endpoint:
{
“schemas”: [
“urn:ietf:params:scim:schemas:core:2.0:User”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”
],
“externalId”: “Worker”,
“id”: “1548197”,
“userName”: “email address removed for privacy reasons”,
“name”: {
“familyName”: “Ker”,
“givenName”: “Wor”
},
“emails”: [
{
“value”: “email address removed for privacy reasons”,
“type”: “work”,
“primary”: true
}
],
“title”: “Developer”,
“locale”: “nl”,
“timezone”: “CEST”,
“urn:ietf:params:scim:schemas:extension:enterprise:2.0:User”: {
“manager”: “0”
},
“active”: true,
“displayName”: “Wor Ker”
}
Please refer to the Azure Active Directory SCIM provisioning documentation (https://docs.microsoft.com/en-us/azure/active-directory/app-provisioning/use-scim-to-provision-users-and-groups) and adapt the SCIM endpoint to be able to process provisioning requests from Azure Active Directory.We have reviewed the documentation referenced, and the format for specifying the manager is exactly as indicated in the documentation.If the “manager” field is removed from the data, the error does not occur. So, the questions are:1. How should we provide manager information in the response of GET User resource call?2. How should we catch the removing of the manager in Azure in a proper way? I would appreciate your assistance in resolving this issue.I’d like to know what is causing the error and how to correctly transmit manager information via SCIM.Thank you in advance for your attention and help! Yours sincerely,Alex Moiseev Read More
Making a quotation filled with data from a table on another worksheet
Good morning,
I haven’t been using Excel a lot but I’ve found a template for a quotation that I want to upgrade. On the first sheet I have all the information that needs to come in the quote, and the second sheet I made a table with all items that could come in the quote. Description, quantity, my price, clients price.
No I’ve got the table at the point I can use it like I want but actually the prices that we sell for should be together with the description, so how can I use one pull down item and make the other colums, like price to follow?
Good morning,I haven’t been using Excel a lot but I’ve found a template for a quotation that I want to upgrade. On the first sheet I have all the information that needs to come in the quote, and the second sheet I made a table with all items that could come in the quote. Description, quantity, my price, clients price. No I’ve got the table at the point I can use it like I want but actually the prices that we sell for should be together with the description, so how can I use one pull down item and make the other colums, like price to follow? Read More
How can I Identify where Office 365 Connectors are used in my Teams
Is there a way to identify all the teams in my tenant that use office 365 connectors? With the announcement that Microsoft will be retired sconnectors soon I want to be proactive in knowing which of my teams need help to migrate away from their usage.
Thanks
Is there a way to identify all the teams in my tenant that use office 365 connectors? With the announcement that Microsoft will be retired sconnectors soon I want to be proactive in knowing which of my teams need help to migrate away from their usage.Thanks Read More
Error – Connect-ExchangeOnline Error Acquiring Token: System.Net.Http.HttpRequestException
Error
Connect-ExchangeOnline
Error Acquiring Token:
System.Net.Http.HttpRequestException: An error occurred while sending the request. —> System.Net.WebException: Remote name could not be resolved: ‘server.proxy.local’
Error Connect-ExchangeOnlineError Acquiring Token:System.Net.Http.HttpRequestException: An error occurred while sending the request. —> System.Net.WebException: Remote name could not be resolved: ‘server.proxy.local’ Read More
re-org index and statistics update jobs are failing
how to resolve failing re-org index and statistics jobs, there are not enough information in the logfile and I verified there are no jobs running at the same time,
Message
Executed as user: CFSsqlmsdata2016svr. ….0.4125.3 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 8:00:00 PM Progress: 2024-07-03 20:00:01.90 Source: {5FB65CC1-7283-42ED-84DA-2A2506E11D2F} Executing query “DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp…”.: 100% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 0% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ApiPoller_CS_Detail_hi…”.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ValueToMonitor_CS_Deta…”.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbNamingConte…”.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbSite_CS_Det…”.: 4% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentError_CS_Detail_his…”.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentStatus_CS_Detail_hi…”.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_DynamicEvidence_CS_Detail_hi…”.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Detail] ON [dbo]….”.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 9% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Hourly] ON [dbo]….”.: 10% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 10% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItemStatus_Hourly] ON …”.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_PortEvidence_CS_Detail_hist]…”.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ProcessEvidence_CS_De… The package execution fa… The step failed.
wondering how to resolve this issue, if any idea please let me know
Thank You,
how to resolve failing re-org index and statistics jobs, there are not enough information in the logfile and I verified there are no jobs running at the same time, MessageExecuted as user: CFSsqlmsdata2016svr. ….0.4125.3 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 8:00:00 PM Progress: 2024-07-03 20:00:01.90 Source: {5FB65CC1-7283-42ED-84DA-2A2506E11D2F} Executing query “DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp…”.: 100% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 0% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ApiPoller_CS_Detail_hi…”.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ValueToMonitor_CS_Deta…”.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbNamingConte…”.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbSite_CS_Det…”.: 4% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentError_CS_Detail_his…”.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentStatus_CS_Detail_hi…”.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_DynamicEvidence_CS_Detail_hi…”.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Detail] ON [dbo]….”.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 9% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Hourly] ON [dbo]….”.: 10% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 10% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItemStatus_Hourly] ON …”.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_PortEvidence_CS_Detail_hist]…”.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ProcessEvidence_CS_De… The package execution fa… The step failed. wondering how to resolve this issue, if any idea please let me know Thank You, Read More
SMS Reminders
You cannot configure anything in your Bookings settings beyond a checkbox to turn the SMS feature on/off.
There is no ability to configure the reminders, for example, sending an SMS 1 hour before the meeting time.
Is there any way to control the SMS reminders like similar to Email reminders ?
Also is there a way to setup SMS reminders in Personal Bookings?
You cannot configure anything in your Bookings settings beyond a checkbox to turn the SMS feature on/off. There is no ability to configure the reminders, for example, sending an SMS 1 hour before the meeting time. Is there any way to control the SMS reminders like similar to Email reminders ? Also is there a way to setup SMS reminders in Personal Bookings? Read More
How to edit the default.aspx page at a Project Online site?
Hey,
I am pretty sure that I had edited the default.aspx page at https://xxxx.sharepoint.com/sites/pwa/default.aspx last October. However, I realized that I cannot update this default page anymore. I tried to append mode=edit at the end of the URL, but no luck.
Would you please advise how I should update this default.aspx page as a site collection administrator?
Thank you very much!
Hey, I am pretty sure that I had edited the default.aspx page at https://xxxx.sharepoint.com/sites/pwa/default.aspx last October. However, I realized that I cannot update this default page anymore. I tried to append mode=edit at the end of the URL, but no luck. Would you please advise how I should update this default.aspx page as a site collection administrator? Thank you very much! Read More
help.
Hello ,
I’m working with a pivot report that I built for almost two years, suddenly at some point, I can’t group date by month, even though everything was working properly, and I checked all the possibilities I know (date, blank, etc.).
The second part is that if I open the same file on another computer, I manage to group the date.
Anyone recognize the problem and know how to advise please.
Hello ,I’m working with a pivot report that I built for almost two years, suddenly at some point, I can’t group date by month, even though everything was working properly, and I checked all the possibilities I know (date, blank, etc.).The second part is that if I open the same file on another computer, I manage to group the date.Anyone recognize the problem and know how to advise please. Read More
Help. Csv file to excel
Hello,
I have a question about importing a csv file to excel.
When I am importing a csv file in excel, the time does not seem to import right. I convert the text to columns, but the time does something strange.
First in the csv file it is in minutes and in excel suddenly in seconds.
Second the numbers who end with a 0 get another number of numbers behind the comma. This results in a different alignment. Which results in that i cannot make the right calculations. These numbers are with a factor 1000 smaller than the numbers who are aligned normal.
(This happens on a macbook btw)
Does someone maybe know why this happens or knows a solution?
Thank you in advance!
Hello, I have a question about importing a csv file to excel. When I am importing a csv file in excel, the time does not seem to import right. I convert the text to columns, but the time does something strange. First in the csv file it is in minutes and in excel suddenly in seconds. Second the numbers who end with a 0 get another number of numbers behind the comma. This results in a different alignment. Which results in that i cannot make the right calculations. These numbers are with a factor 1000 smaller than the numbers who are aligned normal. (This happens on a macbook btw) Does someone maybe know why this happens or knows a solution? Thank you in advance! Read More
Using templates with Copilot in Word
Hi.
I am trying to figure out how to get Copilot in Word to draft a new document but using an existing .dotx template, but alias I just can’t.
I need to know if there’s specific steps to follow to be able to do that I’m not aware of or if I should just stop trying so hard because it’s simply something that is not available in Copilot for Word.
Thanks in advance.
Hi.I am trying to figure out how to get Copilot in Word to draft a new document but using an existing .dotx template, but alias I just can’t.I need to know if there’s specific steps to follow to be able to do that I’m not aware of or if I should just stop trying so hard because it’s simply something that is not available in Copilot for Word.Thanks in advance. Read More
Remove, Hide, or Relocate the Connection Bar in Windows App when in Full Screen on Cloud PC
When using Cloud PC in full screen mode the connection bar always pops up. It’s not Pinned so it auto hides.
This issue is the bar pops up anytime the mouse is on top of screen. When using a browser, for example, to navigate to a different tab the user has to mouse to top of the screen.
This mouse movement pops up the Connection bar which is VERY invasive and blocks a large portion of the top screen which blocks the browsers tabs.
Users have to shift this left/right every time or move the mouse away (wait till it disappears) then hope they have better aiming to click on tab without bringing curser to top of screen… or else the annoying Connection bar pops up.
Is there ANY method to be able to any of the these
Relocate the connection bar to left side screen (right side interferes with up/down scroll)Delay the connection bar popup for few seconds (mouse on top of screen few seconds to show connection bar)Or permanently remove it and use Windows hotkeys to break out of Full Screen modeAny other idea…
When using Cloud PC in full screen mode the connection bar always pops up. It’s not Pinned so it auto hides. This issue is the bar pops up anytime the mouse is on top of screen. When using a browser, for example, to navigate to a different tab the user has to mouse to top of the screen. This mouse movement pops up the Connection bar which is VERY invasive and blocks a large portion of the top screen which blocks the browsers tabs.Users have to shift this left/right every time or move the mouse away (wait till it disappears) then hope they have better aiming to click on tab without bringing curser to top of screen… or else the annoying Connection bar pops up. Is there ANY method to be able to any of the theseRelocate the connection bar to left side screen (right side interferes with up/down scroll)Delay the connection bar popup for few seconds (mouse on top of screen few seconds to show connection bar)Or permanently remove it and use Windows hotkeys to break out of Full Screen modeAny other idea… Read More
Survey settings in CsTeamsFeedbackPolicy
Hello
Please i need your help on this issue.
Could you please confirm if the below policy settings are correct.
My requirement is :
“Give FeedBack” option should appear in Teams.
Allow “Surveys” to appear for users to which they can respond.
Hence I have set “UserInitiatedMode” to Disabled
and
“ ReceiveSurveysMode” to Enabled in the TeamsFeedbackpolicy.
Below details for reference, please let me know if below settings are correct.
PS C:] Get-CsTeamsFeedbackPolicy -Identity Tag:DevTenant_SurveysMode
Identity : Tag:DevTenant_SurveysMode
UserInitiatedMode : Disabled
ReceiveSurveysMode : Enabled
AllowScreenshotCollection : False
AllowEmailCollection : False
AllowLogCollection : False
EnableFeatureSuggestions :
I haven’t received “Survey prompt” yet for account to which this policy was applied.
Hello Please i need your help on this issue. Could you please confirm if the below policy settings are correct.My requirement is :”Give FeedBack” option should appear in Teams.Allow “Surveys” to appear for users to which they can respond. Hence I have set “UserInitiatedMode” to Disabled and” ReceiveSurveysMode” to Enabled in the TeamsFeedbackpolicy.Below details for reference, please let me know if below settings are correct. PS C:] Get-CsTeamsFeedbackPolicy -Identity Tag:DevTenant_SurveysModeIdentity : Tag:DevTenant_SurveysModeUserInitiatedMode : DisabledReceiveSurveysMode : EnabledAllowScreenshotCollection : FalseAllowEmailCollection : FalseAllowLogCollection : FalseEnableFeatureSuggestions : I haven’t received “Survey prompt” yet for account to which this policy was applied. Read More
How to know the original path of an inserted image ?
Hi all,
I have a problem with an Excel file. In this file I used the feature “Insert image above cell” and I chose an image from a local path (on my hard drive). So far so good.
However, if I copy the file to another computer, the image is gone. That’s the concept.
Now the problem is that this an auto-generated Excel file from an external program. I know where the images are but I generated multiple reports, modified some of the images and changed the images in some excel files to point to other folders. It works fine on the original computer but I copied the Excel files and the images (or so I thought) to the other computer and some images are missing.
The question is : how do I know the original path of the image so that I can also copy it and re-link it.
The additionnal question to that is : I modified the local image for some reason (didn’t change the path) and I want to update the shown image to include my modification without closing and opening again the Excel file. Is that possible and how ? But the first question is really more important because basically I have a new laptop and I need to recover the whole file and images to export it if needed later in time when I won’t have the old laptop anymore.
Hi all,I have a problem with an Excel file. In this file I used the feature “Insert image above cell” and I chose an image from a local path (on my hard drive). So far so good. However, if I copy the file to another computer, the image is gone. That’s the concept.Now the problem is that this an auto-generated Excel file from an external program. I know where the images are but I generated multiple reports, modified some of the images and changed the images in some excel files to point to other folders. It works fine on the original computer but I copied the Excel files and the images (or so I thought) to the other computer and some images are missing.The question is : how do I know the original path of the image so that I can also copy it and re-link it. The additionnal question to that is : I modified the local image for some reason (didn’t change the path) and I want to update the shown image to include my modification without closing and opening again the Excel file. Is that possible and how ? But the first question is really more important because basically I have a new laptop and I need to recover the whole file and images to export it if needed later in time when I won’t have the old laptop anymore. Read More
Adding SharePoint tab using graph not possible when pointing to folder
Hi all,
we are struggling to find a solution for this issue:
We need to add a SPO folder as a tab to Team channel using Graph;We cannot use the website tab, as it produces authentication issues (401 – Unauthorized);It works fine when adding a library, but when adding a folder extension, this does not work and returns “Not Found”;When trying to patch a folder path over an existing tab, it works for a couple of seconds and then reverts back to just the library.
Did anyone get this to work? Below our call:
https://graph.microsoft.com/beta/teams/[team]/channels/[channel]/tabs
{
“displayName”: “[name]”,
“email address removed for privacy reasons”: “https://graph.microsoft.com/v1.0/appCatalogs/teamsApps/com.microsoft.teamspace.tab.files.sharepoint”,
“configuration”: {
“entityId”: “”,
“contentUrl”: “https://[domain].sharepoint.com/sites/[site]/Shared%20Documents/General”,
“websiteUrl”: “https://[domain].sharepoint.com/sites/[site]/Shared%20Documents/General”
}
}
Has anyone managed to get this to work or reliably overcome the Unauthorized issue?
Cheers 🙂
Max
Hi all,we are struggling to find a solution for this issue: We need to add a SPO folder as a tab to Team channel using Graph;We cannot use the website tab, as it produces authentication issues (401 – Unauthorized);It works fine when adding a library, but when adding a folder extension, this does not work and returns “Not Found”;When trying to patch a folder path over an existing tab, it works for a couple of seconds and then reverts back to just the library.Did anyone get this to work? Below our call: https://graph.microsoft.com/beta/teams/[team]/channels/[channel]/tabs
{
“displayName”: “[name]”,
“email address removed for privacy reasons”: “https://graph.microsoft.com/v1.0/appCatalogs/teamsApps/com.microsoft.teamspace.tab.files.sharepoint”,
“configuration”: {
“entityId”: “”,
“contentUrl”: “https://[domain].sharepoint.com/sites/[site]/Shared%20Documents/General”,
“websiteUrl”: “https://[domain].sharepoint.com/sites/[site]/Shared%20Documents/General”
}
} Has anyone managed to get this to work or reliably overcome the Unauthorized issue?Cheers :)Max Read More
input serial number in intune while publishing apps
Hi All,
I am trying to install a .msi using Intune, it shows pending because I do not see an option to input serial number in the policy, is there a way to provide the serial number ?
Thanks in Advance
Alex
Hi All, I am trying to install a .msi using Intune, it shows pending because I do not see an option to input serial number in the policy, is there a way to provide the serial number ? Thanks in Advance Alex Read More
vlookup closet strange mismatch (just two value: 0.051 & 0.071)
I have a vlookup question. Attached is a simple worksheet. Why does Cell G7 get the value 28 when I expect the lookup result to be 30?
The formula is lookup the closet match value on A2 to C12.
column F =VLOOKUP($E2,$A$2:$C$12,3)
I have a vlookup question. Attached is a simple worksheet. Why does Cell G7 get the value 28 when I expect the lookup result to be 30?The formula is lookup the closet match value on A2 to C12.column F =VLOOKUP($E2,$A$2:$C$12,3) Read More
How to report on SharePoint activity and usage
Hello
Please i need your help on this issue.
I want to report the SharePoint activity and usage report to management
Hello Please i need your help on this issue. I want to report the SharePoint activity and usage report to management Read More
Count distinct values based on 2 criteria in other columns
Hi all,
First post here, tried to find my answers, but didn’t get a complete solution for my issue, so hope you can help.
I have to count no of distinct trial numbers in a range in column A based on 2 criteria.
I want the trialnumber only to be counted if:
criteria 1: the part rated in column D is a leaf (either leaf1, leaf2, leaf3) and not a plant
criteria 2: there is a value in column z (so no empty cell)
Using the information found in the community, I currently managed to get my distinct trial numbers using this formula: =SUM(1/COUNTIF($A3:$A15;$A3:$A15))
I also managed to get counts based on it being a leaf using this formula: =COUNTIF($D3:$D15;”LEAF*”)
But I’m not managing to get the 2 combined so that he only counts the distict value if it is a leaf, let alone to add the additional criteria that there must be a value in column Z
Thanks for your help
PS. Probably it would be useful to have my file, but I’m not sure how I need to add this to the post.
Hi all, First post here, tried to find my answers, but didn’t get a complete solution for my issue, so hope you can help. I have to count no of distinct trial numbers in a range in column A based on 2 criteria. I want the trialnumber only to be counted if:criteria 1: the part rated in column D is a leaf (either leaf1, leaf2, leaf3) and not a plantcriteria 2: there is a value in column z (so no empty cell) Using the information found in the community, I currently managed to get my distinct trial numbers using this formula: =SUM(1/COUNTIF($A3:$A15;$A3:$A15))I also managed to get counts based on it being a leaf using this formula: =COUNTIF($D3:$D15;”LEAF*”) But I’m not managing to get the 2 combined so that he only counts the distict value if it is a leaf, let alone to add the additional criteria that there must be a value in column Z Thanks for your help PS. Probably it would be useful to have my file, but I’m not sure how I need to add this to the post. Read More