CSA SQL database layout

[JUSTIN LOUCKS]

Does anyone know where to find the database layout of the SQL/MSDE database backend to the VMS/CSA software? I am looking to build some custom reporting on the data gathered by this product and figured it would be a lot easier to do if someone has already mapped out the table definitions and relationships. Any feedback or assistance would be greatly appreciated.

Justin Loucks

[gabelar]

Justin - sorry in advance for this response cause I know you want to hear otherwise. But the database schema isn't public knowledge. I guess it'sossible someone could get the information by hacking it....there is an option in CSA to report to a flat file. The recommended path for cusom reporting it to; 1) extract the data via a flat file 2) then either reimport that into a custom database schema or do operation off of the flat file. I know this sounds like a hassle but from a security standpoint standpoint roviding the database schema isn't considered a best practice.

[tsteger1]

There may be a non-intrusive way you can get this info. Since it isn't something they want publicised, I'll wait for some type of confirmation from Gregory before posting here.