Skip to main content
Question

Database tables with Configuration Profile information


Forum|alt.badge.img+14

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.

2 replies

davidacland
Forum|alt.badge.img+18
  • Valued Contributor
  • 1811 replies
  • July 3, 2015

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.


Forum|alt.badge.img+14
  • Author
  • Contributor
  • 238 replies
  • July 4, 2015

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings