Endpoint Protection

Hi All,

I am integrating SEP to our enterprise monitoring systems here and am using DB queries to enable this. One thing that I need to get is the SEP Domain Name from the database (or elsewhere) which will be used in downstream processing. I can see lots of reference to the DOMAIN_ID within the Schema document, but nothing that has the actual name.

Can anyone shed some light on how this requirement can be fulfilled?

Thanks in advance.

Dean

select domain_id from basic_metadata

Hi @Pete_4u2002,

Unfortunately not what I need.

The DOMAIN_ID is a random character string such as: 5C8D33A489AC13850115C214527C23DA

In the console the Domain will be something more human readable, such as: My Domain

What I need is how to use the DOMAIN_ID to lookup the human readable Domain name that is in the console. This will be used for reporting/alerting so needs to be more sensical than some long random character string.

Regards,

Dean

Domain Name would be Default.

Go to SEPM->Admin->Domains-> on the top you can see the Domain name as default..

If you have multiple Domains within the SEPM it is also mentioned there.............

Hope this helps

Hi @EssKay

You can try this:

SELECT [ID]
      ,[TYPE]
      ,[DOMAIN_ID]
      ,[NAME]
      ,[DESCRIPTION]
FROM [Antivirus_SEM5].[dbo].[BASIC_METADATA]
WHERE [Type] = 'SemDomain'

We get this result.

Would be really intersting to know if you get the same [ID]. I would imagine the [DOMAIN_ID] is unique to the environment. As we have two domains, we get two lines returned.

I'll update the thread about SQL queries with this new one.

Thankyou @Ian_C,

That will work a charm.