Today I was working with a customer on the quality of their inventory data in the CMDB. They have some questions about the data refresh, related to the (still on-going?) datahash problem .
I'm honestly thinking that we should take some serious resolution to resolve the datahash problem outside of the product.
Now this is not what was interesting today. Rather I was saying to the customer that it would be great to have a dashboard where we could review the data quality quickly. After voicing this I went directly into SQL and crafted the query you can find below.
The result-set contains the following columns:
- Data Class Guid
- Data Class Name
- Computer Count
- Modified in the last 4 weeks
- Not modified in the last 4 week
- % up-to-date
The query tries to provide a clean result set (not returning internal data that doesn't relate to computer inventory). To achieve this result we only return...