Helen Love Posted May 3, 2023 Posted May 3, 2023 Hi All I am looking for a way to automatically associated assets with suppliers. Import assets via SCCM using Asset_Data_Import_Tool. I believe you can associated them via Asset Relationship Import tool, but this appears to read data from sql database. Not sure if it can be altered to except import from SCCM. Have also seen mentioned app.cm.explorer.items.dependencies not sure if this is away to assign associations automatically. Thanks in advance.
James Ainsworth Posted May 3, 2023 Posted May 3, 2023 Hi @Helen Love Thanks for your post. 1 hour ago, Helen Love said: Have also seen mentioned app.cm.explorer.items.dependencies not sure if this is away to assign associations automatically. This setting is specific to the Configuration Explorer and doesn't do any linking. It is used for describing the type of dependencies between CIs that are already linked. 1 hour ago, Helen Love said: this appears to read data from sql database. Not sure if it can be altered to except import from SCCM. SCCM is stored in/uses a Microsoft SQL database. You should be able to use a supplier that is stored in SCCM to populate the Supplier ID field on an asset. However, if you are using Supplier Manager then the process might be a little different. I'm not familiar with linking assets to suppliers in Supplier Manager via an asset import. I'll see what I can find out or possibly someone else may be able to help with that.
Helen Love Posted May 4, 2023 Author Posted May 4, 2023 @James Ainsworth thanks for response. I was aware SCCM is using SQL database, Asset Relationship Import tool script does not take into account how to extract details from SCCM though as I say may be able to add code to do so. I have added Supplier information to Asset_Data_Import_Tool. import but not sure how to use it to automatically associate it with supplier. Thanks.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now