Category: Microsoft
Category Archives: Microsoft
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
AttaPoll Referral Code “SCQTE” Get Free 20$
AttaPoll Referral Code “SCQTE” Get Free Rewards 20$ & Refer and Earn More.
Q: What is AttaPoll?
A: AttaPoll is a mobile app that pays its users for completing surveys. It is a platform that connects businesses and market researchers with individuals who are willing to share their opinions and experiences. AttaPoll offers a simple way for companies to gather data and insights about their products or services, while also providing a way for individuals to earn some extra cash.
Q: How much do the surveys pay on AttaPoll?
A: The amount paid for surveys on AttaPoll varies depending on the length and complexity of the survey. Generally, shorter surveys pay around $0.25 to $0.50, while longer surveys can pay up to $5.00 or more. Users are usually notified of the amount they will be paid for a survey before they begin, so they can decide whether or not it is worth their time.
Q: What is AttaPoll Refer and Earn?
A: AttaPoll Refer and Earn is a program that allows users to earn 10% of the money their referred friend makes by completing surveys on AttaPoll. There is no upper limit to the amount that can be earned through referrals.
Q: How does the AttaPoll Refer and Earn program work?
A: To participate in the AttaPoll Refer and Earn program, users must first invite their friends to download and use the AttaPoll app. Once their friends sign up and complete surveys on the app, the user will earn 10% of the money their friend makes from completing those surveys.
Q: What is referral code for AttaPoll?
A: AttaPoll referral code is SCQTE.
Q: Is there a limit to how many friends I can refer to AttaPoll?
A: No, there is no limit to how many friends a user can refer to AttaPoll. The more friends a user refers, the more they can potentially earn through the Refer and Earn program.
Q: How do I refer my friends to AttaPoll?
A: Users can refer their friends to AttaPoll by sharing their unique referral link with them. This link can be found in the “Refer and Earn” section of the app.
Q: Can I find Attapoll Payment Proof from other users?
A: Yes, users often share their Attapoll payment proof on various platforms. To find payment proof, you can explore online forums, social media groups, or even Attapoll’s official channels. Genuine payment proofs from other users can provide assurance about the platform’s legitimacy and prompt payment process.
Q: How will I receive the money earned through the AttaPoll Refer and Earn program?
A: The money earned through the AttaPoll Refer and Earn program will be added to the user’s AttaPoll account balance. Users can cash out their earnings using various payment options available on the app.
Q: Can I track the progress of my referrals in the AttaPoll Refer and Earn program?
A: Yes, users can track the progress of their referrals in the “Refer and Earn” section of the app. The section shows how many friends have signed up using their referral link and how much money they have earned through their referrals.
Q: Is it possible to refer myself or create fake accounts to earn more money through the AttaPoll Refer and Earn program?
A: No, it is not allowed to refer oneself or create fake accounts to earn more money through the AttaPoll Refer and Earn program. AttaPoll has measures in place to detect and prevent such fraudulent activities and users found engaging in such activities will be banned from the platform.
Q: How do I get paid on AttaPoll?
A: Getting paid on AttaPoll is straightforward. Users can receive payments through PayPal or redeem their earnings for gift cards to popular retailers like Amazon or iTunes. The minimum payout threshold for PayPal is $3.00, while gift cards start at $5.00. Once a user has accumulated enough earnings, they can request a payout through the app.
Q: What are the surveys about on AttaPoll?
A: The surveys on AttaPoll cover a wide range of topics, from consumer products to current events. Some surveys are focused on specific industries or professions, while others are more general in nature. Before starting a survey, users are usually provided with some basic information about the topic and the purpose of the survey. Users can choose which surveys they want to participate in, based on their interests and availability.
Q: How long are the surveys on AttaPoll?
A: The length of surveys on AttaPoll can vary greatly. Some surveys can be completed in just a few minutes, while others can take up to 30 minutes or more to complete. Users are usually provided with an estimate of how long a survey will take before they begin, so they can plan accordingly. Surveys that take longer to complete usually pay more than shorter surveys, so users can choose which surveys they want to take based on their available time and payout rates.
Q: Why should I download AttaPoll?
A: Downloading AttaPoll can be a great way to earn some extra cash in your free time. The app is easy to use and provides a variety of survey opportunities that cater to your interests and demographic profile. Additionally, AttaPoll offers a low minimum payout threshold, which means you can cash out your earnings relatively quickly.
Q: How does AttaPoll work?
A: AttaPoll partners with market research companies that are looking to gather consumer insights. When you sign up for AttaPoll, you’ll be asked to provide some basic information about yourself, such as your age, gender, and location. This information is used to match you with surveys that are relevant to your interests and demographics.
When a new survey becomes available, AttaPoll will send you a notification. You’ll then be able to take the survey within the app, and once you’ve completed it, you’ll earn a certain number of points. The number of points you earn will vary depending on the length and complexity of the survey.
Q: Can I take surveys on AttaPoll and earn rewards?
A: Yes, you can take surveys on AttaPoll and earn rewards. As mentioned, you’ll earn points for each survey you complete. Once you accumulate enough points, you can cash out your earnings via PayPal, or you can redeem them for gift cards from popular retailers such as Amazon, Starbucks, and Target.
Q: What are the payment options available on AttaPoll?
A: AttaPoll offers two payment options: PayPal and gift cards. To cash out your earnings via PayPal, you’ll need to have a PayPal account linked to your AttaPoll account. Alternatively, you can choose to redeem your points for gift cards from a variety of popular retailers.
Q: Is it possible to donate my earnings from AttaPoll to charity?
A: AttaPoll does not have a direct option to donate earnings to charity. However, you can use your earnings to purchase a gift card for a charity of your choice and then donate it. This is a great way to use your earnings for a good cause.
AttaPoll Referral Code “SCQTE” Get Free Rewards 20$ & Refer and Earn More. Q: What is AttaPoll?A: AttaPoll is a mobile app that pays its users for completing surveys. It is a platform that connects businesses and market researchers with individuals who are willing to share their opinions and experiences. AttaPoll offers a simple way for companies to gather data and insights about their products or services, while also providing a way for individuals to earn some extra cash. Q: How much do the surveys pay on AttaPoll?A: The amount paid for surveys on AttaPoll varies depending on the length and complexity of the survey. Generally, shorter surveys pay around $0.25 to $0.50, while longer surveys can pay up to $5.00 or more. Users are usually notified of the amount they will be paid for a survey before they begin, so they can decide whether or not it is worth their time. Q: What is AttaPoll Refer and Earn?A: AttaPoll Refer and Earn is a program that allows users to earn 10% of the money their referred friend makes by completing surveys on AttaPoll. There is no upper limit to the amount that can be earned through referrals. Q: How does the AttaPoll Refer and Earn program work?A: To participate in the AttaPoll Refer and Earn program, users must first invite their friends to download and use the AttaPoll app. Once their friends sign up and complete surveys on the app, the user will earn 10% of the money their friend makes from completing those surveys. Q: What is referral code for AttaPoll?A: AttaPoll referral code is SCQTE. Q: Is there a limit to how many friends I can refer to AttaPoll?A: No, there is no limit to how many friends a user can refer to AttaPoll. The more friends a user refers, the more they can potentially earn through the Refer and Earn program. Attapoll Refer and Earn Proof Q: How do I refer my friends to AttaPoll?A: Users can refer their friends to AttaPoll by sharing their unique referral link with them. This link can be found in the “Refer and Earn” section of the app. Q: Can I find Attapoll Payment Proof from other users?A: Yes, users often share their Attapoll payment proof on various platforms. To find payment proof, you can explore online forums, social media groups, or even Attapoll’s official channels. Genuine payment proofs from other users can provide assurance about the platform’s legitimacy and prompt payment process. Attapoll Earning Proof Q: How will I receive the money earned through the AttaPoll Refer and Earn program?A: The money earned through the AttaPoll Refer and Earn program will be added to the user’s AttaPoll account balance. Users can cash out their earnings using various payment options available on the app. Attapoll Earning Proof Paypal Q: Can I track the progress of my referrals in the AttaPoll Refer and Earn program?A: Yes, users can track the progress of their referrals in the “Refer and Earn” section of the app. The section shows how many friends have signed up using their referral link and how much money they have earned through their referrals. Q: Is it possible to refer myself or create fake accounts to earn more money through the AttaPoll Refer and Earn program?A: No, it is not allowed to refer oneself or create fake accounts to earn more money through the AttaPoll Refer and Earn program. AttaPoll has measures in place to detect and prevent such fraudulent activities and users found engaging in such activities will be banned from the platform. Q: How do I get paid on AttaPoll?A: Getting paid on AttaPoll is straightforward. Users can receive payments through PayPal or redeem their earnings for gift cards to popular retailers like Amazon or iTunes. The minimum payout threshold for PayPal is $3.00, while gift cards start at $5.00. Once a user has accumulated enough earnings, they can request a payout through the app. Q: What are the surveys about on AttaPoll?A: The surveys on AttaPoll cover a wide range of topics, from consumer products to current events. Some surveys are focused on specific industries or professions, while others are more general in nature. Before starting a survey, users are usually provided with some basic information about the topic and the purpose of the survey. Users can choose which surveys they want to participate in, based on their interests and availability. Q: How long are the surveys on AttaPoll?A: The length of surveys on AttaPoll can vary greatly. Some surveys can be completed in just a few minutes, while others can take up to 30 minutes or more to complete. Users are usually provided with an estimate of how long a survey will take before they begin, so they can plan accordingly. Surveys that take longer to complete usually pay more than shorter surveys, so users can choose which surveys they want to take based on their available time and payout rates. Q: Why should I download AttaPoll?A: Downloading AttaPoll can be a great way to earn some extra cash in your free time. The app is easy to use and provides a variety of survey opportunities that cater to your interests and demographic profile. Additionally, AttaPoll offers a low minimum payout threshold, which means you can cash out your earnings relatively quickly. Q: How does AttaPoll work?A: AttaPoll partners with market research companies that are looking to gather consumer insights. When you sign up for AttaPoll, you’ll be asked to provide some basic information about yourself, such as your age, gender, and location. This information is used to match you with surveys that are relevant to your interests and demographics. When a new survey becomes available, AttaPoll will send you a notification. You’ll then be able to take the survey within the app, and once you’ve completed it, you’ll earn a certain number of points. The number of points you earn will vary depending on the length and complexity of the survey. Q: Can I take surveys on AttaPoll and earn rewards?A: Yes, you can take surveys on AttaPoll and earn rewards. As mentioned, you’ll earn points for each survey you complete. Once you accumulate enough points, you can cash out your earnings via PayPal, or you can redeem them for gift cards from popular retailers such as Amazon, Starbucks, and Target. Q: What are the payment options available on AttaPoll?A: AttaPoll offers two payment options: PayPal and gift cards. To cash out your earnings via PayPal, you’ll need to have a PayPal account linked to your AttaPoll account. Alternatively, you can choose to redeem your points for gift cards from a variety of popular retailers. Q: Is it possible to donate my earnings from AttaPoll to charity?A: AttaPoll does not have a direct option to donate earnings to charity. However, you can use your earnings to purchase a gift card for a charity of your choice and then donate it. This is a great way to use your earnings for a good cause. Read More
Maximum value for SharePoint List unique ID
Hi everyone,
I have a SharePoint List that gets updated daily. I have 25000-30000 items that get completely deleted every night and then created again with new values and content. So every new item gets a new list ID.
I’m a little bit worried because, even though SharePoint lists can store up to 30 Million items, what happens when the unique ID assigned to each item gets “overflowed”?
For example, right now the last item’s ID is 480368, and as I said before I create 30000 new items every single day , so doing a simple math it would take 1000 days to reach an ID number of 30000000 (if that’s possible, I don’t even know).
What happens when the ID reaches a limit? Would it break the list? Will I be able to keep creating new items?
Just to make it completely clear: the list will never reach the 30 million limit. It will always stay on 25000-30000 items. But I’m scared that the ID will break this process in less than 3 years.
Thanks for your help!
Hi everyone, I have a SharePoint List that gets updated daily. I have 25000-30000 items that get completely deleted every night and then created again with new values and content. So every new item gets a new list ID. I’m a little bit worried because, even though SharePoint lists can store up to 30 Million items, what happens when the unique ID assigned to each item gets “overflowed”? For example, right now the last item’s ID is 480368, and as I said before I create 30000 new items every single day , so doing a simple math it would take 1000 days to reach an ID number of 30000000 (if that’s possible, I don’t even know). What happens when the ID reaches a limit? Would it break the list? Will I be able to keep creating new items? Just to make it completely clear: the list will never reach the 30 million limit. It will always stay on 25000-30000 items. But I’m scared that the ID will break this process in less than 3 years. Thanks for your help! Read More
How do you update analytic rules with Az.Securityinsights Powershell module and ARM templates
I have read all commands from the PowerShell module Az.SecurityInsights but I can’t find anyone taking ARM-template or Json file as argument.
I think there are non-official PowerShell modules that have this feature, but they are 3 years old, and I want to use the official stuff.
I have created ARM-templates that works in the import feature in the GUI but now we want to do this with code.
In the following page there is a statement that say that its possible to manage rules with Powershell:
“To automate rule enablement, push rules to Microsoft Sentinel via API and PowerShell , although doing so requires additional effort. When using API or PowerShell, you must first export the rules to JSON before enabling the rules. API or PowerShell may be helpful when enabling rules in multiple instances of Microsoft Sentinel with identical settings in each instance.”
https://learn.microsoft.com/en-us/azure/sentinel/create-analytics-rules?tabs=azure-portal
I have read all commands from the PowerShell module Az.SecurityInsights but I can’t find anyone taking ARM-template or Json file as argument.I think there are non-official PowerShell modules that have this feature, but they are 3 years old, and I want to use the official stuff. I have created ARM-templates that works in the import feature in the GUI but now we want to do this with code. In the following page there is a statement that say that its possible to manage rules with Powershell: “To automate rule enablement, push rules to Microsoft Sentinel via API and PowerShell , although doing so requires additional effort. When using API or PowerShell, you must first export the rules to JSON before enabling the rules. API or PowerShell may be helpful when enabling rules in multiple instances of Microsoft Sentinel with identical settings in each instance.”https://learn.microsoft.com/en-us/azure/sentinel/create-analytics-rules?tabs=azure-portal Read More
Is the use of NVARCHAR(MAX) acceptable for this scenario?
Hi,
I’m using Azure Data Factory (ADF) Pipelines to ingest several external datasources into our domain. As you’ll know, I need to create a target database table for each source table I’m looking to ingest.
Upon creating the target tables for the first time, I can look at the source tables field properties (datatype and size) and set those same properties for the target tables. My concern is if the source owners change the source field properties in the future and do not notify us (which is a strong possibility) then the ADF Pipelines may fail in which I will then investigate and resolve. There could be another scenario where source field A is 20 characters long, and so I set the target field to be 20 characters long, but then the source field is amended to be 50 characters long, and I’m not informed. This may not break the ADF Pipeline execution but simply truncate the data.
An approach would be to set each target field to be NVARCHAR( MAX). This would (should) avoid the situation above. I’m a one-person band on all things data at my company and am attempting to juggle many things in the best way I can. I feel the NVARCHAR(MAX) approach would reduce headaches and needed time to investigate.
Questions:
1) I understand it isn’t good practice to use NVARCHAR(MAX) unless needed, but would you advise it acceptable with what I’m concerned about?
2) I understand using NVARCHAR(MAX) takes up more database size (allows for 2Gb) but if we’re not actually filling that 2Gb up does it cost more in Azure SQL Server? The volume of data we have isn’t great but I am still considering the costs involved.
TLDR: Would setting target fields as NVARCHAR(MAX) increase Azure SQL Server costs even if the fields only contain 20 characters?
Thanks in advance.
Hi,I’m using Azure Data Factory (ADF) Pipelines to ingest several external datasources into our domain. As you’ll know, I need to create a target database table for each source table I’m looking to ingest.Upon creating the target tables for the first time, I can look at the source tables field properties (datatype and size) and set those same properties for the target tables. My concern is if the source owners change the source field properties in the future and do not notify us (which is a strong possibility) then the ADF Pipelines may fail in which I will then investigate and resolve. There could be another scenario where source field A is 20 characters long, and so I set the target field to be 20 characters long, but then the source field is amended to be 50 characters long, and I’m not informed. This may not break the ADF Pipeline execution but simply truncate the data.An approach would be to set each target field to be NVARCHAR( MAX). This would (should) avoid the situation above. I’m a one-person band on all things data at my company and am attempting to juggle many things in the best way I can. I feel the NVARCHAR(MAX) approach would reduce headaches and needed time to investigate.Questions:1) I understand it isn’t good practice to use NVARCHAR(MAX) unless needed, but would you advise it acceptable with what I’m concerned about?2) I understand using NVARCHAR(MAX) takes up more database size (allows for 2Gb) but if we’re not actually filling that 2Gb up does it cost more in Azure SQL Server? The volume of data we have isn’t great but I am still considering the costs involved.TLDR: Would setting target fields as NVARCHAR(MAX) increase Azure SQL Server costs even if the fields only contain 20 characters?Thanks in advance. Read More
The option “Add a content type” is gone for SharePoint Lists
Hi,
I have a problem with adding a new content type to a SharePoint list. NOT a library. A list.
To add a new content type to a list, you can click the “Add column” and then scroll to the bottom and there you *should* find the option “Add a content type”.
Well, It’s not there anymore.
This is what I see for every list, on every site, on every tenant I tried.
Enabling/disabling content type management doesn’t help.
I can add existing content types but I can’t add a new one.
So, what’s going on? Has this moved?
Thanks,
Bart
Hi,I have a problem with adding a new content type to a SharePoint list. NOT a library. A list.To add a new content type to a list, you can click the “Add column” and then scroll to the bottom and there you *should* find the option “Add a content type”.Well, It’s not there anymore.This is what I see for every list, on every site, on every tenant I tried.Enabling/disabling content type management doesn’t help.I can add existing content types but I can’t add a new one.So, what’s going on? Has this moved? Thanks,Bart Read More
Import ACCDB to SQL SERVER
Hi… working with SQL SERVER MANAGEMENT STUDIO 20.1, I try to import accdb database, and it is impossible. It only allows me to import data from mdb databases.
Any help please?
Thanks in advanced!
Hi… working with SQL SERVER MANAGEMENT STUDIO 20.1, I try to import accdb database, and it is impossible. It only allows me to import data from mdb databases.Any help please?Thanks in advanced! Read More
Windows hello for business for Hybrid Entra Join
Environment:
-No UPN matching between onprem AD and Azure, Third party federation and User provisioning .
-Hybrid Entra Joined devices
-Enrolled to Intune using device credentials as SCCM is setup with co management (Cloud Attach).
Question:
Whether setting up Windows hello for business (Which was working before enrollment) using GPO / or Intune. An error is returned.
Pin:
“this sign in option is only available when connected to your organization’s network”
“Fingerprint and Face”
“The option is currently unavailable”
Multiple methods to setup WFH was attempted and none worked so far.
-Devices -> Win 10 -> Enrollment -> “Configure Windows hello for business”
-Using Custom settings as described here(CSP or GPO):
https://learn.microsoft.com/en-us/windows/security/identity-protection/hello-for-business/configure
-Biometrics devices updated/ Windows updates installed/ All devices and users affected in the organization.
-What could be the issue? Any best effort to get the windows hello for business working again?
Environment:-No UPN matching between onprem AD and Azure, Third party federation and User provisioning .-Hybrid Entra Joined devices-Enrolled to Intune using device credentials as SCCM is setup with co management (Cloud Attach).Question:Whether setting up Windows hello for business (Which was working before enrollment) using GPO / or Intune. An error is returned.Pin:”this sign in option is only available when connected to your organization’s network””Fingerprint and Face””The option is currently unavailable”Multiple methods to setup WFH was attempted and none worked so far.-Devices -> Win 10 -> Enrollment -> “Configure Windows hello for business”-Using Custom settings as described here(CSP or GPO):https://learn.microsoft.com/en-us/windows/security/identity-protection/hello-for-business/configure-Biometrics devices updated/ Windows updates installed/ All devices and users affected in the organization.-What could be the issue? Any best effort to get the windows hello for business working again? Read More
Auto populate a calendar
I am looking for pointers on how to auto populate a calendar with the info in the attached file, basically start and end info with course and subject info
I am looking for pointers on how to auto populate a calendar with the info in the attached file, basically start and end info with course and subject info Read More
How to download songs on Spotify to my computer
Recently , I found some great tracks on Spotify that I’d love to download and listen to offline on my computer. However, I’m not entirely sure how to go about this. When right click on the song, there is no DOWNLOAD option available.
I’ve heard that there are specific tools that can help with downloading songs on Spotify, but the suggestion from Google search is crap! I’m looking for a reliable and straightforward way to do it. Could anyone provide some guidance on how to download Spotify songs onto my computer?
Regards,
Stephane
Recently , I found some great tracks on Spotify that I’d love to download and listen to offline on my computer. However, I’m not entirely sure how to go about this. When right click on the song, there is no DOWNLOAD option available. I’ve heard that there are specific tools that can help with downloading songs on Spotify, but the suggestion from Google search is crap! I’m looking for a reliable and straightforward way to do it. Could anyone provide some guidance on how to download Spotify songs onto my computer? Regards,Stephane Read More
Trying to report mail usage, internal vs externally sent messages
Hi,
I am trying to find a way that I can report per user per day the number of messages sent, split between internal or external. My company has a few different domains that we class as Internal, checked the 365 Admin > Reports section but nothing there appears to provide the breakdown.
Has anyone done this, if so, how exactly, don’t mind if PowerShell or GUI
Hi,I am trying to find a way that I can report per user per day the number of messages sent, split between internal or external. My company has a few different domains that we class as Internal, checked the 365 Admin > Reports section but nothing there appears to provide the breakdown.Has anyone done this, if so, how exactly, don’t mind if PowerShell or GUI Read More
Sync Emails with microsoft email to main organisation (for us NHS mail) email together?
Hi
I want to sync the Microsoft account with our organisation (NHS) email account, is this possible?
We need this to sync into the staffs calendars etc but if its linked with our Microsoft log in (which is a different email) we will need it to be sync. Or is there a way to forward/redirect emails to the NHS account?
We need it to be linked with the account as we do not have permissions etc in the NHS account (as says do not have access to create shared bookings but it is an option on the other Microsoft email account as there licence is linked with this). However this is not the main account we use and need this sync together. Please can i check this ASAP?
Thanks!!
HiI want to sync the Microsoft account with our organisation (NHS) email account, is this possible? We need this to sync into the staffs calendars etc but if its linked with our Microsoft log in (which is a different email) we will need it to be sync. Or is there a way to forward/redirect emails to the NHS account? We need it to be linked with the account as we do not have permissions etc in the NHS account (as says do not have access to create shared bookings but it is an option on the other Microsoft email account as there licence is linked with this). However this is not the main account we use and need this sync together. Please can i check this ASAP? Thanks!! Read More
Microsoft Teams VOIP capability
Hi Team,
Here we have a breakdown of the requirements as per our understanding i am looking for this solution for the India location:
VoIP service to connect users to customer support agents via data calls.Free data calls for customers, including international connections, ensuring no extra charges.SDKs for both iOS and Android platforms to facilitate easy integration using a Call to Connect (CTC) feature.An admin panel for call logs, monitoring, and analytics, offering a robust dashboard experience.Intended for VIP users, implying initially low traffic.VoIP service that allows their VIP users to call directly to their customer support agents from their app.
Need your suggestion? Is it possible to achieve the solution mentioned above using Microsoft Teams? If feasible, could you please guide us on how to implement it? Your guidance on this matter would be highly appreciated.
Hi Team, Here we have a breakdown of the requirements as per our understanding i am looking for this solution for the India location: VoIP service to connect users to customer support agents via data calls.Free data calls for customers, including international connections, ensuring no extra charges.SDKs for both iOS and Android platforms to facilitate easy integration using a Call to Connect (CTC) feature.An admin panel for call logs, monitoring, and analytics, offering a robust dashboard experience.Intended for VIP users, implying initially low traffic.VoIP service that allows their VIP users to call directly to their customer support agents from their app. Need your suggestion? Is it possible to achieve the solution mentioned above using Microsoft Teams? If feasible, could you please guide us on how to implement it? Your guidance on this matter would be highly appreciated. @mgormsen Read More
There is no shadow when moving mouse upon an adaptive card column which was set “Selection action”.
There is a shadow when moving mouse upon an adaptive card column which was set “Selection action” in adaptive card designer.
However, with same adaptive card codes, there is no shadow when moving mouse upon an adaptive card column which was set “Selection action” in teams chat.
The adaptive card codes is :
{
“type”: “AdaptiveCard”,
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“version”: “1.6”,
“body”: [
{
“type”: “ColumnSet”,
“columns”: [
{
“type”: “Column”,
“width”: “stretch”,
“items”: [
{
“type”: “TextBlock”,
“text”: “New TextBlock”,
“wrap”: true
}
],
“selectAction”: {
“type”: “Action.OpenUrl”,
“url”: “https://adaptivecards.io/designer/”
}
}
]
}
]
}
There is a shadow when moving mouse upon an adaptive card column which was set “Selection action” in adaptive card designer. However, with same adaptive card codes, there is no shadow when moving mouse upon an adaptive card column which was set “Selection action” in teams chat. The adaptive card codes is : {
“type”: “AdaptiveCard”,
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“version”: “1.6”,
“body”: [
{
“type”: “ColumnSet”,
“columns”: [
{
“type”: “Column”,
“width”: “stretch”,
“items”: [
{
“type”: “TextBlock”,
“text”: “New TextBlock”,
“wrap”: true
}
],
“selectAction”: {
“type”: “Action.OpenUrl”,
“url”: “https://adaptivecards.io/designer/”
}
}
]
}
]
} Read More
Vlookup with 2 scenarios
Hi All, I am trying to formulate a formula to lookup two values. One is the tag number and the other the date and then it should return the test results in column 4 of the test results tab.
=IFERROR(VLOOKUP(A3, Table10, 1, FALSE)+VLOOKUP(X3, Table10, 2, FALSE)=VLOOKUP(A3,Table10,4,FALSE), “Not Tested”)
Hi All, I am trying to formulate a formula to lookup two values. One is the tag number and the other the date and then it should return the test results in column 4 of the test results tab. =IFERROR(VLOOKUP(A3, Table10, 1, FALSE)+VLOOKUP(X3, Table10, 2, FALSE)=VLOOKUP(A3,Table10,4,FALSE), “Not Tested”) Read More