17.3 Retrieving Inventory information from the Inventory Database Without Using the CIM Schema

ZENworks 7 Server Management provides easy-to-use Inventory database views that allow you to retrieve inventory information from the Inventory database without using the CIM schema.

The Inventory views are predefined device-specific views that are automatically created in the Inventory database after you install the Server Inventory component of ZENworks 7 Server Management.

The nomenclature for the Inventory views is database_schema_name.zen_devicename. For example, mw_dba.zen_processor.

Inventory views that are associated with enums have localized views. For example, mw_dba.zen_processor_ja is the Japanese view for the Processor.

The following sections provide information about the various Inventory views and how to use them:

17.3.1 List of Inventory Views

Table 17-4 ZENworks Inventory Views and their functionality

Inventory View Name

Functionality

Attributes

Description

Is the view Localized?

mw_dba.zen_asset

Retrieves the Asset information

SystemName

DNS name of the inventoried server

Yes

Manufacturer

Name of the manufacturer

Model

Model of the computer system

SerialNumber

Serial number of the computer system assigned bymanufacturer

Tag

Unique identifier of system information

ManagementTechnology

Technology available on the inventoried server such as DMI, WMI, and others

AssetTag

Asset tag number that the ROM-based setup program creates

ModelNumber

Model number of the computer system

mw_dba.zen_battery

Retrieves the Battery information

Name

Device name for the battery, for example, Duracell* DR-36

Yes

Chemistry

The battery chemistry, for example, lithium-ion or nickel metal hydride

DesignCapacity

The design capacity of the battery in mWatt-hours

DesignVoltage

The design voltage of the battery in mVolts

SmartBatteryVersion

The Smart Battery Data Specification version number supported by this battery

InstallDate

The battery manufacture date

Manufacturer

The name of the company that manufactured the battery

SerialNumber

The serial number for the battery

mw_dba.zen_bios

Retrieves the BIOS information

Caption

BIOS label

Yes

InstallDate

The manufacturing date of the BIOS

SerialNumber

Serial number of the computer, assigned duringmanufacture

Version

Version or revision level of the BIOS

Manufacturer

BIOS vendor name

PrimaryBIOS

True state indicates Primary BIOS

BIOSIDBytes

Byte in the BIOS that indicates the computer model

Size

Size of the BIOS

mw_dba.zen_bus

Retrieves the Bus information

BusType

Bus type indicates PCI, ISA, and others

Yes

BusName

Bus name

BusDescription

Bus description

BusVersion

Version of the bus supported by the motherboard

DeviceID

The unique hexadecimal ID for the specific bus

mw_dba.zen_cachememory

Retrieves the Cache memory information

ErrorMethodology

Error correction scheme supported by this cache component, for example, Parity/Single Bit ECC/ MultiBit ECC

Yes

Level

Indicates the cache level; internal cache that is built in to the microprocessors; external cache that is between the CPU and DRAM

WritePolicy

Indicates the two different ways (Write-Back and Write-Through Cache) that the cache can handle to write to the memory

CacheType

Defines the system cache type, for example, Instruction, Data, Unified

LineSize

Size in bytes of a single cache bucket or line

ReplacementPolicy

Algorithm that the cache uses to determine which cache lines or buckets should be reused

ReadPolicy

Indicates whether the data cache is for read operations

Associativity

Defines the system cache associativity (directmapped, 2-way, 4-way)

Speed

Speed of this System Cache module in nanoseconds

Capacity

Size of the data store where the cache information is kept

mw_dba.zen_cdrom

Retrieves the CDROM information

DeviceID

Drive letter allocated for the CD on the inventoried server

No

Manufacturer

Vendor name of the CD

Description

Description of the CD

Caption

Caption of the CD

mw_dba.zen_chassis

Retrieves the Chassis information

AssetTag

Asset tag number of the system chassis. For example, S11127

Yes

NumberOfPowerCords

Total number of power cords attached to a system chassis

ChassisType

Represents whether the system chassis is a laptop, desktop, notebook, docking station and so on

Manufacturer

Name of the system chassis manufacturer. For example, Compaq

SerialNumber

Manufacturer's number used to identify a system chassis. For example, 53R661S

Tag

Unique ID of the system chassis attached to a particular inventoried server. For example, System Enclosure 0

Version

Version number of the system chassis

mw_dba.zen_computerinformation

Retrieves the computer information

