Category: Microsoft
Category Archives: Microsoft
Preservation Hold Reporting on all SharePoint Online Sites within a Tenant
Hello everyone,
I’m trying to find out if there was a way to report on Preservation Holds for all SharePoint Online sites in a tenant. What I want to know is:
How many sites have preservation holdsHow many files/folders are in thereTotal size of preservation hold per site (pref in GB)
any thoughts, help or guidance would be very much appreciated.
Hello everyone, I’m trying to find out if there was a way to report on Preservation Holds for all SharePoint Online sites in a tenant. What I want to know is:How many sites have preservation holdsHow many files/folders are in thereTotal size of preservation hold per site (pref in GB)any thoughts, help or guidance would be very much appreciated. Read More
“.tmp.driveupload”
I am having an issue where my word doc (set to autosave to OneDrive business desktop app) on my PC is suddenly saved in a “.tmp.driveupload” folder online under a different file name (random numbers), with autosave switched off.
If I do not notice this happening, the change to the document is not saved under the expected folder and file name, resulting in no change made to the file I opened.
The only workaround I’ve found is to “save a copy” and overwrite the file I opened in the original folder. This only works if I notice the sudden name change and file save in the tmp folder. If I don’t, the changes are lost because the tmp file is deleted (to recycle bin) on exit and the tmp folder is not synced to my PC. I have to go online to the OneDrive business website, guess which file it may be, restore that from the OneDrive recycle bin, and hope it is the file I was looking for. The frequency of this happening means that there are numerous tmp files under pseudo file names to scour through.
One-hour plus on the phone with MS Office subscription support is of no help.
I am having an issue where my word doc (set to autosave to OneDrive business desktop app) on my PC is suddenly saved in a “.tmp.driveupload” folder online under a different file name (random numbers), with autosave switched off. If I do not notice this happening, the change to the document is not saved under the expected folder and file name, resulting in no change made to the file I opened. The only workaround I’ve found is to “save a copy” and overwrite the file I opened in the original folder. This only works if I notice the sudden name change and file save in the tmp folder. If I don’t, the changes are lost because the tmp file is deleted (to recycle bin) on exit and the tmp folder is not synced to my PC. I have to go online to the OneDrive business website, guess which file it may be, restore that from the OneDrive recycle bin, and hope it is the file I was looking for. The frequency of this happening means that there are numerous tmp files under pseudo file names to scour through. One-hour plus on the phone with MS Office subscription support is of no help. Read More
connecting data from two different excel sheets
I’ve got data records on one sheet (source) that includes a column of the names (of people) associated with each record. In another column, I have a 1 in each record for those persons that have expressed a desire for being a volunteer. I would like to find a way – using the criterion: a 1 in the ‘wanting to volunteer’ column – to copy the names from those records in the source sheet to a list (a column of cells) in a destination sheet, in the same workbook. I’ve attempted to use the advanced filter option in the data tab, but either that’s not the right tack or I’m not setting it up right. Any thoughts?
I’ve got data records on one sheet (source) that includes a column of the names (of people) associated with each record. In another column, I have a 1 in each record for those persons that have expressed a desire for being a volunteer. I would like to find a way – using the criterion: a 1 in the ‘wanting to volunteer’ column – to copy the names from those records in the source sheet to a list (a column of cells) in a destination sheet, in the same workbook. I’ve attempted to use the advanced filter option in the data tab, but either that’s not the right tack or I’m not setting it up right. Any thoughts? Read More
Microsoft 365 apps for macOS close and reinstall without notification – Known Issue
Hi, I was hoping to post this here to maybe get some more visibility about an outstanding issue regarding the built-in Intune Microsoft 365 apps for macOS package as documented here: ( Microsoft 365 apps for macOS close and reinstall without notification – Intune | Microsoft Learn )
We are still seeing this issue occurring where it appears that Intune is unable to correctly detect that the Office Suite for macOS was deployed. This causes the application to display as “Pending Install” and causes all M365 apps (Outlook, Teams (work or school), OneNote, OneDrive, Excel, Word, PowerPoint) to reinstall when device syncs, causing user loss of data and productivity. I’ve seen posts about this issue as far back as 2022. Is there any current work being done to address this issue? The current suggested resolution is to change the app assignment from “Required” to “Available for Enrolled Devices” which is not really ideal. We are using ABM with ADE (w/ user affinity). Mac OS Sonoma 14.5
If any MS MVP’s can post an update, that would be really helpful. @ScottSawyer
Hi, I was hoping to post this here to maybe get some more visibility about an outstanding issue regarding the built-in Intune Microsoft 365 apps for macOS package as documented here: ( Microsoft 365 apps for macOS close and reinstall without notification – Intune | Microsoft Learn ) We are still seeing this issue occurring where it appears that Intune is unable to correctly detect that the Office Suite for macOS was deployed. This causes the application to display as “Pending Install” and causes all M365 apps (Outlook, Teams (work or school), OneNote, OneDrive, Excel, Word, PowerPoint) to reinstall when device syncs, causing user loss of data and productivity. I’ve seen posts about this issue as far back as 2022. Is there any current work being done to address this issue? The current suggested resolution is to change the app assignment from “Required” to “Available for Enrolled Devices” which is not really ideal. We are using ABM with ADE (w/ user affinity). Mac OS Sonoma 14.5 If any MS MVP’s can post an update, that would be really helpful. @ScottSawyer Read More
Freecash Referral Bonus Code {FC2003}: Get $250 Sign up Bonus & 30% Referral Reward
Download the Freecash app and use code {FC2003} during sign up and earn up to $250 welcome bonus. You can earn extra money if you refer your freecash referral code “FC2003” to your friend and family and you will get 30% commission what they earn. The more you refer the more you earn. So Keep Referring
Download the Freecash app and use code {FC2003} during sign up and earn up to $250 welcome bonus. You can earn extra money if you refer your freecash referral code “FC2003” to your friend and family and you will get 30% commission what they earn. The more you refer the more you earn. So Keep Referring Read More
Two Way Lookup
Hi all,
I am getting myself confused on this one – how can I return the corresponding name for a match based on the horizontal header and a non empty cell?
I know how to do a one way lookup, but struggling with this one!
Please see attached example which will explain it better!
Thank you for your help!
Hi all,I am getting myself confused on this one – how can I return the corresponding name for a match based on the horizontal header and a non empty cell? I know how to do a one way lookup, but struggling with this one! Please see attached example which will explain it better! Thank you for your help! Read More
Cannot switch out of S Mode
Hi,
There doesn’t seem to be a specific community hub for my question, so perhaps someone can direct me. I just bought a Lenovo, I’m using windows 10 or 11 i’m not sure which, and when I click “Get” to switch off S mode all I get is a page saying “Something happened and we couldn’t start the upgrade”.
The reason I bought a Lenovo because the software I need for a contract requires Windows. And I can’t download the software because of the S mode, which won’t switch off. To add to my frustration the contract has already started and I’m behind.
I’ve updated the laptops software, restarted numerous times, and I get the same message.
If anyone can help, that would be much appreciated.
Hi, There doesn’t seem to be a specific community hub for my question, so perhaps someone can direct me. I just bought a Lenovo, I’m using windows 10 or 11 i’m not sure which, and when I click “Get” to switch off S mode all I get is a page saying “Something happened and we couldn’t start the upgrade”. The reason I bought a Lenovo because the software I need for a contract requires Windows. And I can’t download the software because of the S mode, which won’t switch off. To add to my frustration the contract has already started and I’m behind. I’ve updated the laptops software, restarted numerous times, and I get the same message. If anyone can help, that would be much appreciated. Read More
Missing rights as Global Admin
Hello community,
I’m facing a strange problem. Since yesterday I do not have full rights in Exchange Online Admin center when logged in as Global Admin. Menus are missing in navigation pane and I’n not able to edit any features. I don’t know what happed, I cannot remember that I’ve mades any changes on the Admin Acount.
I tried it on 2 different machines, Firefox, Edge and Chrome, 2 different Global Admin users. Always the same problen.
This is a screenshot from the navigation pane, unfortunately in german but i think you can see what’s missing.
All other Admin centers work fine.
Any ideas? Any help is appreciated.
Thanks,
Markus
Hello community, I’m facing a strange problem. Since yesterday I do not have full rights in Exchange Online Admin center when logged in as Global Admin. Menus are missing in navigation pane and I’n not able to edit any features. I don’t know what happed, I cannot remember that I’ve mades any changes on the Admin Acount.I tried it on 2 different machines, Firefox, Edge and Chrome, 2 different Global Admin users. Always the same problen. This is a screenshot from the navigation pane, unfortunately in german but i think you can see what’s missing. All other Admin centers work fine.Any ideas? Any help is appreciated. Thanks,Markus Read More
Understanding SQL Server (on-premises) Updates
Are updates for SQL Server delivered via Windows Update?
I am looking at implementing a new patch management solution in place for our organization.
The products we are looking at leverage automation / control over the Windows Update Agent to perform this function.
I need to understand if I need to look for the specific ability to control the installation of SQL patches / updates with these solutions.
We have many versions of SQL Server across all companies – so understanding that how updates are delivered might be different between modern and more legacy versions.
I am finding the MS documentation unclear, so any comments are greatly appreciated!
Are updates for SQL Server delivered via Windows Update? I am looking at implementing a new patch management solution in place for our organization. The products we are looking at leverage automation / control over the Windows Update Agent to perform this function. I need to understand if I need to look for the specific ability to control the installation of SQL patches / updates with these solutions. We have many versions of SQL Server across all companies – so understanding that how updates are delivered might be different between modern and more legacy versions. I am finding the MS documentation unclear, so any comments are greatly appreciated! Read More
Issue with “Greater” Calculation Logic in ADF Pipeline
Hello ADF Community,
I am currently facing an issue with a piece of code in my ADF pipeline that has been functioning correctly for like 2 years until recently. The code is designed to handle date calculations for incremental loads based on historical depth parameters. The parameters are always negative and stored in string type. Below is the original code that was working before:
@IF(
greater(activity(‘Get table properties’).output.count,0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
greater(activity(‘Get table properties’).output.value[0].Depth_History_In_Days_start_time,’0′),
formatDateTime(adddays(utcnow(),int(pipeline().parameters.Depth_History_In_Days_start)),’yyyy-MM-dd’),
formatDateTime(utcnow(),’yyyy-MM-dd’)
)
)
),
formatDateTime(adddays(utcnow(),0),’yyyy-MM-dd’)
)
Issue Description
Until recently, this logic correctly loaded data based on the historical depth parameters. However, it now seems to be malfunctioning, leading to incorrect date calculations and always selecting today dates. (utcnow)
My Investigation and Changes
To address this issue, I simplified the logic, assuming the problem might be due to redundant checks and over-complication. Here’s the updated version of the code:
@IF(
greater(activity(‘Get table properties’).output.count, 0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time, ‘null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
),
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
)
Despite these changes, I am still unclear on why the original logic stopped working. The Depth_History_In_Days_start_time and Depth_History_In_Days_end_time variables are strings, and we have been using greater than 0 for comparisons, which worked previously since in string comparison, -2 is considered greater than 0.
Could anyone provide insights into why the original code might have stopped functioning correctly? Have there been any updates or changes in ADF that might affect string comparison logic? Any guidance or suggestions to ensure reliable date calculations would be greatly appreciated.
Thank you in advance for your assistance!
Hello ADF Community,I am currently facing an issue with a piece of code in my ADF pipeline that has been functioning correctly for like 2 years until recently. The code is designed to handle date calculations for incremental loads based on historical depth parameters. The parameters are always negative and stored in string type. Below is the original code that was working before: @IF(
greater(activity(‘Get table properties’).output.count,0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
greater(activity(‘Get table properties’).output.value[0].Depth_History_In_Days_start_time,’0′),
formatDateTime(adddays(utcnow(),int(pipeline().parameters.Depth_History_In_Days_start)),’yyyy-MM-dd’),
formatDateTime(utcnow(),’yyyy-MM-dd’)
)
)
),
formatDateTime(adddays(utcnow(),0),’yyyy-MM-dd’)
) Issue DescriptionUntil recently, this logic correctly loaded data based on the historical depth parameters. However, it now seems to be malfunctioning, leading to incorrect date calculations and always selecting today dates. (utcnow)My Investigation and ChangesTo address this issue, I simplified the logic, assuming the problem might be due to redundant checks and over-complication. Here’s the updated version of the code: @IF(
greater(activity(‘Get table properties’).output.count, 0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time, ‘null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
),
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
) Despite these changes, I am still unclear on why the original logic stopped working. The Depth_History_In_Days_start_time and Depth_History_In_Days_end_time variables are strings, and we have been using greater than 0 for comparisons, which worked previously since in string comparison, -2 is considered greater than 0. Could anyone provide insights into why the original code might have stopped functioning correctly? Have there been any updates or changes in ADF that might affect string comparison logic? Any guidance or suggestions to ensure reliable date calculations would be greatly appreciated.Thank you in advance for your assistance! Read More
Window Minimizing Automatically When Hovering Over It in Windows 11
Hello everyone,
I’m experiencing an issue with my Windows 11 system that I haven’t been able to resolve. When I move my cursor over a window that is not maximized, the window automatically disappears and minimizes. This happens consistently and is quite frustrating.
Best Regards.
Hello everyone, I’m experiencing an issue with my Windows 11 system that I haven’t been able to resolve. When I move my cursor over a window that is not maximized, the window automatically disappears and minimizes. This happens consistently and is quite frustrating. Best Regards. Read More
MDE Alerts tab and quarantine files location
Hello,
I have a few questions that I hope you can help clarify.
Filtering MDE Alerts by Detection Source: In Microsoft Defender for Endpoint (MDE), is it possible to filter alerts based on their detection source? Specifically, if we want to view only those alerts generated by MDE itself, how can we achieve that? Any guidance on this would be greatly appreciated.
Quarantine Location in MDE: According to a Google search, the quarantine location for MDE is specified as “/ProgramData/Microsoft/Windows Defender/Quarantine”. Could you please confirm if this information is accurate? If there’s an official reference from Microsoft documentation, I would appreciate it if you could share the link.Regards,
Hello, I have a few questions that I hope you can help clarify.Filtering MDE Alerts by Detection Source: In Microsoft Defender for Endpoint (MDE), is it possible to filter alerts based on their detection source? Specifically, if we want to view only those alerts generated by MDE itself, how can we achieve that? Any guidance on this would be greatly appreciated.Quarantine Location in MDE: According to a Google search, the quarantine location for MDE is specified as “/ProgramData/Microsoft/Windows Defender/Quarantine”. Could you please confirm if this information is accurate? If there’s an official reference from Microsoft documentation, I would appreciate it if you could share the link.Regards, Read More
Azure AD Sync Entra ID Sync Connect SSO problem
Hi community,
i have an entra id connect sync running with sso.
It is working fine, but if I want to change the configuration (new OU) I’m ending with a failure.
Can somebody tell me what the problem is?
Thanks, Greets, Steffen
Hi community, i have an entra id connect sync running with sso.It is working fine, but if I want to change the configuration (new OU) I’m ending with a failure.Can somebody tell me what the problem is? Thanks, Greets, Steffen Read More
Attapoll Referral Code {CNUCL} Get $10.00 Sign up Bonus & 15% Referral Commission
Use the latest Attapoll referral code “CNUCL” to unlock a free box worth up to $25. And you can also share your referral code to earn 15% what your referred earns. As of 2024 the latest Attapoll bonus code is [CNUCL] that give users up to $25 cash bonus on sign up and extra commission reward.
Use the latest Attapoll referral code “CNUCL” to unlock a free box worth up to $25. And you can also share your referral code to earn 15% what your referred earns. As of 2024 the latest Attapoll bonus code is [CNUCL] that give users up to $25 cash bonus on sign up and extra commission reward. Read More
MS Word CV Template.
I want a word template document as shown in the uploaded image ‘CV.jpg’. I have actually created it on a website Zety.com for resume template however the download is not free hence I took the screenshot. Can anyone create the exact template as seen in the uploaded image? Just create the exact format and I will fill the details myself. Thanks.
I want a word template document as shown in the uploaded image ‘CV.jpg’. I have actually created it on a website Zety.com for resume template however the download is not free hence I took the screenshot. Can anyone create the exact template as seen in the uploaded image? Just create the exact format and I will fill the details myself. Thanks. Read More
Issue with Date Calculation Logic in ADF Pipeline
Hello ADF Community,
I am currently facing an issue with a piece of code in my ADF pipeline that has been functioning correctly for like 2 years until recently. The code is designed to handle date calculations for incremental loads based on historical depth parameters. The parameters are always negative and stored in string type. Below is the original code that was working before:
@IF(
greater(activity(‘Get table properties’).output.count,0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
greater(activity(‘Get table properties’).output.value[0].Depth_History_In_Days_start_time,’0′),
formatDateTime(adddays(utcnow(),int(pipeline().parameters.Depth_History_In_Days_start)),’yyyy-MM-dd’),
formatDateTime(utcnow(),’yyyy-MM-dd’)
)
)
),
formatDateTime(adddays(utcnow(),0),’yyyy-MM-dd’)
)
Issue Description
Until recently, this logic correctly loaded data based on the historical depth parameters. However, it now seems to be malfunctioning, leading to incorrect date calculations and always selecting today dates. (utcnow)
My Investigation and Changes
To address this issue, I simplified the logic, assuming the problem might be due to redundant checks and over-complication. Here’s the updated version of the code:
@IF(
greater(activity(‘Get table properties’).output.count, 0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time, ‘null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
),
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
)
Despite these changes, I am still unclear on why the original logic stopped working. The Depth_History_In_Days_start_time and Depth_History_In_Days_end_time variables are strings, and we have been using greater than 0 for comparisons, which worked previously since in string comparison, -2 is considered greater than 0.
Could anyone provide insights into why the original code might have stopped functioning correctly? Have there been any updates or changes in ADF that might affect string comparison logic? Any guidance or suggestions to ensure reliable date calculations would be greatly appreciated.
Thank you in advance for your assistance!
Hello ADF Community,I am currently facing an issue with a piece of code in my ADF pipeline that has been functioning correctly for like 2 years until recently. The code is designed to handle date calculations for incremental loads based on historical depth parameters. The parameters are always negative and stored in string type. Below is the original code that was working before: @IF(
greater(activity(‘Get table properties’).output.count,0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time,’null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
IF(
greater(activity(‘Get table properties’).output.value[0].Depth_History_In_Days_start_time,’0′),
formatDateTime(adddays(utcnow(),int(pipeline().parameters.Depth_History_In_Days_start)),’yyyy-MM-dd’),
formatDateTime(utcnow(),’yyyy-MM-dd’)
)
)
),
formatDateTime(adddays(utcnow(),0),’yyyy-MM-dd’)
) Issue DescriptionUntil recently, this logic correctly loaded data based on the historical depth parameters. However, it now seems to be malfunctioning, leading to incorrect date calculations and always selecting today dates. (utcnow)My Investigation and ChangesTo address this issue, I simplified the logic, assuming the problem might be due to redundant checks and over-complication. Here’s the updated version of the code: @IF(
greater(activity(‘Get table properties’).output.count, 0),
IF(
not(equals(activity(‘Get table properties’).output.value[0].Start_Time, ‘null’)),
activity(‘Get table properties’).output.value[0].Start_Time,
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
),
formatDateTime(adddays(utcnow(), int(pipeline().parameters.Depth_History_In_Days_start)), ‘yyyy-MM-dd’)
) Despite these changes, I am still unclear on why the original logic stopped working. The Depth_History_In_Days_start_time and Depth_History_In_Days_end_time variables are strings, and we have been using greater than 0 for comparisons, which worked previously since in string comparison, -2 is considered greater than 0. Could anyone provide insights into why the original code might have stopped functioning correctly? Have there been any updates or changes in ADF that might affect string comparison logic? Any guidance or suggestions to ensure reliable date calculations would be greatly appreciated.Thank you in advance for your assistance! Read More
Seeking a Microsoft 365 CoPilot Experienced Specialist / Expert
We are a small organisation that is actively working towards the full implementation of Microsoft CoPilot within our operations here.
We are looking for a CoPilot specialist and an all-round reliable set of hands to assist with this in-person at the office in Mayfair, London. We offer an attractive hourly rate that is based on the individuals experience and references.
If this fits your current profile please reply with Interested and your email for me to get back to you on.
We are a small organisation that is actively working towards the full implementation of Microsoft CoPilot within our operations here. We are looking for a CoPilot specialist and an all-round reliable set of hands to assist with this in-person at the office in Mayfair, London. We offer an attractive hourly rate that is based on the individuals experience and references. If this fits your current profile please reply with Interested and your email for me to get back to you on. Read More
Purview DLP reports
Which report type suits the top 10 files that have matched DLP policies?
a) DLP policy matches
b) incident reports
Which report type suits the top 10 files that have matched DLP policies?a) DLP policy matchesb) incident reports Read More
Which Dynamics version, config ourselves, pricing
Hello.
I work at a small charity and I’m trying to determine which version of Dynamics is suitable for us. I can’t find any clear information as to the differences between the different versions and which might be best for us.
Our main areas of focus are:
Service user details – e.g. name, address, membership number, medical issues, etc.Case details – each user could have many cases (such as dealing with a landlord, or pension issues), with each case having many contacts at different dates.Activities – many different activities, with many instances of each one (like twice weekly badminton).
We would be able to find an SU, click on their details, pull up a list of their cases past and present, add additional contact details to their case for each contact we have with them, say how long the contact was, and how much was charged. Also, see what clubs/activities they’ve attended and when.
We want a weekly/monthly calendar view booking system for reception to book SU contacts/appointments. In the future, we might want to have it available on the internet for SUs to book a slot themselves.
For each instance of an activity, record who came, who paid a fee (if there was one).
Be able to apply various tags to each SU (e.g. volunteer, paid member, daycare user), so we can have a list at a glance and be able to run reports on just those people.
Running reports to see who did what activity, when they did it, who did what activity, how many case contacts we had between two dates, how much money was generated, etc. would be great.
We are not focused on dealing with individual donors or fundraising, but we are interested in keeping a list of grant applications we’ve submitted and what money we’ve received from them, if any.
Our charity has a very limited budget, so the system would be designed and put together by myself.
My questions are:
Which version of Dynamics is best for us?Will it be free from MS, or do we have to apply for some kind of grant? We are already registered as a nonprofit with MS.Will MS give us Dynamics so we can produce our own software, or do we have to do it though a Partner?If with a Partner, does it cost money?
We’re a small charity with a very small budget, so can’t afford to spend big money on things, unfortunately.
Many thanks.
Hello.I work at a small charity and I’m trying to determine which version of Dynamics is suitable for us. I can’t find any clear information as to the differences between the different versions and which might be best for us. Our main areas of focus are: Service user details – e.g. name, address, membership number, medical issues, etc.Case details – each user could have many cases (such as dealing with a landlord, or pension issues), with each case having many contacts at different dates.Activities – many different activities, with many instances of each one (like twice weekly badminton). We would be able to find an SU, click on their details, pull up a list of their cases past and present, add additional contact details to their case for each contact we have with them, say how long the contact was, and how much was charged. Also, see what clubs/activities they’ve attended and when. We want a weekly/monthly calendar view booking system for reception to book SU contacts/appointments. In the future, we might want to have it available on the internet for SUs to book a slot themselves. For each instance of an activity, record who came, who paid a fee (if there was one). Be able to apply various tags to each SU (e.g. volunteer, paid member, daycare user), so we can have a list at a glance and be able to run reports on just those people. Running reports to see who did what activity, when they did it, who did what activity, how many case contacts we had between two dates, how much money was generated, etc. would be great. We are not focused on dealing with individual donors or fundraising, but we are interested in keeping a list of grant applications we’ve submitted and what money we’ve received from them, if any. Our charity has a very limited budget, so the system would be designed and put together by myself. My questions are: Which version of Dynamics is best for us?Will it be free from MS, or do we have to apply for some kind of grant? We are already registered as a nonprofit with MS.Will MS give us Dynamics so we can produce our own software, or do we have to do it though a Partner?If with a Partner, does it cost money?We’re a small charity with a very small budget, so can’t afford to spend big money on things, unfortunately. Many thanks. Read More
Exchange 2019 – The remote certificate is invalid according to the validation procedure
Hi guys,
I`m starting with Exchange and already facing an issue regarding SMTP Service.
I have an app that needs to relay SMTP through my Exhange 2019.
A receive connector has been created, the app IP was allowed into this receive connector, port 587 configured, FQDN mail.domain.com configured as well.
I have this domain.com zone in my internal DNS and of course, an A record pointing MAIL entry to the Exchange Server.
I will paste the script that I`m using to try the SMTP relay at the end of this post.
So, sometimes the relay works and sometimes fails and returns:
Send-MailMessage : The remote certificate is invalid according to the validation procedure.
At C:UsersMYuserDesktopsmtptest.ps1:15 char:9
+ Send-MailMessage @sendMailParams -BodyAsHtml -Credential $cre …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.Mail.SmtpClient:SmtpClient) [Send-MailMessage], AuthenticationException
+ FullyQualifiedErrorId : AuthenticationException,Microsoft.PowerShell.Commands.SendMailMessage
I have two certificates installed in this Exchange Server, one is issued by internal CA and the other one by a public CA. The second one is a wildcert for *domain.com.
My point is, what am I missing? It seems a little weird for me that sometimes work and sometimes dont.
This is the ps1 script that I`m using to try the smtp relay:
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$sendMailParams = @{
From = email address removed for privacy reasons
To = email address removed for privacy reasons
Subject = “Test SMTP Relay”
Body = “Email sent for tests purposes”
SMTPServer = “mail.domain.com”
Port = 587
Encoding = “UTF8”
}
Send-MailMessage @sendMailParams -BodyAsHtml -Credential $credential -UseSsl
Of course, the certificate is valid, is assigned to SMTP Service in Exchange Server and is TLS1.2.
The mail.domain.com resolves for Exchange Server IP and the Application can reach the server using internal IP and mentioned port.
Anonymous user is allowed for now in receive connector.
Thanks in advance
Hi guys, I`m starting with Exchange and already facing an issue regarding SMTP Service.I have an app that needs to relay SMTP through my Exhange 2019. A receive connector has been created, the app IP was allowed into this receive connector, port 587 configured, FQDN mail.domain.com configured as well.I have this domain.com zone in my internal DNS and of course, an A record pointing MAIL entry to the Exchange Server. I will paste the script that I`m using to try the SMTP relay at the end of this post.So, sometimes the relay works and sometimes fails and returns:Send-MailMessage : The remote certificate is invalid according to the validation procedure.
At C:UsersMYuserDesktopsmtptest.ps1:15 char:9
+ Send-MailMessage @sendMailParams -BodyAsHtml -Credential $cre …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.Mail.SmtpClient:SmtpClient) [Send-MailMessage], AuthenticationException
+ FullyQualifiedErrorId : AuthenticationException,Microsoft.PowerShell.Commands.SendMailMessage I have two certificates installed in this Exchange Server, one is issued by internal CA and the other one by a public CA. The second one is a wildcert for *domain.com. My point is, what am I missing? It seems a little weird for me that sometimes work and sometimes dont. This is the ps1 script that I`m using to try the smtp relay:[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$sendMailParams = @{
From = email address removed for privacy reasons
To = email address removed for privacy reasons
Subject = “Test SMTP Relay”
Body = “Email sent for tests purposes”
SMTPServer = “mail.domain.com”
Port = 587
Encoding = “UTF8”
}
Send-MailMessage @sendMailParams -BodyAsHtml -Credential $credential -UseSsl
Of course, the certificate is valid, is assigned to SMTP Service in Exchange Server and is TLS1.2.The mail.domain.com resolves for Exchange Server IP and the Application can reach the server using internal IP and mentioned port.Anonymous user is allowed for now in receive connector. Thanks in advance Read More