BlackBerry® Enterprise Solution

[curtis]

The Subject of this post basically says it all, but I'll elaborate a bit here:

I'm trying to monitor how well our Applications and Software Configurations are deploying to users, and I need to be able to do 2 things:

1) Query the database for all users who are assigned a certain Software Configuration

then

2) Query all installed Applications for these same users

I'll then compare the 2, to see whether or not the correct applications from that Software Config are actually on there users' devices.

I already know how to query for #2, I can see the list of Apps in the SyncDeviceMgmt table

But, I haven't yet been able to find a field anywhere in the database yet that indicates what Software Configuration a user has assigned to them.

I'm wondering if there's anyone else out there who's poked around at this level before, and if you've got any insights.

thanks

[BBsingh]

you can see that in BES policy logs, not sure about DB.

[AndyDufresne · Accepted solution]

the handheldconfig table will let you know what Software Configurations you have

the userconfig table (column HandheldConfigId) will tell you which software configuration is assigned to that user in question

[curtis]

This is so simple, and yet, you have no idea how long I've been trying to get someone to give me this answer... 

Thanks

[AndyDufresne]

---

curtis wrote:

This is so simple, and yet, you have no idea how long I've been trying to get someone to give me this answer... 

Thanks

---

you're quite welcome.