Hello forum,
I just created a my own report, it works but loading result page slow extremely. When I remove 2 lines below, the responding time is very fast then, please help me to fix this. Thanks!
[code]sys_sw_software_key.key_text,[/code] [code]INNER JOIN sys_sw_software_key ON sys_sw_software_key.system_id = system.system_id[/code]
My report [code] <?xml version="1.0" encoding="ISO-8859-1"?> <report> <details> <report_name>Full - Motherboard</report_name> <report_display_in_menu>y</report_display_in_menu> <report_sql><![CDATA[ SELECT system.first_timestamp, system.`timestamp`, system.hostname, system.man_ip_address, sys_hw_network_card_ip.net_mac_address, sys_sw_windows.windows_user_name, system.os_name, system.os_version, system.pc_os_bit, sys_sw_software_key.key_text, system.model, sys_hw_motherboard.manufacturer, sys_hw_motherboard.serial, sys_hw_motherboard.processor_type, system.form_factor FROM system INNER JOIN sys_sw_windows ON sys_sw_windows.system_id = system.system_id INNER JOIN sys_hw_motherboard ON sys_hw_motherboard.system_id = system.system_id INNER JOIN sys_hw_network_card_ip ON sys_hw_network_card_ip.system_id = system.system_id INNER JOIN sys_sw_software_key ON sys_sw_software_key.system_id = system.system_id GROUP BY system.hostname ORDER BY hostname ]]></report_sql> <report_view_file>v_report</report_view_file> <report_view_contents></report_view_contents> <report_processing></report_processing> <report_sort_column>0</report_sort_column> </details> <columns> <column> <column_order>0</column_order> <column_name>First Scan</column_name> <column_variable>first_timestamp</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> <column> <column_order>1</column_order> <column_name>Latest Scan</column_name> <column_variable>timestamp</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> <column> <column_order>2</column_order> <column_name>Name</column_name> <column_variable>hostname</column_variable> <column_type>link</column_type> <column_link>/main/system_display/</column_link> <column_secondary>system_id</column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>3</column_order> <column_name>IP Address</column_name> <column_variable>man_ip_address</column_variable> <column_type>ip_address</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>4</column_order> <column_name>MAC</column_name> <column_variable>net_mac_address</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>5</column_order> <column_name>User</column_name> <column_variable>windows_user_name</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>6</column_order> <column_name>Domain</column_name> <column_variable>domain</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> <column> <column_order>7</column_order> <column_name>Operating System</column_name> <column_variable>os_name</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>8</column_order> <column_name>Service Pack</column_name> <column_variable>os_version</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>9</column_order> <column_name>OS Bit</column_name> <column_variable>pc_os_bit</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>10</column_order> <column_name>Product Key</column_name> <column_variable>key_text</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>11</column_order> <column_name>Motherboard</column_name> <column_variable>model</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>12</column_order> <column_name>Manufacturer</column_name> <column_variable>manufacturer</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>13</column_order> <column_name>Motherboard Serial</column_name> <column_variable>serial</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>14</column_order> <column_name>CPU Socket</column_name> <column_variable>processor_type</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <column_order>15</column_order> <column_name>Form</column_name> <column_variable>form_factor</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> </columns> </report> [/code]
|