We are also a Mobicontrol cloud customer so I went the API route. Being a Google G-suite shop I used Google App Script to query all of our devices and then query the location of our devices. The scripts put all the data into a Google Sheet. Time triggers allow us query regularly so we can do all kind of fun things like reports, graphs, alerts, and maps all with near real time data.

Here I used Awesome Tables to give us a way to see the devices on a map. I can also filter by each site which helps managers find their devices. 

Hello matt,

never try but if you can get the location of all device INSIDE the databse soti ..

Looks on your system if you have these information INSIDE the db soti 

you can export all these lat / long name of device to a other system and display a map

Thanks for your reply.

As a Cloud customer I don't have direct access to the DB so that won't be an option for me. I found a way to do this, its not elegant but it gave me the information I was seeking, your own mileage may vary.

I ran a device location report within the Mobicontrol console for the last complete period of location data collection as specified in my data collection rule. I collect data every 20 minutes so when I ran my report I was only concerned with the most recent location data so I set the report to grab only the last 30 minutes. I set CSV for the report output format.

(SOTI-- it would be great to be able ot specify a relative time instead of absolute time for reports-- instead of specifying a begin/end time/date value it would be beneficial to be able to set "Last Hour". "Last Day", etc)

Once I got the CSV I opened in Excel and deleted all columns except for device name, latitude, and longitude. I imported this new CSV into My Maps in Google Maps (https://www.google.com/maps/d/) and now I have a visual representation of the geographic distribution of my enrolled devices:

Matt,

I don't use reports. However with v15.0.0+ you can use the APIs to get the last known location. You can request location of a single device or location of all devices in a group. 

That's pretty cool Greg, do you have any info you can share to help someone "roll their own" who is not API savvy and/or a GSuite user?

Looks like we cross-posted. We aren't on v15 yet, was this method well-documented or did you have to bake it yourself? And is GSuite required for this or just easier?