[Brendan42]

Hi All.
Running BES 4.1 with Exchange. I need to be able to see what memory each of the handheld devices have, using BES Manager. I know you can select a device and go to the Device (read-only) section, but I need to export this value for all our devices. Really not happy to try and do it manually for 800 devices. Anybody know if it can be done via SNMP, BESalert, anything at all...
Thanks in advance.

[amukhey]

You mean the available memory of each device or the capacity memory of each device out of the box?

[hdawg]

I'm guessing capacity ... If you install the BESUserAdminService (you can get it here: https://www.blackberry.com/BRK/entryPoint.do) ... you can execute a BESUserAdminClient command to get the stats ...

something like: BESUserAdminClient -p PWDYOUSET -stats -users -b BESSERVERNAME

[amukhey]

Why not just do an export from the BES manager and it will give you user's PIN, model, memory, IMEI, etc. All the info necessary to creating a report.

[hdawg]

... because I'm a dooMAS and like doing it that way. Yeah, that'd be about a billion and a half times easier ... I always forget what you can and cannot export out.

[amukhey]

LOL, each person has their own way of doing things and what works for them to make their lives easier & As long as you get the things you need done

[Brendan42]

Thanks hdawg and amukhey for the replies.
I need to get the current Available memory (after apps etc.), not the memory installed on the device. Our esteemed leaders want to roll an application out to the devices but we would like to be sure it's not going to cause problems with low memory (probably just looking for an excuse to upgrade)

Hdawg, you seem to be the most active member on these forums, haven't been on a thread yet that didn't have the monkey

[hdawg]

I've just been a bit addicted the past few months. I spent a LOOOOONG time lurking and then finally decided to start contributing. Funny thing, I read / post here for selfish reasons really; it keeps me thinking and helps me do my job better. Half the questions I see here I'd never see in my job purely because of what I focus on... plus the banter back and forth is fun

Now that I went off on a tangent ... I know of know way to get the amount of free memory from a device other than Options > Status. Even the User Admin service will only give you what apps are on ... I'll ping our PAM and see if / where that might be on a feature request list.

[jibi]

It can be found in the database under the SyncDeviceMgmt table. You would need to parse it as follows:

UserConfigId: unique value for each user
TableId: For our purposes, this would be equal to 5 for the device status statistics
Data: Available Memory can be found between the <t3></t3> tags, listed in bytes (divide by 1024 and round to get KB free)

UserConfigId can be tied back to the UserConfig table and Id value to find the DisplayName.

The Data above is defined as follows:
t2: Signal
t3: Available Memory / File Free (device)
t4: Battery Level / Battery (device)
t5: Uptime (in seconds; divide by 86400 and work out the remainder)

Hope that helps. Will be a pain in the butt to tabulate otherwise. Also, this data is only reported every few hours (standard synchronization of HandheldAgent information, I believe), so it may not be completely accurate.

RIM's standard exported data has only ever included information that is stored directly in the database as a standard value. When the Manager/Handheld Config Tool has been required to do the math and parsing around the stored data, it has not been included in the exports. Hope that may explain it a bit. If you have a good programmer (PHP, ASP, scripting) who knows how to interact with an MSSQL database, then you should be able to pull this data and parse it correctly.

[hdawg]

Thank you!

[Brendan42]

Thanks all for your help, will try the database now.