Adding New Operating Systems to Virtual Machine Manager

Tags: System Center, Virtual Machine Manager

Virtual Machine Manager - The OS list is Incomplete

The list of Operating Systems for VMM is very out of date if you compare it to the list of VM types in VCenter (or reality, where we all like to live occasionally). You won't find FreeBSD, or Debian versions later than v7 (and V11 is in testing now). You won't see current RHEL or Centos, or anything even vaguely esoteric.

And if you're like me, and you like to have that information available in VMM either for audit, or because you want to be able to automate things based on the guest OS, this is annoying.

Where The Data Lives

This is all stored in the Virtual Machine Manager database, which is usually VirtualManagerDB on your SQL server. There's a table called tbl_IL_OS which has these fields. Note that I can't find documentation for these, so the purpose and appropriate values are a best guess not necessarily correct:

Column NameData TypePurposeSample Values
OSId uniqueidentifier (that's GUID, for the rest of us) Primary Key - this is unique and other tables will refer to the data in this table using this key value c0e5b0a9-3c18-4cd9-8fe8-affc6652f2c1
Name nvarchar(64), cannot be NULL The name of the OS, displayed in the VMM console when creating or editing a VM FreeBSD 12.0 x64
Description nvarchar(2048), cannot be NULL A description for the OS. I haven't yet figured out where this is shown FreeBSD 12.0 x64
Edition int, can be NULL
ValueUsed For
0 Windows Server Standard
1 Windows Server Enterprise
2 Windows Server Datacenter
3 Windows Server Web
4 Small Business Server
5 Windows Server Essentials
NULL Everything else
NULL
ProductType int, can be NULL
ValueUsed For
1 Windows Desktops (whether Home, Business, Enterprise)
3 Windows Servers
NULL Everything Else
NULL
Version nvarchar(32), can be NULL A suitable version string for the OS - match to the major.minor version if it's significant 12.0
Architecture nvarchar(32), cannot be NULL The CPU platform - I've seen only x86 and AMD64 here AMD64
OSFlags int, cannot be NULL No idea. Seems to be set to 28 for most Linux AMD64 platforms, 17 for Linux x86, but it's 252 for Windows 10 and 764 for Server 2016, so it's probably some sort of bitmasked value and it's inconsistent. 28
VMWareGuestId nvarchar(32), can be NULL This is effectively a foreign key into the list of Guest IDs in the VMWare VCenter API. I used the VMWare API reference for these values freebsd12_64Guest
OSType int, cannot be NULL Looks like this is set to 0 for Windows, 1 for Linux/BSD, and 2 for other stuff (like NetWare) 1

How to Add a New OS

Since this looks like a normal SQL database table, you can add your own entries. Note that you do this at your own risk - I don't know what else might tie into this table (or any stored procedures that reference it). You will want to take precautions - back up the database, understand what you're doing rather than blindly running scripts from the Internet - but in my lab testing it worked well.

Connect to your VMM database server with SQL Management Studio. Create a new query in your VMM database and run a query like this:

INSERT INTO tbl_IL_OS (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestID, OSType)
VALUES (NEWID(), 'FreeBSD 12.0 x64', 'FreeBSD 12.0 x64', NULL, NULL, 12.0, 'amd64', 28, 'freebsd12_64Guest', 1)

If this goes well, you should get a result like this:

(1 row(s) affected)

You might need to close and re-open the console to see your new OS in the list of options for a VM.

Add All the Operating Systems

If you're feeling particularly lucky, here's the script I used to create all the OSs to match the VMWare API for version 6.7. It's long, and after running it, the VMM console didn't work. I don't yet know why but hey - have at it. Note that previously I had added a few new OS entries, principally Debian and FreeBSD, and the console was fine, suggesting perhaps some assumptions about the number of OSs in the list, or an array running out of space or something:

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

No Comments

Add a Comment