I would like to create a custom report for our Apple\Mac inventory (which include the KACE client) that will include the following fields but I'm unsure of how to do so. The information for each of the fields below will be entered manually. We have a relatively small Apple\Mac environment. 

1. Employee Name
2. Model
3. Serial Number
4. Purchase Date
5. Warranty Expiration Date
6. Filevault Key
7. Firmware Password

Thanks in advance!
2 Comments   [ + ] Show Comments


  • Where do you intend to store purchase date, warranty expiration date, filevault key and firmware password? The easiest location would be to store them in the computer asset by adding those as custom fields. If that is the case then you can build this report using the reporting wizard.
  • Hi Chuck - thanks for getting back to me. Yes, I am planning to store\create these fields under a new asset 'Apple Inventory' but when I generate the report, the respective headings do not appear as I would like. For instance, the Name field is called 'Asset Name'. If possible, I'm more than willing to continue this conversation via email so I can provide you an example of my report via an attachment but would prefer to keep my email address hidden so its remains private from others. Let me know your thoughts and thanks again!
    • I would recommend adding the fields to the current computer asset type, otherwise you will have to do more custom reporting in order to link the new asset type to the devices in inventory.

      Regardless, if you just want to change the column headers:
      Create the report using the wizard
      Save the report
      Open the report to edit it
      Click the Edit SQL button
      Each column of the report will appear in a comma delimited list in the first part of the statement after the word Select. Find each column that you want to rename and add an alias using the AS keyword. For your example, there will probably be something like:
      that you want to modify make to read:
      ASSET.NAME as "Asset Name",

      Add the aliases to the relevant columns and save the report. You will get a notice that the report will not longer be editable using the wizard. If that makes you nervous then make a copy of the report first and make these changes to the copy.
Please log in to comment

There are no answers at this time


Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja