406,371 questions

Sort by: Updated
Updated Created Answers
2 answers

Interpreting Risky Sign-ins

We have a conditional access policy set up that requires MFA when the sign-in risk is medium or high. We have been getting emails that state "user at risk detected" and the detail is almost always a risky sign-in from some oddball location with…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,282 questions
asked 2021-01-22T21:50:01.457+00:00
Blake Hensley 1 Reputation point
answered 2021-01-22T22:40:02.943+00:00
Marilee Turscak-MSFT 37,141 Reputation points Microsoft Employee
4 answers One of the answers was accepted by the question author.

Dynamic schema (column) mapping in Azure Data Factory using Data Flow

I was able to implement dynamic schema(column) mapping programmatically by specifying the mapping in copy activity -> translator property as mentioned in this article.…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,257 questions
asked 2020-10-06T23:22:06.63+00:00
jigsm 236 Reputation points
commented 2021-01-22T22:36:43.087+00:00
jigsm 236 Reputation points
3 answers One of the answers was accepted by the question author.

Select rows with same id but different *multiple* values in another columns

I tried for some time now, read many posts but I still can't figure out how to handle this request: How to create an output where the ID, date and all mutated data is shown (that is, including the ID, date and other data just before a change occurs, and…

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
asked 2021-01-18T13:29:14.86+00:00
Hupkes 41 Reputation points
accepted 2021-01-22T22:33:32.157+00:00
Hupkes 41 Reputation points
3 answers One of the answers was accepted by the question author.

Azure Data Factory: collectionReference not supported in dynamic TabularTranslator

Hi there, The Copy Activity doesn't use the specified "collectionReference" value in the dynamic mapping. Consider the payload: { "skip": 0, "take": 2, "rows": [ { "Column_one":…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,257 questions
asked 2020-11-05T14:28:34.143+00:00
TerrenceV 21 Reputation points
commented 2021-01-22T22:30:03.307+00:00
Catameo, Fred (Taguig City 1634) 236 Reputation points
1 answer

Im missing the config key in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network

Im having issues with my internet and one of the solutions that ive found on the internet is to delete the config key in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network so that it can regenerate but in my registry there isnt even a config…

Windows 10 Network
Windows 10 Network
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Network: A group of devices that communicate either wirelessly or via a physical connection.
2,386 questions
asked 2021-01-22T22:06:10.84+00:00
Alex 1 Reputation point
answered 2021-01-22T22:20:20.297+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

Reset sum() OVER PARTITION BY for condition

Hello, I would like to help myself, I have a table with 4 columns, (Id, Grp, Amount, SumMonto). The Amount column is money type and handles 4 decimal places. so values ​​of 0.0001 are stored. I want to add the Cumulative Amount column and every time…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,485 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
asked 2021-01-18T22:47:21.643+00:00
Napo 21 Reputation points
commented 2021-01-22T22:17:11.16+00:00
Napo 21 Reputation points
1 answer

Is there an option to Clear Azure SSO Session without closing the browser ?

I have enabled SSO for SAAS application and wanted to implement Logout , While doing this i observed that Azure SSO Session is still active in browser though i redirect the user to https://login.microsoftonline.com/common/wsfederation?wa=wsignout1.0. I…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,282 questions
asked 2021-01-22T15:18:30.36+00:00
M, Senthil Kumar 1 Reputation point
answered 2021-01-22T22:16:51.363+00:00
Marilee Turscak-MSFT 37,141 Reputation points Microsoft Employee
1 answer

Unable to resolve the IP address for the metadata endpoint error is coming while Adding AD FS as a SAML identity provider in ADB2C.

We are trying to add AD FS as a SAML identity provider using custom policies in Azure Active Directory B2C. We have configured the AD FS server using federation server proxy. We have followed the following links for the setup:…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,282 questions
asked 2021-01-22T15:57:42.857+00:00
Mohit Aggarwal 1 Reputation point
answered 2021-01-22T22:07:15.42+00:00
James Hamil 26,996 Reputation points Microsoft Employee
1 answer

three sessions in computer management\File Sessions\ are not from the correct computers

When, on our Server 2012R2 file server, I go into Computer Management, then System Tools, then Shared Folders\Sessions, it shows that I have a session open on the server. However, the computer that it says I am connecting from is incorrect. It…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,077 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,621 questions
asked 2021-01-20T22:41:49.567+00:00
Bill Tkach 11 Reputation points
commented 2021-01-22T22:05:34.777+00:00
Bill Tkach 11 Reputation points
1 answer

Cretificate & Transcript i snot available to Download

Hi, I am M Shahdab Khan my MCID: 99078114 I have passed exam 740 on 16 Jan 2021 more than 5 days have passed but still certificate and transcript is not available to download. I woul dbe highly gratefull if you can make it available to download or…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
42,090 questions
asked 2021-01-22T17:28:20.51+00:00
Mohammed Shahdab Khan 1 Reputation point
answered 2021-01-22T22:03:31.297+00:00
Anonymous
2 answers

