Guide to Importing/Modeling DATE values into LDMS with Data Analytics

Version 8

    Verified Product Versions

    Endpoint Manager 9.6Endpoint Manager 2016.xEndpoint Manager 2018.x

    There may be an instance in which you may want to import date's into your LDMS Inventory. Let's say for instance if you were importing this data into a new attribute in inventory all you'd have to do is simply name the new attribute in your import rule and you're done. Unfortunately when importing DATE types it doesn't work the same way. In order to import a date you will need to first model the inventory attribute.


    Here's an example of the process you'd take in order to set this up.  Make sure you have a good fresh backup of your database before making any modifications:


    Step 1: Model your inventory attributes.

    • Navigate to Data Translation Services (DTS) in your Management Suite Console, then find the Model Attributes Button.



    It should look like this.


    • Then you'll want to fill out the form. It should look something like this:


         Please note that you can add this information to whatever table you like. You can even create new database tables if you put in a Table name and make sure to not check the add to existing table box.

    • Make sure to mark your Type as 99 so that you can retain your data after a full sync scan.


    • When you're done filling out all the columns and attributes you want, all you need to do is click the Model Now button. When if finishes you should be greeted with a popup similar to the following:


                        Additional Reading: Here's more info on modeling attributes using DA.


    IMPORTANT:  After making these changes to the Database, make sure to restart the LANDESK Inventory Server Service.  It would not be a bad idea to stop the inventory service first and start it back up again once you've made the changes.


    Step 2: Import your data.


    This part is pretty straight forward. I've attached a csv example of the data I'm importing here but you can set this up however you'd like.


    In the above image we are just importing 2 columns with the Device_Name column set as the Key. This way we can link this data with information already in inventory.


    So here's the device in inventory:


    Just drag and drop this guy on our new Import Rule and hit start. Now, you should be presented with a similar prompt to the one below:



              Additional Reading:Guide to Importing and Merging New Computers with Data Analytics - Data Translation Services



    Step 3: Check your work!

    At this point you should be good to go. Just double check inventory and you should see something like this:
    And there ya go! Everything imported successfully and now we can run reports and queries and evaluate these fields as actual dates and not strings!