Public Scratchpad | Download, Select Code To D/L |
$select = $dbh->prepare(" SELECT Server, SUM(Average) AS NetUse, FROM stats WHERE Statistic Like 'NetworkInterface%' ");
Data looks like this
Server,Statistic,Average "MGM9469DC31","MemoryPagessec",15.604275 "MGM9469DC31","PhysicalDiskTotalPCTDiskTime",8.740074 "MGM9469DC31","PhysicalDiskTotalAvgDiskQueueLength",0.087401 "MGM9469DC31","ProcessorTotalPCTProcessorTime",10.410065 "MGM9472FE01","MemoryPagessec",9.633776 "MGM9472FE01","NetworkInterfaceHPNC3163FastEthernetNIC2NetworkLoadBala +ncingFilte rDeviceBytesTotalsec",96810.245977 "MGM9472FE01","NetworkInterfaceHPNC3163FastEthernetNICBytesTotalsec",3 +164.367221 "MGM9472FE01","NetworkInterfaceHPNC7770GigabitServerAdapterBytesTotals +ec",613.16 0639 "MGM9472FE01","PhysicalDiskTotalPCTDiskTime",3.504199 "MGM9472FE01","PhysicalDiskTotalAvgDiskQueueLength",0.035042 "MGM9472FE01","ProcessorTotalPCTProcessorTime",10.900135
Error:
SQL ERROR: Bad table or column name 'FROM stats' has chars not alphanu +meric or underscore! DBD::CSV::db prepare failed: SQL ERROR: Bad table or column name 'FROM + stats' has chars not alphanumeric or underscore! [for Statement " SELECT Server, SUM(Average) AS NetUse, FROM stats WHERE Statistic Like 'NetworkInterface%' "] at ./hosts2.pl line 62. DBD::CSV::db prepare failed: SQL ERROR: Bad table or column name 'FROM + stats' has chars not alphanumeric or underscore! [for Statement " SELECT Server, SUM(Average) AS NetUse, FROM stats WHERE Statistic Like 'NetworkInterface%' "] at ./hosts2.pl line 62.