I.T. Co. deployed standardized IT-infrastructure in 73 Slavianka branches


I.T. Co. deployed standardized IT-infrastructure in 73 Slavianka branches
I.T. Co. has completed the project on introduction of Microsoft infrastructure services in branch network of Slavianka OJSC under the Ministry of Defense of the Russian Federation. Works on standardized infrastructure replication in all the branches were completed in only 1,5 months. As a result the common infrastructure environment has been created on the basis of 213 servers at scales of geographically distributed network, IT-infrastructure manageability and security have been improved and its support cost has been reduced.

Slavianka OJSC is the Russian largest company in the field of housing management of military communities of the Ministry of Defense, operational support and comprehensive servicing of barracks and quarters, and water supply networks. Currently the Management company Slavianks OJSC carries out modernization of funds and develops the efficient work with population in 73 existing branches, as well as arranges divisions in hard-to-reach country regions. The introduction of innovative approach to management with the use of modern information technologies was staked on in this project. RetailComp Company was involved as prime contractor to carry-out the comprehensive modernization of Slavianka IT-infrastructure.

During the global project implementation on creation of modern telecommunications infrastructure of the company the main tasks were separated out. One of them came to improvement of branches manageability from the central office and provision of all Slavianka branches with the common geographically-distributed information structure instead of manifold solutions. One of the conditions of infrastructure services introduction was the extremely tight timetable – deployment of all solutions in all the branches should be implemented in 1, 5 months.

I.T. Co., having the rich experience of geographically dispersed companies’ automation, proposed the Customer the most optimal solution on introduction of Microsoft infrastructure services in branch network within the shortest possible time and in result was appointed Executor of this project.

Work commenced in April 2011. At first professionals of I.T. Co. developed technical solution and mechanism of automated replication of branches infrastructure, and then conducted pilot introduction and “prototype” testing in Moscow division. Modern standardized infrastructure was based on Microsoft Windows Server 2008 R2.

Typical solution on branch infrastructure standardization includes installation and connection of three servers to the network, adjustment of VPN-tunnel to Moscow office on the basis of Juniper, set up of virtualization platform based on the Microsoft Hyper-V and adjustment on two physical servers in virtual environment of four servers with several roles. It is the common directory service Active Directory, files and printing services, terminal access, management of information security and configurations’ life cycle. Besides, the backup system based on Microsoft Data Protection Manager was provided for one of the servers, and the Customer's business applications and management server of MS SQL data were installed on the third physical server.

Since mid of May, after successful testing and approbation of technical solution in Moscow department, its replication has began in 72 branches with operative deployment of services on 213 servers. I.T. Co. professionals developed master-disk, engineer connected it to the server on-site – and the further process of installation, adjustment and testing of server infrastructure have been launching automatically by clicking one button. One branch modernization took 1-2 days. The project is unique for its extremely high level of deployment automation of IT-infrastructure on all territory of the Customer, effective paralleling of operations and practically eliminating human factor from installation and adjustment processes.

“Today we understand that efficient management of accounting, operating and maintenance of such dispersed fund is impossible without introduction of technological innovations. Information systems allow us to improve quality and efficiency of public service. In a result of cooperation with I.T. Co. all our branches were included into standardized IT-infrastructure within scheduled term”, – comments Oleg V. Zemskov, the IT Department Director of Slavianka OJSC. We have reached the new stage of infrastructure development, that will allow reducing costs for its maintenance, as well as significantly improving information manageability and security networkwide. Quality improvement of IT services providing will certainly lead to easy and efficient servicing of our guests and regular customers. It can be declared with all responsibility that Slavianka takes active part in the certain measures on management modernization that were headed for by our country management.