ComputerName

Name of the inventoried server as represented in eDirectory, such as the fully qualified DN of the inventoried server

No

PrimaryOwner

The name of the primary user or owner of this system

PrimaryOwnerContact

The phone number of the primary user of this system

mw_dba.zen_currentlogindetails

Retrieves the current login information

CurrentUser

User logged in to the Primary eDirectory tree when the inventoried server was scanned

No

mw_dba.zen_disk

Retrieves the disk information

RemovableDisk

Removable disk

Yes

Manufacturer

Vendor name of the disk

Description

Description of the disk

PhysicalCylinders

Number of cylinders

PhysicalHeads

Number of heads

SectorsPerTrack

Removable disk drive sectors per track

Capacity

Capacity of the removable disk

mw_dba.zen_diskusage

Retrieves the disk usage information

FileExtension

The file extension for which the disk usage is scanned for.

No

TotalDiskUsage

Total disk usage for all the files of the specified extension.

mw_dba.zen_displayadapter

Retrieves the display adapter information

Description

Description of the display adapter

Yes

VideoMemoryType

The type of video memory for this adapter, for example, VRAM/SRAM/DRAM/EDO RAM

MaxMemorySupported

Maximum memory that the display adapter supports for VIDEO RAM

CurrentBitsPerPixel

Number of adjacent color bits for each pixel

CurrentHorizontalResolution

Number of horizontal pixels shown by the display

CurrentVerticalResolution

Number of vertical pixels shown by the display

MaxRefreshRate

Maximum refresh rate of the monitor for redrawing the display, measured in Hertz

MinRefreshRate

Minimum refresh rate of the monitor for redrawing the display, measured in Hertz

VideoArchitecture

The architecture of the video subsystem in this system, for example, CGA/VGA/SVGA/8514A

NumberOfColorPlanes

Number of color planes supported by the video system

ChipSet

Chip set used by the controller to compare system capabilities

DACType

Digital-to-Analog converter type

ProviderName

Vendor name

mw_dba.zen_displaydriver

Retrieves the display driver information

Manufacturer

Name of the display driver manufacturer

Yes

Version

Version number of the display driver

InstallDate

Install date of the display driver

IsShadowed

If True, the display driver is currently being shadowed

mw_dba.zen_distinguishedname

Retrieves the distinguished name

DistinguishedName

Distinguished name

No

Tree

eDirectory tree name

mw_dba.zen_dma

Retrieves the DMA information

Description

Name of the logical device that is currently using this DMA channel

Yes

DMAChannel

Number of the Direct Memory Access (DMA) channel that a computer uses for transferring data to and from devices quicker than from computers without a DMA channel

Availability

Indicates whether Virtual Direct Memory Access (DMA) is supported

BurstMode

A data transmission mode in which data is sent faster than normal

mw_dba.zen_dnsname

Retrieves the DNS name

HostName

DNS name of the inventoried server

No

mw_dba.zen_floppy

Retrieves the floppy information

DeviceID

The floppy name representing the floppy

No

Manufacturer

Vendor name

Description

Floppy drive description

PhysicalCylinders

Total number of cylinders or tracks on the floppy.

PhysicalHeads

Floppy drive R/W heads

SectorsPerTrack

Floppy drive sectors per track

Capacity

Floppy drive capacity

mw_dba.zen_inventoryscanner

Retrieves the inventory scanner information

LastScanDate

The date when the Scanner was last scanned. Stored as milliseconds so it can be read and displayed in any appropriate date format

Yes

InventoryServer

Name of the Inventory server to which the scans are sent. It is not the complete DN of the server name

Version

Version of the Scanner running on the inventoried server

ScanMode

The management technology used by the Scanner, such as WMI or DMI, for scanning the computer system

RecentInformation

Latest inventory information

generaldictionaryversion

Version of the General dictionary

privatedictionaryversion

Version of the Private dictionary

mw_dba.zen_ipaddress

Retrieves the IP address

Address

The unique address assigned to a computer on an IP Internet

No

SubnetMask

The subnet mask of the inventoried server paired with an IP address specifies to an IP router which octets or bits in the IP address are the network ID and which octets or bits are the node ID

mw_dba.zen_ipxaddress

Retrieves the IPX address

Address

The IPX address of the inventoried server

No

mw_dba.zen_irq

Retrieves the IRQ information

IRQNumber

