servers

Description

This table describes the list of computers specifying their name, type, comments and service pack.

Fields

Field name

Data type

Description

id_snapshot

number

Identifier of the network snapshot.

server_name

string

Netbios name of the server without the two preceding backslash characters.

domain_name

string

Name of the domain (or the workgroup) to which the servers belongs.

type

number

Number composed of a bit mask describing the type of the server (see Appendix 1).

texttype

string

A comprehensible text string describing the preceding type value.

comments

string

Comments of the server.

maxusers

number

Maximal number of concurrent connected users. If this value equals -1, it means that there is no limit.

userspath

string

This string contains the path to user directories.

sp

string

Describes the actual Windows NT Service Pack installed.

install_date

date

Date when the operating system has been installed.

bios_type

string

Description of the Bios.

bios_date

string

Bios date (useful for Y2K tests).

os

string

Active operating system.

OSLevel

 

0 = workstation/ 1 = server/ 2 advanced server

wmi

number

Equals 1 if Windows Management Instrumentation is active on the computer. Otherwise, it is equals to 0.

ram

number

Amount of physical memory (MB).

ramUsed

number

Memory in use (MB)

dns_hostname

string

 

dns_domain_name

string

 

dns_suffixes

string

 

Manufacturer

string

Computer's manufacturer

Model

string

Computer's model

Serial

string

Computer's serial number

MBManufacturer

string

Motherboard's manufacturer

MBModel

string

Motherboard's model

MBSerial

string

Motherboard's serial

SmBIOSVersion

string

Supported version of the SMBIOS standard

DComEnabled

number

0/1 DCOM is disabled/enabled

RegisteredOwner

string

Name of the registered user

RegisteredOrganization

string

Name of the registered company

LastUser

string

Last logged on user (link to users\account_name)

SystemRoot

string

OS directory (commonly c:\winnt c:\windows)

ProgramFilesDir

string

Commonly c:\program files\

CommonFilesDir

string

Commonly c:\program files\Common Files

BootTime

number

Time interval (in days) since the last boot of the machine

IdleTime

number

Idle Time (in days) since the last boot. % Used processor time = 100-IdleTime/BootTime*100

ScanTime

time

Scan time

IEVersion

number

Internet Explorer version

IESPNumber

number

Internet Explorer service pack

LanguageId

number

Operating system language. See appendix 2 for the meaning of this number.

CanonicalName

string

Canonical name of the computer in the Active Directory

Container

string

Container of the computer in the Active Directory

ComputerState

number

1/0 need a reboot yes/no

ChassisType

number

Computer case see appendix 3.

Appendix 1

Symbolic constant

Value

Meaning

SV_TYPE_WORKSTATION

0x00000001

All LAN Manager workstations.

SV_TYPE_SERVER

0x00000002

All LAN Manager servers.

SV_TYPE_SQLSERVER

0x00000004

Any server running with Microsoft SQL Server.

SV_TYPE_DOMAIN_CTRL

0x00000008

Primary domain controller.

SV_TYPE_DOMAIN_BAKCTRL

0x00000010

Backup domain controller.

SV_TYPE_TIMESOURCE

0x00000020

Server running the Timesource service.

SV_TYPE_AFP

0x00000040

Apple File Protocol servers.

SV_TYPE_NOVELL

0x00000080

Novell servers.

SV_TYPE_DOMAIN_MEMBER

0x00000100

LAN Manager 2.x Domain Member.

SV_TYPE_LOCAL_LIST_ONLY

0x40000000

Servers maintained by the browser.

SV_TYPE_PRINT

0x00000200

Server sharing print queue.

SV_TYPE_DIALIN

0x00000400

Server running dial-in service.

SV_TYPE_XENIX_SERVER

0x00000800

Xenix server.

SV_TYPE_MFPN

0x00004000

Microsoft File and Print for Netware.

SV_TYPE_NT

0x00001000

Windows NT (either Workstation or Server).

SV_TYPE_WFW

0x00002000

Server running Windows for Workgroups.

SV_TYPE_SERVER_NT

0x00008000

Windows NT non-DC server.

SV_TYPE_POTENTIAL_BROWSER

0x00010000

Server that can run the Browser service.

SV_TYPE_BACKUP_BROWSER

0x00020000

Server running a Browser service as backup.

SV_TYPE_MASTER_BROWSER

0x00040000

Server running the master Browser service.

SV_TYPE_DOMAIN_MASTER

0x00080000

Server running the domain master Browser.

SV_TYPE_DOMAIN_ENUM

0x80000000

 Primary Domain.

SV_TYPE_WINDOWS

0x00400000

 Windows 95 or later.

SV_TYPE_ALL

0xFFFFFFF

All servers.

Appendix 2

Symbolic constant

Value

Meaning

