How to get effective asset reporting?
I am not a SQL guy. I can make sense of stuff a bit, but everything I have done reporting wise up to this point has been some significant trial and error, so it has been slow going.
I am working on getting the report together from the data warehouse DB.
It looks like the view CiresonHardwareAssetDimvw has pretty much everything that I need in my report. The part that I am kind of stuck on is what to join in order to get the enumeration values for a couple of items.
The ModelEnum, ManufacturerEnum, HardwareAssetStatus, and HardwareAssetType fields are giving me a hard time. I can't find where to link to in order to see the actual value.
I am guessing that the data is somewhere in the DisplayStringDimvw but I am not sure what columns I can join to get it translated.
Additionally, has anyone else been disappointed with the reporting available for assets out of the box? The two reports are nice and generic, but realistically it seems like this is a little more convoluted than it should be to retrieve this kind of data. I know everything is in there, but it is a maze to navigate. Maybe it is from being relatively inexperienced with traversing a DB, but some sort of query builder or something would go a long way to improving things.