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…
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.…
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…
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":…
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…
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…
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…
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:…

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…
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…
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…
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…
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"> …
unable to create azure resource
Though I have subscription unable to create resources.

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). …
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…
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…
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,…
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. …
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…