Set Custodian from Asset Import

Ben_HoltBen_Holt Customer IT Monkey ✭
Is it possible to set the Custodian field from a CSV file asset import? I've got an automated CSV file generated from our MDM system that contains the information about our cell phones and tablets, but I can't seem to figure out how to import the custodian when trying to map the fields with the import connector.

Thanks
Ben

Answers

  • Roland_KindRoland_Kind Partner Adept IT Monkey ✭✭
    Hi Ben, 

    I am not familiar with the Asset Import Connector - but using the Default SCSM Method it is just a matter of the appropriate type projection (e.g. for Windows Computer)

    ProjectionType: Microsoft.Windows.Computer.ProjectionType
    ProjectionSeed: Microsoft.Windows.Computer
    Components:
       Alias                          TargetType                                                             TargetEndPoint
       -----                          ----------                                                             ---------------
       PhysicalComputer               Microsoft.SystemCenter.ConfigurationManager.DeployedComputer    DeployedComputer
       OperatingSystem                Microsoft.Windows.OperatingSystem                                      OperatingSystem
       NetworkAdapter                 Microsoft.Windows.Peripheral.NetworkAdapter                            LogicalDevice
       Processor                      Microsoft.Windows.Peripheral.Processor                                 LogicalDevice
       PhysicalDisk                   Microsoft.Windows.Peripheral.PhysicalDisk                              LogicalDevice
       LogicalDisk                    Microsoft.Windows.Peripheral.LogicalDisk                               LogicalDevice
       PrimaryUser                    System.User                                                            UsedBy
       Custodian                      System.User                                                            OwnedBy
       ImpactedWorkItem               System.WorkItem                                                        RelatesToWorkItem
       RelatedWorkItem                System.WorkItem                                                        IsAboutConfigItems
       FileAttachment                 System.FileAttachment                                                  FileAttachment
       RelatedConfigItem              System.ConfigItem                                                      TargetConfigItem
       RelatedConfigItemSource        System.ConfigItem                                                      SourceConfigItem
       RelatedKnowledgeArticles       System.Knowledge.Article                                               KnowledgeDocument

    and using an according XML template like this one:

    <CSVImportFormat>
          <Projection Type="Microsoft.Windows.Computer.ProjectionType">
            <Seed>
              <Class Type="Microsoft.Windows.Server.Computer">           
                <Property ID="PrincipalName"/>
                <Property ID="PhysicalProcessors"/>
                <Property ID="LogicalProcessors"/>           
                <Property ID="IsVirtualMachine"/>          
                <Property ID="ActiveDirectoryObjectSid"/>            
                <Property ID="LastInventoryDate"/>           
              </Class>
            </Seed>
          
            <Component Alias="PhysicalComputer">
              <Seed>
                <Class Type="Microsoft.SystemCenter.ConfigurationManager.DeployedComputer">  
                <Property ID="HardwareId"/> 
                <Property ID="Manufacturer"/>
                <Property ID="DisplayName"/> 
                <Property ID="NumberOfProcessors"/>
                </Class>
              </Seed>
            </Component>     
          
            <Component Alias="OperatingSystem">
              <Seed>
                <Class Type="Microsoft.Windows.OperatingSystem">
                  <Property ID="OSVersionDisplayName"/>      
                  <Property ID="LogicalProcessors"/>                                               
                </Class>
              </Seed>
             </Component>
           
            <Component Alias="Processor">
          <Seed>
            <Class Type="Microsoft.Windows.Peripheral.Processor">
              <Property ID="Name"/>                 
              <Property ID="DeviceID"/>
              <Property ID="DisplayName"/>        
              <Property ID="Speed"/>         
            </Class>
          </Seed>
        </Component>
                   
          </Projection>
        </CSVImportFormat>

    maybe this helps you - as you can see, the custodian is a member of the type projection :-)

    regards

    Roland
Sign In or Register to comment.