Number of the Interrupt Request Line (IRQ), from 0 to 15

Yes

Availability

Availability of the specific IRQ channel

TriggerType

IRQ Trigger type

Shareable

If True, the system IRQ can be shared across devices

mw_dba.zen_keyboard

Retrieves the keyboard information

KeyboardLayout

Layout of the keyboard

No

KeyboardSubtype

Type of the keyboard

KeyboardDescription

Description of the keyboard, such as IBM Enhanced 101 or 102 keys

NumberOfFunctionKeys

Total number of function keys

KeyboardDelay

Delay before the repeat of a key

TypematicRate

Rate of processing the keys

mw_dba.zen_lastlogindetails

Retrieves the last login details

LastUser

User most recently logged in to the Primary eDirectory tree through Novell Client when the inventoried server was scanned

No

mw_dba.zen_macaddress

Retrieves the MAC address

MACAddress

Unique node address permanently coded in the network adapter that identifies a specific computer on a network

No

mw_dba.zen_memory

Retrieves the memory information

TotalMemory

Total memory of the inventoried server

No

mw_dba.zen_microsoftdomainname

Retrieves the Microsoft domain name

DomainName

Domain name of the inventoried server

No

mw_dba.zen_internalmodem

Retrieves the internal modem information

Name

Identifying information of the modem

No

Description

Additional information about the modem

ProviderName

Name of the vendor

DeviceID

Special hexadecimal string identifying the modem type

mw_dba.zen_monitor

Retrieves the monitor information

DeviceID

Unique ID of a desktop monitor that is attached to an inventoried server.

For example, DesktopMonitor1.

No

ModelID

Unique ID of a model of the monitor. It is a combination of the Manufacturer ID and Product ID.

For example, DELA001.

MonitorDescription

Description of the monitor.

NominalSize

A number representing the diagonal width of the monitor (the distance from one corner of the screen to the opposite corner of the screen)

For example, 17”

You can customize the scan of the nominal size of the monitor by configuring the HWRules ini file using the Server Inventory policy.

ViewableSize

A number representing the diagonal width of the screen image excluding the black borders around the image's edge

For example, 15.8”

ManufacturedDate

Year in which the monitor was manufactured

MonitorSerialNumber

Manufacturer's number used to identify a monitor

For example, 23DDC24N9067

Manufacturer

Name of the monitor's manufacturer

For example, DELL Computer Corp

Model

Product name of the monitor given by the manufacturer

For example, DELL E771a

mw_dba.zen_motherboard

Retrieves the motherboard information

Description

General description of the motherboard

No

Manufacturer

Name of the motherboard manufacturer

Version

Version of the motherboard

NumberOfSlots

The number of expansion slots in the motherboard for adding more memory, graphic capabilities, and support for special devices

mw_dba.zen_mouse

Retrieves the mouse information

MouseType

Mouse type

Yes

MouseName

Identifying information of the mouse

NumberOfButtons

Number of buttons on the mouse

IRQNumber

Interrupt assigned to this device

mw_dba.zen_mousedriver

Retrieves the mouse driver information

DriverName

Name of the mouse driver

No

DriverVersion

Version number of the mouse driver

mw_dba.zen_NetworkAdapter

Retrieves the network adapter information

Caption

Network adapter caption

Yes

Description

Network adapter description

InstallDate

Install date of the network adapter

Name

Network adapter name

PermanentAddress

Node address stored permanently in the adapter

MACAddress

The MAC address stored in the network adapter

MaxSpeed

Rate at which the data is transferred over the LAN

AdapterType

Type of network adapter, such as FDDI or token ring

ProviderName

Name of the provider

mw_dba.zen_NetworkAdapterDriver

Retrieves the network adapter driver information

Description

Description of the network adapter driver installed on the inventoried server

For example, IBM 10/100 Ethernet adapter, EN-2420Px Ethernet adapter

No

Name

Name of the network adapter driver

Version

Version of the network adapter

mw_dba.zen_parallelport

Retrieves the parallel port information

PortName

The logical name of the input-output device on this parallel port, under this operating environment

Yes

HasDMASupport

If True, DMA is supported

PortAddress

Base I/O address for this parallel port

IRQNumber

IRQ number of the parallel port

mw_dba.zen_powersupply

Retrieves the power supply information

Description

Expanded description of the input voltage capability for this power supply

No

TotalOutputPower

