function getSoftware($deviceid) { $PluginSccmSccmdb = new PluginSccmSccmdb(); $PluginSccmSccmdb->connect(); $query = "SELECT ArPd.DisplayName00 as \"ArPd-DisplayName\",\n ArPd.InstallDate00 as \"ArPd-InstallDate\",\n ArPd.Version00 as \"ArPd-Version\",\n ArPd.Publisher00 as \"ArPd-Publisher\"\n FROM Add_Remove_Programs_DATA ArPd\n INNER JOIN v_R_System VrS on VrS.ResourceID=ArPd.MachineID\n WHERE ArPd.MachineID = '" . $deviceid . "'"; $datas = array(); $result = $PluginSccmSccmdb->exec_query($query); while ($data = mssql_fetch_array($result, MSSQL_ASSOC)) { foreach ($data as $key => $value) { $data[$key] = utf8_encode($this->cleanValue($value)); } $datas[] = $data; } $PluginSccmSccmdb->disconnect(); return $datas; }
function getMedias($deviceid) { $PluginSccmSccmdb = new PluginSccmSccmdb(); $PluginSccmSccmdb->connect(); $query = "\n SELECT distinct\n Description0 as \"Med-Description\",\n Manufacturer0 as \"Med-Manufacturer\",\n Caption0 as \"Med-Model\",\n Name0 as \"Med-Name\",\n SCSITargetID0 as \"Med-SCSITargetId\",\n MediaType0 as \"Med-Type\"\n FROM v_GS_CDROM\n WHERE ResourceID = '" . $deviceid . "'"; $datas = array(); $result = $PluginSccmSccmdb->exec_query($query); $data = array(); if (function_exists('sqlsrv_fetch_array')) { $data = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC); } elseif (function_exists('mssql_fetch_array')) { $data = mssql_fetch_array($result, MSSQL_ASSOC); } while ($data) { foreach ($data as $key => $value) { $data[$key] = utf8_encode($this->cleanValue($value)); } $datas[] = $data; } $PluginSccmSccmdb->disconnect(); return $datas; }