Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Security Community Blog

DB Report of all coumputers in SEPM

Created: 25 Aug 2009 • 1 comment
hemu's picture
+1 1 Vote
Login to vote

Dear Friends please find attached SQL query for DB 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

Comments 1 CommentJump to latest comment

Joe Bagnulo's picture

Hemu,
I dare say that is a beautiful work of art that rivals the great works of Michelangelo!

If I could give +100 I would!

This is an utterly fantastic time-saver that I highly recommend all administrators to schedule as an auto-refreshing table.

For anyone else also having to deal with a legacy server for managing down-level clients just omit the section below:

(

sa.MAJOR_VERSION > 10 OR sa.MAJOR_VERSION = 5)

0
Login to vote