Video Screencast Help
Search Video Help Close Back
to help

Complete list of Reports in SEPM

Created: 18 Mar 2013 | 5 comments
diabolicus23's picture
diabolicus23 Partner Accredited
0 0 Votes
Login to vote

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

 

Thanks!

Discussion Filed Under:
, , , ,

Comments 5 Comments • Jump to latest comment

admin_sepm's picture
admin_sepm
Complete list of Reports in SEPM - Comment:18 Mar 2013 : Link

Read it

https://www-secure.symantec.com/connect/forums/sepm-reports-daily-basis-and-weekly-basis

Thanks.

0
Login to vote
Ambesh_444's picture
Ambesh_444 Partner Accredited
Complete list of Reports in SEPM - Comment:18 Mar 2013 : Link

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

Please mark your thread as 'SOLVED' with the answer that helps you.

0
Login to vote
Brian81's picture
Brian81 Trusted Advisor
Complete list of Reports in SEPM - Comment:18 Mar 2013 : Link

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

 

SEP Knowledge Base

Endpoint SWAT

0
Login to vote
SameerU's picture
SameerU Partner Accredited
Complete list of Reports in SEPM - Comment:18 Mar 2013 : Link

Hi

Please refer the link below:

http://www.symantec.com/business/support/index?pag...

Regards

 

0
Login to vote
Mithun Sanghavi's picture
Mithun Sanghavi Symantec Employee Technical Support Accredited
Complete list of Reports in SEPM - Comment:18 Mar 2013 : Link

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
Symantec Technical Support Engineer, SEP
MIM | MCSA | MCTS | STS | ITIL v3

Twitter: @mithun_sanghavi

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<&a

0
Login to vote