cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Convert SWQL to SQL

Please help me convert the below SWQL to SQL -

SELECT [data].[Node].[DisplayName] AS [DisplayName],[data].[Databases].[Name] AS [Name],[data].[ProductVersion] AS [ProductVersion],[data].[Status] AS [Status],[data].[ProductLevel] AS [ProductLevel],[data].[OrionSite].[Status] AS [Status1],[data].[Node].[CustomProperties].[Environment] AS [Environment],[data].[InstanceType] AS [InstanceType],[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.apm.sqlserverapplication AS data
WHERE
((([data].[Status]) != (@p0)))
WITH NOLOCK RETURN XML RAW (p0=0)
0 Kudos
0 Replies