This content has been marked as final. Show 16 replies
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?
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.
As far as queries is concerned.. Could I take a rain check.. I may need them in the near future ??
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'
group by SiteName
order by actv
This will definitely help.
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.
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.
thanks. and that was very fast i just tried it.
what tables do you think i'm most intereseted in?