I had a problem wih the Dell servers showing serial number so I added this to the vbs script:
[code]Set colSMBIOS = objWMIService.ExecQuery ("Select * from Win32_SystemEnclosure",,48) For Each objSMBIOS in colSMBIOS bios_asset_tag = objSMBIOS.SerialNumber Next
Set colItems = objWMIService.ExecQuery("Select * from Win32_BIOS",,48) For Each objItem in colItems Descrip = clean(objItem.Description) Manufacturer = clean(objItem.Manufacturer) SerialNumber = clean(objItem.SerialNumber) SMBIOSBIOSVersion = clean(objItem.SMBIOSBIOSVersion) Version = clean(objItem.Version) Next
form_input = "bios^^^" & Descrip & "^^^" _ & Manufacturer & "^^^" _ & SerialNumber & "^^^" _ & SMBIOSBIOSVersion & "^^^" _ & Version & "^^^" _ & bios_asset_tag & "^^^" entry form_input,comment,objTextFile,oAdd,oComment form_input = ""[/code]
then I added this to the system_summary.php file:
[code]$sql2 = "SELECT * from Bios WHERE bios_uuid = '$pc'"; $result2 = mysql_query($sql2, $db); if ($myrow2 = mysql_fetch_array($result2)) { $assettag = $myrow2["bios_asset_tag"]; } if ($myrow = mysql_fetch_array($result)){ if ($assettag = $myrow["system_id_number"]) { $serialnum = $myrow["system_id_number"]; } elseif ($myrow["system_id_number"] = ' ') { $serialnum = $myrow2["bios_asset_tag"]; } else { $serialnum = $myrow["system_id_number"]; }[/code]
and then replaced $myrow["system_id_number"] to $serialnum where the page data gets displayed.
Probably a better and cleaner way to do it but I am new to PHP and fairly new to VBScript.
|