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 message 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!