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