Schema ZTS
Schema ZTS
created by (c) SQL Reporter

Schema ZTS
    Environment
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Name char 64 latin1
    Data char 255 latin1

    Hardware
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Typ char 64 latin1
    Name char 64 latin1
    Data char 64 latin1

    Network
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Idx char 64 latin1
    Name char 64 latin1
    Data char 64 latin1

    Printers
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Idx char 64 latin1
    Name char 64 latin1
    Port char 64 latin1

    QuickFix
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Idx char 64 latin1
    Description char 64 latin1
    InstalledOn char 64 latin1

    Services
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    ServiceName char 64 latin1
    DisplayName char 64 latin1
    Status char 64 latin1

    Software
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    DisplayName char 64 latin1
    Publisher char 64 latin1
    DisplayVersion char 64 latin1

    Users
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Idx char 64 latin1
    Data char 64 latin1

    Windows
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Name char 64 latin1
    Data char 64 latin1

    ZStatus
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    LastScan char 32 latin1

    ZTasks
    COLUMN DATA MAX CHARSET
    Host (fk) char 32 latin1
    Time char 64 latin1
    Day char 64 latin1
    ShwTsk char 64 latin1
    RepTsk char 64 latin1
    Typ char 64 latin1
    Path char 64 latin1

    ZTHosts
    COLUMN DATA MAX CHARSET
    Host [PRIMARY] char 32 latin1
    FirstScan char 32 latin1