Convert SWQL to SQL

Create Post

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 Replies

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.