Category: Microsoft
Category Archives: Microsoft
What to do when QuickBooks Administrator Permissions Needed issues?
Troubleshooting Solutions: QuickBooks Administrator Permissions Needed
Verify Administrator Status: Ensure that your user account is indeed designated as an administrator in QuickBooks. Go to the “Company” menu, select “Users,” and then “Set Up Users and Roles” to confirm your permissions. If not, update your user role to administrator.Check User Permissions: Review the specific permissions assigned to your user account. Navigate to “Company” > “Users” > “Set Up Users and Roles” and verify that the required permissions are enabled for your account. Ensure that you have permissions for tasks such as creating transactions, accessing sensitive financial data, and modifying company settings.Reboot QuickBooks and System: Sometimes, technical glitches can cause permission issues. Close QuickBooks and restart your computer to refresh the system. Then, relaunch QuickBooks and attempt the task again to see if the problem persists.Update QuickBooks: Ensure that you’re using the latest version of QuickBooks. Outdated software may contain bugs or compatibility issues that could interfere with administrator permissions. Check for updates by selecting “Help” > “Update QuickBooks” and follow the prompts to install any available updates.Run QuickBooks as Administrator: Try running QuickBooks with elevated privileges by right-clicking the QuickBooks shortcut icon and selecting “Run as administrator.” This action grants the program additional permissions that may resolve the issue you’re experiencing.Review Security Software Settings: Antivirus or firewall software on your system could potentially block QuickBooks from accessing certain features or files, leading to permission issues. Temporarily disable or adjust the settings of your security software to allow QuickBooks full access, then attempt the task again.Create a New Admin User: As a workaround, create a new user account with administrator privileges. Navigate to “Company” > “Users” > “Set Up Users and Roles” and add a new user with full admin permissions. Log in with the new account and see if you can perform the desired tasks without any issues.Check Windows User Account Control (UAC) Settings: Windows User Account Control settings may restrict certain actions in QuickBooks. Adjust the UAC settings by typing “UAC” in the Windows search bar, selecting “Change User Account Control settings,” and moving the slider to the lowest (never notify) setting. Restart your computer and attempt the task again.Repair QuickBooks Installation: If none of the above solutions resolve the issue, repair your QuickBooks installation. Close QuickBooks, open the Control Panel, navigate to “Programs” > “Programs and Features,” select QuickBooks from the list, and choose “Repair.” Follow the on-screen instructions to repair the installation.Contact QuickBooks Support: If the problem persists after trying the troubleshooting steps above, reach out to QuickBooks customer support for further assistance. Provide detailed information about the issue you’re experiencing, including any error messages or specific tasks you’re unable to perform. They can offer personalized guidance to help resolve the permissions issue.
Troubleshooting Solutions: QuickBooks Administrator Permissions Needed Verify Administrator Status: Ensure that your user account is indeed designated as an administrator in QuickBooks. Go to the “Company” menu, select “Users,” and then “Set Up Users and Roles” to confirm your permissions. If not, update your user role to administrator.Check User Permissions: Review the specific permissions assigned to your user account. Navigate to “Company” > “Users” > “Set Up Users and Roles” and verify that the required permissions are enabled for your account. Ensure that you have permissions for tasks such as creating transactions, accessing sensitive financial data, and modifying company settings.Reboot QuickBooks and System: Sometimes, technical glitches can cause permission issues. Close QuickBooks and restart your computer to refresh the system. Then, relaunch QuickBooks and attempt the task again to see if the problem persists.Update QuickBooks: Ensure that you’re using the latest version of QuickBooks. Outdated software may contain bugs or compatibility issues that could interfere with administrator permissions. Check for updates by selecting “Help” > “Update QuickBooks” and follow the prompts to install any available updates.Run QuickBooks as Administrator: Try running QuickBooks with elevated privileges by right-clicking the QuickBooks shortcut icon and selecting “Run as administrator.” This action grants the program additional permissions that may resolve the issue you’re experiencing.Review Security Software Settings: Antivirus or firewall software on your system could potentially block QuickBooks from accessing certain features or files, leading to permission issues. Temporarily disable or adjust the settings of your security software to allow QuickBooks full access, then attempt the task again.Create a New Admin User: As a workaround, create a new user account with administrator privileges. Navigate to “Company” > “Users” > “Set Up Users and Roles” and add a new user with full admin permissions. Log in with the new account and see if you can perform the desired tasks without any issues.Check Windows User Account Control (UAC) Settings: Windows User Account Control settings may restrict certain actions in QuickBooks. Adjust the UAC settings by typing “UAC” in the Windows search bar, selecting “Change User Account Control settings,” and moving the slider to the lowest (never notify) setting. Restart your computer and attempt the task again.Repair QuickBooks Installation: If none of the above solutions resolve the issue, repair your QuickBooks installation. Close QuickBooks, open the Control Panel, navigate to “Programs” > “Programs and Features,” select QuickBooks from the list, and choose “Repair.” Follow the on-screen instructions to repair the installation.Contact QuickBooks Support: If the problem persists after trying the troubleshooting steps above, reach out to QuickBooks customer support for further assistance. Provide detailed information about the issue you’re experiencing, including any error messages or specific tasks you’re unable to perform. They can offer personalized guidance to help resolve the permissions issue. Read More
What to do when Quickbooks payroll update error ps038?
Troubleshooting Solutions: QuickBooks payroll update error ps038
QuickBooks users occasionally encounter errors like PS038 during payroll updates. This issue may arise due to various reasons, such as incorrect tax table installation, damaged QuickBooks company file, or outdated software. Here’s a comprehensive guide to troubleshoot and resolve QuickBooks Payroll Update Error PS038:
1. Verify Payroll Subscription:
Ensure that your QuickBooks payroll subscription is active and up-to-date. Navigate to the ‘Employees’ menu, select ‘My Payroll Service’, and then click on ‘Account/Billing Information’. Confirm the subscription status and update if necessary.
2. Check Internet Connection:
A stable internet connection is crucial for successful payroll updates. Verify your internet connectivity and ensure that there are no network interruptions. If using a wireless connection, consider switching to a wired connection for stability.
3. Update QuickBooks Software:
Ensure that your QuickBooks software is updated to the latest version. Go to the ‘Help’ menu and select ‘Update QuickBooks Desktop’. Follow the prompts to install any available updates. Updated software often includes fixes for known issues like PS038.
4. Verify User Account Control (UAC) Settings:
Adjust User Account Control settings to allow QuickBooks to perform updates smoothly. Navigate to the Control Panel, select ‘User Accounts’, and click on ‘Change User Account Control settings’. Set the slider to a lower level (not recommended to disable UAC entirely) and click ‘OK’.
5. Download and Install Payroll Tax Table Updates Manually:
If the automatic update fails, download the latest payroll tax table update manually from the Intuit website. Save the file to your computer and install it following the on-screen instructions. After installation, attempt to update payroll again.
6. Run QuickBooks File Doctor:
QuickBooks File Doctor is a diagnostic tool that can repair various QuickBooks-related issues, including PS038. Download and run the tool from the Intuit website. Follow the prompts to scan and repair your QuickBooks company file. After the repair process, attempt to update payroll again.
7. Check Firewall and Security Software Settings:
Ensure that your firewall or security software isn’t blocking QuickBooks updates. Configure firewall settings to allow QuickBooks connections and exceptions. Consult your security software documentation for instructions on how to add QuickBooks as a trusted application.
8. Verify Payroll Settings and Preferences:
Double-check your payroll settings and preferences to ensure everything is configured correctly. Navigate to the ‘Edit’ menu, select ‘Preferences’, and choose ‘Payroll & Employees’. Review each section for accuracy, especially tax-related settings.
9. Temporarily Disable Antivirus Software:
Sometimes, antivirus software can interfere with QuickBooks updates. Temporarily disable your antivirus program and attempt to update payroll again. Remember to re-enable it after the update process is complete.
10. Contact QuickBooks Support:
If the issue persists after trying the above solutions, contact QuickBooks support for further assistance. Provide them with detailed information about the error and steps you’ve taken to troubleshoot. They can offer personalized guidance to resolve the PS038 error.
By following these troubleshooting steps, you should be able to resolve QuickBooks Payroll Update Error PS038 and successfully update your payroll without any further issues.
Troubleshooting Solutions: QuickBooks payroll update error ps038 QuickBooks users occasionally encounter errors like PS038 during payroll updates. This issue may arise due to various reasons, such as incorrect tax table installation, damaged QuickBooks company file, or outdated software. Here’s a comprehensive guide to troubleshoot and resolve QuickBooks Payroll Update Error PS038: 1. Verify Payroll Subscription:Ensure that your QuickBooks payroll subscription is active and up-to-date. Navigate to the ‘Employees’ menu, select ‘My Payroll Service’, and then click on ‘Account/Billing Information’. Confirm the subscription status and update if necessary.2. Check Internet Connection:A stable internet connection is crucial for successful payroll updates. Verify your internet connectivity and ensure that there are no network interruptions. If using a wireless connection, consider switching to a wired connection for stability.3. Update QuickBooks Software:Ensure that your QuickBooks software is updated to the latest version. Go to the ‘Help’ menu and select ‘Update QuickBooks Desktop’. Follow the prompts to install any available updates. Updated software often includes fixes for known issues like PS038.4. Verify User Account Control (UAC) Settings:Adjust User Account Control settings to allow QuickBooks to perform updates smoothly. Navigate to the Control Panel, select ‘User Accounts’, and click on ‘Change User Account Control settings’. Set the slider to a lower level (not recommended to disable UAC entirely) and click ‘OK’.5. Download and Install Payroll Tax Table Updates Manually:If the automatic update fails, download the latest payroll tax table update manually from the Intuit website. Save the file to your computer and install it following the on-screen instructions. After installation, attempt to update payroll again.6. Run QuickBooks File Doctor:QuickBooks File Doctor is a diagnostic tool that can repair various QuickBooks-related issues, including PS038. Download and run the tool from the Intuit website. Follow the prompts to scan and repair your QuickBooks company file. After the repair process, attempt to update payroll again.7. Check Firewall and Security Software Settings:Ensure that your firewall or security software isn’t blocking QuickBooks updates. Configure firewall settings to allow QuickBooks connections and exceptions. Consult your security software documentation for instructions on how to add QuickBooks as a trusted application.8. Verify Payroll Settings and Preferences:Double-check your payroll settings and preferences to ensure everything is configured correctly. Navigate to the ‘Edit’ menu, select ‘Preferences’, and choose ‘Payroll & Employees’. Review each section for accuracy, especially tax-related settings.9. Temporarily Disable Antivirus Software:Sometimes, antivirus software can interfere with QuickBooks updates. Temporarily disable your antivirus program and attempt to update payroll again. Remember to re-enable it after the update process is complete.10. Contact QuickBooks Support:If the issue persists after trying the above solutions, contact QuickBooks support for further assistance. Provide them with detailed information about the error and steps you’ve taken to troubleshoot. They can offer personalized guidance to resolve the PS038 error.By following these troubleshooting steps, you should be able to resolve QuickBooks Payroll Update Error PS038 and successfully update your payroll without any further issues. Read More
Conditional formatting in Excel
I have a workbook saved for members of our racing team (each person on a row) to signify their availability for each week’s racing during the season (columns). I’ve set it up with a data validation (for yes/no/no response) and once they make their choice, I’d like the conditional formatting to kick in and make it easier to see how many are in for a given week, so I was thinking a YES entry would -> green fill/dark green text, NO-> red fill/dark red text, no response would stay with no fill. We have 20 people/rows, 22 weeks of racing/columns, and I want to try and do something once that would apply to all. When I went to conditional formatting, I couldn’t see how I set multiple options or specify the range of cells to which I want it to apply. Can someone help? Thanks in advance.
I have a workbook saved for members of our racing team (each person on a row) to signify their availability for each week’s racing during the season (columns). I’ve set it up with a data validation (for yes/no/no response) and once they make their choice, I’d like the conditional formatting to kick in and make it easier to see how many are in for a given week, so I was thinking a YES entry would -> green fill/dark green text, NO-> red fill/dark red text, no response would stay with no fill. We have 20 people/rows, 22 weeks of racing/columns, and I want to try and do something once that would apply to all. When I went to conditional formatting, I couldn’t see how I set multiple options or specify the range of cells to which I want it to apply. Can someone help? Thanks in advance. Read More
How Partitioning works
Good afternoon,
I can’t find any information about how partitioning works inside SQL Server.
Faced with a situation. Example:
There is a table with lists (id,category,price,idPart), where there is an identifier that works for partitioning.
12 partitions from 0 to 12
Please tell me why the query for the partition field is slower
SELECT id,category,price FROM dbo.myTable WHERE id Part = 1
And the query using the partition function works faster
SELECT id,category,price FROM dbo.myTable WHERE $PARTITION.pf(idPart) = 1
Good afternoon,I can’t find any information about how partitioning works inside SQL Server.Faced with a situation. Example:There is a table with lists (id,category,price,idPart), where there is an identifier that works for partitioning.12 partitions from 0 to 12Please tell me why the query for the partition field is slowerSELECT id,category,price FROM dbo.myTable WHERE id Part = 1And the query using the partition function works fasterSELECT id,category,price FROM dbo.myTable WHERE $PARTITION.pf(idPart) = 1 Read More
How to Fix Quickbooks Multi-User Mode Not Working After Update?
Troubleshooting Solutions: Quickbooks Multi-User Mode Not Working After Update
Quickbooks Multi-User Mode Not Working After Update can be frustrating but usually has straightforward fixes. Here are steps to troubleshoot the issue:
Check Network Connectivity: Ensure all computers are connected to the same network. If there are any network issues, resolve them first. You can restart your router or switch to a wired connection if possible.Update QuickBooks: Confirm that all computers have the latest QuickBooks update installed. Sometimes, outdated software can lead to compatibility issues, causing Multi-User Mode to malfunction.Restart QuickBooks Database Server Manager: Navigate to the computer hosting the company file and restart the QuickBooks Database Server Manager. Go to the Start menu, search for “QuickBooks Database Server Manager,” and select it. Then, click on “Scan Folders” to rescan the company file. This should refresh the connection for Multi-User Mode.Check Firewall and Antivirus Settings: Firewalls or antivirus software may block QuickBooks from accessing the network, causing Multi-User Mode to fail. Temporarily disable these programs and check if Multi-User Mode works. If it does, you’ll need to configure firewall and antivirus settings to allow QuickBooks access.Verify Hosting Settings: Ensure that only the server or host computer is set to host Multi-User access. Open QuickBooks on the host computer, go to the File menu, select “Utilities,” and then click “Host Multi-User Access.” On client computers, this option should be disabled.Check File Permissions: Verify that the user permissions are set correctly for the company file. Go to the location where the company file is stored, right-click on it, select “Properties,” and then navigate to the “Security” tab. Ensure that all users have the necessary permissions to access the file.Use QuickBooks File Doctor: QuickBooks File Doctor is a tool provided by Intuit to diagnose and repair common QuickBooks issues. Download and run QuickBooks File Doctor, select your company file, and follow the on-screen instructions to fix any detected issues.Create a New User: Sometimes, user profiles can become corrupted, causing Multi-User Mode problems. Create a new user profile on the affected computer and try accessing Multi-User Mode with the new profile.Recreate Network Data File: If none of the above solutions work, try recreating the network data file. Go to the computer hosting the company file, open QuickBooks Database Server Manager, and select “Start Scan.” This will recreate the network data file and might resolve the Multi-User Mode issue.
Following these troubleshooting steps should help you resolve the Quickbooks Multi-User Mode Not Working After Update problem efficiently, ensuring smooth collaboration among users. If the issue persists, contacting QuickBooks support might be necessary for further assistance.
Troubleshooting Solutions: Quickbooks Multi-User Mode Not Working After UpdateQuickbooks Multi-User Mode Not Working After Update can be frustrating but usually has straightforward fixes. Here are steps to troubleshoot the issue:Check Network Connectivity: Ensure all computers are connected to the same network. If there are any network issues, resolve them first. You can restart your router or switch to a wired connection if possible.Update QuickBooks: Confirm that all computers have the latest QuickBooks update installed. Sometimes, outdated software can lead to compatibility issues, causing Multi-User Mode to malfunction.Restart QuickBooks Database Server Manager: Navigate to the computer hosting the company file and restart the QuickBooks Database Server Manager. Go to the Start menu, search for “QuickBooks Database Server Manager,” and select it. Then, click on “Scan Folders” to rescan the company file. This should refresh the connection for Multi-User Mode.Check Firewall and Antivirus Settings: Firewalls or antivirus software may block QuickBooks from accessing the network, causing Multi-User Mode to fail. Temporarily disable these programs and check if Multi-User Mode works. If it does, you’ll need to configure firewall and antivirus settings to allow QuickBooks access.Verify Hosting Settings: Ensure that only the server or host computer is set to host Multi-User access. Open QuickBooks on the host computer, go to the File menu, select “Utilities,” and then click “Host Multi-User Access.” On client computers, this option should be disabled.Check File Permissions: Verify that the user permissions are set correctly for the company file. Go to the location where the company file is stored, right-click on it, select “Properties,” and then navigate to the “Security” tab. Ensure that all users have the necessary permissions to access the file.Use QuickBooks File Doctor: QuickBooks File Doctor is a tool provided by Intuit to diagnose and repair common QuickBooks issues. Download and run QuickBooks File Doctor, select your company file, and follow the on-screen instructions to fix any detected issues.Create a New User: Sometimes, user profiles can become corrupted, causing Multi-User Mode problems. Create a new user profile on the affected computer and try accessing Multi-User Mode with the new profile.Recreate Network Data File: If none of the above solutions work, try recreating the network data file. Go to the computer hosting the company file, open QuickBooks Database Server Manager, and select “Start Scan.” This will recreate the network data file and might resolve the Multi-User Mode issue.Following these troubleshooting steps should help you resolve the Quickbooks Multi-User Mode Not Working After Update problem efficiently, ensuring smooth collaboration among users. If the issue persists, contacting QuickBooks support might be necessary for further assistance. Read More
How fix QuickBooks Crashing When Opening Company File after update?
Troubleshooting Solutions: QuickBooks Crashing When Opening Company File
Run QuickBooks File Doctor: QuickBooks File Doctor can diagnose and repair company file issues causing crashes. Download and run the tool from the QuickBooks website. Follow the on-screen instructions to scan and fix any detected problems.Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Open QuickBooks and go to the Help menu. Select “Update QuickBooks Desktop” and install any available updates. Outdated software can lead to compatibility issues and crashes.Check for Windows Updates: Make sure your operating system is up to date with the latest Windows updates. Press Win + I to open the Settings app, then go to Update & Security > Windows Update and click “Check for updates.”Disable Compatibility Mode: Right-click the QuickBooks shortcut or executable file, select “Properties,” and go to the Compatibility tab. If “Run this program in compatibility mode” is checked, uncheck it. Compatibility mode can cause conflicts with modern operating systems.Verify Company File: Check if the company file is damaged or corrupted. Open QuickBooks and press Ctrl + O to open a company file. Select the company file and press Ctrl + F3 to run the Verify Data utility. Follow the prompts to check for and repair any data issues.Recreate QBWUSER.INI file: Close QuickBooks, press Win + R, type “%AppData%” (without quotes), and press Enter. Navigate to Intuit > QuickBooks (year) and locate the QBWUSER.INI file. Rename it to QBWUSER.INI.old and restart QuickBooks. A new QBWUSER.INI file will be created.Run QuickBooks Install Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the QuickBooks website. This tool can resolve common installation issues and repair components that may be causing QuickBooks to crash.Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks and cause crashes. Disable all add-ons and extensions, then try opening the company file again. If QuickBooks opens without crashing, gradually re-enable each add-on to identify the problematic one.Create a New Windows User: User profile corruption can lead to QuickBooks crashes. Create a new Windows user account with administrative privileges. Log in with the new account and try opening the company file. If QuickBooks works fine, the original user profile may be corrupted.Contact QuickBooks Support: If the issue persists after trying the above solutions, contact QuickBooks customer support for further assistance. They can provide personalized troubleshooting steps and guidance based on your specific situation.
By following these troubleshooting steps, you should be able to resolve the issue of QuickBooks crashing when opening a company file and continue using the software smoothly.
Troubleshooting Solutions: QuickBooks Crashing When Opening Company File Run QuickBooks File Doctor: QuickBooks File Doctor can diagnose and repair company file issues causing crashes. Download and run the tool from the QuickBooks website. Follow the on-screen instructions to scan and fix any detected problems.Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Open QuickBooks and go to the Help menu. Select “Update QuickBooks Desktop” and install any available updates. Outdated software can lead to compatibility issues and crashes.Check for Windows Updates: Make sure your operating system is up to date with the latest Windows updates. Press Win + I to open the Settings app, then go to Update & Security > Windows Update and click “Check for updates.”Disable Compatibility Mode: Right-click the QuickBooks shortcut or executable file, select “Properties,” and go to the Compatibility tab. If “Run this program in compatibility mode” is checked, uncheck it. Compatibility mode can cause conflicts with modern operating systems.Verify Company File: Check if the company file is damaged or corrupted. Open QuickBooks and press Ctrl + O to open a company file. Select the company file and press Ctrl + F3 to run the Verify Data utility. Follow the prompts to check for and repair any data issues.Recreate QBWUSER.INI file: Close QuickBooks, press Win + R, type “%AppData%” (without quotes), and press Enter. Navigate to Intuit > QuickBooks (year) and locate the QBWUSER.INI file. Rename it to QBWUSER.INI.old and restart QuickBooks. A new QBWUSER.INI file will be created.Run QuickBooks Install Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the QuickBooks website. This tool can resolve common installation issues and repair components that may be causing QuickBooks to crash.Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks and cause crashes. Disable all add-ons and extensions, then try opening the company file again. If QuickBooks opens without crashing, gradually re-enable each add-on to identify the problematic one.Create a New Windows User: User profile corruption can lead to QuickBooks crashes. Create a new Windows user account with administrative privileges. Log in with the new account and try opening the company file. If QuickBooks works fine, the original user profile may be corrupted.Contact QuickBooks Support: If the issue persists after trying the above solutions, contact QuickBooks customer support for further assistance. They can provide personalized troubleshooting steps and guidance based on your specific situation.By following these troubleshooting steps, you should be able to resolve the issue of QuickBooks crashing when opening a company file and continue using the software smoothly. Read More
Import file as an array
Hi,
I have the following in a script that is working fine using the following:
$string = @ (“xxx”, “yyy”, “zzz”)
After I changed to the following that get from a file, it does not work:
$string = @()
$string += import-csv C:tempfile.csv
The content of file.csv
xxx
yyy
zzz
Can anyone advise how to resolve?
Hi, I have the following in a script that is working fine using the following:$string = @ (“xxx”, “yyy”, “zzz”) After I changed to the following that get from a file, it does not work:$string = @()$string += import-csv C:tempfile.csv The content of file.csvxxxyyyzzz Can anyone advise how to resolve? Read More
Microsoft Defender for Open-Source Relational Databases Now Supports Multicloud (AWS RDS)
Introduction:
Many organizations use multiple cloud providers today, which makes security misconfigurations more likely due to the solution scale and complexity. Moreover, different practices and concepts among each cloud provider’s implementation create bigger internal knowledge gaps.
No matter how many cloud providers an organization uses, a database is the core of each application, storing the organization’s most valuable data: PII, financial and payment information, medical information, and other sensitive data. This makes databases the most attractive attack target for any threat actor – from inside or outside.
Even though there is more awareness of exposure misconfigurations (thanks to cybersecurity education and posture management products that reveal these issues), public datasets show that the most risky database misconfiguration – exposing databases to the internet is not going down. This fact emphasizes the importance of threat protection that will act as a last line of defense and help detect, in near real-time, attacks that endanger databases and the critical data they contain.
Internet exposed databases count through time.
(Source: Time series · General statistics · The Shadowserver Foundation)
Announcement:
Microsoft Defender for open-source relational databases have been long focusing on providing comprehensive protection for Azure databases.
Today, we’re excited to announce another significant milestone in our cloud database security journey: Microsoft Defender for open-source relational databases plans now extend their protection to multicloud environments, starting with Amazon RDS on AWS. The workloads supported in AWS RDS are:
Aurora PostgreSQL
Aurora MySQL
PostgreSQL
MySQL
MariaDB
This release includes full parity with the alert types of support for managed Azure OSS databases:
Anomalous database access and query patterns – For example, a logon from a suspicious location or from a domain not seen in the past 60 days.
Suspicious database activities – For example, a user accessing a database service from a breached computer which communicated with a crypto-mining C&C server.
Brute-force attacks – With the ability to separate simple brute force attempt from a successful brute force.
Under public preview, you can turn on the Defender for open-source relational databases plan for AWS RDS at no cost. This marks a pivotal moment in our commitment to securing your business-critical data across cloud environments.
This announcement makes Microsoft the sole major security provider offering multicloud database protection, a significant step forward in building an end-to-end multicloud & Cloud native application protection platform (CNAPP).
Defender for Cloud stands out with its comprehensive approach, covering a diverse range of databases and leveraging Microsoft’s dual role as a cloud and security provider. This integration enables us to provide unparalleled scanning depth and real-time threat detection capabilities, enhancing security across multicloud environments.
This multicloud database protection announcement is part of Microsoft’s commitment to build a comprehensive Cloud Native Application Protection Platform (CNAPP). CNAPP integrates advanced data threat intelligence, , and data threat protection to provide in depth cloud data security insight and breadth of data security protection across various cloud platforms.
Microsoft’s CNAPP infographic
Features
You will now have full flexibility to mix and match the protection on your multicloud databases:
Protection layers for multicloud database protection
Foundational CSPM – Free out of the box (OOTB) control plane recommendations are generated once you connect your account to Microsoft Defender for Cloud.
Recommendations are evaluated and generated OOTB for all connected cloud environments.
Advanced posture management with Defender CSPM (DCSPM) – Discovers your databases, what types of sensitive data they contain and assesses risk to that data based on context gathered across all the clouds in the customer’s scope.
Misconfigurations and sensitive data are discovered and displayed as part of an attack path
Advanced threat protection with Defender for open-source relational databases – Provides threat protection by generating near real-time alerts based on suspicious and anomalous access patterns to your databases.
Attack path also highlights active attack on the vulnerable resources
MDC lists the alert history on the resource we can see brute force attacks, connections from harmful applications and more
Brute force attack detected from an IP that was reported as a Tor exit node
Finally, Microsoft Defender for Cloud offers seamless integration with Defender XDR, which offers enhanced threat detection and response capabilities. It’s crucial for organizations to adopt both Defender for Cloud and Defender XDR personas to effectively manage and mitigate security risks across their multicloud environments.
Defender XDR identified an incident where the same IP tried to brute force cloud databases in AWS and Azure
Sensitive data discovery is built-in!
Defender for open-source databases on AWS will be the first database threat protection plan to bundle sensitive data discovery as part of its core value, without depending on other plans (such as DCSPM) or incur additional costs. Once the plan is enabled the discovery process will be scheduled weekly and you will be able to consume the findings in all the main MDC experiences:
Alerts – filter alerts by resources with findings, alert page enrichment
Inventory – filter resources with findings
Resource health – enrichment with findings
Security explorer (new!) – You will also be able to query the findings using security explorer even without enabling DCSPM.
Only findings’ data will be queryable – other pieces of context require enabling DCSPM.
Conclusion
In conclusion, Microsoft Defender for open-source relational databases now support multicloud database protections in AWS RDS environments. This change signifies a pivotal advancement in cloud security. Through its holistic approach embodied by CNAPP, Microsoft empowers organizations to safeguard their critical data assets consistently across diverse cloud platforms.
Resources:
To learn more about Defender for Cloud, click here.
Read about Defender for open-source relational databases documentation here.
Read about sensitive data discovery.
Defender for open-source relational databases alerts reference.
Start free trial here.
Microsoft Tech Community – Latest Blogs –Read More
Windows server 2022 failover cluster
In a single Windows Failover cluster of 4 nodes can we have different storage for two nodes and for other two nodes different storage is it possible or not?
In a single Windows Failover cluster of 4 nodes can we have different storage for two nodes and for other two nodes different storage is it possible or not? Read More
Outlook changes the “Modified” field when moving/copying a Contact.
Hi friends!
I use Outlook 2021.
When I copy/move a Contact item from one Contacts folder to another Contacts folder, the “Modified” field gets updated to the current date. I don’t modify the Contact itself… I only move it or copy it.
Is there a way to keep the “Modified” field unchanged?
Thank you for your help,
Martin
Hi friends!I use Outlook 2021.When I copy/move a Contact item from one Contacts folder to another Contacts folder, the “Modified” field gets updated to the current date. I don’t modify the Contact itself… I only move it or copy it.Is there a way to keep the “Modified” field unchanged?Thank you for your help,Martin Read More
Unlink OneDrive account from PC
Hi Team,
Is there a way to automate the process of unlinking of OneDrive account?
As for 1-2 accounts, we perform manual steps: open the OneDrive settings, go to the account tab, and click Unlink this PC.
But for thousands Laptops/desktop we don’t want our techs to have to do the same. The idea is to stop the sync, unlink the account from this PC and from explorer remove OneDrive.
Hi Team,Is there a way to automate the process of unlinking of OneDrive account?As for 1-2 accounts, we perform manual steps: open the OneDrive settings, go to the account tab, and click Unlink this PC.But for thousands Laptops/desktop we don’t want our techs to have to do the same. The idea is to stop the sync, unlink the account from this PC and from explorer remove OneDrive. Read More
Surface Pro 7 not booting off USB for Ubuntu install
Hi all.
I’ve got a Surface Pro 7 that’s getting a bit long in the tooth. I’ve read that various Linux distros run well on it. Ubuntu in particular has quite a few detailed set-up guides. So I decided to give it a shot.
The problem is, the Surface won’t boot from a USB key. The UEFI/BIOS is set to boot from USB first, before anything else. I’ve tried:
— 5 different USB keys (various sizes (apparently 64GB don’t work) from 32GB down to 8)
— writing the Ubuntu ISO to the key using balenaEtcher, Rufus, and the dd command from a command prompt in a Linux virtual machine.
— setting the security setting in the Surface’s UEFI/BIOS to off and third party (not Microsoft Only)
— turned off all other boot devices, so that it ONLY tries booting from the USB
— openSUSE Tumbleweed instead of Ubuntu
— Windows 11 (for poops and giggles, just to see) instead of Linux
— turned on the Surface normally, and while holding the down volume button.
Nothing works. It just sits there with the white Surface/Windows logo on a black screen, like it’s mockingly judging me, until I eventually turn it off. I’ve left it like that for as long as an hour, just to see if the trhing would figure out what I wanted it do do.
How on earth to I get the thing to actually boot off USB and into the Ubuntu installer?
Hi all. I’ve got a Surface Pro 7 that’s getting a bit long in the tooth. I’ve read that various Linux distros run well on it. Ubuntu in particular has quite a few detailed set-up guides. So I decided to give it a shot. The problem is, the Surface won’t boot from a USB key. The UEFI/BIOS is set to boot from USB first, before anything else. I’ve tried: — 5 different USB keys (various sizes (apparently 64GB don’t work) from 32GB down to 8)– writing the Ubuntu ISO to the key using balenaEtcher, Rufus, and the dd command from a command prompt in a Linux virtual machine.– setting the security setting in the Surface’s UEFI/BIOS to off and third party (not Microsoft Only)– turned off all other boot devices, so that it ONLY tries booting from the USB– openSUSE Tumbleweed instead of Ubuntu– Windows 11 (for poops and giggles, just to see) instead of Linux– turned on the Surface normally, and while holding the down volume button. Nothing works. It just sits there with the white Surface/Windows logo on a black screen, like it’s mockingly judging me, until I eventually turn it off. I’ve left it like that for as long as an hour, just to see if the trhing would figure out what I wanted it do do. How on earth to I get the thing to actually boot off USB and into the Ubuntu installer? Read More
How to fix QuickBooks Enterprise 2024 keeps crashing after update?
Troubleshooting Solutions : QuickBooks Enterprise 2024 keeps crashing
Dealing with QuickBooks Enterprise 2024 keeps crashing can be frustrating, but several troubleshooting steps can help resolve the issue and ensure smooth operation of the software.
1. Update QuickBooks Enterprise: Ensure you’re using the latest version of QuickBooks Enterprise 2024. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.
2. Verify System Requirements: Ensure your computer meets the minimum system requirements for running QuickBooks Enterprise 2024. Inadequate hardware or outdated software can lead to performance issues and crashes. Check the QuickBooks support website for the system requirements for your version.
3. Run QuickBooks File Doctor: QuickBooks File Doctor is a tool designed to diagnose and repair issues that can cause crashes and other errors. Download and run the QuickBooks File Doctor from the Intuit website. Follow the on-screen instructions to scan and repair any detected issues with your company file.
4. Check for Data Corruption: Data corruption in your company file can lead to crashes in QuickBooks Enterprise. Use the Verify Data and Rebuild Data utilities to check for and repair data integrity issues. Go to the File menu, select Utilities, and then Verify Data. Follow the prompts to repair any detected issues.
5. Disable Compatibility Mode: If you’ve enabled compatibility mode for QuickBooks Enterprise, it may be conflicting with the software and causing crashes. Right-click the QuickBooks Desktop shortcut icon, select Properties, and navigate to the Compatibility tab. Ensure that the “Run this program in compatibility mode for” option is unchecked.
6. Update Windows and Drivers: Ensure your Windows operating system and device drivers are up to date. Outdated operating systems or drivers can cause compatibility issues with QuickBooks Enterprise, leading to crashes. Check for and install any available Windows updates, as well as updates for your device drivers.
7. Review Event Viewer Logs: Check the Event Viewer logs on your computer for any system errors or warnings related to QuickBooks Enterprise crashes. Open Event Viewer by pressing Windows key + R, typing “eventvwr.msc” in the Run dialog, and pressing Enter. Look for any critical or error events under Windows Logs > Application.
8. Clean Install QuickBooks Enterprise: If all else fails, consider performing a clean install of QuickBooks Enterprise. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Ensure you back up your company file before reinstalling.
By following these troubleshooting solutions, you can effectively address the issue of QuickBooks Enterprise 2024 keeps crashing and restore stability to your accounting software. If the problem persists after attempting these steps, consider reaching out to QuickBooks support for further
assistance.
Troubleshooting Solutions : QuickBooks Enterprise 2024 keeps crashing Dealing with QuickBooks Enterprise 2024 keeps crashing can be frustrating, but several troubleshooting steps can help resolve the issue and ensure smooth operation of the software. 1. Update QuickBooks Enterprise: Ensure you’re using the latest version of QuickBooks Enterprise 2024. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.2. Verify System Requirements: Ensure your computer meets the minimum system requirements for running QuickBooks Enterprise 2024. Inadequate hardware or outdated software can lead to performance issues and crashes. Check the QuickBooks support website for the system requirements for your version.3. Run QuickBooks File Doctor: QuickBooks File Doctor is a tool designed to diagnose and repair issues that can cause crashes and other errors. Download and run the QuickBooks File Doctor from the Intuit website. Follow the on-screen instructions to scan and repair any detected issues with your company file.4. Check for Data Corruption: Data corruption in your company file can lead to crashes in QuickBooks Enterprise. Use the Verify Data and Rebuild Data utilities to check for and repair data integrity issues. Go to the File menu, select Utilities, and then Verify Data. Follow the prompts to repair any detected issues.5. Disable Compatibility Mode: If you’ve enabled compatibility mode for QuickBooks Enterprise, it may be conflicting with the software and causing crashes. Right-click the QuickBooks Desktop shortcut icon, select Properties, and navigate to the Compatibility tab. Ensure that the “Run this program in compatibility mode for” option is unchecked.6. Update Windows and Drivers: Ensure your Windows operating system and device drivers are up to date. Outdated operating systems or drivers can cause compatibility issues with QuickBooks Enterprise, leading to crashes. Check for and install any available Windows updates, as well as updates for your device drivers.7. Review Event Viewer Logs: Check the Event Viewer logs on your computer for any system errors or warnings related to QuickBooks Enterprise crashes. Open Event Viewer by pressing Windows key + R, typing “eventvwr.msc” in the Run dialog, and pressing Enter. Look for any critical or error events under Windows Logs > Application.8. Clean Install QuickBooks Enterprise: If all else fails, consider performing a clean install of QuickBooks Enterprise. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Ensure you back up your company file before reinstalling. By following these troubleshooting solutions, you can effectively address the issue of QuickBooks Enterprise 2024 keeps crashing and restore stability to your accounting software. If the problem persists after attempting these steps, consider reaching out to QuickBooks support for furtherassistance. Read More
How to fix QuickBooks Enterprise 2024 keeps shutting down after update?
Troubleshooting Solutions : QuickBooks Enterprise 2024 keeps shutting down
Persistent QuickBooks Enterprise 2024 keeps shutting down can significantly disrupt business operations, but several troubleshooting steps can help identify and resolve the underlying issues causing these shutdowns.
1. Update QuickBooks Enterprise: Ensure you have the latest version of QuickBooks Enterprise installed. Developers frequently release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.
2. Review System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Enterprise 2024. Inadequate hardware or outdated software can lead to performance issues and unexpected shutdowns. Visit the QuickBooks support website to review the system requirements for your version.
3. Check Event Viewer Logs: Inspect the Event Viewer logs on your computer to identify any system errors or warnings related to QuickBooks Enterprise shutdowns. Open Event Viewer by pressing Windows key + R, typing “eventvwr.msc” in the Run dialog, and pressing Enter. Look for any critical or error events under Windows Logs > Application.
4. Disable Antivirus or Security Software: Overzealous antivirus or security software can mistakenly flag QuickBooks Enterprise processes as threats, leading to unexpected shutdowns. Temporarily disable your antivirus or security software and check if the issue persists. If the shutdowns stop, add QuickBooks Enterprise to the software’s exceptions list.
5. Verify Company File: A corrupted or damaged company file can cause QuickBooks Enterprise to shut down unexpectedly. Use the Verify Data utility to check for data integrity issues and the Rebuild Data tool to fix them. Go to the File menu, select Utilities, and then Verify Data. Follow the prompts to repair any detected issues.
6. Clean Install QuickBooks Enterprise: If none of the above solutions resolve the issue, consider performing a clean reinstall of QuickBooks Enterprise. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Ensure you back up your company file before reinstalling.
7. Contact QuickBooks Support: If you’re still experiencing shutdowns after trying the troubleshooting steps, reach out to QuickBooks support for further assistance. They can provide personalized guidance and additional troubleshooting steps to address the issue effectively.
By following these troubleshooting solutions, you can identify and resolve the underlying issues causing QuickBooks Enterprise 2024 keeps shutting down unexpectedly. Restoring stability to your accounting software will help minimize disruptions and ensure smooth business operations.
Troubleshooting Solutions : QuickBooks Enterprise 2024 keeps shutting down Persistent QuickBooks Enterprise 2024 keeps shutting down can significantly disrupt business operations, but several troubleshooting steps can help identify and resolve the underlying issues causing these shutdowns. 1. Update QuickBooks Enterprise: Ensure you have the latest version of QuickBooks Enterprise installed. Developers frequently release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.2. Review System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Enterprise 2024. Inadequate hardware or outdated software can lead to performance issues and unexpected shutdowns. Visit the QuickBooks support website to review the system requirements for your version.3. Check Event Viewer Logs: Inspect the Event Viewer logs on your computer to identify any system errors or warnings related to QuickBooks Enterprise shutdowns. Open Event Viewer by pressing Windows key + R, typing “eventvwr.msc” in the Run dialog, and pressing Enter. Look for any critical or error events under Windows Logs > Application.4. Disable Antivirus or Security Software: Overzealous antivirus or security software can mistakenly flag QuickBooks Enterprise processes as threats, leading to unexpected shutdowns. Temporarily disable your antivirus or security software and check if the issue persists. If the shutdowns stop, add QuickBooks Enterprise to the software’s exceptions list.5. Verify Company File: A corrupted or damaged company file can cause QuickBooks Enterprise to shut down unexpectedly. Use the Verify Data utility to check for data integrity issues and the Rebuild Data tool to fix them. Go to the File menu, select Utilities, and then Verify Data. Follow the prompts to repair any detected issues.6. Clean Install QuickBooks Enterprise: If none of the above solutions resolve the issue, consider performing a clean reinstall of QuickBooks Enterprise. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Ensure you back up your company file before reinstalling.7. Contact QuickBooks Support: If you’re still experiencing shutdowns after trying the troubleshooting steps, reach out to QuickBooks support for further assistance. They can provide personalized guidance and additional troubleshooting steps to address the issue effectively. By following these troubleshooting solutions, you can identify and resolve the underlying issues causing QuickBooks Enterprise 2024 keeps shutting down unexpectedly. Restoring stability to your accounting software will help minimize disruptions and ensure smooth business operations. Read More
Rules – Outlook Desktop
I have recently added a Web based email provider but still want to use Outlook (2019) as my front end. At present I created a new Profile for the IMAP based account but still want to access my existing POP3 based account until all contacts have updated to my new email address.
My issue is with Rules in that I assumed that Rules would be applied at the Account level but that appears not to be the case as they seem to be applied at the Profile level. Based on advice from another thread I then added the condition “message has arrived through the ********* Account” to one of my rules as a test. However, when checking the Rule in the other Account I find that the same Account reference has also been applied in that Account which is clearly not what I want to happen.
This leads me to think that the Rules are applied at Profile level and not at Account level despite A different account being specified in the Rule settings.
Has anyone a similar experience or suggested solutions?
I have recently added a Web based email provider but still want to use Outlook (2019) as my front end. At present I created a new Profile for the IMAP based account but still want to access my existing POP3 based account until all contacts have updated to my new email address.My issue is with Rules in that I assumed that Rules would be applied at the Account level but that appears not to be the case as they seem to be applied at the Profile level. Based on advice from another thread I then added the condition “message has arrived through the ********* Account” to one of my rules as a test. However, when checking the Rule in the other Account I find that the same Account reference has also been applied in that Account which is clearly not what I want to happen.This leads me to think that the Rules are applied at Profile level and not at Account level despite A different account being specified in the Rule settings.Has anyone a similar experience or suggested solutions? Read More
Need help simplifying my nested IF formula
So I have been tracking my progress in transcribing classical music pieces by using nested IF statements to determine whether a multi-part piece is partly or completely done from inputs in the individual parts. For something like a 4 movement symphony or sonata, that nested IF statement looks like so:
=IF(E13=”Partly”,”Partly”,IF(E13=”Yes”,IF(E14=”Yes”,IF(E15=”Yes”,IF(E16=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”No”))
And the results:
All movements cells set to the value of No = No in full piece cell
Partly in first movement cell = Partly in full piece cell
Any movement cells from the first to the second to last set to Yes +/- last movement set to Partly = Partly in full piece cell
All movement cells set to Yes = Yes in full piece cell
Not too bad. But what if I’m dealing with pieces/piece sets that have many many parts to them? Like say a set of 25 folk songs? Well now the nested IF formula looks like this:
=IF(E663=”Partly”,”Partly”,IF(E663=”Yes”,IF(E664=”Yes”,IF(E665=”Yes”,IF(E666=”Yes”,IF(E667=”Yes”,IF(E668=”Yes”,IF(E669=”Yes”,IF(E670=”Yes”,IF(E671=”Yes”,IF(E672=”Yes”,IF(E673=”Yes”,IF(E674=”Yes”,IF(E675=”Yes”,IF(E676=”Yes”,IF(E677=”Yes”,IF(E678=”Yes”,IF(E679=”Yes”,IF(E680=”Yes”,IF(E681=”Yes”,IF(E682=”Yes”,IF(E683=”Yes”,IF(E684=”Yes”,IF(E685=”Yes”,IF(E686=”Yes”,IF(E687=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),),”Partly”),”Partly”),”Partly”),”Partly”),”No”))
And with operas, it gets even worse cause I have multiple levels of these nested IF formulas like so:
Full Opera Level, Nested IF formula includes Overture and individual acts:
=IF(F2506=”Partly”,”Partly”,IF(F2506=”Yes”,IF(F2507=”Yes”,IF(F2532=”Yes”,IF(F2553=”Yes”,IF(F2580=”Yes”,IF(F2603=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”No”))
Act Level, Nested IF formula includes individual scenes:
=IF(F2508=”Partly”,”Partly”,IF(F2508=”Yes”,IF(F2512=”Yes”,IF(F2515=”Yes”,IF(F2518=”Yes”,IF(F2521=”Yes”,IF(F2524=”Yes”,IF(F2528=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”No”))
Scene Level, Nested IF formula includes individual sections within, very comparable to the symphony/sonata example I mentioned before.
Is there any way to simplify this down while still keeping the changes that result for each piece/piece set/opera level as I complete the individual movements/pieces/opera sections?
So I have been tracking my progress in transcribing classical music pieces by using nested IF statements to determine whether a multi-part piece is partly or completely done from inputs in the individual parts. For something like a 4 movement symphony or sonata, that nested IF statement looks like so:=IF(E13=”Partly”,”Partly”,IF(E13=”Yes”,IF(E14=”Yes”,IF(E15=”Yes”,IF(E16=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”No”))And the results:All movements cells set to the value of No = No in full piece cellPartly in first movement cell = Partly in full piece cellAny movement cells from the first to the second to last set to Yes +/- last movement set to Partly = Partly in full piece cellAll movement cells set to Yes = Yes in full piece cellNot too bad. But what if I’m dealing with pieces/piece sets that have many many parts to them? Like say a set of 25 folk songs? Well now the nested IF formula looks like this:=IF(E663=”Partly”,”Partly”,IF(E663=”Yes”,IF(E664=”Yes”,IF(E665=”Yes”,IF(E666=”Yes”,IF(E667=”Yes”,IF(E668=”Yes”,IF(E669=”Yes”,IF(E670=”Yes”,IF(E671=”Yes”,IF(E672=”Yes”,IF(E673=”Yes”,IF(E674=”Yes”,IF(E675=”Yes”,IF(E676=”Yes”,IF(E677=”Yes”,IF(E678=”Yes”,IF(E679=”Yes”,IF(E680=”Yes”,IF(E681=”Yes”,IF(E682=”Yes”,IF(E683=”Yes”,IF(E684=”Yes”,IF(E685=”Yes”,IF(E686=”Yes”,IF(E687=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),),”Partly”),”Partly”),”Partly”),”Partly”),”No”)) And with operas, it gets even worse cause I have multiple levels of these nested IF formulas like so: Full Opera Level, Nested IF formula includes Overture and individual acts:=IF(F2506=”Partly”,”Partly”,IF(F2506=”Yes”,IF(F2507=”Yes”,IF(F2532=”Yes”,IF(F2553=”Yes”,IF(F2580=”Yes”,IF(F2603=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”No”)) Act Level, Nested IF formula includes individual scenes:=IF(F2508=”Partly”,”Partly”,IF(F2508=”Yes”,IF(F2512=”Yes”,IF(F2515=”Yes”,IF(F2518=”Yes”,IF(F2521=”Yes”,IF(F2524=”Yes”,IF(F2528=”Yes”,”Yes”,”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”Partly”),”No”)) Scene Level, Nested IF formula includes individual sections within, very comparable to the symphony/sonata example I mentioned before. Is there any way to simplify this down while still keeping the changes that result for each piece/piece set/opera level as I complete the individual movements/pieces/opera sections? Read More
Get-SPOTenantServicePrincipalPermissionGrants unknown error
I have been unable to run Get-SPOTenantServicePrincipalPermissionGrants to tenant service principal permission grants since Saturday 27th April 2024.
I have been unable to run Get-SPOTenantServicePrincipalPermissionGrants to tenant service principal permission grants since Saturday 27th April 2024. Read More
MS Teams bot task/fetch desktop app cookies
Issue: In the Teams desktop app, all cookies are not set. Only 2 cookies are getting set in the Teams desktop app.
The issue is not seen in the web-based Teams app. In the desktop app, all cookies are not showing up. Only 2 cookies are getting set in the desktop app.
1. When the URL connect.abc.com/form.html is open through task/fetch we are setting cookies and HTML content using Response.
These cookies are used to make subsequent API requests to load the drop-down values of the form. We have verified that cookies are set and working properly in a web browser.
2. The issue is in the desktop app as the desktop app is not setting all cookies it is only setting 2 cookies.
Issue: In the Teams desktop app, all cookies are not set. Only 2 cookies are getting set in the Teams desktop app. The issue is not seen in the web-based Teams app. In the desktop app, all cookies are not showing up. Only 2 cookies are getting set in the desktop app. 1. When the URL connect.abc.com/form.html is open through task/fetch we are setting cookies and HTML content using Response.These cookies are used to make subsequent API requests to load the drop-down values of the form. We have verified that cookies are set and working properly in a web browser.2. The issue is in the desktop app as the desktop app is not setting all cookies it is only setting 2 cookies. Read More
exploring options for virtual desktops for my team
Hello, I oversee a team of 4 members primarily based offshore. I aim to grant them access to our browser-based application, which currently imposes restrictions based on region. They access the application by remotely connecting to my laptops using software like Anydesk or TeamViewer. Subsequently, they utilize browsers to carry out their tasks. I’m exploring alternatives to bypass the necessity of using my laptops and provide them with access via a virtual machine hosted on platforms like AWS or Microsoft’s solutions, among others. As this area is unfamiliar, I seek guidance on determining the most cost-effective solution and its pros and cons. Thank you. Read More
Forms Feature Request – Response link copyable
We have a form set up to collect and monitor some “issues”. When I get a response, there’s a button with a link to “Go to comment”.
PROBLEM: I don’t use my default browser for office365. I can’t find a way to get the url without having to log into office/sharepoint/forms in my default browser. I can Open Hyperlink, but can’t Copy Hyperlink.
I noticed the headers and <a href> tags differ between the 2 email sources. I “withheld” the url for privacy, though you shouldn’t be able to access it if I didn’t.
REQUEST: Can we get the hyperlink in the Go to comment link automatically generated by forms to allow Copy Hyperlink?
Interestingly, I replied to the email instead of trying to get the url opened. In the response from the sender, if I scroll down to the bottom of the email, I’m able to Copy the Hyperlink!
BROKEN SOURCE:
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd“>
<html xmlns=”http://www.w3.org/1999/xhtml” xmlns:v=”urn:schemas-microsoft-com:vml” xmlns:o=”urn:schemas-microsoft-com:office:office”>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=us-ascii”>
<meta name=”viewport” content=”width=device-width, initial-scale=1″>
…
<td style=”mso-line-height-rule: exactly;width: 184px”><!–[if mso]>
<a href=”withheld”>
<v:roundrect xmlns:v=”urn:schemas-microsoft-com:vml” xmlns:w=”urn:schemas-microsoft-com:office:word” href=”withheld” style=”height:40px;v-text-anchor:middle;width:184px” arcsize=”2%” strokecolor=”#0078D7″ fillcolor=”#0078D7″>
<w:anchorlock/>
<center style=”color:#ffffff;font-family: ‘Segoe UI’, sans-serif;font-size:16px”> Go to comment </center>
</v:roundrect>
</a>
<![endif]–><!–[if !mso]> <!—-><a href=”withheld” class=”OpenButton” style=”display: inline-block; font-size: 16px; color: #ffffff; background-color: #0078D7; border-color: #0078D7; border-radius:3px;border-style:solid; text-decoration: none;text-align:center;line-height:38px;width:184px”>Go
to comment </a><!– <![endif]–></td>
WORKING SOURCE:
<html xmlns:v=”urn:schemas-microsoft-com:vml” xmlns:o=”urn:schemas-microsoft-com:office:office” xmlns:w=”urn:schemas-microsoft-com:office:word” xmlns:m=”http://schemas.microsoft.com/office/2004/12/omml” xmlns=”http://www.w3.org/TR/REC-html40“><head><meta http-equiv=Content-Type content=”text/html; charset=us-ascii”><meta name=Generator content=”Microsoft Word 15 (filtered medium)”><!–[if !mso]><style>v:* {behavior:url(#default#VML);}
o:* {behavior:url(#default#VML);}
w:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]–>
…
<td width=184 style=’width:138.0pt;padding:.75pt .75pt .75pt .75pt;height:30.0pt’><p class=MsoNormal style=’mso-line-height-alt:0pt’><a href=”withheld”><span style=’font-size:1.0pt;background:#F3F2F1;text-decoration:none’><img border=0 width=186 height=42 style=’width:1.9375in;height:.4375in’ id=”Picture_x0020_7″ src=”cid:image012.png@01DA9BDD.BAD65FA0″ alt=”Go to comment “></span></a><span style=’font-size:1.0pt’><o:p></o:p></span></p></td><td style=’padding:.75pt .75pt .75pt .75pt;height:30.0pt’></td></tr><tr><td style=’padding:.75pt .75pt .75pt .75pt’></td>
We have a form set up to collect and monitor some “issues”. When I get a response, there’s a button with a link to “Go to comment”. PROBLEM: I don’t use my default browser for office365. I can’t find a way to get the url without having to log into office/sharepoint/forms in my default browser. I can Open Hyperlink, but can’t Copy Hyperlink. I noticed the headers and <a href> tags differ between the 2 email sources. I “withheld” the url for privacy, though you shouldn’t be able to access it if I didn’t. REQUEST: Can we get the hyperlink in the Go to comment link automatically generated by forms to allow Copy Hyperlink? Interestingly, I replied to the email instead of trying to get the url opened. In the response from the sender, if I scroll down to the bottom of the email, I’m able to Copy the Hyperlink!BROKEN SOURCE:<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”><html xmlns=”http://www.w3.org/1999/xhtml” xmlns:v=”urn:schemas-microsoft-com:vml” xmlns:o=”urn:schemas-microsoft-com:office:office”><head><meta http-equiv=”Content-Type” content=”text/html; charset=us-ascii”><meta name=”viewport” content=”width=device-width, initial-scale=1″>…<td style=”mso-line-height-rule: exactly;width: 184px”><!–[if mso]><a href=”withheld”><v:roundrect xmlns:v=”urn:schemas-microsoft-com:vml” xmlns:w=”urn:schemas-microsoft-com:office:word” href=”withheld” style=”height:40px;v-text-anchor:middle;width:184px” arcsize=”2%” strokecolor=”#0078D7″ fillcolor=”#0078D7″><w:anchorlock/><center style=”color:#ffffff;font-family: ‘Segoe UI’, sans-serif;font-size:16px”> Go to comment </center></v:roundrect></a><![endif]–><!–[if !mso]> <!—-><a href=”withheld” class=”OpenButton” style=”display: inline-block; font-size: 16px; color: #ffffff; background-color: #0078D7; border-color: #0078D7; border-radius:3px;border-style:solid; text-decoration: none;text-align:center;line-height:38px;width:184px”>Goto comment </a><!– <![endif]–></td> WORKING SOURCE:<html xmlns:v=”urn:schemas-microsoft-com:vml” xmlns:o=”urn:schemas-microsoft-com:office:office” xmlns:w=”urn:schemas-microsoft-com:office:word” xmlns:m=”http://schemas.microsoft.com/office/2004/12/omml” xmlns=”http://www.w3.org/TR/REC-html40″><head><meta http-equiv=Content-Type content=”text/html; charset=us-ascii”><meta name=Generator content=”Microsoft Word 15 (filtered medium)”><!–[if !mso]><style>v:* {behavior:url(#default#VML);}o:* {behavior:url(#default#VML);}w:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}</style><![endif]–>…<td width=184 style=’width:138.0pt;padding:.75pt .75pt .75pt .75pt;height:30.0pt’><p class=MsoNormal style=’mso-line-height-alt:0pt’><a href=”withheld”><span style=’font-size:1.0pt;background:#F3F2F1;text-decoration:none’><img border=0 width=186 height=42 style=’width:1.9375in;height:.4375in’ id=”Picture_x0020_7″ src=”cid:image012.png@01DA9BDD.BAD65FA0″ alt=”Go to comment “></span></a><span style=’font-size:1.0pt’><o:p></o:p></span></p></td><td style=’padding:.75pt .75pt .75pt .75pt;height:30.0pt’></td></tr><tr><td style=’padding:.75pt .75pt .75pt .75pt’></td> Read More