Attribute value that represents the total output power of the power supply

mw_dba.zen_processor

Retrieves the processor information

DeviceID

Special hexadecimal string identifying the processor type

Yes

Description

Additional information about the processor

Role

Type of processor such as central processor, math coprocessor, and others

Family

Identification of the processor family such as Pentium II, Pentium III, and others

OtherFamilyDescription

Additional description about the Processor Family, such as Pentium Processor with MMX technology

UpgradeMethod

The method by which this processor can be upgraded, if upgrades are supported

MaxClockSpeed

Maximum clock speed of the processor

CurrentClockSpeed

Current clock speed of the processor

Stepping

Single-byte code characteristic provided by microprocessor vendors to identify the processor model

mw_dba.zen_serialport

Retrieves the serial port information

PortName

The logical name of the I/O device on this serial port, under this operating environment

No

PortAddress

Base input-output address for this serial port

IRQNumber

IRQ number of the serial port

mw_dba.zen_soundadapter

Retrieves the sound adapter information

Name

Label of the multimedia card

No

Description

Description of the multimedia component for the server

ProviderName

Name of the provider

mw_dba.zen_systemslot

Retrieves the system slot information

SlotDescription

Card currently occupying this slot

No

MaxDataWidth

Maximum bus width of cards accepted in the slot

ThermalRating

Maximum thermal dissipation of the slot in milliwatts

mw_dba.zen_unixOS

Retrieves the UNIX operating system information

Type

Operating system of the inventoried server

Yes

Caption

Operating system name

CodePage

Language code page of the operating system

Version

Version number of the operating system

InstallDate

Install date of the operating system

VirtualMemorySize

Total number of bytes in the virtual address space of the calling process

VisibleMemorySize

Total memory as reported by the operating system

ProviderName

Name of the provider

KernelVersion

Version number of the operating system

SwapSpaceSize

Total swap space size

mw_dba.zen_windowsOS

Retrieves the Windows operating system information

Type

Operating system of the inventoried server

Yes

OtherTypeDescription

Additional description of the operating system if available

Caption

Operating system name

CodePage

Language code page of the operating system

Version

Version number of the operating system

InstallDate

Install date of the operating system

VirtualMemorySize

Total number of bytes in the virtual address space of the calling process

VisibleMemorySize

Total memory as reported by the operating system

ProviderName

Name of the provider

mw_dba.zen_NetWareOS

Retrieves the NetWare operating system information

Type

Operating system of the inventoried server

Yes

Caption

Operating system name

CodePage

Language code page of the operating system

Version

Version number of the operating system

InstallDate

Install date of the operating system

VirtualMemorySize

Total number of bytes in the virtual address space of the calling process

VisibleMemorySize

Total memory as reported by the operating system

SizeStoredInPagingFiles

The total number of KBytes that can be stored in the OperatingSystem's paging files

ProviderName

Name of the provider

AccountingVersion

NetWare server specific attributes

InternetBridgeSupport

NetWare server specific attributes

MaxNumberOfConnections

NetWare server specific attributes

MaxNumberOfVolumes

NetWare server specific attributes

PeakConnectionsUsed

NetWare server specific attributes

PrintServerVersion

NetWare server specific attributes

QueuingVersion

NetWare server specific attributes

RevisionLevel

NetWare server specific attributes

SecurityRestrictionLevel

NetWare server specific attributes

SFTLevel

NetWare server specific attributes

TTSlevel

NetWare server specific attributes

VAPVersion

NetWare server specific attributes

VirtualConsoleVersion

NetWare server specific attributes

InternalNetworkNumber

NetWare server specific attributes

mw_dba.zen_software

Retrieves the software information

Name

Vendor-defined name of the product represented as a vendor trademark or registered trademark.

Yes

Vendor

Vendor name of the software

Version

User-friendly version of a product.

For example, the version for Windows 2000 is 2000 or Major.Minor Version of the Product.

ProductID

A unique, 16-character identifier for an installed product. This identifier is available from MSI on Windows

The format is ABCD-1234-WXYZ-PQRS

InternalVersion

Internal version of a product

The format is:

major version.minor version.build.sub build number

or

major version.minor version.build

Language

User-friendly name for the language of this copy of the product

FriendlyName

Display name of the software

Uninstallstring

The command to invoke for uninstalling this product instance. Currently, this is available in Add/Remove Programs (ARP) and MSI on Windows

