97,632 questions

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

SQL Max(Date) query could return multiple rows

Having a devil of a time trying to find a query to return what I need. I have a table as above. I am trying to use max(eff_date) to return the last record(s). Most of the time, only 1 record will be returned for the max(eff_date), but sometimes, more…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,818 questions
asked 2024-05-13T14:12:50.9366667+00:00
Joseph Mancini 41 Reputation points
commented 2024-05-13T15:03:09.8+00:00
Joseph Mancini 41 Reputation points
4 answers One of the answers was accepted by the question author.

Users with MFA: Enabled, Disabled, Enforced

I manage a Azure AD Does anyone have a PowerShell script that can help me get all users from Azure Active directory with MFA: Enabled, Disabled, Enforced Thanks for the help.

PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,103 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,691 questions
asked 2023-08-09T19:25:14.8066667+00:00
GuestGuivenchi 105 Reputation points
commented 2024-05-13T15:02:11.83+00:00
Rich Matheisen 45,096 Reputation points
2 answers One of the answers was accepted by the question author.

Can a single Entra P1 license be used to collect account configuration data within a tenant without requiring P1 licenses for every user?

I am trying to evaluate a tenant's user accounts for proper configuration of conditional access policies, MFA registration, and more. I've found that a single service account with a P1 license can query the graph API for this information, but I'm unsure…

Microsoft Entra
asked 2024-04-30T00:02:14.08+00:00
Vincent Tran 20 Reputation points
accepted 2024-05-13T14:49:09.0966667+00:00
Vincent Tran 20 Reputation points
1 answer One of the answers was accepted by the question author.

Migrating from VNET (Classic) to ARM has interruption on the resources?

Have a good day, Migrating from VNET (Classic) to ARM has interruption on the resources (apparentaly not) ?, Also in case something goes wrong there's a rollback for this change ? we don't want to have issues with the services. the following link is what…

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,183 questions
asked 2024-05-10T20:06:42.5266667+00:00
Herbert Rodriguez 20 Reputation points
commented 2024-05-13T14:48:47.1+00:00
KapilAnanth-MSFT 35,986 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Set ACLs on Storage Container using Powershell - Authorization Mismatch

Hi all, I am having trouble using Powershell to set ACLs on a storage account container using: Update-AzDataLakeGen2AclRecursive The error suggests that I do not have permissions, however I can set ACLs through the Azure Portal, and can set and…

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,723 questions
asked 2024-05-02T22:16:47.8533333+00:00
John Aherne 141 Reputation points
commented 2024-05-13T14:39:58.96+00:00
Amrinder Singh 2,590 Reputation points Microsoft Employee
12 answers One of the answers was accepted by the question author.

Unable to drag and drop outlook attachments to file explorer after new outlook preview turned on

Hi Everyone, Out organisation is now being prompted to try the new outlook version in preview. We have noticed that in this new version you cannot drag and drop attached files in an email to file explorer (downloads, OneDrive etc) you have to actually…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,049 questions
asked 2023-05-26T02:53:24.7633333+00:00
Elie K 545 Reputation points
answered 2024-05-13T14:36:59.7933333+00:00
VirginieMaury-5437 0 Reputation points
2 answers One of the answers was accepted by the question author.

EDI cross reference table

Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,818 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2024-04-19T19:37:38.3733333+00:00
Jonathan Brotto 60 Reputation points
accepted 2024-05-13T14:34:58.0033333+00:00
Jonathan Brotto 60 Reputation points
1 answer One of the answers was accepted by the question author.

Timeout and Connection Issues in ADF with Azure Managed Postgres: Npgsql Exception

I’m currently engaged with ADF and Azure Managed Postgres, and I’ve been encountering a persistent issue where look-ups and query-sourced copy activities consistently time out around the 35-second mark. Failures happened on 'Source' side.…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,656 questions
asked 2023-11-02T19:52:13.55+00:00
ClarissaJacquline 200 Reputation points
commented 2024-05-13T14:34:46.0366667+00:00
Emmanuel KLEIN 0 Reputation points
1 answer One of the answers was accepted by the question author.

Sharepoint Online Site Audit Log

In the Site Collection Audit log I need to run the Deleted Items report. The problem is it only gives me the option to save the document to a SharePoint location, which I do not want to do since others will see it. Is there anyway I can save the document…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,885 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,755 questions
asked 2024-05-12T10:09:12.6466667+00:00
rr-4098 1,256 Reputation points
accepted 2024-05-13T14:11:54.7166667+00:00
rr-4098 1,256 Reputation points
3 answers One of the answers was accepted by the question author.

How to create VM inside the Vmware worksation on Azure VM?

Hi Team, We have installed Vmware workstation in Azure VM (Size: Standard D4s v3) and trying to deploy/create one VM(Windows/GNS3) on top of it, but were getting error : Hyper-V is not enabled. We have enabled the Hyper-V in Azure VM and re-tried but…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,212 questions
asked 2023-07-12T10:03:32.1533333+00:00
Rajan Gahlout 20 Reputation points
edited an answer 2024-05-13T14:01:26.5866667+00:00
Alex Bykovskyi 1,831 Reputation points
1 answer One of the answers was accepted by the question author.

Data Mesh architecture implementation on Azure data lake

Hi friends, Data mesh architecture is a decentralized approach that organizes data based on business domains (e.g., marketing, sales, HR), I have the following questions Is it required to build a separate data lake for each department? When data…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,359 questions
asked 2024-05-07T09:29:55.1333333+00:00
Anshal 1,946 Reputation points
accepted 2024-05-13T13:59:26.5033333+00:00
Anshal 1,946 Reputation points
1 answer One of the answers was accepted by the question author.

