IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'amazonlinux2_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Amazon Linux 2 (64 bit)', 'Amazon Linux 2 (64 bit) - Since vSphere API 6.7.1', NULL, NULL, NULL, 'AMD64', 28, 'amazonlinux2_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'asianux3_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Asianux Server 3 (64 bit)', 'Asianux Server 3 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'asianux3_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'asianux3Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Asianux Server 3', 'Asianux Server 3 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'asianux3Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'asianux4_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Asianux Server 4 (64 bit)', 'Asianux Server 4 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'asianux4_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'asianux4Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Asianux Server 4', 'Asianux Server 4 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'asianux4Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'asianux5_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Asianux Server 5 (64 bit)', 'Asianux Server 5 (64 bit) - Since vSphere API 6.0', NULL, NULL, NULL, 'AMD64', 28, 'asianux5_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'asianux7_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Asianux Server 7 (64 bit)', 'Asianux Server 7 (64 bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'AMD64', 28, 'asianux7_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'asianux8_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Asianux Server 8 (64 bit)', 'Asianux Server 8 (64 bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'AMD64', 28, 'asianux8_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'centos6_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CentOS 6 (64-bit)', 'CentOS 6 (64-bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'centos6_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'centos64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CentOS 4/5 (64-bit)', 'CentOS 4/5 (64-bit) - Since vSphere API 4.1', NULL, NULL, NULL, 'x86', 17, 'centos64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'centos6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CentOS 6', 'CentOS 6 - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'centos6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'centos7_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CentOS 7 (64-bit)', 'CentOS 7 (64-bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'centos7_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'centos7Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CentOS 7', 'CentOS 7 - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'centos7Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'centos8_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CentOS 8 (64-bit)', 'CentOS 8 (64-bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'x86', 17, 'centos8_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'centosGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CentOS 4/5', 'CentOS 4/5 - Since vSphere API 4.1', NULL, NULL, NULL, 'x86', 17, 'centosGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'coreos64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'CoreOS Linux (64 bit)', 'CoreOS Linux (64 bit) - Since vSphere API 6.0', NULL, NULL, NULL, 'AMD64', 28, 'coreos64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin10_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.6 (64 bit)', 'Mac OS 10.6 (64 bit) - Since vSphere API 5.0', NULL, NULL, NULL, 'AMD64', 28, 'darwin10_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin10Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.6', 'Mac OS 10.6 - Since vSphere API 5.0', NULL, NULL, NULL, 'x86', 17, 'darwin10Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin11_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.7 (64 bit)', 'Mac OS 10.7 (64 bit) - Since vSphere API 5.0', NULL, NULL, NULL, 'AMD64', 28, 'darwin11_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin11Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.7', 'Mac OS 10.7 - Since vSphere API 5.0', NULL, NULL, NULL, 'x86', 17, 'darwin11Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin12_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.8 (64 bit)', 'Mac OS 10.8 (64 bit) - Since vSphere API 5.5', NULL, NULL, NULL, 'AMD64', 28, 'darwin12_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin13_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.9 (64 bit)', 'Mac OS 10.9 (64 bit) - Since vSphere API 5.5', NULL, NULL, NULL, 'AMD64', 28, 'darwin13_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin14_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.10 (64 bit)', 'Mac OS 10.10 (64 bit) - Since vSphere API 6.0', NULL, NULL, NULL, 'AMD64', 28, 'darwin14_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin15_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.11 (64 bit)', 'Mac OS 10.11 (64 bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'AMD64', 28, 'darwin15_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin16_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.12 (64 bit)', 'Mac OS 10.12 (64 bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'AMD64', 28, 'darwin16_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin17_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'macOS 10.13 (64 bit)', 'macOS 10.13 (64 bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'AMD64', 28, 'darwin17_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin18_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'macOS 10.14 (64 bit)', 'macOS 10.14 (64 bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'AMD64', 28, 'darwin18_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwin64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.5 (64 bit)', 'Mac OS 10.5 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'darwin64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'darwinGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mac OS 10.5', 'Mac OS 10.5', NULL, NULL, NULL, 'x86', 17, 'darwinGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian10_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 10 (64 bit)', 'Debian GNU/Linux 10 (64 bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'AMD64', 28, 'debian10_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian10Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 10', 'Debian GNU/Linux 10 - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'debian10Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian4_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 4 (64 bit)', 'Debian GNU/Linux 4 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'debian4_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian4Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 4', 'Debian GNU/Linux 4 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'debian4Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian5_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 5 (64 bit)', 'Debian GNU/Linux 5 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'debian5_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian5Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 5', 'Debian GNU/Linux 5 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'debian5Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian6_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 6 (64 bit)', 'Debian GNU/Linux 6 (64 bit) - Since vSphere API 5.0', NULL, NULL, NULL, 'AMD64', 28, 'debian6_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 6', 'Debian GNU/Linux 6 - Since vSphere API 5.0', NULL, NULL, NULL, 'x86', 17, 'debian6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian7_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 7 (64 bit)', 'Debian GNU/Linux 7 (64 bit) - Since vSphere API 5.5', NULL, NULL, NULL, 'AMD64', 28, 'debian7_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian7Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 7', 'Debian GNU/Linux 7 - Since vSphere API 5.5', NULL, NULL, NULL, 'x86', 17, 'debian7Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian8_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 8 (64 bit)', 'Debian GNU/Linux 8 (64 bit) - Since vSphere API 6.0', NULL, NULL, NULL, 'AMD64', 28, 'debian8_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian8Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 8', 'Debian GNU/Linux 8 - Since vSphere API 6.0', NULL, NULL, NULL, 'x86', 17, 'debian8Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian9_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 9 (64 bit)', 'Debian GNU/Linux 9 (64 bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'AMD64', 28, 'debian9_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'debian9Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Debian GNU/Linux 9', 'Debian GNU/Linux 9 - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'debian9Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'dosGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'MS-DOS.', 'MS-DOS.', NULL, NULL, NULL, 'x86', 17, 'dosGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'eComStation2Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'eComStation 2.0', 'eComStation 2.0 - Since vSphere API 5.0', NULL, NULL, NULL, 'x86', 17, 'eComStation2Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'eComStationGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'eComStation 1.x', 'eComStation 1.x - Since vSphere API 4.1', NULL, NULL, NULL, 'x86', 17, 'eComStationGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'fedora64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Fedora Linux (64 bit)', 'Fedora Linux (64 bit) - Since vSphere API 5.1', NULL, NULL, NULL, 'AMD64', 28, 'fedora64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'fedoraGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Fedora Linux', 'Fedora Linux - Since vSphere API 5.1', NULL, NULL, NULL, 'x86', 17, 'fedoraGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'freebsd11_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'FreeBSD 11 x64', 'FreeBSD 11 x64 - Since vSphere API 6.7', NULL, NULL, NULL, 'x86', 17, 'freebsd11_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'freebsd11Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'FreeBSD 11', 'FreeBSD 11 - Since vSphere API 6.7', NULL, NULL, NULL, 'x86', 17, 'freebsd11Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'freebsd12_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'FreeBSD 12 x64', 'FreeBSD 12 x64 - Since vSphere API 6.7', NULL, NULL, NULL, 'x86', 17, 'freebsd12_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'freebsd12Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'FreeBSD 12', 'FreeBSD 12 - Since vSphere API 6.7', NULL, NULL, NULL, 'x86', 17, 'freebsd12Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'freebsd64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'FreeBSD x64', 'FreeBSD x64', NULL, NULL, NULL, 'x86', 17, 'freebsd64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'freebsdGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'FreeBSD', 'FreeBSD', NULL, NULL, NULL, 'x86', 17, 'freebsdGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'genericLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Other Linux', 'Other Linux - Since vSphere API 5.5', NULL, NULL, NULL, 'x86', 17, 'genericLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'mandrakeGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mandrake Linux', 'Mandrake Linux - Since vSphere API 5.5', NULL, NULL, NULL, 'x86', 17, 'mandrakeGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'mandriva64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mandriva Linux (64 bit)', 'Mandriva Linux (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'mandriva64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'mandrivaGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Mandriva Linux', 'Mandriva Linux - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'mandrivaGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'netware4Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Novell NetWare 4', 'Novell NetWare 4', NULL, NULL, NULL, 'x86', 17, 'netware4Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'netware5Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Novell NetWare 5.1', 'Novell NetWare 5.1', NULL, NULL, NULL, 'x86', 17, 'netware5Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'netware6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Novell NetWare 6.x', 'Novell NetWare 6.x', NULL, NULL, NULL, 'x86', 17, 'netware6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'nld9Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Novell Linux Desktop 9', 'Novell Linux Desktop 9', NULL, NULL, NULL, 'x86', 17, 'nld9Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oesGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Open Enterprise Server', 'Open Enterprise Server', NULL, NULL, NULL, 'x86', 17, 'oesGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'openServer5Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'SCO OpenServer 5', 'SCO OpenServer 5 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'openServer5Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'openServer6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'SCO OpenServer 6', 'SCO OpenServer 6 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'openServer6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'opensuse64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'OpenSUSE Linux (64 bit)', 'OpenSUSE Linux (64 bit) - Since vSphere API 5.1', NULL, NULL, NULL, 'AMD64', 28, 'opensuse64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'opensuseGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'OpenSUSE Linux', 'OpenSUSE Linux - Since vSphere API 5.1', NULL, NULL, NULL, 'x86', 17, 'opensuseGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oracleLinux6_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Oracle 6 (64-bit)', 'Oracle 6 (64-bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'oracleLinux6_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oracleLinux64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Oracle Linux 4/5 (64-bit)', 'Oracle Linux 4/5 (64-bit) - Since vSphere API 4.1', NULL, NULL, NULL, 'x86', 17, 'oracleLinux64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oracleLinux6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Oracle 6', 'Oracle 6 - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'oracleLinux6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oracleLinux7_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Oracle 7 (64-bit)', 'Oracle 7 (64-bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'oracleLinux7_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oracleLinux7Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Oracle 7', 'Oracle 7 - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'oracleLinux7Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oracleLinux8_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Oracle 8 (64-bit)', 'Oracle 8 (64-bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'x86', 17, 'oracleLinux8_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'oracleLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Oracle Linux 4/5', 'Oracle Linux 4/5 - Since vSphere API 4.1', NULL, NULL, NULL, 'x86', 17, 'oracleLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'os2Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'OS/2', 'OS/2', NULL, NULL, NULL, 'x86', 17, 'os2Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other24xLinux64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 2.4x Kernel (64 bit) (experimental)', 'Linux 2.4x Kernel (64 bit) (experimental)', NULL, NULL, NULL, 'AMD64', 28, 'other24xLinux64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other24xLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 2.4x Kernel', 'Linux 2.4x Kernel', NULL, NULL, NULL, 'x86', 17, 'other24xLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other26xLinux64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 2.6x Kernel (64 bit) (experimental)', 'Linux 2.6x Kernel (64 bit) (experimental)', NULL, NULL, NULL, 'AMD64', 28, 'other26xLinux64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other26xLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 2.6x Kernel', 'Linux 2.6x Kernel', NULL, NULL, NULL, 'x86', 17, 'other26xLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other3xLinux64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 3.x Kernel (64 bit)', 'Linux 3.x Kernel (64 bit) - Since vSphere API 5.5', NULL, NULL, NULL, 'AMD64', 28, 'other3xLinux64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other3xLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 3.x Kernel', 'Linux 3.x Kernel - Since vSphere API 5.5', NULL, NULL, NULL, 'x86', 17, 'other3xLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other4xLinux64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 4.x Kernel (64 bit)', 'Linux 4.x Kernel (64 bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'AMD64', 28, 'other4xLinux64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'other4xLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 4.x Kernel', 'Linux 4.x Kernel - Since vSphere API 6.7', NULL, NULL, NULL, 'x86', 17, 'other4xLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'otherGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Other Operating System', 'Other Operating System', NULL, NULL, NULL, 'x86', 17, 'otherGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'otherGuest64') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Other Operating System (64 bit) (experimental)', 'Other Operating System (64 bit) (experimental)', NULL, NULL, NULL, 'AMD64', 28, 'otherGuest64', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'otherLinux64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux (64 bit) (experimental)', 'Linux (64 bit) (experimental)', NULL, NULL, NULL, 'AMD64', 28, 'otherLinux64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'otherLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Linux 2.2x Kernel', 'Linux 2.2x Kernel', NULL, NULL, NULL, 'x86', 17, 'otherLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'redhatGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Linux 2.1', 'Red Hat Linux 2.1', NULL, NULL, NULL, 'x86', 17, 'redhatGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel2Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 2', 'Red Hat Enterprise Linux 2', NULL, NULL, NULL, 'x86', 17, 'rhel2Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel3_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 3 (64 bit)', 'Red Hat Enterprise Linux 3 (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'rhel3_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel3Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 3', 'Red Hat Enterprise Linux 3', NULL, NULL, NULL, 'x86', 17, 'rhel3Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel4_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 4 (64 bit)', 'Red Hat Enterprise Linux 4 (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'rhel4_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel4Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 4', 'Red Hat Enterprise Linux 4', NULL, NULL, NULL, 'x86', 17, 'rhel4Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel5_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 5 (64 bit) (experimental)', 'Red Hat Enterprise Linux 5 (64 bit) (experimental) - Since VI API 2.5', NULL, NULL, NULL, 'AMD64', 28, 'rhel5_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel5Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 5', 'Red Hat Enterprise Linux 5 - Since VI API 2.5', NULL, NULL, NULL, 'x86', 17, 'rhel5Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel6_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 6 (64 bit)', 'Red Hat Enterprise Linux 6 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'rhel6_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 6', 'Red Hat Enterprise Linux 6 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'rhel6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel7_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 7 (64 bit)', 'Red Hat Enterprise Linux 7 (64 bit) - Since vSphere API 5.5', NULL, NULL, NULL, 'AMD64', 28, 'rhel7_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel7Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 7', 'Red Hat Enterprise Linux 7 - Since vSphere API 5.5', NULL, NULL, NULL, 'x86', 17, 'rhel7Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'rhel8_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Red Hat Enterprise Linux 8 (64 bit)', 'Red Hat Enterprise Linux 8 (64 bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'AMD64', 28, 'rhel8_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sjdsGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Sun Java Desktop System', 'Sun Java Desktop System', NULL, NULL, NULL, 'x86', 17, 'sjdsGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles10_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux Enterprise Server 10 (64 bit) (experimental)', 'Suse Linux Enterprise Server 10 (64 bit) (experimental) - Since VI API 2.5', NULL, NULL, NULL, 'AMD64', 28, 'sles10_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles10Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse linux Enterprise Server 10', 'Suse linux Enterprise Server 10 - Since VI API 2.5', NULL, NULL, NULL, 'x86', 17, 'sles10Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles11_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux Enterprise Server 11 (64 bit)', 'Suse Linux Enterprise Server 11 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'sles11_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles11Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse linux Enterprise Server 11', 'Suse linux Enterprise Server 11 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'sles11Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles12_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux Enterprise Server 12 (64 bit)', 'Suse Linux Enterprise Server 12 (64 bit) - Since vSphere API 5.5', NULL, NULL, NULL, 'AMD64', 28, 'sles12_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles12Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse linux Enterprise Server 12', 'Suse linux Enterprise Server 12 - Since vSphere API 5.5', NULL, NULL, NULL, 'x86', 17, 'sles12Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles15_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux Enterprise Server 15 (64 bit)', 'Suse Linux Enterprise Server 15 (64 bit) - Since vSphere API 6.7', NULL, NULL, NULL, 'AMD64', 28, 'sles15_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'sles64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux Enterprise Server 9 (64 bit)', 'Suse Linux Enterprise Server 9 (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'sles64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'slesGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux Enterprise Server 9', 'Suse Linux Enterprise Server 9', NULL, NULL, NULL, 'x86', 17, 'slesGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'solaris10_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Solaris 10 (64 bit) (experimental)', 'Solaris 10 (64 bit) (experimental)', NULL, NULL, NULL, 'AMD64', 28, 'solaris10_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'solaris10Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Solaris 10 (32 bit) (experimental)', 'Solaris 10 (32 bit) (experimental)', NULL, NULL, NULL, 'x86', 17, 'solaris10Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'solaris11_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Solaris 11 (64 bit)', 'Solaris 11 (64 bit) - Since vSphere API 5.0', NULL, NULL, NULL, 'AMD64', 28, 'solaris11_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'solaris6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Solaris 6', 'Solaris 6', NULL, NULL, NULL, 'x86', 17, 'solaris6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'solaris7Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Solaris 7', 'Solaris 7', NULL, NULL, NULL, 'x86', 17, 'solaris7Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'solaris8Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Solaris 8', 'Solaris 8', NULL, NULL, NULL, 'x86', 17, 'solaris8Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'solaris9Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Solaris 9', 'Solaris 9', NULL, NULL, NULL, 'x86', 17, 'solaris9Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'suse64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux (64 bit)', 'Suse Linux (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'suse64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'suseGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Suse Linux', 'Suse Linux', NULL, NULL, NULL, 'x86', 17, 'suseGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'turboLinux64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Turbolinux (64 bit)', 'Turbolinux (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'turboLinux64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'turboLinuxGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Turbolinux', 'Turbolinux', NULL, NULL, NULL, 'x86', 17, 'turboLinuxGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'ubuntu64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Ubuntu Linux (64 bit)', 'Ubuntu Linux (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'ubuntu64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'ubuntuGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Ubuntu Linux', 'Ubuntu Linux', NULL, NULL, NULL, 'x86', 17, 'ubuntuGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'unixWare7Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'SCO UnixWare 7', 'SCO UnixWare 7 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'unixWare7Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'vmkernel5Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'VMware ESX 5', 'VMware ESX 5 - Since vSphere API 5.0', NULL, NULL, NULL, 'x86', 17, 'vmkernel5Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'vmkernel65Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'VMware ESX 6.5', 'VMware ESX 6.5 - Since vSphere API 6.5', NULL, NULL, NULL, 'x86', 17, 'vmkernel65Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'vmkernel6Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'VMware ESX 6', 'VMware ESX 6 - Since vSphere API 6.0', NULL, NULL, NULL, 'x86', 17, 'vmkernel6Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'vmkernelGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'VMware ESX 4', 'VMware ESX 4 - Since vSphere API 5.0', NULL, NULL, NULL, 'x86', 17, 'vmkernelGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'vmwarePhoton64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'VMware Photon (64 bit)', 'VMware Photon (64 bit) - Since vSphere API 6.5', NULL, NULL, NULL, 'AMD64', 28, 'vmwarePhoton64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'win2000AdvServGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 2000 Advanced Server', 'Windows 2000 Advanced Server', NULL, NULL, NULL, 'x86', 17, 'win2000AdvServGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'win2000ProGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 2000 Professional', 'Windows 2000 Professional', NULL, NULL, NULL, 'x86', 17, 'win2000ProGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'win2000ServGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 2000 Server', 'Windows 2000 Server', NULL, NULL, NULL, 'x86', 17, 'win2000ServGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'win31Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 3.1', 'Windows 3.1', NULL, NULL, NULL, 'x86', 17, 'win31Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'win95Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 95', 'Windows 95', NULL, NULL, NULL, 'x86', 17, 'win95Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'win98Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 98', 'Windows 98', NULL, NULL, NULL, 'x86', 17, 'win98Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows7_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 7 (64 bit)', 'Windows 7 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'windows7_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows7Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 7', 'Windows 7 - Since vSphere API 4.0', NULL, NULL, NULL, 'x86', 17, 'windows7Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows7Server64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2008 R2 (64 bit)', 'Windows Server 2008 R2 (64 bit) - Since vSphere API 4.0', NULL, NULL, NULL, 'AMD64', 28, 'windows7Server64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows8_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 8 (64 bit)', 'Windows 8 (64 bit) - Since vSphere API 5.0', NULL, NULL, NULL, 'AMD64', 28, 'windows8_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows8Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 8', 'Windows 8 - Since vSphere API 5.0', NULL, NULL, NULL, 'x86', 17, 'windows8Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows8Server64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 8 Server (64 bit)', 'Windows 8 Server (64 bit) - Since vSphere API 5.0', NULL, NULL, NULL, 'AMD64', 28, 'windows8Server64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows9_64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 10 (64 bit)', 'Windows 10 (64 bit) - Since vSphere API 6.0', NULL, NULL, NULL, 'AMD64', 28, 'windows9_64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows9Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 10', 'Windows 10 - Since vSphere API 6.0', NULL, NULL, NULL, 'x86', 17, 'windows9Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windows9Server64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows 10 Server (64 bit)', 'Windows 10 Server (64 bit) - Since vSphere API 6.0', NULL, NULL, NULL, 'AMD64', 28, 'windows9Server64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'windowsHyperVGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Hyper-V', 'Windows Hyper-V - Since vSphere API 5.5', NULL, NULL, NULL, 'x86', 17, 'windowsHyperVGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winLonghorn64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Longhorn (64 bit) (experimental)', 'Windows Longhorn (64 bit) (experimental) - Since VI API 2.5', NULL, NULL, NULL, 'AMD64', 28, 'winLonghorn64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winLonghornGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Longhorn (experimental)', 'Windows Longhorn (experimental) - Since VI API 2.5', NULL, NULL, NULL, 'x86', 17, 'winLonghornGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winMeGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Millenium Edition', 'Windows Millenium Edition', NULL, NULL, NULL, 'x86', 17, 'winMeGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetBusinessGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Small Business Server 2003', 'Windows Small Business Server 2003', NULL, NULL, NULL, 'x86', 17, 'winNetBusinessGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetDatacenter64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2003, Datacenter Edition (64 bit) (experimental)', 'Windows Server 2003, Datacenter Edition (64 bit) (experimental) - Since VI API 2.5', NULL, NULL, NULL, 'AMD64', 28, 'winNetDatacenter64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetDatacenterGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2003, Datacenter Edition', 'Windows Server 2003, Datacenter Edition - Since VI API 2.5', NULL, NULL, NULL, 'x86', 17, 'winNetDatacenterGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetEnterprise64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2003, Enterprise Edition (64 bit)', 'Windows Server 2003, Enterprise Edition (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'winNetEnterprise64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetEnterpriseGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2003, Enterprise Edition', 'Windows Server 2003, Enterprise Edition', NULL, NULL, NULL, 'x86', 17, 'winNetEnterpriseGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetStandard64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2003, Standard Edition (64 bit)', 'Windows Server 2003, Standard Edition (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'winNetStandard64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetStandardGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2003, Standard Edition', 'Windows Server 2003, Standard Edition', NULL, NULL, NULL, 'x86', 17, 'winNetStandardGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNetWebGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Server 2003, Web Edition', 'Windows Server 2003, Web Edition', NULL, NULL, NULL, 'x86', 17, 'winNetWebGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winNTGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows NT 4', 'Windows NT 4', NULL, NULL, NULL, 'x86', 17, 'winNTGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winVista64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Vista (64 bit)', 'Windows Vista (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'winVista64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winVistaGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows Vista', 'Windows Vista', NULL, NULL, NULL, 'x86', 17, 'winVistaGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winXPHomeGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows XP Home Edition', 'Windows XP Home Edition', NULL, NULL, NULL, 'x86', 17, 'winXPHomeGuest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winXPPro64Guest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows XP Professional Edition (64 bit)', 'Windows XP Professional Edition (64 bit)', NULL, NULL, NULL, 'AMD64', 28, 'winXPPro64Guest', 1) END
IF NOT EXISTS (SELECT * FROM tbl_IL_OS WHERE VMWareGuestID = 'winXPProGuest') BEGIN INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType) VALUES (NEWID(), 'Windows XP Professional', 'Windows XP Professional - ', NULL, NULL, NULL, 'x86', 17, 'winXPProGuest', 1) END
