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

Query on Assets!!!

Created: 30 Apr 2008 • Updated: 21 May 2010 | 1 comment
Hi,
 
I want to generate a report which will display "Event Count per Asset". I got a query inside System queries which correlates Assets with Incidents, but i cant find any query which correlates Assets wid Events. Any easier way to write this query??? ...plz revert!!!
 
 
Regards,
neil
 

Comments 1 CommentJump to latest comment

lukaszfr's picture

Hi,

I think, that you can create new SQL query based on events which are related to created incidents and only these events you can correlate with Assets. Events which aren't related to an incident are stored in files on /eventarchive directory and not in database.

Regards,
Antilles