PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- public static function getList()
- {
- return DB::connection('sqlsrv_system_center')
- ->table('v_R_SYSTEM')
- ->join('v_GS_COMPUTER_SYSTEM', 'v_GS_COMPUTER_SYSTEM.ResourceID', '=', 'v_R_SYSTEM.ResourceID')
- ->join('v_GS_NETWORK_ADAPTER_CONFIGUR', function ($join) {
- $join->on('v_GS_NETWORK_ADAPTER_CONFIGUR.ResourceID', '=', 'v_R_SYSTEM.ResourceID')
- ->where('v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0', 'like', '10.233.33.%')
- ->orWhere('v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0', 'like', '10.233.62.%')
- ->orWhere('v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0', 'like', '10.233.34.%')
- ->orWhere('v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0', 'like', '10.233.5.%')
- ->orWhere('v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0', 'like', '10.233.70.%')
- ->orWhere('v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0', 'like', '10.233.134.%')
- ->orWhere('v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0', 'like', '10.233.139.%');
- })
- ->join('v_GS_OPERATING_SYSTEM', 'v_GS_OPERATING_SYSTEM.ResourceID', '=', 'v_R_SYSTEM.ResourceID')
- ->join('v_GS_WORKSTATION_STATUS', 'v_GS_WORKSTATION_STATUS.ResourceID', '=', 'v_R_SYSTEM.ResourceID')
- ->join('v_GS_ADD_REMOVE_PROGRAMS', function($join){
- $join->on('v_R_SYSTEM.ResourceID', '=', 'v_GS_ADD_REMOVE_PROGRAMS.ResourceID')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Пакет исправлений%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Windows XP Hotfix%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Security Update%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Update for Windows%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Исправление для Windows%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Обновление безопасности%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Пакет исправлений для Windows%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Hotfix for Windows%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Windows Installer%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Обновление для Windows%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'Исправление для проигрывателя%')
- ->where('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0', 'not like', 'MSXML%');
- })->select('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0','v_GS_ADD_REMOVE_PROGRAMS.Publisher0', 'v_GS_ADD_REMOVE_PROGRAMS.ProdID0')
- ->addSelect(DB::raw("COUNT('*') as total")) ->groupBy('v_GS_ADD_REMOVE_PROGRAMS.DisplayName0','v_GS_ADD_REMOVE_PROGRAMS.Publisher0', 'v_GS_ADD_REMOVE_PROGRAMS.ProdID0')
- ->get();
- }