Hi Everyone, We currently used a non-Microsoft Asset Management System that keeps information that SCCM would not, such as Primary User, Primary Location, Department, Primary User, Primary Use, etc. I'm looking to integrate this into SCCM so that when our IT Users run a query, report, or look at the machine properties these values are available. Currently we export what we need from SCCM, do the same from the Asset Management System, and then use Excel or a Business Intelligence product to line up everything by serial number or name. I'm very knowledgeable about the schema of the Asset Management database - I know what information we need and where to find it, I just don't know how to get it into the right place in SCCM. I looked into IDMIFs, but developing a solution where the MIF is generated and then copied to the destination computer is a bit of a reach. If these could be generated periodically and collected from a single computer it would be easier. Thanks for your thoughts, Chris.

Option 1 would be to stick these values into the computer objects in Active Directory using ADSI scripts. You could use fields like ExtensionAttribute01. You could fish them back out by adding the extra fields in Active Directory System Discovery. Option 2 would be to use Linked SQL Server tables: Creating Linked Servers (SQL Server Database Engine) http://msdn.microsoft.com/en-us/library/ff772782.aspx I'd probably go this 2nd route if it were me, though the Microsoft guys like it less when you modify their precious database :).

Hi Will, if I do a linked server, how would the tables from the linked database show up in Resource Explorer & the Query's?