Video Screencast Help

Export SEP Computer info from SQL

Created: 28 Oct 2010 | 3 comments

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?

Comments 3 CommentsJump to latest comment

mon_raralio's picture

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.

“Your most unhappy customers are your greatest source of learning.”

pete_4u2002's picture

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

pete_4u2002's picture

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

Therew are columsn processor_nuim and processor_type.

Hope that helps :-)