[astroudjr]

I am trying to automate exporting all the device information from the BES. Is there a way to do this with in the 4.16 console? I have tried connecting to the SQL DB but with-out the schema to where all the device information is located this would take a very long time to produce a query that I need. Any help would be greatly appreciated.

I need this information to update my companies asset DB system on a daily basis.

[knottyrope]

Take a look at this

SQL Script to grab user / handheld data - Port3101.org : Your BES Connection

[astroudjr]

Thanks, this is exactly what I needed!!!!

[DavidAdams]

Alternatively use Excel to lookup your SQL directly, vUserConfigStats should have most if not all the info you need. That way there is little/no risk to your SQL by a slip in the query statement.