Report -- can't find "Record Created:"
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
Answers (1)
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)
Comments:
-
Thanks so much - jfrasier 11 years ago
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 - Jbr32 11 years ago