//==================================================================================== // OCS INVENTORY REPORTS // Copyleft Pierre LEMMET 2005 // Web: http://ocsinventory.sourceforge.net // // This code is open source and may be copied and modified as long as the source // code is always made freely available. // Please refer to the General Public Licence http://www.gnu.org/ or Licence.txt //==================================================================================== //Modified on 11/25/2005 $filtreSSN=" AND b.ssn <> 'N/A' AND b.ssn <> '(null string)' AND b.ssn <> '' AND b.ssn <> 'INVALID' AND b.ssn <> 'SYS-1234567890' AND b.ssn <> 'SYS-9876543210' AND b.ssn <> 'SN-12345' AND b.ssn <> 'SN-1234567890' AND b.ssn <> '1111111111' AND b.ssn <> '1111111' AND b.ssn <> '1' AND b.ssn <> '0123456789' AND b.ssn <> '12345' AND b.ssn <> '123456' AND b.ssn <> '1234567' AND b.ssn <> '12345678' AND b.ssn <> '123456789' AND b.ssn <> '1234567890' AND b.ssn <> '123456789000' AND b.ssn <> '12345678901234567' AND b.ssn <> '0000000000' AND b.ssn <> '000000000' AND b.ssn <> '00000000' AND b.ssn <> '0000000' AND b.ssn <> '000000' AND b.ssn <> 'NNNNNNN' AND b.ssn <> 'xxxxxxxxxxx' AND b.ssn <> 'EVAL' AND b.ssn <> 'IATPASS' AND b.ssn <> 'none' AND b.ssn <> 'To Be Filled By O.E.M.' AND b.ssn <> 'Tulip Computers' AND b.ssn <> 'Serial Number xxxxxx' AND b.ssn <> 'SN-123456fvgv3i0b8o5n6n7k'"; $filtreMAC=" AND n1.macaddr <> '44:45:53:54:00:00' AND n1.macaddr <> '44:45:53:54:00:01' AND n1.macaddr <> '00:00:00:00:00:00'"; $fromBase="hardware h LEFT JOIN accountinfo a ON a.hardware_id = h.id LEFT JOIN bios b ON b.hardware_id = h.id LEFT OUTER JOIN networks n1 on b.hardware_id=n1.hardware_id"; $whereBase="n1.hardware_id = h.id "; if( $mesMachines ) { $whereBase .= "AND $mesMachines"; } $from = array(); $where = array(); $group = array(); $order = array(); // hostname seul $from[4] = "hardware h2"; $where[4] = " $whereBase AND h.name = h2.name AND h.id <> h2.id"; $group[4] = "h.id"; $order[4] = "h.name"; // ssn seul $from[5] = "hardware h2, bios b2"; $where[5] = "$whereBase AND b2.hardware_id = h2.id AND b2.ssn = b.ssn AND h.id <> h2.id $filtreSSN"; $group[5] = "h.id"; $order[5] = "b.ssn"; //mac seule $from[6] = "hardware h2, networks n2"; $where[6] = " $whereBase AND n2.hardware_id = h2.id AND n2.macaddr = n1.macaddr AND h.id <> h2.id $filtreMAC"; $group[6] = "h.id"; $order[6] = "n1.macaddr"; // hostname + ssn $from[1] = "hardware h2, bios b2"; $where[1] = " $whereBase AND b2.hardware_id = h2.id AND h.name=h2.name AND b2.ssn = b.ssn AND h.id <> h2.id $filtreSSN"; $group[1] = "h.id"; $order[1] = "h.name,b.ssn"; // hostname + mac $from[2] = "hardware h2, networks n2"; $where[2] = " $whereBase AND n2.hardware_id = h2.id AND h.name = h2.name AND n2.macaddr = n1.macaddr AND h.id <> h2.id $filtreMAC"; $group[2] = "h.id"; $order[2] = "h.name,b.ssn"; // mac + ssn $from[3] = "networks n2, bios b2"; $where[3] = " $whereBase AND b2.hardware_id = n2.hardware_id AND b2.hardware_id <> b.hardware_id AND n1.macaddr = n2.macaddr AND b2.ssn = b.ssn $filtreSSN $filtreMAC"; $group[3] = "h.id"; $order[3] = "n1.macaddr,b.ssn"; if(isset($_POST["subredon"])) { for( $i = 1 ; $i <= $_POST["maxredon"] ; $i++) { if(! isset($_POST["ch".$i])) continue; $res = mysql_query("SELECT deviceid,id,lastcome FROM hardware WHERE id=".$_POST["ch".$i], $_SESSION["readServer"]) or die(mysql_error($_SESSION["readServer"])); $afus[] = mysql_fetch_array($res,MYSQL_ASSOC); } if(sizeof($afus)<2) { echo "
"; //if ( $valr[0] > 0 ) { switch($j) { case 1: echo $l->g(193); break ; case 2: echo $l->g(194); break ; case 3: echo $l->g(195); break ; case 4: echo $l->g(196); break ; case 5: echo $l->g(197); break ; case 6: echo $l->g(198); break ; } echo ": ".$valr[0]." |