SOLVED
Home

SYNTAX ERROR when trying to resolve 'ProtectionStatus'

%3CLINGO-SUB%20id%3D%22lingo-sub-1101201%22%20slang%3D%22en-US%22%3ESYNTAX%20ERROR%20when%20trying%20to%20resolve%20'ProtectionStatus'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101201%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20a%20query%20like%20this%3A%3C%2FP%3E%3CDIV%3E%3CPRE%3E%3CSPAN%3EProtectionStatus%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Elimit%3C%2FSPAN%3E%20%3CSPAN%3E150%3C%2FSPAN%3E%3C%2FPRE%3E%3CDIV%3E%3CSPAN%3EThat%20fails%20with%3A%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CPRE%3ESYNTAX%20ERROR%3CBR%20%2F%3E'take'%20operator%3A%20Failed%20to%20resolve%20table%20or%20column%20expression%20named%20'ProtectionStatus'%3C%2FPRE%3E%3CP%3EThis%20query%20used%20to%20work%206%20months%20ago%2C%20but%20now%20it%20looks%20like%20if%20table%20'ProtectionStatus'%20had%20vanished...any%20hints%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1101201%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1101803%22%20slang%3D%22en-US%22%3ERe%3A%20SYNTAX%20ERROR%20when%20trying%20to%20resolve%20'ProtectionStatus'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F513360%22%20target%3D%22_blank%22%3E%40mpena1475%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20have%20removed%20this%20solution%20pack%20(or%20its%20no%20longer%20working)%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fazuremarketplace.microsoft.com%2Fen-us%2Fmarketplace%2Fapps%2Fmicrosoft.antimalwareoms%3Ftab%3Doverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fazuremarketplace.microsoft.com%2Fen-us%2Fmarketplace%2Fapps%2Fmicrosoft.antimalwareoms%3Ftab%3Doverview%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1104416%22%20slang%3D%22en-US%22%3ERe%3A%20SYNTAX%20ERROR%20when%20trying%20to%20resolve%20'ProtectionStatus'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1104416%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3Bthat%20was%20it%2C%20thanks%20a%20lot!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
mpena1475
New Contributor

Hi all!

 

I've a query like this:

ProtectionStatus
| limit 150
That fails with:
SYNTAX ERROR
'take' operator: Failed to resolve table or column expression named 'ProtectionStatus'

This query used to work 6 months ago, but now it looks like if table 'ProtectionStatus' had vanished...any hints?

 

Thanks!

2 Replies
Highlighted
Highlighted

@Clive Watson that was it, thanks a lot!!

Related Conversations
MSTeams Groups in outlook with macros disabled
ReadyorNot in Microsoft Teams on
0 Replies
Unknown Login Error
Alex_P3462 in Microsoft Teams on
0 Replies
Spelling Pop-Up Stuck on SharePoint List
aricornish in SharePoint on
0 Replies
Problem with OneDrive
esholder in OneDrive for Business on
5 Replies