Supportpack

Installed support pack number of the product

SoftwareEdition

Product edition defined by the vendor. For example, Professional

LastExecutionTime

Date and time stamp when the product was last executed

Frequencyofusage

Number of times the product is used

Description

Description of the product

InstallationSource

Identifies the file system path where the installation files were stored when installing this product instance. Currently, this is available in ARP and MSI on Windows

InformationRepository

Source of scan, which can be, Add/Remove Programs, MSI, Software Dictionary, or PRODUCTS.DAT

Category

Product category to which the product belongs

For example, Office is a part of the Productivity tools category and Solitaire is a game

Helplink

Support web site URL for the product that is available in ARP and MSI

PackageGUID

Vendor-defined GUID for a product that is available in MSI

Path

Directory path where the product is installed on the inventoried server

mw_dba.zen_softwaregroup

Retrieves the software group information

Name

Vendor-defined name of the software group represented as a vendor trademark or registered trademark

Yes

Vendor

Vendor name for the software group

Version

User-friendly version of a software group

ProductID

A unique, 16-character identifier for an installed product. This identifier is available from MSI on Windows

The format is ABCD-1234-WXYZ-PQRS.

InternalVersion

Internal version of a product

The format is:

major version.minor version.build.sub build number

or

major version.minor version.build

Language

User-friendly name for the language of this copy of the product

FriendlyName

Display name of the software

Uninstallstring

The command to invoke for uninstalling this product instance. Currently, this is available in Add-Remove Programs (ARP) and MSI on Windows

Supportpack

Installed support pack number of the product

SoftwareEdition

Product edition defined by the vendor. For example, Professional.

LastExecutionTime

Date and time stamp when the product was last executed

Frequencyofusage

Number of times the product group is used

Description

Description of the product group

InstallationSource

Identifies the file system path where the installation files were stored when installing this product instance. Currently, this is available in ARP and MSI on Windows

InformationRepository

Source of scan, which can be, Add/Remove Programs, MSI, Software Dictionary, or PRODUCTS.DAT

Category

Product category to which the product belongs

For example, Office is a part of the Productivity tools category and Solitaire is a game

Helplink

Support web site URL for the product that is available in ARP and MSI

PackageGUID

Vendor-defined GUID for a product that is available in MSI

Path

Directory path where the product is installed on the inventoried server

mw_dba.zen_softwarepatch

Retrieves the software patch information

productid

Software ID of the software patch

No

PatchName

Vendor-defined name for the patch

mw_dba.zen_antivirus

Retrieves the antivirus product information

Name

Vendor-defined name of the antivirus product represented as a vendor trademark or registered trademark

Yes

Vendor

Vendor name for the antivirus product

Version

User-friendly version of the antivirus product

ProductID

A unique, 16-character identifier for an installed antivirus product. This identifier is available from MSI on Windows

The format is ABCD-1234-WXYZ-PQRS

InternalVersion

Internal version of the antivirus product

The format is:

major version.minor version.build.sub build number

or

major version.minor version.build

Language

User-friendly name for the language of this copy of antivirus product

FriendlyName

Display name of the antivirus product

Uninstallstring

The command to invoke for uninstalling this product instance. Currently, this is available in Add/Remove Programs (ARP) and MSI on Windows

Supportpack

Installed support pack number of the antivirus product

SoftwareEdition

Antivirus Product edition defined by the vendor

LastExecutionTime

Date and time stamp when the antivirus product was last executed

Frequencyofusage

Number of times the antivirus product is used

Description

Description of the antivirus product

InstallationSource

Identifies the file system path where the installation files were stored when installing this antivirus product instance. Currently, this is available in ARP and MSI on Windows

InformationRepository

Source of scan, which can be Add/Remove Programs, MSI, Software Dictionary, or PRODUCTS.DAT

DefinitionDate

The date of the virus definition file installed on the computer. Some anti-virus products combine date and version into a single string

DefinitionVersion

The vendor-defined version of the virus definition file that has been installed on a computer

Category

Product category to which the antivirus product belongs

Helplink

Support Web site URL for the antivirus product that is available in ARP and MSI

PackageGUID

Vendor-defined GUID for the antivirus product that is available in MSI

Path

Directory path where the antivirus product is installed on the inventoried server

mw_dba.zen_dictionaryfile

Retrieves the ZENworks software dictionary file information

fileid

