What table do you use for software like WinZip or Windows 10?

tammykuhns · ‎06-16-2020

We are implementing the CSDM and trying to move from everything in the software table to to appropriate tables such as cmdb_ci_service, cmdb_ci_appl, etc. I'm trying to determine where to put Configuration items used by Incident/Problem/Change which are actually software - examples: WinZip, Windows10, SnagIt, etc.

What is the best practice?

Chris Chambers1 · ‎06-16-2020

Hi Tammy,

The Software Model [cmdb_software_product_model] table is used for storing the... Software Models! e.g. Winzip v24, SnagIT 2018 etc. The actual installations of those is cmdb_sam_sw_install, mentioned before - the installs will need to relate to a Model.

You might also consider the Business Application [cmdb_ci_business_app] table to store the items you mention, which has software models related to them, through services and their lifecycles. Take a look at it, its a standard CMDB table now.

A common misconception used to be that such applications are store in the cmdb_ci_appl table, but the right home is cmdb_ci_business_app. You will need to decide which table suits your purpose: storing Software Models vs Software Installations vs Applications.

Hope this is helpful,

Chris

View solution in original post

Ashutosh Munot1 · ‎06-16-2020

Hi,

Windows 10 in my opinion is a Software model and it is installed on server or computer.

I dont know if you have SAM or not but we have and we have entry in cmdb_sam_sw_install table for each windows software mapped with CI i.e. computer or Server.

Thanks,
Ashutosh

tammykuhns · ‎06-16-2020

I agree that it would show up in the cmdb_sam_sw_install table for the tracking of software license. However, if someone calls the helpdesk with a Windows 10 issue - how would you log the incident as Windows10 because that that isn't used by incident.

Ashutosh Munot1 · ‎06-16-2020

HI,

Again, it will be installed on the Laptop or server. So they should create incident for the machine and not directly to the product.

Thanks,
Ashutosh

Paul Santaniell · ‎06-16-2020

Tammy,

I'll echo the feedback from Ashutosh. The software is not an operational CI. The operational CI is the laptop for incident, problem and change. The other approach I've seen is to put these in Business Apps, which is also not an operational CI either. We're going the software model approach for desktop apps.

Paul