Migrated SharePoint 2016 list view filtering on [Me] does not return items in SharePoint Online

All SharePoint 2016 list views filtering on [Me] migrated to SharePoint Online no longer show items when any individual views them in SharePoint Online. They do not see their items, but if they look in SharePoint 2016 they do see items. What is the…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,755 questions
asked 2024-05-07T16:12:05.72+00:00
Anita H 20 Reputation points
edited a comment 2024-05-13T13:54:13.9566667+00:00
Anita H 20 Reputation points
2 answers One of the answers was accepted by the question author.

how to make conditional format on data type:lookup for sharepoint list

Hello, Am using SharePoint 365 and I tried to make conditional format on 1 column (type: lookup) that reads from another list in the site called (dropdown list) , but am getting an error : [object Object] on this column (on left side of the table is…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,755 questions
asked 2023-01-30T08:02:33.3033333+00:00
Fahad Shaheen 20 Reputation points
commented 2024-05-13T13:53:17.34+00:00
Jeremy Erickson 0 Reputation points
1 answer One of the answers was accepted by the question author.

Sentinel bicep deployment : InvalidParameter - Solution product cannot start with 'OMSGallery/' as it is reserved for Microsoft first party solutions.

Hello, i am learning how to script and i wish to deploy Sentinel with bicep. I have created a script from Microsoft templates and have added variables as well as a jsonc parameters file. I use VSC with the bicep extension in order to "easily"…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,832 questions
Microsoft Sentinel
Microsoft Sentinel
A scalable, cloud-native solution for security information event management and security orchestration automated response. Previously known as Azure Sentinel.
991 questions
asked 2023-01-17T16:00:00.0266667+00:00
Dunvael LE ROUX 40 Reputation points
edited a comment 2024-05-13T13:41:05.5+00:00
Pradeep Laxakar 0 Reputation points
1 answer One of the answers was accepted by the question author.

Graph API Outlook Webhooks

I am trying to build a security system to monitor user's incoming emails and determine if the contents contain anything malicious. Initially, I want to use an outlook add-in, but there does not seem to be a way to automatically run the add-in…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,727 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,533 questions
asked 2023-12-05T18:01:28.3+00:00
Kyle Webster 20 Reputation points
commented 2024-05-13T13:18:27.1+00:00
Arturs Klesuns 0 Reputation points
2 answers One of the answers was accepted by the question author.

server 2016 patches

With regards to slightly older versions of windows server (namely windows server 2016), is it still standard that Microsoft issue monthly patches every month for that version, or do patches become less frequent the older a version becomes, and more…

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,391 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,210 questions
asked 2024-05-13T09:41:59.7633333+00:00
crib bar 576 Reputation points
answered 2024-05-13T13:17:30.8166667+00:00
Navanath Yenpure 155 Reputation points
1 answer One of the answers was accepted by the question author.

Adding resources to dynamic scope

I know it might be out of scope but need your inputs on this. how to add dynamic scope to existing maintenance configuration. I have created maintenance configuration using terraform. here is the code for maintenance configuration: provider…

Azure Update Manager
Azure Update Manager
An Azure service to centrally manages updates and compliance at scale.
240 questions
asked 2024-04-25T17:42:01.4333333+00:00
Varma 1,170 Reputation points
accepted 2024-05-13T13:14:06.2233333+00:00
Varma 1,170 Reputation points
2 answers One of the answers was accepted by the question author.

*.net referenced dll is not seen with a using statement

Hi, I have a project called MBSAnalysisMVCWebApp which is a web app. I reference MBSAnalysisMVCWebApp from my main MVC project called Mbsa. But when I try a using statement, It says MBSAnalysisMVCWebApp cannot be seen?  The MBSAnalysisMVCWebApp.dll…

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,291 questions
asked 2024-04-29T15:37:56.6+00:00
iqworks Information Quality Works 256 Reputation points
commented 2024-05-13T12:53:04.2333333+00:00
iqworks Information Quality Works 256 Reputation points
1 answer One of the answers was accepted by the question author.

Enable Hybrid Benefit for Linux VM

Hi All, Greetings of the Day! We wanted to deploy a Linux VM in Azure and avail Azure hybrid Benefit for the Linux VM as we have on-prem licenses. how do we avail this feature while creating the VM is there a feature to enable. After Deploying the…

Microsoft Intune Linux
Microsoft Intune Linux
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Linux: A family of open-source Unix-like operating systems.
44 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
38 questions
Windows Server Licensing
Windows Server Licensing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
23 questions
asked 2024-05-08T10:31:48.69+00:00
Ashok Chandra Venkumahanti (Microland) 40 Reputation points
accepted 2024-05-13T12:45:41.8333333+00:00
Ashok Chandra Venkumahanti (Microland) 40 Reputation points
3 answers One of the answers was accepted by the question author.

Resources and resource group stuck on delete

I attempted to delete, via Azure Portal, a resource group and its associated resources (approximately 25), which were created using Terraform, due to a corrupted state file. The deletion process was successful except for a Linux function app and its app…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,327 questions
asked 2024-05-09T14:36:05.38+00:00
Mauricio Bittar 20 Reputation points
accepted 2024-05-13T12:16:20.4633333+00:00
Mauricio Bittar 20 Reputation points