Dictionary File ID

Yes

directoryid

Directory ID

FileName

Filename of the dictionary file

Directory

Directory name in which the dictionary file is stored

FileVersion

Dictionary file version

FileSize

Dictionary file size

LastModified

Last modified date of the dictionary file

InternalName

Internal name

ProductVersion

The version of the product represented by this file

Company

Vendor name

ProductName

The product which this file represents

Language

User-friendly name for the language of this copy of the file

SoftwareDictionaryID

ID of the file as represented in the General software dictionary

mw_dba.zen_excludedfile

Retrieves the excluded file information

fileid

Excluded file ID

Yes

directoryid

Directory ID

FileName

Filename of the excluded file

Directory

Directory name in which the excluded file is stored

FileVersion

Excluded file version

FileSize

Excluded file size

LastModified

Last modified date of the excluded file

InternalName

Internal name

ProductVersion

The version of the product represented by this file

Company

Vendor name

ProductName

The product which this file represent

Language

User-friendly name for the language of this copy of the file

mw_dba.zen_locktable

Retrieves the lock table information

ComputerName

Computer name

Yes

LastScanTime

The date when the Scanner was last scanned. Stored as milliseconds time value so it can be read and displayed in any appropriate date format

RecentInformation

Latest information

mw_dba.zen_removabledisk

Retrieves the removable disk information

Manufacturer

Vendor name for the removable disk

No

Description

Description of the removable disk

PhysicalCylinders

Total number of cylinders or tracks on the disk

PhysicalHeads

Number of heads

SectorsPerTrack

Number of sectors per track

Capacity

Total size

mw_dba.zen_fixeddisk

Retrieves the fixed disk information

Manufacturer

Vendor name of the fixed disk

No

Description

Description of the fixed disk

PhysicalCylinders

Total number of cylinders or tracks on the disk

PhysicalHeads

Number of heads

SectorsPerTrack

Number of sectors per track

Capacity

Total size

mw_dba.zen_WindowsLocalFileSystem

Retrieves the Windows local file system information

Name

Windows local file system name

No

FileSystemSize

Windows local file system size

AvailableSpace

Windows local file system space

FileSystemType

Windows local file system type

Caption

Windows local file system caption

DeviceID

Device ID

VolumeSerialNumber

Windows local file system volume number

mw_dba.zen_NetWareLocalFileSystem

Retrieves the NetWare local file system information

Name

NetWare local file system name

No

FileSystemSize

NetWare local file system size

AvailableSpace

NetWare local file system available space

FileSystemType

NetWare local file system type

Caption

NetWare local file system caption

DeviceID

Device ID

VolumeSerialNumber

NetWare local file volume serial number

mw_dba.zen_LinuxLocalFileSystem

Retrieves the Linux local file system information

Name

Linux local file system name

No

FileSystemSize

Linux local file system size

AvailableSpace

Linux local file system available space

FileSystemType

Linux local file system type

Caption

Linux local file system caption

DeviceID

Device ID

VolumeSerialNumber

Linux local file system volume serial number

17.3.2 How to Use the Inventory Views

You can use the Inventory views along with SQL statements, and execute the SQL statements from the Inventory database prompt or in any third-party database front-end application.

Examples:

  • To retrieve all the processor information:

    select * from mw_dba.zen_processor
    
  • To retrieve specific processor information:

    select DeviceID, Description,   Role,   Family,   OtherFamilyDescription,   UpgradeMethod,   MaxClockSpeed, CurrentClockSpeed from mw_dba.zen_processor
    
  • To retrieve all software information:

    select * from mw_dba.zen_software
    
  • To retrieve software information along with its suite details:

    select soft.name, softsuite.name from mw_dba.zen_software soft, mw_dba.zen_softwaregroup softsuite where soft.name = ’ZENworks Desktop Management Inventory Server’ and soft.parentinstanceid=softsuite.pinstanceid;
    
  • To retrieve software patch information:

    select suite.name, patchname from mw_dba.zen_softwaregroup suite, mw_dba.zen_softwarepatch patch where suite.pinstanceid=patch.pinstanceid
    
  • To retrieve software suite patch information:

    select soft.name, patchname from mw_dba.zen_software soft, mw_dba.zen_softwarepatch patch where soft.pinstanceid=patch.pinstanceid;
    
  • To retrieve anti-virus software information:

    select * from mw_dba.zen_antivirus