How to manually import device serial numbers vis CSV in as Asset ID into IGEL UMS?


Hey Guys, i would like to import an Asset ID into all devices in UMS, i have a CSV list of Device Serial Number, Asset ID . is there a manual on how to do this?


Sounds like an IMI task (RestAPI) – but donโ€™t know, if updating an attribute is included already.

I assume the endpoints are in the UMS already and you want to update them with one additional attribute, right?


possible with PSIGEL: github.com/IGEL-Community/PSIGEL/blob/master/Docs/Update-UMSDevice.md


Correct all end points are in there and want to update the assit id attribute.

Thanks ill try it.

Example script:

#LOAD INSTALL-MODULES

Import-Module Posh-SSH

Import-Module PSIGEL

#just a counter

$count=0

#generate cookie

$Websession = New-UMSAPICookie -Computername igelrmserver

#Create export

#Get-UMSDevice -Computername ‘igelrmserver’ -WebSession $WebSession | Select Id,Mac | Export-Csv C:ScriptsIGELExport.csv

# PowerShell Import-CSV to View Properties

$imports = Import-Csv C:ScriptsIGELExport.csv -Delimiter ‘,’

ForEach ($import in $imports){

$AssetId = $($import.AssetId)

$Serial = $($import.Serial)

$Mac = $($import.Mac)

$Id = $($import.Id)

Update-UMSDevice -Computername ‘igelrmserver’ -WebSession $WebSession -Id $Id -AssetId $AssetId

$count=$count+1

}

Write-host $count “Devices Updated”

Example csv input:

AssetId,Serial,Mac,Id

HWWS5450,14D3F3C01B18330F30,00E0C51C370D,27855

HWWS5427,14D3F3C01B18330F37,00E0C51C3714,27856

HWWS5428,14D3F3C01B18330F42,00E0C51C371F,27857

HWWS5429,14D3F3C01B18330F77,00E0C51C3754,27858

HWWS5430,14D3F3C01B18330F80,00E0C51C375D,27859

@member @member thanks for the quick feedback.


๐Ÿ‘ great ๐Ÿ™‚


IGEL and Community rocks ๐Ÿ˜‰


Up Next: Show a QR code on screen based on this AssetID. if we need to check our CMBD or Asset management.

Continue reading and comment on the thread ‘How to manually import device serial numbers vis CSV in as Asset ID into IGEL UMS?’.  Not a member? Join Here!

Learn more, search the IGEL Knowledge Base



Ask a question or comment on the above messasge thread?

Join or log in to the IGEL Community to ask us anything and meet other IGEL customers, partners, and EUC enthusiasts.

Submit a question, or Join Today!


Popular Message Threads


Categories & Tags: