Kaseya Community

Where is the DNS Name obtained within the Database Views?

  • Looking at the vMachine Database view, there's DNS Server fields (4 of them), but I'm not finding a place to pull the system's full DNS Name from, even though it's a column in the Agent Status screen..

    Can anyone advise?

  • I don't see anything in the documentation either, so I turned to SQL...

    For FQDN, try this: #vAgentSummaryGridContents.dnsComputerName#

    Computers not on a domain will return host name only. Non-Windows computers will return NULL.

  • Hello,

    If you are looking for the table which the full DNS computer name is located, you can try the following query against the "Users" ksubscribers database table.

    select dnscomputername from users where dnscomputername like '%ponce%'