{"id":34201,"date":"2025-06-05T05:27:43","date_gmt":"2025-06-05T03:27:43","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/it-ops-cmdb-dw-with-master-data-for-commodity-hardware-software\/"},"modified":"2025-06-05T05:27:43","modified_gmt":"2025-06-05T03:27:43","slug":"it-ops-cmdb-dw-with-master-data-for-commodity-hardware-software","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/it-ops-cmdb-dw-with-master-data-for-commodity-hardware-software\/","title":{"rendered":"IT Ops CMDB\/DW With Master Data For Commodity Hardware\/software?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi Dataseters<\/p>\n<p>I&#8217;ve asked LLMs and scoured .. github etc for projects to no avail, but ideally if anyone knows of a fact\/dimension style open source schema model (not unlike BMC\/Service Now logical data CDM models) with dimensions pre-populated with typical vendors\/makes\/models both on hardware\/software dimensions. Ideally in Postgres\/Maria .. but if in Oracle etc, that&#8217;s fine too, easy conversion.<\/p>\n<p>Anyone who has Snow\/Flexera\/ServiceNow .. might build such a skeleton frame with custom tables for midrange\/networking .. w UNSPC codes etc<\/p>\n<p>Sure I can subscribe to big ITSM vendors, but ideally id just fork something the community has already built, then ETL\/ELT facts in our own use. Also DIY, it&#8217;s like reinventing the wheel, im sure many of you have already built this&#8230;<\/p>\n<p>Its a shot in the dark .. but just seeing if anyone has seen useful projects<\/p>\n<p>thanks in advance<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Laymans_Perspective\"> \/u\/Laymans_Perspective <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1l3ou6s\/it_ops_cmdbdw_with_master_data_for_commodity\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1l3ou6s\/it_ops_cmdbdw_with_master_data_for_commodity\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-34201 jlk' href='javascript:void(0)' data-task='like' data-post_id='34201' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-34201 lc'>0<\/span><\/a><\/div><\/div> <div class='status-34201 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi Dataseters I&#8217;ve asked LLMs and scoured .. github etc for projects to no avail, but ideally&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-34201","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/34201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=34201"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/34201\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=34201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=34201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=34201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}