cancel
Showing results for 
Search instead for 
Did you mean: 
Dorino
Level 7
Report Inappropriate Content
Message 1 of 17

Epo Database

Hi there

Is there any documentation explaining the function of the tables within the ePO database in SQL server.
I have 17 ePO servers with more than 900 Distributed repositories, and would be helpful in running my own custom queries.

Thanks

Dorino
16 Replies
epo909
Level 9
Report Inappropriate Content
Message 2 of 17

RE: Epo Database

I never heard of any public docs about the table structure.
However you can open a support case and ask for the tables relationship.

Anyway, I have a lot of custom sql queries that might interest you. What type of query are you looking about for example?
Dorino
Level 7
Report Inappropriate Content
Message 3 of 17

EPO 3.6.1 Database Tables

Hi

Thanks

I have developed software that queries and draws the DAILY DAT status from 20 ePO servers and databases all over Africa and exports it to a Excel worksheet..

So far, it works well. (I have managed to stop people login onto the servers just to generate these stats..WHich was a time consuming process)

Some of these servers have 300 distributed repositories, and would have like to know where the repository data is stored. We need to re-create the database, and would like to find an easy way of "importing" the repositories, than manually re-creating them.

Dorino
Dorino
Level 7
Report Inappropriate Content
Message 4 of 17

RE: EPO 3.6.1 Database Tables

As far as queries is concerned.. Could I take a rain check.. I may need them in the near future ??
epo909
Level 9
Report Inappropriate Content
Message 5 of 17

RE: EPO 3.6.1 Database Tables

Epo repository configuration is not stored on DB, you need to make a copy of SiteMgr.xml from each ePO box.

This may help.
epo909
Level 9
Report Inappropriate Content
Message 6 of 17

RE: EPO 3.6.1 Database Tables

The only thing you can query the bd, regarding repository, is their activity (to know what's the most used, for balancing purposes for example), with something like this:

select Sitename, count(*) as actv from productevents
where Year(EventLocalDateTime) ='2008' and Month(EventLocalDateTime)='08'
and SiteName<>''
group by SiteName
order by actv
Dorino
Level 7
Report Inappropriate Content
Message 7 of 17

RE: EPO 3.6.1 Database Tables

Thanks

This will definitely help.

custom sql

hi: epo909

I'd be very interested in any custom queries you have and might be willing to share. I've been charged with building a suite of reports directly from the epo database and i could sure use some place to start. i'm a developer and not familiar with the epo product.
epo909
Level 9
Report Inappropriate Content
Message 9 of 17

RE: custom sql

Sure.

For example, my all time favorite is:


select eventlocaldatetime, productname, productversion,
hostname, username, virusname, name, filename, engineversion,datversion
from events, eventfilterdesc
where events.autoid > (select max(autoid) - 100 from events)
and eventfilterdesc.eventid = events.tvdeventid
and eventfilterdesc.language = '0409'
order by eventlocaldatetime desc


This returns you the last 100 entries of the 'events' table, in which you will find that is the place to be.
Even if you have a 20Gb DB (like me) the query time is very fast, so it can be used to output real time info, has a linux root-tail for example.

RE: custom sql

thanks. and that was very fast i just tried it.

what tables do you think i'm most intereseted in?