This table describes the list of computers specifying their name, type, comments and service pack.
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. |
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. |
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 |
|
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. |
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')