locked
SCSM Authoring customizing CI RRS feed

  • Question

  • Question for the super smart people =)

    We have a 3rd party Ticketing System that we are getting rid of but one of the major benefits is the Relation fields for a Person. We have a SQL database that hosts the following data (basic idea). These items are tagged by a barcode reader and obviously many things like (some phones) and Cubes are not in Active Directory or SCCM.

    Name

    Cube

    Mobile Device

    Monitor

    PC

    We are having some trouble with importing of this CI data. We created a custom computer class, and want to add aditional files to the "Computerform". Currently we can only add (1) but obviously we need to add serveral more. Once these are created we need to understand how to get this SQL data into it so we can relate the "Username" to all the associated items they own.

    The first thing that comes to mind is am I doing this all wrong? Is there a way to leverage a workflow to go get this data from SQL and fill it in / associate it to?

    Thanks in advance!!

     

    Tuesday, March 22, 2011 2:04 AM

Answers

  • If you've got access to Opalis (Sorry, System Center Ochestrator), you could look at using that.

    You could use the IP's to run a SQL query to get data out of your old system, and then use the SCSM IP's to update or create new CI Objects.

    Depending on your database layout of the old system, you could even get it to monitor for new items in it and create them within SCSM while you're migrating saving you the time of replicating the workload in both systems manually.

    Cheers,
    SB

    P.S. This might also be of interest to you if you're adding things like monitors and mobile devices etc:
    http://systemscentre.blogspot.com/2011/01/asset-management-solution-for-service.html

    I'll be updating it too in this next week or so!


    My System Center Blog
    Wednesday, March 30, 2011 6:28 AM

All replies

  • Hi,

    You could use CSV Connector aveilable in SCSM, of course you would have to exporta data from SQL to CSV first. Or you can write your own connector. Or you can use PowerShell (SMlets). Do you have to transfer data one time only or on the regular basis?

    Regards!


    http://www.purgar.net
    Tuesday, March 22, 2011 10:33 AM
  • Thanks for the reply - so it would be one time - my hope is that the fields would work and then from that point I could just update the resources in SCSM as new people / devices came in.
    Wednesday, March 23, 2011 6:56 PM
  • Hey Christian

    Based on your information, CSV import would be a good way to go. Check this blog post for details --> http://blog.scsmfaq.ch/2011/01/02/csv-import-of-objects/. I hope this helps.

    regards
    Marcel

    Wednesday, March 23, 2011 8:58 PM
  • If you've got access to Opalis (Sorry, System Center Ochestrator), you could look at using that.

    You could use the IP's to run a SQL query to get data out of your old system, and then use the SCSM IP's to update or create new CI Objects.

    Depending on your database layout of the old system, you could even get it to monitor for new items in it and create them within SCSM while you're migrating saving you the time of replicating the workload in both systems manually.

    Cheers,
    SB

    P.S. This might also be of interest to you if you're adding things like monitors and mobile devices etc:
    http://systemscentre.blogspot.com/2011/01/asset-management-solution-for-service.html

    I'll be updating it too in this next week or so!


    My System Center Blog
    Wednesday, March 30, 2011 6:28 AM