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?

 

Thanks!

Comments 5 CommentsJump to latest comment

Ambesh_444's picture

Hi,

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 g.id=sa.group_id 
inner join identity_map p on p.id=sa.last_server_id 
inner join identity_map s on s.id=sa.domain_id 
inner join identity_map q on q.id=sa.last_site_id 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,

Ambesh

"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."

.Brian'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 http://www.symantec.com/docs/TECH95538

 

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

Hello,

For SEP 11.x, check these Articles:

About the different types of Symantec Endpoint Protection Manager Reports

http://www.symantec.com/docs/TECH95538

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

http://www.symantec.com/docs/TECH95763

Trick to export customized reports from Symantec endpoint Manager

https://www-secure.symantec.com/connect/articles/trick-export-customized-reports-symantec-endpoint

 

For SEP 12.1, check these Articles below:

About the types of reports

http://www.symantec.com/docs/HOWTO81124

Viewing a daily or weekly status report

http://www.symantec.com/docs/HOWTO80812

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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