Jump to content

Master Systems Database - CMDB ***HELP***

Recommended Posts

Is anyone using the Asset CMDB for a master systems database?

We want to use the CMDB as the source of truth for all our end user systems, it would include all the relevant attributes we need such as "Sys Name", "Supplier", “who uses the system”, “who supports the system” etc.

Once we have this populated in the CMDB we wanted to then pull some of this information into an IC in the scenario;

A doctor raises a request for systems access, within the IC there is an option to select a “persona” of which he/she selects “Doctor”. We have this persona recorded against the same attribute in the CMDB for systems a doctor would use. Does anyone know whether we could use a sql filter in the “Asset Search Term” which is in the Assets Form within the IC to filter the systems which include the persona “doctor” so he/she only selects the systems related to their role. Screenshot below. This would be a complete game changer for us and prevent us having to create around 44 simple lists to account for this particular scenario. Not to mention how much this simplifies the BPM being able to inject the information and then potentially lookup "Supporting team" in the BPM to inject and manage the workflow rather than using lots of workflow branches for each simple list in the event we cannot use the CMDB as the data store. It seems like lots of the good work has been done by Hornbill but there are some small gaps (seemingly small to me but might not be for a dev) to improve this one or two steps further to really make this an advanced and enhanced feature. 


If its not possible would be a great feature request! 




@Adrian Simpkins


  • Like 1
Link to comment
Share on other sites

Thanks Dan, unfortunately your suggested way forward won't work in our scenario. The IC we are looking to introduce this feature to is for our new starter process so at this stage there isn't an AD user object created to have LDAP imported and added to a group to present the list. This would work well for our existing members of staff but ideally want a process for systems access that is consistent for new starters and existing staff to re-use the developed BPM and IC elements and save time on maintenance. 

My suggestion of creating sql filters in the Asset form to limit the dynamic drop down check box field to only show data for a specific set of Asset classes, asset types and even down to specific attributes recorded against an asset. I can see this being very useful for large organisations that use the CMDB for software/systems asset database because you have a single source of truth (CMDB) and all recorded information such as supporting team against that asset record for the BPM to act on. 

Without this our only option is to create several simple lists which require updating everytime a system/software is added or decommissioned. The BPM also then needs a a high volume of decision nodes to manage the various outcomes in the workflow and, again will need updating every time there is a change to a system/software. 


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...