Microsoft Report Builder connection to SQL Server DB behind VPN

I have MS Report Builder installed on my Windows 10 laptop and unable to connect to the SQL Server database that is housed on a different network and only accessible through VPN. How can I connect directly to that database to develop reports? Thank…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,485 questions
asked 2021-01-21T21:06:13.33+00:00
Linda Doan 6 Reputation points
commented 2021-01-22T21:58:37.267+00:00
Linda Doan 6 Reputation points
3 answers One of the answers was accepted by the question author.

Advanced Threat Analytics (atauser) leaks NTLMv2 hashes, captured by SpiderLabs\Responder red teaming tool.

Hello, We have Advanced Threat Analytics (ATA) 1.9 on-premise. The lightweight agents are deployed to domain controllers. Directory services data source is configured with a domain account. When running a red teaming assessment, if we run…

Microsoft Configuration Manager
asked 2021-01-06T20:47:55.117+00:00
c3rberus 21 Reputation points
accepted 2021-01-22T21:55:35.733+00:00
c3rberus 21 Reputation points
1 answer One of the answers was accepted by the question author.

Problem reading xml nodes to a table

Hi, I'm having issue reading all the ModelID's with respect to the Model. How do I get all ModelID's into the table w.r.t the CompanyCode DECLARE @XmlData XML SET @XmlData = '<Product> <Model CompanyCode="3020"> …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,485 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
asked 2021-01-22T20:49:51.893+00:00
Brian collins 141 Reputation points
accepted 2021-01-22T21:34:36.413+00:00
Brian collins 141 Reputation points
0 answers

unable to create azure resource

Though I have subscription unable to create resources.

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,282 questions
asked 2021-01-22T12:19:53.817+00:00
R, Divya 1 Reputation point
commented 2021-01-22T21:33:57.32+00:00
JamesTran-MSFT 36,811 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

openrowset-bulk insert only reading the first Json object and not parsing correctly

I'm having problems importing my data from local file originally copied from our Azure Blob container. What I'm seeing so far is that I'm only getting the first JSON object, and the OPENJSON is not paring that object correctly (I'm getting nulls). …

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
asked 2021-01-20T17:00:33.08+00:00
Anonymous
accepted 2021-01-22T21:24:39.87+00:00
Anonymous
1 answer

ThreatIntelligenceIndicator correlation and False Positive removal

Hi community, My ThreatIntelligenceIndicator table was fed from an external feed via Graph Security API. I use it to query against CommonSecurityLog with a query like so: let QueryTime=ago(4h) CommonSecurityLog | where…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,477 questions
Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
1,497 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.
1,222 questions
asked 2021-01-22T00:11:01.407+00:00
SentinelNoob 191 Reputation points
commented 2021-01-22T21:13:34.253+00:00
Marilee Turscak-MSFT 37,141 Reputation points Microsoft Employee
1 answer

received email Start using Conditional Access in Azure Active Directory by 30 January 2021

I received this email: Start using Conditional Access in Azure Active Directory by 30 January 2021 Directory by 30 January 2021 You're receiving this email because you use the preview of configurable token lifetimes in Azure Active Directory (Azure…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,282 questions
asked 2021-01-22T20:38:35.68+00:00
sachin sontakke 1 Reputation point
answered 2021-01-22T21:01:31.737+00:00
Marilee Turscak-MSFT 37,141 Reputation points Microsoft Employee
1 answer

Get MS Forms response and fill PDF template

I am trying to create a flow that gets response from an MS Forms and matched the answers into an editable PDF file. I can't seem to find a way to do that without using 3rd party licenses. Any ideas? I have tried using OneDrive create file,…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
42,090 questions
asked 2021-01-22T20:51:49.143+00:00
Samantha Deakin 1 Reputation point
answered 2021-01-22T20:54:31.993+00:00
Anonymous
3 answers

Help to change INF file for install drivers in windows 10

Hi everyone. I have an USB wireless adapter, ID MQ4WUG2400, and the update driver stopped on windows XP version. I used it until windows 7 but I cannot in windows 10. I would like help to change the INF file to enable the installation in windows 10. …

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,077 questions
asked 2021-01-15T19:34:39.307+00:00
Robrazil 1 Reputation point
commented 2021-01-22T20:42:00.553+00:00
Pavel A 431 Reputation points
3 answers One of the answers was accepted by the question author.

Intranet for non-365 users

We have had SharePoint since SharePoint 2003. Several years ago we made the jump to SharePoint Online/Office 365 from SharePoint 2016 on premise. At the time, we had just migrated to SharePoint 2016 Server the year before so my supervisor did not want…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,227 questions
asked 2021-01-08T18:25:49.24+00:00
Forbes, Nancy 21 Reputation points
accepted 2021-01-22T20:40:02.613+00:00
Forbes, Nancy 21 Reputation points