Feature Request - Perform inventory search from inputted CSV

[jarednichols]

Hi-

It would be great if I could do an inventory search based upon information inputted via CSV. We have various other tools that create reports and sometimes we need to dig and see why a machine was flagged on a report. In a current report I'm working on, 57 machines were flagged that were Macs. To even get to this, I had to export my inventory as CSV and then do vlookups in Excel. Now that I have my 57 Macs, I have to perform a search on each one to see things like their last check-in date.

If I were able to upload a properly formatted CSV (e.g. hostname is the first column of the CSV) and have the JSS return the matching machines, that would infinitely ROCK. Like a level of rock that would save me so much time.

Thanks

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

[tlarkin]

I requested something similar a while back. I wanted to import from CSV into a policy or smart group. So that way when I run a report in Casper and save to CSV or webpage or whatever I can later scope out my policy to only those machines, which actually may be spread across several smart groups.

Good idea

-Tom

[donmontalvo]

What Jared said.

Now imagine getting lists of hundreds of computers that (for whatever reason) needs to be put into a Smart Computer Group.

Now imagine how much manual labor and room for error it would be (and is) to have someone sit and copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste, copy, paste...lunch time....

Ya, import of properly formatted TAB or CSV file would be immensely helpful...more so the larger and more dynamic the environment.

I sent this in for a feature request...and I caught JAMF folks at a couple of the User Group meetings a while back to rattle their cages. I'm sure this could be a lucrative project for someone with development skills outside of the JAMF group...you know, $.99 at the Apple store... ;)

Don

[#4]

I have the same problem since we occasionally need to input machines for
testing groups or machines from casper reports that someone else has munged. I wrote a script a while ago that reads machines from a file (a single
column CSV; CSV in case I needed more fields) and pushes them into a group. It's pretty crude cause I don't use it that often but I've cleaned it up a
little for external use.

http://dl.dropbox.com/u/1826667/cg.rb

You need to add your username and password to the script. I did it that way
cause I don't like username and passwords showing up in ps/top.

It's pretty straightforward. Feel free to modify/improve. I was thinking
of working on a basic client that would let you do fancy-schmancy stuff but
I figure JAMF will be adding a lot of this stuff soon anyway.

It's in Ruby and I've used only the standard libraries (there are much nicer
things than ruby http and rexml) because I know some people don't like
having to/can't install gems on certain machines.