Query to list GUP servers

[Migration User]

Hi,

I would need some help in how to create a list of GUP servers.

I know that (SELECT * FROM GUP_LIST) is easy but those columns are unreadable. For example I would like to know the name, IP, status of all my GUP servers.

Cloud someone help me with this?

 

Thank you in advance!

 

Zoltán

[Migration User]

You can use GUP Health Checkong Monitore

Check this Artical.

SEP Content Distribution Monitor (for GUP health-checking)

http://www.symantec.com/connect/downloads/new-sep-content-distribution-monitor-gup-health-checking

[Mithun Sanghavi]

Hello,

The list of all GUP is listed in a file called globallist.xml, which is present in the folder.

C:\Program Files\Symantec\Symantec Endpoint Protection Manager\data\outbox\agent\gup

With this you get to know all the machines that are configured.

Another possibility is to use the Search Clients feature (Clients > Clients tab):

 

Then just export the list.

A quick and easy but powerful way is the SEP Content Distribution Monitor:

https://www-secure.symantec.com/connect/downloads/sep-content-distribution-monitor

Reference: https://www-secure.symantec.com/connect/forums/export-gup-list

Hope that helps!!

[pete]

the above tool mentioned is the one you might be interested to look into.

else brose to path on SEPM to know the list of GUP

:\Program Files\Symantec\Symantec Endpoint Protection Manager\data\outbox\agent\gup

once you identify you can serach the GUP from SEPM console to know it's status.

[Migration User]

I got it. Thanks.

[Migration User]

To answer your query using SQL as per your SELECT statement, try this:

DECLARE @TimeZoneDiff int   
SELECT @TimeZoneDiff = datediff(minute, getutcdate(), getdate())

SELECT [GUP_LIST].[GUP_ID]
      ,[GUP_LIST].[COMPUTER_ID]
      ,UPPER([SEM_COMPUTER].[COMPUTER_NAME])
      ,[GUP_LIST].[IP_ADDRESS]
      ,CAST((case when IP_ADDRESS < 0 then 0xFFFFFFFF + IP_ADDRESS else IP_ADDRESS end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDRESS < 0 then 0xFFFFFFFF + IP_ADDRESS else IP_ADDRESS end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDRESS < 0 then 0xFFFFFFFF + IP_ADDRESS else IP_ADDRESS end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDRESS < 0 then 0xFFFFFFFF + IP_ADDRESS else IP_ADDRESS end & 0xFF as VARCHAR) as GUP_IP_ADDRESS
      ,[GUP_LIST].[PORT]
      ,[GUP_LIST].[USN]
      ,dateadd(minute, @TimeZoneDiff, dateadd(second, [GUP_LIST].[TIME_STAMP]/1000, '01-01-1970 00:00:00')) as [Time Stamp]
      ,[GUP_LIST].[DELETED]
  FROM [Antivirus_SEM5].[dbo].[GUP_LIST] LEFT OUTER JOIN
                      dbo.SEM_COMPUTER ON dbo.GUP_LIST.COMPUTER_ID = dbo.SEM_COMPUTER.COMPUTER_ID

 Mithuns search is easiest from the console.

If you are looking for more SQL queries, have a look at this thread.https://www-secure.symantec.com/connect/forums/sql-querys-database. The IP address conversion is thanks to Pete_4u2002.

[Migration User]

good