(imported topic written by kd@ml91)
Is there a Visio Diagram for BigFix sql database ?
(imported comment written by BenKus)
Hi kd@ml,
Nope… although you can generate an ERD diagram automatically from SQL Server… but either way, it probably won’t be that interesting because the BigFix database tables are optimized for ongoing rapid insertions with bulk queries and so our database structure is very “flat”. We don’t maintain many foreign key relationships that usually help connect the tables (so basically your diagram would be a lot of independent tables and it probably doesn’t help much).
You can find more information on how to query the BigFix database from here: http://support.bigfix.com/cgi-bin/kbdirect.pl?id=161
Ben