Device Export from Wyse Management Suite

Tagged: 

Viewing 12 posts - 1 through 12 (of 12 total)
  • Author
    Posts
  • December 17, 2019 at 12:31 pm #51428
    duncanblake36
    Participant
    • Total Post: 25
    • Regular Joe
    • ★★

    Hi Guys,

    Can some one please tell me how to export all the devices out of WMS to a csv.

    I need the Hostname, LAN MAC and Wireless MAC.

    Is there a simple app or command to run to get this info.

    I’m running the latest version of WMS.

    Cheers

    Duncan

    December 17, 2019 at 1:18 pm #51429
    ConfGen
    Keymaster
    • Total Post: 10692
    • Jedi Master
    • ★★★★★★★

    Click on Device tab
    Click on More Actions
    Select Export devices to CSV

    If this is not available to you, then it is a Pro feature. I am not sure at the moment.

    CG

    December 17, 2019 at 2:22 pm #51433
    Phibue
    Participant
    • Total Post: 45
    • Frequent Flyer
    • ★★★

    It’s a Pro feature.

    Check https://technicalhelp.de/topic/export-devices-from-wms-1-1/ for an alternative.

    December 17, 2019 at 9:50 pm #51437
    duncanblake36
    Participant
    • Total Post: 25
    • Regular Joe
    • ★★

    I have the free version.

    I’ve tried all those commands. Seems to be incompatible with the latest version. There has to be a simpler way to extract this info.

    is there anyway of getting a dump out of the database or similar? I need to get those MAC addresses so I can load them into our Cisco Identity Service Engine for our provisioning network.

    December 17, 2019 at 11:23 pm #51438
    ConfGen
    Keymaster
    • Total Post: 10692
    • Jedi Master
    • ★★★★★★★

    Do you get any error messages when trying the cmd commands?

    CG

    December 18, 2019 at 8:59 am #51442
    Phibue
    Participant
    • Total Post: 45
    • Frequent Flyer
    • ★★★

    I’m running WMS 1.4 and ran these commands successfully a few minutes ago:

    Batch file:

    “C:\Program Files\DELL\WMS\MongoDB\bin\mongoexport” –db stratus –collection devices –type=csv –out C:\TEMP\Export\wmsreport.csv -u stratus –authenticationDatabase “admin” /fieldFile:”C:\TEMP\Export\fields.txt”

    fields.txt

    name
    groupName
    modelName
    macAddress
    ip
    subnet
    serialNum
    devicePlatformType
    cpuFamily
    registrationTime
    isOnline
    isCompliant
    isCheckinCompliant
    isInstalledAppCompliant
    isConfigCompliant
    isCaValidationOn
    isActive
    flashSize
    lastCheckinTime
    lastConfigTime
    timezoneName
    lastLoggedInUser
    hasAlerts
    osCaption
    osBuildVersion
    mandatoryAppCompliantStatus
    uptime

     

     

     

    December 18, 2019 at 11:23 am #51453
    Phibue
    Participant
    • Total Post: 45
    • Frequent Flyer
    • ★★★

    Are you using a .bat- or .cmd-file? Did you copy & paste the command from here? If so, check the double quotes/quotation marks. Delete them and enter them manually and try again.

    December 18, 2019 at 11:26 am #51454
    duncanblake36
    Participant
    • Total Post: 25
    • Regular Joe
    • ★★

    .bat.

    Replaced all the ” with correct ones. Also replaced all the – with correct ones.

    it just doesn’t like

    -collection devices -type=csv

     

     

    December 18, 2019 at 11:56 am #51456
    Phibue
    Participant
    • Total Post: 45
    • Frequent Flyer
    • ★★★

    Try this: 

    
"C:\Program Files\DELL\WMS\MongoDB\bin\mongoexport" --db stratus --collection devices --type=csv --out C:\TEMP\Export\wmsreport.csv -u stratus --authenticationDatabase "admin" /fieldFile:"C:\TEMP\Export\fields.txt"
    December 18, 2019 at 12:03 pm #51460
    duncanblake36
    Participant
    • Total Post: 25
    • Regular Joe
    • ★★

    Champion. Works a treat now.

    Last question. I need a list of variables as I need the wireless MAC address.

    Do you have a list of what’s available?

     

    December 18, 2019 at 12:42 pm #51462
    duncanblake36
    Participant
    • Total Post: 25
    • Regular Joe
    • ★★

    All good now. Just did a view page source on the portal and it tells you.

    FYI

    Wifi Mac is

    wiFiMacAddress

    <tr><td>Wi-Fi MAC Address</td><td><$= device.wiFiMacAddress $></td></tr>

    September 22, 2022 at 4:22 am #107914
    Tuborg
    Participant
    • Total Post: 9
    • Regular Joe
    • ★★

    In the Export the Column for lastLoggedInUser is blank…

    Any Idease why  ?

  • Author
    Posts
Viewing 12 posts - 1 through 12 (of 12 total)
  • You must be logged in to reply to this topic.