Skip to content

Instantly share code, notes, and snippets.

@lashomb

lashomb/jss_query

Created October 29, 2013 04:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lashomb/7209102 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lashomb/7209102 to your computer and use it in GitHub Desktop.
Download ZIP
query from computers_denormalized
Raw
jss_query
SELECT cd.username, cd.computer_name, cd.make, cd.model, cd.total_ram_mb, cd.operating_system_name, cd.operating_system_version, cd.operating_system_build, cd.serial_number, cd.processor_type, cd.processor_count, cd.processor_speed_mhz FROM computers_denormalized AS cd INTO OUTFILE '/Users/Shared/compinfo.txt';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment