topic Re: CSA SQL database layout in Network Security

CSA SQL database layout

JUSTIN LOUCKS — Sun, 10 Mar 2019 09:16:32 GMT

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

Re: CSA SQL database layout

gabelar — Thu, 10 Feb 2005 18:17:38 GMT

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.

Re: CSA SQL database layout

tsteger1 — Thu, 17 Feb 2005 00:55:34 GMT

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.