Writing to the CMDB
Hi Connect Forum Dev Community,
We have written an external intranet application that exposes assets assigned to ‘holding’ locations when not actually assigned to an employee. This is to allow managers to re-allocate idle assets as new employees commence and to put assets in a hold location when employees leave.
At the moment we are emailing the assignment requests to the IT helpdesk where the actual Altiris transfer will be carried out manually. This creates a lag time between assigning the asset in the external app and the actual assignment in Altiris.
The app lists available assets from the live Altiris database and we have identified the need to write a ‘reserved’ flag back to the table as they are assigned in the external app to a user. This will prevent the asset showing up in other managers lists as an available asset before the actual Altiris assignment can be done.
Can anyone help out with a suitable table and column that we can write the ‘Reserved’ flag to that will be visible/editable to the Altiris operator? (it will need to be deleted when the asset is assigned.) Alternativly could we just create a new table/column to accomplish this?
The next obvious step to the above is to write the asset assignment directly to Altiris from the external app, eliminating the helpdesk email and manual assignment.
Does anyone have any experience/knowledge with writing asset assignments directly to Altiris from an external app? We need to know what tables need to be populated, (there seem to be multiple tables populated for various reasons), and if any internal workflows/triggers will be affected.