LANG_NEUTRAL

0x00

Neutral

LANG_ARABIC

0x01

Arabic

LANG_BULGARIAN

0x02

Bulgarian

LANG_CATALAN

0x03

Catalan

LANG_CHINESE

0x04

Chinese

LANG_CZECH

0x05

Czech

LANG_DANISH

0x06

Danish

LANG_GERMAN

0x07

German

LANG_GREEK

0x08

Greek

LANG_ENGLISH

0x09

English

LANG_SPANISH

0x0a

Spanish

LANG_FINNISH

0x0b

Finnish

LANG_FRENCH

0x0c

French

LANG_HEBREW

0x0d

Hebrew

LANG_HUNGARIAN

0x0e

Hungarian

LANG_ICELANDIC

0x0f

Icelandic

LANG_ITALIAN

0x10

Italian

LANG_JAPANESE

0x11

Japanese

LANG_KOREAN

0x12

Korean

LANG_DUTCH

0x13

Dutch

LANG_NORWEGIAN

0x14

Norwegian

LANG_POLISH

0x15

Polish

LANG_PORTUGUESE

0x16

Portuguese

LANG_ROMANIAN

0x18

Romanian

LANG_RUSSIAN

0x19

Russian

LANG_CROATIAN

0x1a

Croatian

LANG_SERBIAN

0x1a

Serbian

LANG_SLOVAK

0x1b

Slovak

LANG_ALBANIAN

0x1c

Albanian

LANG_SWEDISH

0x1d

Swedish

LANG_THAI

0x1e

Thai

LANG_TURKISH

0x1f

Turkish

LANG_URDU

0x20

Urdu

LANG_INDONESIAN

0x21

Indonesian

LANG_UKRAINIAN

0x22

Ukrainian

LANG_BELARUSIAN

0x23

Belarusian

LANG_SLOVENIAN

0x24

Slovenian

LANG_ESTONIAN

0x25

Estonian

LANG_LATVIAN

0x26

Latvian

LANG_LITHUANIAN

0x27

Lithuanian

LANG_FARSI

0x29

Farsi

LANG_VIETNAMESE

0x2a

Vietnamese

LANG_ARMENIAN

0x2b

Armenian

LANG_AZERI

0x2c

Azeri

LANG_BASQUE

0x2d

Basque

LANG_MACEDONIAN

0x2f

FYRO Macedonian

LANG_AFRIKAANS

0x36

Afrikaans

LANG_GEORGIAN

0x37

Georgian

LANG_FAEROESE

0x38

Faeroese

LANG_HINDI

0x39

Hindi

LANG_MALAY

0x3e

Malay

LANG_KAZAK

0x3f

Kazak

LANG_KYRGYZ

0x40

Kyrgyz

LANG_SWAHILI

0x41

Swahili

LANG_UZBEK

0x43

Uzbek

LANG_TATAR

0x44

Tatar

LANG_BENGALI

0x45

Not supported

LANG_PUNJABI

0x46

Punjabi

LANG_GUJARATI

0x47

Gujarati

LANG_ORIYA

0x48

Not supported

LANG_TAMIL

0x49

Tamil

LANG_TELUGU

0x4a

Telugu

LANG_KANNADA

0x4b

Kannada

LANG_MALAYALAM

0x4c

Not supported

LANG_ASSAMESE

0x4d

Not supported

LANG_MARATHI

0x4e

Marathi

LANG_SANSKRIT

0x4f

Sanskrit

LANG_MONGOLIAN

0x50

Mongolian

LANG_GALICIAN

0x56

Galician

LANG_KONKANI

0x57

Konkani

LANG_MANIPURI

0x58

Not supported

LANG_SINDHI

0x59

Not supported

LANG_SYRIAC

0x5a

Syriac

LANG_KASHMIRI

0x60

Not supported

LANG_NEPALI

0x61

Not supported

LANG_DIVEHI

0x65

Divehi

LANG_INVARIANT

0x7f

 

 

Appendix 3 Chassis type

Number

Case

1

Other

2

Unknown

3

Desktop

4

Low Profile Desktop

5

Pizza Box

6

Mini Tower

7

Tower

8

Portable

9

LapTop

10

Notebook

11

Hand Held

12

Docking Station

13

All in One

14

Sub Notebook

15

Space-saving

16

Lunch Box

17

Main Server Chassis

18

Expansion Chassis

19

SubChassis

20

Bus Expansion Chassis

21

Peripheral Chassis

22

RAID Chassis

23

Rack Mount Chassis

24

Multi-system chassis.

Example

As an example, to know all the Windows NT workstations without the service pack 5 installed, use the following SQL query:

SELECT * FROM servers WHERE (type & 0x00001000 <> 0) AND (sp <> 'Service Pack 4')