Video Screencast Help

total clients

Created: 03 Nov 2012 • Updated: 04 Nov 2012 | 2 comments
This issue has been solved. See solution.

how to see total clients on symantec endpoint protection 11.x ?

Comments 2 CommentsJump to latest comment

Ashish-Sharma's picture

If you use a SQL backend server you can run the following script in SQL Server Manager to query the number of clients you have. 

use sem5
select name as Countries, count(*) as Clients
from sem5.sem_client
left outer join sem5.identity_map on sem_client.domain_id=identity_map.id
group by name
order by Clients

Or

If you have embedded database

you can still use the query by opening dbisqlc.exe under "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32" , enter the dba username and password and copy that query to execute.

Thanks In Advance

Ashish Sharma

 

 

SOLUTION
_Brian's picture

The home page also shows this

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.