I am using the wizard and want to report on the date that the computer first checked into the KACE box. I am thinking it is that date (Record Created:), but that field is not listed in the wizard.

I was going to try to use a third party reporter (Toad) but I don't know which table it is in, or the field name.

Does anyone have any ideas?

Thanks so much

Jane

Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • We have a report that might help you, it shows objected created within the last 24 hours.


    SELECT MACHINE.NAME AS SYSTEM_NAME, BIOS_SERIAL_NUMBER as Serial_Number, RAM_TOTAL as Installed_Ram, OS_NAME as Operating_System, USER_LOGGED as LastUser, (SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=12092) AS Local_Admin_List_WIN_ONLY FROM MACHINE where CREATED > DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY SYSTEM_NAME
Please log in to comment

Answers

0

This is in the MACHINE.CREATED field.  Unfortunately this is not a selectable field in the wizard.  Get your report looking the way you want without the CREATED field.  You can then edit the SQL to add that field (or any other field) to the report.  You can use Toad, MySQL Workbench, or any other MySQL/ODBC application to tweak your query outside of KACE and to look around at the tables and fields.  Most of the names (table and field) indicate the content.  Appendix D of the Admin Guide has a listing of the tables and the related KACE component. (http://www.kace.com/support/resources/documentation)

Answered 08/02/2013 by: grayematter
Fourth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity