https://community.hpe.com/t5/server-management-systems/hp-sim-database-schema/m-p/3979306#M26762 I am working on a data warehousing project as part of a graduate class (IS549) at DePaul university. My class project is a simple project which will extract data from the sim database put it through the ETL process and then make it available for query/analysis. Its an academic project, so please be patient with this request.<BR /><BR />As part of extraction, I would like have a fact table that contains alerts for the week with dimension tables that provide device information. <BR /><BR />I need an assist with my dimension model (star schema), what are the best table to pull information on polling and status?. I See the device table, DB_deviceCPU, DB_deviceinfo, DB_deviceInfoEx tables have valid information. Any other suggestions for the dimensional model?. Also where can I get my hands on the schema and a description of the tables? Wed, 11 Apr 2007 09:01:20 GMT Terry Fernandez 2007-04-11T09:01:20Z https://community.hpe.com/t5/server-management-systems/hp-sim-database-schema/m-p/3979306#M26762 I am working on a data warehousing project as part of a graduate class (IS549) at DePaul university. My class project is a simple project which will extract data from the sim database put it through the ETL process and then make it available for query/analysis. Its an academic project, so please be patient with this request.<BR /><BR />As part of extraction, I would like have a fact table that contains alerts for the week with dimension tables that provide device information. <BR /><BR />I need an assist with my dimension model (star schema), what are the best table to pull information on polling and status?. I See the device table, DB_deviceCPU, DB_deviceinfo, DB_deviceInfoEx tables have valid information. Any other suggestions for the dimensional model?. Also where can I get my hands on the schema and a description of the tables? Wed, 11 Apr 2007 09:01:20 GMT https://community.hpe.com/t5/server-management-systems/hp-sim-database-schema/m-p/3979306#M26762 Terry Fernandez 2007-04-11T09:01:20Z https://community.hpe.com/t5/server-management-systems/hp-sim-database-schema/m-p/3979307#M26763 The reference I know about that covers descriptions of the tables etc. is the HPSIM User Guide - follow the attached link to the reference library;<BR /><A href="http://h18004.www1.hp.com/products/servers/management/hpsim/infolibrary.html" target="_blank">http://h18004.www1.hp.com/products/servers/management/hpsim/infolibrary.html</A><BR /><BR /> Wed, 11 Apr 2007 15:42:02 GMT https://community.hpe.com/t5/server-management-systems/hp-sim-database-schema/m-p/3979307#M26763 Rob Buxton 2007-04-11T15:42:02Z