1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
| CREATE OR REPLACE FUNCTION add_to_log() RETURNS Funsction ass NULL $$
DECLARE
mstr VARCHAR (30);
astr VARCHAR (100);
retstr VARCHAR (254);
BEGIN
INSERT INTO "Main".users ("FIO" ,"User_login","Position" ,business_telephone,department)
(SELECT "ФИО","Login","Должность","Телефон","Отдел" FROM public."UsersAD");
CREATE TABLE "Main".users_temp AS (SELECT DISTINCT * FROM "Main".users );
DROP TABLE "Main"."users ;
Alter Table "Main".users_temp RENAME TO "Main".users ;
Insert Into Main.Software (NetworkName,name_software,Version,Publisher,DateOfInstallation)
Select Сетевое имя, Название,Версия,Издатель,Дата установки from public.Software;
Create TABLE "Main".Software_temp AS (select Distinct * from "Main".Software );
DROP TABLE "Main".Software_temp ;
Alter Table "Main".Software_temp RENAME TO "Main".Software_temp ;
Insert Into "Main"."PC_AD"("SamAccountName" ,"DisplayName","Name" ,"Description","Enabled","LastLogon")
Select "SamAccountName","DisplayName","Name" ,"Description","Enabled","LastLogon" from public."PC_AD";
Create TABLE "Main"."PC_AD_temp" AS (select Distinct * from "Main"."PC_AD" );
DROP TABLE "Main"."PC_AD" ;
Alter Table "Main"."PC_AD_temp" RENAME TO "Main"."PC_AD" ;
Insert Into "Main"."Office_Equipment" ("NetworkName",equipment,"TYPE","VersionDriver","STATUS","Server")
Select "Сетевое имя", "Имя","Тип","Версия драйвера","Статус","Сервер" from public."Office_Equipment";
Create TABLE "Main"."Office_Equipment_temp" AS (select Distinct * from "Main"."Office_Equipment" );
DROP TABLE "Main"."Office_Equipment" ;
Alter Table "Main"."Office_Equipment_temp" RENAME TO "Main"."Office_Equipment" ;
Insert Into "Main"."OS" ("NetWorkName","Name_OS","Bit_OS","ServiceP","Date_installion")
Select "Сетевое имя","Имя","Архитектура","Пакет обновления","Дата установки" from public."OS";
Create TABLE "Main"."OS_temp" AS (select Distinct * from "Main"."OS" );
DROP TABLE "Main"."OS" ;
Alter Table "Main"."OS_temp" RENAME TO "Main"."OS" ;
Insert Into "Main"."Network_interface" ("NetWorkName","Specification","Brand","IP","MAC","TYPE","STATUS" )
Select "Сетевое имя","Имя","Производитель","IP адрес","MAC адрес","Тип адаптера","Статус сетевого подключения" from public."Network_interface";
Create TABLE "Main"."Network_interface_temp" AS (select Distinct * from "Main"."Network_interface" );
DROP TABLE "Main"."Network_interface" ;
Alter Table "Main"."Network_interface_temp" RENAME TO "Main"."Network_interface" ;
Insert Into "Main"."Hard_drive" ("NetworkName","Model","SIZE","Type_Interface","Serial","Type_hardisk" )
Select "Сетевое имя", "Модель","Размер, ГБ","Тип интерфейса","Серийный номер","Тип носителя" from public."Hard Drive";
Create TABLE "Main"."Hard_drive_temp" AS (select Distinct * from "Main"."Hard_drive" );
DROP TABLE "Main"."Hard_drive_temp" ;
Alter Table "Main"."Hard_drive_temp" RENAME TO "Main"."Hard_drive" ;
Insert Into "Main"."Flash" ("NetworkName","Model","SIZE","FIO")
Select "Сетевое имя", "Модель","Размер, ГБ","Полное имя" from public."Flash";
Create TABLE "Main"."Flash_temp" AS (select Distinct * from "Main"."Flash" );
DROP TABLE "Main"."Flash" ;
Alter Table "Main"."Flash_temp" RENAME TO "Main"."Flash" ;
Insert into "Main"."CPU" ("NetworkName", "Brand","Frequency","Core","Socket","Model","POWER")
Select "Сетевое имя", "Производитель", "Максимальная частота, МГц","Число ядер","Обозначение разъема","Имя","TDP, ватт" from public."CPU";
Create TABLE "Main"."CPU_temp" AS (select Distinct * from "Main"."CPU" );
DROP TABLE "Main"."CPU" ;
Alter Table "CPU_temp" RENAME TO "Main"."CPU" ;
;
RETURN OLD ;
END IF ;
END ;
$$ LANGUAGE plpgsql; |
(
