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;
}
