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

How to query the API to get a list of all tables matching a keyword?

Tried SWQL Studio with various SELECT LIKE keyword combinations with no success.

Thanks in advance.

Find more posts tagged with

Accepted answers

SELECT FullName

FROM Metadata.Entity

WHERE FullName LIKE '%alert%'

All comments

SELECT FullName

FROM Metadata.Entity

WHERE FullName LIKE '%alert%'

How can I avoid listing Inherited column names from the returned list of column names?

Thanks,

Reju Alex

Metadata.Property has an IsInherited property. You can use this to filter them out. Like this:

SELECT EntityName, Name, Type

FROM Metadata.Property

WHERE IsInherited=False

Quick Links