Hardware: Physical Storage
Monitors the usage information on all media types like logical, physical Drives, external drives etc. configured on a device within N-central.
Methodology: Kimball Star Schema.
Fact Type: Transactional (Latest).
Grain: The latest available storage size of a device.
Hardware: Physical Storage schema
Hardware: Physical Storage table joins
FACT: FACT_PHYSICAL_STORAGE_LATEST
Dimension | Dimension key | Fact key | Cardinality |
---|---|---|---|
DIM_TENANT |
TENANT_DK |
TENANT_DK |
1:N |
DIM_CUSTOMER |
CUSTOMER_SK |
CUSTOMER_SK |
1:N |
DIM_CUSTOMER_LATEST |
CUSTOMER_DK |
CUSTOMER_DK |
1:N |
DIM_SITE |
SITE_SK |
SITE_SK |
1:N |
DIM_SITE_LATEST |
SITE_DK |
SITE_DK |
1:N |
DIM_DEVICE_SUMMARY |
DEVICE_SK |
DEVICE_SK |
1:N |
DIM_DEVICE_SUMMARY_LATEST |
DEVICE_DK |
DEVICE_DK |
1:N |
DIM_PHYSICAL_STORAGE |
STORAGE_DK |
STORAGE_DK |
1:N |
Boilerplate for Hardware: Physical Storage joins
Select
-- enter columns here
From SHARED_ANALYTICS_DATA.SHARED_DATA.FACT_PHYSICAL_STORAGE_LATEST f
Join SHARED_ANALYTICS_DATA.SHARED_DATA.DIM_CUSTOMER c on f.Customer_SK = c.Customer_SK
Join SHARED_ANALYTICS_DATA.SHARED_DATA.DIM_CUSTOMER_LATEST cl on f.Customer_DK = cl.Customer_DK
join SHARED_ANALYTICS_DATA.SHARED_DATA.DIM_SITE s on f.Site_SK = s.Site_SK
join SHARED_ANALYTICS_DATA.SHARED_DATA.DIM_SITE_LATEST sl on f.Site_DK = sl.Site_DK
join SHARED_ANALYTICS_DATA.SHARED_DATA.DIM_DEVICE_SUMMARY d on f.Device_SK = d.Device_SK
join SHARED_ANALYTICS_DATA.SHARED_DATA.DIM_DEVICE_SUMMARY_LATEST dl on f.Device_DK = dl.Device_DK
join SHARED_ANALYTICS_DATA.SHARED_DATA.DIM_PHYSICAL_STORAGE dp on f.Storage_DK = dp.Storage_DK
-- Group By columns here
-- Having clauses here
-- Order by columns here