Tagged: WMS Export Device CSV
- This topic has 11 replies, 4 voices, and was last updated 1 year, 11 months ago by
Tuborg.
-
AuthorPosts
-
December 17, 2019 at 12:31 pm #51428
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 #51429Click on Device tab
Click on More Actions
Select Export devices to CSVIf 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 #51433It’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 #51437I 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 #51438Do you get any error messages when trying the cmd commands?
CG
December 18, 2019 at 8:59 am #51442I’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
uptimeDecember 18, 2019 at 11:23 am #51453Are 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.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 #51456Try 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 #51460Champion. 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 #51462All 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 #107914In the Export the Column for lastLoggedInUser is blank…
Any Idease why ?
-
AuthorPosts
- You must be logged in to reply to this topic.