Security Controls

OperatingSystemFamily View

The Reporting2.OperatingSystemFamily view defines the operating system family.

Column Name Data Type Nullable Description
Id smallint   The operating system family id.
Value nvarchar(100)   The string value of the id.
Description nvarchar(256)   Provides a simple description of the value.

Content

You can run the following query to verify the contents of the Reporting.OperatingSystemFamily view.

SELECT [Id]

,[Value]

,[Description]

FROM [SecurityControls].[Reporting2].[OperatingSystemFamily]

ID Value Description
0 Unknown Invalid or Unknown type.
1 AIX This is an AIX operating system.
2 Hpux This is an HP-UX operating system.
3 Linux This is a Linux operating system.
4 Mac This is a MAC operating system.
5 Solaris This is a Solaris operating system.
6 Windows This is a Windows operating system.

Was this article useful?