About Slavianka OJSC
Slavianka OJSC is the Russian largest company dealing with housing management of military communities of the Ministry of Defense, as well as with operational support and comprehensive servicing of barracks and quarters, and water supply networks of military communities of the Russian Ministry of Defense. Currently the company is actively developing. 73 branches were established, additional detached divisions are being arranged in hard-to-reach areas and regions for the purpose of facilitating the work with population and improving the quality of services provided. Slavianka branches are operating almost in all regions: From Murmansk to Stavropol, from Kronshtadt to Petrovapvosk-Kamchatsky. More information is available on web-site

Module: advertising
Class: CAdvBanner
File: /var/www/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetPageWeights_RS
Line: 943
MySQL Query Error: SELECT DISTINCT B.TYPE_SID, B.ID BANNER_ID, B.WEIGHT BANNER_WEIGHT, B.SHOWS_FOR_VISITOR, B.FIX_CLICK, B.FIX_SHOW, B.KEYWORDS BANNER_KEYWORDS, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, B.FLYUNIFORM FLYUNIFORM, B.MAX_SHOW_COUNT MAX_SHOW_COUNT, B.SHOW_COUNT SHOW_COUNT, C.ID CONTRACT_ID, C.WEIGHT CONTRACT_WEIGHT, C.KEYWORDS CONTRACT_KEYWORDS FROM b_adv_type T INNER JOIN b_adv_banner B ON ( B.ACTIVE='Y' and B.TYPE_SID = T.SID and B.STATUS_SID = 'PUBLISHED' and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y') and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_banner_2_site BS ON ( BS.BANNER_ID = B.ID and BS.SITE_ID = 'en') INNER JOIN b_adv_contract C ON ( C.ID = B.CONTRACT_ID and C.ACTIVE='Y' and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_contract_2_site CS ON ( CS.CONTRACT_ID = B.CONTRACT_ID and CS.SITE_ID = 'en') INNER JOIN b_adv_contract_2_type CT ON ( CT.CONTRACT_ID = C.ID and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID)) INNER JOIN b_adv_banner_2_weekday BW ON ( BW.BANNER_ID = B.ID and BW.C_WEEKDAY='FRIDAY' and BW.C_HOUR = '8') INNER JOIN b_adv_contract_2_weekday CW ON ( CW.CONTRACT_ID = C.ID and CW.C_WEEKDAY='FRIDAY' and CW.C_HOUR = '8') LEFT JOIN b_adv_banner_2_group UG1 ON ( (UG1.BANNER_ID = B.ID and UG1.GROUP_ID in (2) and UG1.GROUP_ID<>2) ) LEFT JOIN b_adv_banner_2_page BP1 ON ( BP1.BANNER_ID = B.ID and BP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_banner_2_page BP2 ON ( BP2.BANNER_ID = B.ID and BP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3688/index.php' like concat(BP2.PAGE, '%')) LEFT JOIN b_adv_contract_2_page CP1 ON ( CP1.CONTRACT_ID = C.ID and CP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_contract_2_page CP2 ON ( CP2.CONTRACT_ID = C.ID and CP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3688/index.php' like concat(CP2.PAGE, '%')) LEFT JOIN b_adv_banner_2_stat_adv BA ON BA.BANNER_ID = B.ID LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND ( ( (B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY') AND BC.COUNTRY_ID='' ) OR ( B.STAT_TYPE='REGION' AND BC.COUNTRY_ID='' AND BC.REGION='' ) OR ( B.STAT_TYPE='CITY' AND BC.CITY_ID='0' ) ) WHERE T.ACTIVE = 'Y' and ( B.STAT_COUNT is null or B.STAT_COUNT = 0 or BC.BANNER_ID is not null ) and BP2.ID is null and CP2.ID is null and (BP1.ID is null or '/en/media-center/news/3688/index.php' like concat(BP1.PAGE, '%')) and (CP1.ID is null or '/en/media-center/news/3688/index.php' like concat(CP1.PAGE, '%')) and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0') and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='') and ( (B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null) or (B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null) ) ORDER BY B.TYPE_SID desc, C.ID desc [Got error 28 from storage engine]

DB query error.
Please try later.