Need guidance for creating custom resource query

sankeyj

I have a SQL query that I can run on the server, but I don't know how to convert it to put it in a custom resource query. (assuming I can)  I've been looking through the SWQL filter syntax listing and a couple other docs, but this is the first time I've tried to do this resource and it's just not clear how to do it.  The examples I've seen don't look like my query at all.

This is the query, pretty simple:

SELECT ComponentStatisticData FROM [dbo].[APM_CurrentStatistics] where ApplicationName = 'all queue stats cstsgisb51'

When I run this in datamanager it works.

Any suggestions would be greatly appreciated.

thanks,
Jan

sankeyj

Figured this out on my own.  Downloaded the SolarWinds SDK tool and used it to identify the appropriate alias' for my query.