Video Screencast Help

Complete list of Reports in SEPM

Created: 18 Mar 2013 | 5 comments
diabolicus23's picture

Is it possible to have a complete list of the reports that we can generate inside SEPM?


Comments 5 CommentsJump to latest comment

Ambesh_444's picture


You can run below query in your sql and you can get full report of SEPM.

Full report query.:

use bcpsem5
select pat.version as vd_version,'|',i.MAC_addr1,'|', i.CURRENT_LOGIN_USER,'|',i.computer_name,'|',i.ip_addr1_text,'|',OPERATION_SYSTEM,'|',
dateadd(s,convert(bigint,i.TIME_STAMP)/1000,'01-01-1970 00:00:00'),'|',
dateadd(s,convert(bigint,CREATION_TIME)/1000,'01-01-1970 00:00:00'),'|',i.DELETED,'|',
LAST_UPDATE_TIME,'|',agent_version,'|' as group_name from 
sem_agent as sa with (nolock) left outer join pattern pat on sa.pattern_idx=pat.pattern_idx
inner join v_sem_computer i on i.computer_id=sa.computer_id 
--inner join identity_map g on 
inner join identity_map p on 
inner join identity_map s on 
inner join identity_map q on where 
(sa.agent_type='105' or sa.agent_type='151') and sa.deleted='0' 
and (sa.major_version >10 or sa.major_version=5) and I.DELETED = 0

Thank& Regards,


"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

Brɨan's picture

This should be the full list:

About the different types of Symantec Endpoint Protection Manager Reports

Article:TECH95538  |  Created: 2009-01-14  |  Updated: 2009-01-14  |  Article URL

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.

Mithun Sanghavi's picture


For SEP 11.x, check these Articles:

About the different types of Symantec Endpoint Protection Manager Reports

How to add your favorite reports in the Symantec Endpoint Protection Manager console

Trick to export customized reports from Symantec endpoint Manager

For SEP 12.1, check these Articles below:

About the types of reports

Viewing a daily or weekly status report

Hope that helps!!

Mithun Sanghavi
Senior Consultant

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.