Endpoint Protection

 View Only
  • 1.  Export SEP Computer info from SQL

    Posted Oct 28, 2010 10:01 PM

    This has been boggling me for days.

    I'm trying to find the computer processor info stored in the SEP SQL Database. The Info that i'm looking for is highlighted below in red.

    Everything else in this window eg, OS, Memory, Diskspace, Can be found in the database tables besides what i'm trying to look for.

    Does anyone know where i could find this information?



  • 2.  RE: Export SEP Computer info from SQL

    Posted Oct 29, 2010 12:08 AM

    If you go to Monitors > Logs and select Computer status.

    The exported txt file when renamed to a csv file will show the processor type but not the same info that you've shown.



  • 3.  RE: Export SEP Computer info from SQL

    Broadcom Employee
    Posted Oct 29, 2010 12:17 AM

    check the DB schema reference guide , by the mean time, i will also check on the query.



  • 4.  RE: Export SEP Computer info from SQL

    Broadcom Employee
    Posted Oct 29, 2010 12:20 AM

     select * from sem_computer it should give you the result you looking for.

    Therew are columsn processor_nuim and processor_type.

     

    Hope that helps :-)