Database tables with Configuration Profile information

[powellbc]

We are trying to author a report that shows which printers are deployed by which Configuration Profiles. We are doing this with a direct database query. Does anyone know which tables I should be looking at? The OS_X_Configuration_Profile... tables do not seem to include any payload information, but in the console when looking at the configuration profile information that information is there, so there must be somewhere in the db to query for it I would think.

Any ideas? The JSS is a Windows server btw, though I would think that would not matter.

[davidacland]

Not sure exactly which table is needed, but you are right, being a windows server wouldn't make a difference. Using mysql show tables; should show you a list of the tables. Hopefully one stands out.

What you are looking for sounds like it would be stored in multiple fields so it might be trickier than a standard db lookup though.

[powellbc]

I am totally comfortable doing table joins, but I cannot find a table with a name that seems to fit it. :(