topic Re: Fetch all available properties in DQL

Fetch all available properties

educampver — Thu, 01 Jun 2023 06:57:29 GMT

Hi,

Is it possible to fetch a specific entity's available properties with DQL?

Thanks.

Re: Fetch all available properties

sinisa_zubic — Thu, 01 Jun 2023 09:51:36 GMT

Hi Edu,

Just use the describe command like this, and you will get as result all potential fields

describe(dt.entity.host)

Best,
Sini

Re: Fetch all available properties

36Krazyfists — Sun, 21 Apr 2024 12:11:55 GMT

What I want is to list a host and all of its properties' values. It seems like I need to specify every property in a fieldsAdd command... There doesn't seem to be anything synonymous to

SELECT * from Hosts WHERE HostName = 'SomeServerName'

Instead, I have to know and select all of the property names ahead of time, which kind of stinks if that's the case. Definitely would be convenient to add a wildcard feature for fields if so.