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

Version 6

    Verified Product Versions

    LANDESK Management Suite 9.6LANDESK Management Suite 2016.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:

     

    Step 1: Model your inventory attributes.

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

    model_attr.png


    It should look like this.

     

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

    model_attr1.png

         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.

    model_attr2.png

    • 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:

    model_attr3.png

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

     

    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.

    import_date_date.png

    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:

    inventory.png

    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:

    import_date_date2.png

     

              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:
    inventory1.png
    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!