Importing Software Related to Computers via CSV

Importing Software Related to Computers via CSV

  • Comments 9
  • Likes

As a follow on post to the post on Importing Computers via CSV, I wanted to also share with you the method for importing information about the software installed on those computers.  Neil Lydick, one of the developers on our team, put together the resources you’ll need:

  • A management pack file that defines a new type projection.
  • A data mapping file for software and software updates.
  • A sample data file.

You’ll need to import the management pack file into SCSM first since the mapping file depends on it to import the data correctly.

Keep in mind that the System.SoftwareItem class has a compound key comprised of these five properties:

  1. Publisher
  2. ProductName
  3. VersionString
  4. IsVirtualApplication
  5. LocaleID

Each unique combination of those represents a new Software Item.  If you import a data file with this data:

Computer’s Principal Name Publisher Version String Product Name Is Virtual Application Locale ID
mycomputer1.mydomain.com Microsoft 1.0.0.0 Office Word false 1033
mycomputer1.mydomain.com Microsoft Corporation 1.0.0.0 Office Word false 1033
mycomputer2.mydomain.com Microsoft 1.0.0.0 Office Word false 1033

You will get 2 instances of Software Item – one for the one published by ‘Microsoft’ and another one published by ‘Microsoft Corporation’.  Because the first and third rows have the exact same values for all the key properties the third row will just create a new relationship between mycomputer2 and the software title that will already exist because it was created by importing the first row.

Note: If a Windows computer with the principal name specified does not already exist a new one will be created.

Software Update also has a compound key comprised of the following two properties:

  1. Title
  2. Vendor

Attached are the necessary files.

Attachment: SoftwareCSVImport.zip
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Hello Travis, what are the chances we can get a how to for importing and assigning assets to users from a csv file?  The existing documentation demonstrates how to do this with existing CIs, but I can't find anything for a custom CI.  I have a custom ci created, and can import the assets without issue, but for the life of me I cannot get the "System.ConfigItemOwnedByUser" field to be populated by the AD user name.

  • @kpm -

    You'll need to create a type projection which spans your custom class and the ConfigItemOwnedByUser relationship type.  Then you can create a CSV data file which has two columns - user domain, user name.  That will create the relationship to the user.

    You can get more informatio on CSV import here:

    blogs.technet.com/.../using-the-csv-import-feature.aspx

  • It would be nice if we could just grab this from Configuration Manager since it has all this, the perfect solution would be to get it from SCCM on a Re-occurring Schedule.  

  • @David -

    It is a part of the SCCM-SCSM connector already.   This is just an option for people that don't have SCCM.

  • This is really nice article and has also helped me in getting in to the concept...Thanks a lot..

  • well  its maby good for some people  or  very good  innformations  for some but u no >>"":::::?????{??>><<%%#@@@!!!!!!!!!!!!!!!!&&&&&&&##@@!!&&??>?>?>:":":}}:}}{{PPP{{L:<:<:<:<::<:<:@@

  • online advertising software - get your ads out today 11686
    are you spending countless hours trying to promote a product online? visit us today for time saving software, blasters and submitters that will save you hours and
    put money in your pocket. submit to over 20,000 websites in 5 minutes visit:the links on the right.
    for more information visit: (http://tinyurl.com/6j53ne6) ids (11686)

  • This post clears some doubts bout such systems. really wonderful information has been shared through this post.
    http://www.spyone.in/spy-mobile-software.html">Spy Mobile Software | http://www.stingsoftware.in/">Sting Software

  • Thanks for sharing this type of informative information.