Skip to main content
Question

pulling data from Inventory?

  • October 29, 2009
  • 5 replies
  • 3 views

Looking for a pointer to the Inventory database structure, and recommendations on the best way to pull out the data (to feed to other systems).

Thanks,
Dave

5 replies

Forum|alt.badge.img+31
  • Honored Contributor
  • October 29, 2009

Email Jamf support they will give you the schematics of how their database works. They did for me when I was looking at pulling inventory data into our student check out system.


Forum|alt.badge.img+24
  • Valued Contributor
  • October 30, 2009

Hi-

Jamf Support just sent me an article on doing this and I've done the same thing.
http://jamfsoftware.com/kb/article.php?id=022

Use MySQL Query Browser to construct queries for your other system to use.

j
---
Jared F. Nichols
Desktop Engineer, Infrastructure & Operations
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436


donmontalvo
Forum|alt.badge.img+36
  • Hall of Fame
  • June 7, 2011

Seems like MySQL Query Browser has been EOL'd...any recommendations on an alternative? We've been asked to look into building queries...

http://dev.mysql.com/doc/query-browser/en/

Thanks,
Don


Forum|alt.badge.img+13

how about their suggestion? http://dev.mysql.com/downloads/workbench

or the free sequel pro: http://www.sequelpro.com


donmontalvo
Forum|alt.badge.img+36
  • Hall of Fame
  • June 7, 2011

Hi Nate,

I pointed the DBA to the link, they asked me to see what's the recommended tool for use on Mac (incase there were any favorites). Not sure if it matters what platform they're on. I'll pass along your recommendations.

Thanks,
Don