Endpoint Protection

dear friends DB query for SEPM report.


use sem5
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,
dateadd(s,convert(bigint,LAST_UPDATE_TIME)/1000,'01-01-1970 00:00:00') lastupdatetime,agent_version, g.name 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

Hi,

       If you could let us know how exactly can we assist you.

Let us know what is the problem exactly  you are facing.  

the problem i am facing is not able to fatch logs from monitor tab.......thats y i am using DB query which is as above.....

I think no one in intrested in geting reports directly form DB.................

I agree with admins not bothering to directly go to the DB. Too busy fixing the clients computers.
Anyway, what particular error do you get when fetching the logs and what data are you trying to obtain?

Contact Symantec in your area if you can get hold of the Threat Reporter.

bad gateway error

thats y we devloped above script to get DB report

Here's the link on how to fix it:
https://www-secure.symantec.com/connect/forums/how-troubleshoot-bad-gateway-error-generating-reports-sepm

Kudos to Peterpan. :)