Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Where do custom query resources store the entered SWQL code? Inetpub or DB?

bluefunelemental

‌for source control

Find more posts tagged with

Accepted answers

All comments

bluefunelemental

Found them in the Select * FROM [dbname].dbo.ResourceProperties WHERE PropertyName = 'SWQL'

and used this SQL to collate them

SELECT TOP 1000 r.[ResourceID]

,r.[ViewID]

,'/Orion/SummaryView.aspx?ViewID=' + CONVERT(varchar,r.viewID) AS [DetailsURL]

,r.[ViewColumn]

,r.[Position]

,r.[ResourceName]

--,[ResourceFile]

,r.[ResourceTitle]

,r.[ResourceSubTitle]

,rp.PropertyName

,rp.PropertyValue

FROM [Orion].[dbo].[Resources] r

inner join [Orion].[dbo].[ResourceProperties] rp on r.ResourceID=rp.ResourceID

where rp.PropertyName = 'SWQL'

order by ViewID,ViewColumn,Position

Quick Links