Endpoint Protection

 View Only

  • 1.  Is there way to generate a report from SEP that tells me ALL units and their operating systems

    Posted Mar 12, 2014 11:36 AM

    I would like to run a report that will generate all PC's and server and what OS's are installed. How can I do this? I am in the reporting area but need a little bit of a boost here.

    Thanks



  • 2.  RE: Is there way to generate a report from SEP that tells me ALL units and their operating systems

    Posted Mar 12, 2014 11:39 AM

    You can export computer status report



  • 3.  RE: Is there way to generate a report from SEP that tells me ALL units and their operating systems

    Posted Mar 12, 2014 11:40 AM

    Computer Status report sir...gives you EVERYTHING!

    Monitors >> Logs and select Computer Status

    Export to CSV and drop into Excel.



  • 4.  RE: Is there way to generate a report from SEP that tells me ALL units and their operating systems
    Best Answer

    Posted Mar 12, 2014 11:42 AM

    monitor - logs - computer status report save it as .csv

    open it in excel

    that will give you the OS info there is column called Opertating system , Colum H



  • 5.  RE: Is there way to generate a report from SEP that tells me ALL units and their operating systems

    Posted Mar 12, 2014 11:44 AM

    Some more way find OS information

    You can export Computer status report.

     SEPM-->Monitors Tab-->Logs--Computer status logs

    Exporting a log report in Symantec Endpoint Protection Manager in .csv format

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

     

    Or

    SEP Client Information Query. Query result shows:
    ♦ SEP Computer name
    ♦ Installed SEP Version
    ♦ AV definition revision with the timestamp of the last update
    ♦ Assignement to SEPM Group
    ♦ Operating System
    ♦ Logged-on User
    ♦ MAC address
    ♦ IP address

    select i.computer_name
, agent_version
, pat.version as vd_version
, dateadd(s,convert(bigint,LAST_UPDATE_TIME)/1000,'01-01-1970 00:00:00') lastupdatetime
, g.name as group_name
, i.OPERATION_SYSTEM
, i.CURRENT_LOGIN_USER
, i.MAC_addr1
, i.ip_addr1_text
, i.DELETED
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 I.DELETED = 0
order by group_name, operation_system, i.COMPUTER_name

     

    Compilation of SQL queries to the SEPM database

    https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database

    https://www-secure.symantec.com/connect/forums/sql-querys-database

     



  • 6.  RE: Is there way to generate a report from SEP that tells me ALL units and their operating systems

    Posted Mar 12, 2014 12:01 PM

    Hi, 

     

    Computer status cannot be scheduled but has to be manally made, if you would like to schedule it in the future support our idea.

    https://www-secure.symantec.com/connect/ideas/schedule-computer-status-report



  • 7.  RE: Is there way to generate a report from SEP that tells me ALL units and their operating systems

    Posted Mar 12, 2014 12:36 PM

    Hi Bryan S,

     

    The answers above are correct.  Details on all Windows and Mac machines managed by the SEPM will be contained in that report.

    If you have Linux computers in the organization, they will be included too IF you have installed and configured the optional SAVFL Reporter component.

     

    SAV for Linux: A (Somewhat) Illustrated Guide Part 4: SAVFL Reporter
    https://www-secure.symantec.com/connect/articles/sav-linux-somewhat-illustrated-guide-part-4-savfl-reporter