Manuals

Reporting and Task Management: Dell OpenManage IT Assistant Version 8.0 User's Guide

Back to Contents Page

Reporting and Task Management

Dell OpenManage™ IT Assistant Version 8.0 User's Guide

Custom Reporting

IT Assistant Database Schema Information

Managing Tasks

Dell OpenManage™ IT Assistant provides the ability to:

Create customized reports for all systems in your enterprise
Execute command line instructions on managed devices from a central console, including shutdown and wake up
Perform software compliance checking and updates on an individual managed system

The basics of these capabilities are shown here using the same user scenarios presented in "Configuring Dell OpenManage™ IT Assistant to Monitor Your Systems." For more detailed information on these topics, see the Dell OpenManage IT Assistant Online Help.

Custom Reporting

IT Assistant uses data from the Microsoft® SQL Server database to create customized reports. These reports are based on data gathered during discovery and inventory cycles.

The devices or groups that you select to include in your report correspond to fields in the IT Assistant database. When you execute a report, a database query is created. The following figure provides an example.

Figure 9-1. Custom Reporting in IT Assistant

For example, you can compile a report containing:

Details of the hardware devices being managed by IT Assistant, including servers, switches, and storage devices
BIOS, firmware, and driver versions contained on specific devices
Other asset or cost of ownership details

You can specify different output formats for any report, such as HTML, XML, or CSV (comma-separated values). Any customized report template you create can be saved and used later.

Creating a New Report

To illustrate IT Assistant's report capabilities, let us take another look at Jane's enterprise:

Among her group of managed systems, she has 50 Dell™ PowerEdge™ servers. However, she is not sure exactly which servers have which type of network interface card installed. She can answer that question quickly by using IT Assistant's reporting tool:

From IT Assistant, Jane will:

Select Views→ Reports, then right-click All Reports in the left navigation pane.
Choose New Report.

The Add Report wizard starts.

She then specifies the following:

A Name for her report, not to exceed 64 characters
An optional Description

Click Next.

In the Select Devices dialog box, Jane chooses Select devices/groups from the tree below, then Servers from the available devices list.

NOTE: Selecting the top-level attribute in the device list automatically selects all of the attributes below it. Expanding the attributes in the tree allows you to select the specific attributes that you want to include. A check mark with a gray background for the group selection indicates that you have made individual selections within the group. A check mark with a white background indicates that you have selected the entire group. Consequently, as the group membership changes, the selection is applicable to the modified group members.

Click Next.

Under Select Attributes, she chooses NIC.
Then, she specifies a preferred Sort by order and clicks Next.
On the Summary page, she either accepts her choices or goes back and changes them. This creates a new report with the name Jane specified in step 2.

When Jane has confirmed her configuration, she goes to the reports window in IT Assistant and right-clicks the report name she created and chooses Execute→ HTML Reports.

An HTML format-based report showing NIC device information for each of the 50 PowerEdge servers in her enterprise is displayed.

Choosing a query-based report:

Jane could also opt for a query-based report. Instead of choosing Select devices/groups from the tree below in the report wizard, she could choose Select a query. Then, she can either select a query that she created earlier, or create a new query by clicking the New button. She can specify the parameters for a query report as shown in the following table:

Table 9-1. Query Report Parameters

Name of the Query
Specifies the name of the query.

Query Criteria
Specifies the query criteria. For example, to create a new query with the query criteria for all devices that correspond to a subnet, specify:
Where: IP Address Starts With 143.166.155
The query operators are:
Contains — Specifies that the query criteria string contain a certain set of characters.

Ends With — Specifies that the query criteria string ends with a certain set of characters.

Is — Specifies that the query criteria string exactly match these characters.

Starts With — Specifies that the query criteria string starts with these characters.

You can expand the query with up to 10 subqueries, which together constitute the complete query. Join the subqueries by using AND/OR operators.
NOTE: If you make any changes while editing an existing query and save that query, the original query is replaced.

Run Query
Runs the query and displays the results.

Save Query
Saves the query.

Cancel
Closes the Query Editor window without saving your input.

NOTE: You can click Run Query to test a query before saving it.

NOTE: If you want to run reports on RAC devices, and choose RAC type as one of the attributes to include in the report, the generated report may list the values 2, 8, or 16 against the RAC type column. These values are mapped as follows:
2 = DRAC II
8 = DRAC III/DRAC 4/DRAC 5
16 = Baseboard Management Controller (BMC)

Editing, Deleting, or Running Reports

Whichever type of report she creates, Jane can edit, delete, rename, or run it at any time by right clicking the report name in the Reports window.

Pre-defined Reports

IT Assistant provides several pre-defined reports you can use immediately. These reports will be displayed in the left portion of the Reports window. Click the report name to see a summary of the information the report is designed to gather.

IT Assistant Database Schema Information

IT Assistant gathers data that is stored in associated tables and is linked by the DeviceID, an internal identifier. The associated data is stored in the following tables.

NOTE: The primary keys for the tables are marked with an asterisk (*).

Table 9-2. IT Assistant Database Schema

Column Name	Data Type	Data Size	Nulls Allowed	Description
Device Table
DeviceId*	int	4	No	Internal device identification used as a Foreign Key in all related tables.
DeviceName	nvarchar	256	Yes	The name IT Assistant uses to identify the device, which is the name shown in the Device Tree in the user interface (UI).
DeviceInstrumentationName	nvarchar	256	Yes	The name of the device retrieved from the MIB II SysName or CIM.
DeviceDNSName	nvarchar	256	Yes	Fully qualified name as returned by the DNS Server
DeviceType	int	4	Yes	The type of device. Workstations = 3 Servers = 4 Desktops = 5 Portables = 6 Network Switches = 8 RACs = 9 KVMs = 10 Unknown = 2 or any value not listed
DeviceInventoryTime	datetime	8	Yes	The last time that IT Assistant collected inventory data from the device.
DeviceStatusedTime	datetime	8	Yes	The last time that IT Assistant collected the global health data from the device.
DeviceDiscoveredTime	datetime	8	Yes	The last time IT Assistant interrogated the system to determine what agents were present.
DeviceProtocols	int	4	Yes	Bitmask indicating what protocols the device supported. Bit 1 = SNMP Bit 4 = CIM Bit 8 = IPMI
DevicePreferredProtocol	int	4	Yes	The protocol by which the remote device prefers to be managed. 1 = SNMP 2 = CIM
DeviceAssetTag	nvarchar	64	Yes	This attribute defines the device's asset tag.
DeviceServiceTag	nvarchar	64	Yes	This attribute defines the device's service tag.
DeviceSystemId	int	4	Yes	The manufacturer's ID for the system model.
DeviceSystemModelType	nvarchar	64	Yes	The manufacturer's model name.
DeviceLocation	nvarchar	256	Yes	The device location as retrieved from the remote agent.
DellSystem	int	4	Yes	The Boolean flag indicating if the device has a Dell-enabled agent.
SubnetLastDiscoveredOn	nvarchar	256	Yes	The last discovery range that was used to discover the device.
Agent Table
DeviceId*	int	4	No	The Foreign Key (FK) to the Device Table.
AgentName*	nvarchar	256	No	The name of the agent.
AgentVersion	nvarchar	64	Yes	The version of the agent.
AgentManufacturer	nvarchar	64	Yes	The manufacturer of the agent.
AgentDescription	nvarchar	256	Yes	A brief description of what the agent manages.
AgentGlobalStatus	int	4	Yes	The global status of the agent. Not Known = 0 Unknown = 1 Normal = 4 Warning = 8 Critical = 16
AgentInstallTime	datetime	8	Yes	The time the agent was installed, if available.
AgentId	int	4	Yes	Internal ID used to distinguish between agents. RAC Out-Of-Band Agent = 1 Server Administrator = 2 Microsoft® WMI =3 OMCI = 4 Physical Manager = 6 Storage Manager = 7 Dell™ PowerEdge™1655MC Switch = 8 Dell PowerConnect™ 3248 = 9 PowerConnect 5224 = 10 PowerConnect 3024 = 11 PowerConnect 5012 = 12 PowerConnect 3048 = 13 PowerConnect 3000MIB = 14 KVM = 15 Inventory Agent = 16 RAC In-Band Agent = 17
AgentURL	nvarchar	256	Yes	The Web address of the management application (if the agent supports a Web-based access).
AgentData	ntext	16	Yes	Extended agent data; for internal use only.
Array Disk Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
ArrayDiskNumber*	int	4	No	The instance number of this array disk entry.
ArrayDiskName	nvarchar	256	Yes	The array disk's name as represented in Storage Management.
ArrayDiskVendorName	nvarchar	64	Yes	The array disk's (re)seller's name.
ArrayDiskModelNumber	nvarchar	64	Yes	The array disk's model number.
ArrayDiskSerialNumber	nvarchar	64	Yes	The array disk's unique identification number from the manufacturer.
ArrayDiskPartNumber	nvarchar	64	Yes	The array disk's part number.
ArrayDiskRevision	nvarchar	64	Yes	The array disk's firmware version.
ArrayDiskEnclosureId	nvarchar	64	Yes	The SCSI ID of the enclosure processor to which this array disk belongs.
ArrayDiskChannel	int	4	Yes	The bus to which this array disk is connected.
ArrayDiskLength	int	4	Yes	The array disk's size in gigabytes. If the size is 0, it is smaller than a gigabyte.
ArrayDiskBusType	nvarchar	64	Yes	The array disk's bus type. Possible values: SCSI, IDE, Fibre Channel, SSA, USB, and SATA.
ArrayDiskTargetId	int	4	Yes	The SCSI target ID which this array disk is assigned.
ArrayDiskLUNId	int	4	Yes	The durable unique ID for this array disk.
Controller Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
ControllerNumber*	int	4	No	The instance number of this controller entry.
ControllerName	nvarchar	64	Yes	The name of the controller in this subsystem as represented in Storage Management. Includes the controller type and instance, for example: PERC 3/QC 1.
ControllerVendor	nvarchar	64	Yes	The controller's reseller's name.
ControllerType	nvarchar	64	Yes	The type of controller.
ControllerState	nvarchar	64	Yes	The current condition of the controller's subsystem.
ControllerStatus	int	4	Yes	The controller's status
ControllerFWVersion	nvarchar	64	Yes	The controller's current firmware version.
ControllerCacheSize	int	4	Yes	The controller's current amount of cache memory.
ControllerPhysicalDeviceCount	int	4	Yes	The number of physical devices on the controller channel, including both disks and the controller.
ControllerLogicalDeviceCount	int	4	Yes	The number of virtual disks on the controller.
ControllerPartnerStatus	nvarchar	64	Yes	Indicates the availability of the redundant controller in a redundant configuration.
ControllerMemorySize	int	4	Yes	The amount of memory on the controller.
ControllerDriveChannelCount	int	4	Yes	The number of redundant controller drive channels.
ControllerChargeCount	int	4	Yes	The number of charges that have been applied to the battery on this controller.
ControllerDriverVersion	nvarchar	64	Yes	The currently installed driver version for this controller.
ControllerSPAReadCacheSize	int		Yes	The read cache size on controller A.
ControllerSPAWriteCacheSize	int		Yes	The write cache size on controller A.
ControllerSPBReadCacheSize	int		Yes	The read cache size on controller B.
ControllerSPBWriteCacheSize	int		Yes	The write cache size on controller B.
ControllerCachePageSize	int		Yes	The page cache size for the controller.
ControllerSPAReadCachePolicy	nvarchar	64	Yes	The read cache policy on controller A.
ControllerSPAWriteCachePolicy	nvarchar	64	Yes	The write cache policy on controller A.
ControllerSPBReadCachePolicy	nvarchar	64	Yes	The read cache policy on controller B.
ControllerSPBWriteCachePolicy	nvarchar	64	Yes	The write cache policy on controller B.
Enclosure Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
EnclosureNumber*	int	4	No	The instance number of the enclosure entry.
EnclosurePartNumber	nvarchar	64	Yes	The part number of the enclosure entry.
EnclosureSerialNumber	nvarchar	64	Yes	The serial number of the enclosure entry.
EnclosureName	nvarchar	256	Yes	The enclosure's name.
EnclosureVendor	nvarchar	256	Yes	The enclosure's reseller's name.
EnclosureId	int	4	Yes	The SCSI address of the processor.
EnclosureLocationofManufacture	nvarchar	256	Yes	The enclosure's manufacture location.
EnclosureServiceTag	nvarchar	64	Yes	The enclosure identification used when consulting customer support.
EnclosureAssetTag	nvarchar	64	Yes	The user-definable asset tag for the enclosure.
EnclosureAssetName	nvarchar	64	Yes	The user-definable asset name for the enclosure.
EnclosureProductId	nvarchar	64	Yes	The enclosure's product identification, which also corresponds to the enclosure type.
EnclosureType	nvarchar	64	Yes	The type of enclosure.
EnclosureChannelNumber	int	4	Yes	The channel number, or bus, to which the enclosure is connected.
EnclosureBackplanePartNum	nvarchar	64	Yes	The part number of the enclosure's backplane.
EnclosureSCSIId	int	4	Yes	The SCSI ID of the controller to which this enclosure is attached.
Enclosure Management Module Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
EMMNumber*	int	4	No	The instance number of the enclosure management module.
EMMName	nvarchar	256	Yes	The name of the enclosure.
EMMVendor	nvarchar	256	Yes	The management module reseller's name.
EMMPartNumber	nvarchar	64	Yes	The part number of the enclosure memory module.
EMMFWVersion	nvarchar	64	Yes	Firmware version of the enclosure memory module.
VirtualDisk Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
VirtualDiskNumber*	int	4	No	Instance number of this virtual disk entry.
VirtualDiskName	nvarchar	256	Yes	The virtual disk's label generated by Storage Management or entered by the user.
VirtualDiskDeviceName	nvarchar	256	Yes	Device name used by this virtual disk's member disks.
VirtualDiskLength	int	4	Yes	The size of this virtual disk in gigabytes.
VirtualDiskWritePolicy	nvarchar	64	Yes	Indicates whether the controller's write cache will be used when writing to a virtual disk.
VirtualDiskReadPolicy	nvarchar	64	Yes	Indicates whether the controller's read cache will be used when reading from a virtual disk.
VirtualDiskCachePolicy	nvarchar	64	Yes	Indicates whether the controller's cache is used when reading from or writing to a virtual disk.
VirtualDiskLayout	nvarchar	64	Yes	The virtual disk's RAID type.
VirtualDiskStripeSize	int	4	Yes	The stripe size of this virtual disk in bytes.
VirtualDiskStripeElementSize	int	4	Yes	The stripe element size of this virtual disk in blocks.
VirtualDiskTargetId	int	4	Yes	Unique ID for the virtual disk.
VirtualDiskLUNId	nvarchar	64	Yes	The durable unique LUN ID for this virtual disk.
Volume Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
VolumeNumber*	int	4	Yes	Instance number of the volume entry.
VolumeDriveLetter	nvarchar	64	Yes	The volume's path (or drive letter) according to the operating system.
VolumeLabel	nvarchar	256	Yes	The user-definable label for this volume.
VolumeSize	int	4	Yes	The size of the volume in megabytes.
Firmware Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
FirmwareChassisIndex*	int	4	No	The firmware chassis index (zero based).
FirmwareIndex*	int	4	No	The firmware index (zero based).
FirmwareType	nvarchar	64	Yes	The firmware type.
FirmwareName	nvarchar	64	Yes	The name of the firmware.
FirmwareVersion	nvarchar	64	Yes	The firmware version.
MemoryDevice Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
MemoryDeviceChassisIndex*	int	4	No	This attribute defines the index (one based) of the associated chassis.
MemoryDeviceIndex*	int	4	No	This attribute defines the index (one based) of the memory device.
MemoryDeviceName	nvarchar	256	Yes	This attribute defines the location of the memory device.
MemoryDeviceBankName	nvarchar	256	Yes	This attribute defines the location of the bank for the memory device.
MemoryDeviceType	nvarchar	256	Yes	This attribute defines the type of the memory device.
MemoryDeviceFormFactor	nvarchar	256	Yes	This attribute defines the form factor of the memory device.
MemoryDeviceSize	int	4	Yes	This attribute defines the size of the memory device.
MemoryDeviceFailureMode	nvarchar	256	Yes	This attribute defines the failure mode of the memory device.
NIC Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
NICId*	int	4	No	The unique instance ID of the NIC.
NICIPAddress	nvarchar	40	Yes	The IP address assigned to the NIC.
NICNetmask	nvarchar	40	Yes	The subnet mask assigned to the NIC.
NICMACAddress	nvarchar	24	Yes	The MAC address of the NIC.
NICManufacturer	nvarchar	256	Yes	The reseller of the NIC.
NICPingable	int	4	Yes	A flag indicating that IT Assistant communicates with the device using this IP address.
Operating System Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
OSId*	int	4	No	The instance ID for the operating system.
OSName	nvarchar	64	Yes	The name of the operating system.
OSRevision	nvarchar	64	Yes	The revision of the operating system (for example, the Microsoft Windows® service pack or the Linux kernel version)
OSTotalPhysicalMemory	int	4	Yes	The total physical memory reported by the operating system in megabytes.
OSLocale	nvarchar	64	Yes	The locale for the operating system.
OSType	int	4	Yes	The type of operating system.
PowerSupply Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
PowerSupplyChassisIndex*	int	4	No	This attribute defines the index (one based) of the chassis.
PowerSupplyIndex*	int	4	No	This attribute defines the index (one based) of the power supply.
PowerSupplyType	nvarchar	256	Yes	This attribute defines the type of the power supply.
PowerSupplyLocation	nvarchar	256	Yes	This attribute defines the location of the power supply.
PowerSupplyOutputWatts	int	4	Yes	This attribute defines the maximum sustained output wattage of the power supply, in tenths of watts.
Processor Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
ProcessorChassisIndex*	int	4	No	This attribute defines the index (one based) of the chassis.
ProcessorIndex*	int	4	No	This attribute defines the index (one based) of the processor.
ProcessorFamily	nvarchar	256	Yes	This attribute defines the family of the processor device.
ProcessorCurrentSpeed	int	4	Yes	This attribute defines the current speed of the processor device in MHz. Zero indicates that the current speed is unknown.
ProcessorSlotNumber	int	4	Yes	This attribute defines the slot that the processor occupies.
SMBIOS Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
ParallelPortConfiguration	nvarchar	64	Yes	Defines the parallel port configuration.
ParallelPortMode	nvarchar	64	Yes	The mode of the parallel port.
SerialPortYesConfiguration	nvarchar	64	Yes	Defines the serial port 1 configuration.
SerialPort2Configuration	nvarchar	64	Yes	Defines the serial port 2 configuration.
IDEController	nvarchar	64	Yes	Defines whether the IDE controller is enabled or disabled.
BuiltinNIC	nvarchar	64	Yes	Defines whether the built-in NIC is enabled or disabled.
BuiltinFloppy	nvarchar	64	Yes	Defines whether the built-in floppy disk controller is enabled, auto, or read-only.
BuiltinPointingDevice	nvarchar	64	Yes	Defines whether the built-in pointing device (mouse) port is enabled or disabled.
WakeupOnLAN	nvarchar	64	Yes	Defines whether Wake-On-LAN is disabled, enabled for on-board NIC only, or enabled for add-in NIC only. If Enabled with boot to NIC option is selected, the system boots from the NIC boot-ROM upon a remote wake up.
WakeupOnLANMethod	nvarchar	64	Yes	Defines the Wake-On-LAN method supported by the system.
AutoOn	nvarchar	64	Yes	Defines the auto-on configuration: disabled, every day or week days (Monday-Friday).
AutoOnHour	nvarchar	64	Yes	Defines the hour when the system is turned on (0-23).
AutoOnMinute	nvarchar	64	Yes	Defines the minutes when the system is turned on (0-59).
BootSequence	nvarchar	64	Yes	Defines the boot sequence for the next system boot.
ChassisIntrusionStatus	nvarchar	64	Yes	Reports the status of the system with regard to Chassis Intrusion (Detected or Not Detected). A value of Unknown indicates either that chassis intrusion is not supported by this system, or that the chassis intrusion event reporting has been disabled by the user. If the value is Detected, you may set it to Not Detected to enable the system to receive the next event and to stop generating events for now.
IntegratedAudio	nvarchar	64	Yes	The status of the system's built-in sound device.
PCISlots	nvarchar	64	Yes	The status of the system's add-on PCI slots (enabled/disabled).
USBPorts	nvarchar	64	Yes	The status of the USB ports (on/off).
SoftwareInventory Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
ComponentId	nvarchar	64	Yes	The component identifier for the software.
InstanceId*	nvarchar	32	No	The instance identifier for the hardware.
HWDeviceId	nvarchar	16	Yes	The hardware device identifier of the PCI ID.
HWVendorId	nvarchar	16	Yes	The hardware vendor identifier of the PCI ID.
HWSubDeviceId	nvarchar	16	Yes	The hardware subdevice identifier of the PCI ID.
HWSubVendorId	nvarchar	16	Yes	The hardware subvendor identifier of the PCI ID.
SubComponentId	nvarchar	64	Yes	The subcomponent identifier for the hardware.
HWDescription	nvarchar	128	Yes	The description of the hardware.
SoftwareType	nvarchar	64	Yes	The type of software, for example, driver (DRVR), firmware (FRMW), and so on.
SoftwareVersion	nvarchar	64	Yes	The software version number.
SoftwareDescription	nvarchar	128	Yes	The description of the software.
SoftwareInventoryOS Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
OSVendor	nvarchar	64	Yes	The operating system vendor name.
OSMajorVersion	nvarchar	16	Yes	The major version of the operating system.
OSMinorVersion	nvarchar	16	Yes	The minor version of the operating system.
OSSPMajorVersion	nvarchar	16	Yes	The Service Pack major version.
OSSPMinorVersion	nvarchar	16	Yes	The Service Pack minor version.
SwitchDevice Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
SwitchIndex*	int	4	No	The index of the switch.
SwitchAssetTag	nvarchar	255	Yes	The asset tag of the switch.
SwitchServiceTag	nvarchar	255	Yes	The service tag of the switch.
SwitchSerialNumber	nvarchar	255	Yes	The serial number of the switch.
CostOfOwnership Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
CooIndex*	int	4	No	The index of the cost of ownership.
PurchaseCost	nvarchar	64	Yes	The initial purchase cost of the system.
WayBillNumber	nvarchar	64	Yes	The way bill number.
InstallationDate	nvarchar	64	Yes	The date that the system was installed.
PurchaseOrderNumber	nvarchar	64	Yes	The purchase order number.
PurchaseDate	nvarchar	64	Yes	The date that the system was purchased.
SigningAuthorityName	nvarchar	64	Yes	The signing authority reference.
OriginalMachineConfigurationExpensed	nvarchar	64	Yes	The original system configuration that was expensed.
OriginalMachineConfigurationVendorName	nvarchar	64	Yes	The original system configuration vendor name.
CostCenterInformationVendorName	nvarchar	64	Yes	The cost center information vendor name.
UserInformationUserName	nvarchar	64	Yes	The user name.
ExtendedWarrantyStartDate	nvarchar	64	Yes	The extended warranty start date.
ExtendedWarrantyEndDate	nvarchar	64	Yes	The extended warranty end date.
ExtendedWarrantyCost	nvarchar	64	Yes	The extended warranty cost.
ExtendedWarrantyProviderName	nvarchar	64	Yes	The extended warranty provider name.
OwnershipCode	nvarchar	64	Yes	The ownership code.
CorporateOwnerName	nvarchar	64	Yes	The owner's name.
HazardousWasteCodeName	nvarchar	64	Yes	The hazardous waste code name.
DeploymentDateLength	nvarchar	64	Yes	The deployment date length.
DeploymentDurationUnitType	nvarchar	64	Yes	The deployment duration unit type.
TrainingName	nvarchar	64	Yes	The training name.
OutsourcingProblemDescription	nvarchar	64	Yes	The outsourcing problem description.
OutsourcingServiceFee	nvarchar	64	Yes	The outsourcing service fee.
OutsourcingSigningAuthority	nvarchar	64	Yes	The outsourcing signing authority.
OutsourcingProviderFee	nvarchar	64	Yes	The outsourcing provider fee.
OutsourcingProviderServiceLevel	nvarchar	64	Yes	The outsourcing provider service level.
InsuranceCompanyName	nvarchar	64	Yes	The insurance company's name.
BoxAssetTagName	nvarchar	64	Yes	The device's asset tag.
BoxSystemName	nvarchar	64	Yes	The device's host name.
BoxCPUSerialNumberName	nvarchar	64	Yes	The device's CPU serial number.
DepreciationDuration	nvarchar	64	Yes	The depreciation duration.
DepreciationDurationUnitType	nvarchar	64	Yes	The depreciation duration units.
DepreciationPercentage	nvarchar	64	Yes	The depreciation percentage.
DepreciationMethod	nvarchar	64	Yes	The depreciation method.
RegistrationIsRegistered	nvarchar	64	Yes	The registration is registered.
ContactInfo Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
ContactName*	nvarchar	64	No	The contact name.
ContactInformation	nvarchar	64	Yes	The information for this contact.
ContactDescription	nvarchar	64	Yes	The description for this contact.
Cluster Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
ClusterIndex*	int	4	No	The cluster index.
ClusterType	int	4	Yes	The cluster type.
ClusterTypeName	nvarchar	64	Yes	The cluster type name.
ClusterName	nvarchar	255	Yes	The cluster name.
ClusterDescription	nvarchar	255	Yes	The cluster description.
FRU Information Table
DeviceId*	int	4	No	The device ID.
FRUChassisindex*	int	4	No	The field replaceable unit (FRU) chassis index.
FRUIndex*	int	4	No	The FRU index.
FRUDeviceName	nvarchar	255	Yes	The FRU device name.
FRUManufacturer	nvarchar	255	Yes	The FRU manufacturer name.
FRUSerialNumber	nvarchar	255	Yes	The FRU serial number.
FRUPartNumber	nvarchar	255	Yes	The FRU part number.
FRURevision	nvarchar	255	Yes	The FRU revision number.
FRUManufacturingDate	date	8	Yes	The FRU manufacturing date.
Printer Supply Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
PrinterSupplyIndex*	int	4	No	The printer supply index.
PrinterSupplyDescription	nvarchar	64	Yes	The printer supply description.
PrinterSupplyLevel	nvarchar	16	Yes	The printer supply level.
PrinterSupplyMaxLevel	int	4	Yes	The maximum level of printer supply.
PrinterSupplyType	nvarchar	64	Yes	The printer supply type.
Printer Input Tray Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
PrinterInputTrayIndex*	int	4	No	The printer input tray index.
PrinterInputName	nvarchar	64	Yes	Name of the printer input.
PrinterInputVendorName	nvarchar	64	Yes	Name of the printer (re)seller.
PrinterInputModel	nvarchar	64	Yes	Name of the input tray model.
PrinterInputDescription	nvarchar	64	Yes	The printer input description.
PrinterInputMaxCapacity	nvarchar	64	Yes	The maximum capacity of the printer input module.
PrinterInputCurrentCapacity	nvarchar	64	Yes	The current capacity of the printer input module.
PrinterInputMediaType	nvarchar	64	Yes	The media type.
Printer Output Tray Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
PrinterOutputIndex*	int	4	No	The printer output index.
PrinterOutputName	nvarchar	64	Yes	Name of the output unit.
PrinterOutputVendorName	nvarchar	64	Yes	Name of the printer (re)seller.
PrinterOutputModel	nvarchar	64	Yes	Name of the output tray model.
PrinterOutputDescription	nvarchar	64	Yes	The printer output description.
PrinterOutputMaxCapacity	nvarchar	64	Yes	The maximum output capacity of the printer.
Printer Cover Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
PrinterCoverIndex*	int	4	No	The printer cover index.
PrinterCoverDescription	nvarchar	64	Yes	The printer cover description.
PrinterCoverStatus	nvarchar	64	Yes	The printer cover status.
Tape Drive Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
TapeDriveIndex*	int	4	No	The tape drive index.
TapeDriveVendor	nvarchar	64	Yes	Name of the tape drive vendor.
TapeDriveModel	nvarchar	64	Yes	Name of the tape drive model.
TapeDriveType	nvarchar	64	Yes	The tape drive type.
TapeDriveFirmwareVersion	nvarchar	32	Yes	Firmware version of the tape drive.
TapeDriveSerialNumber	nvarchar	32	Yes	Serial number of the tape drive.
TapeDriveWMN	nvarchar	32	Yes	WMN for the tape drive.
TapeDriveCleaningRequired	nvarchar	32	Yes	Specifies whether the tape drive requires cleaning.
TapeLibraryScsiId	int			Specifies the SCSI ID of the Tape library
Tape Library Table
DeviceId*	int	4	No	The Foreign Key to the Device Table.
TapeLibraryIndex*	int	4	No	The tape library index.
TapeLibraryVendor	nvarchar	64	Yes	Name of the tape library vendor.
TapeLibraryModel	nvarchar	64	Yes	Name of the tape library model.
TapeLibraryFirmwareVersion	nvarchar	32	Yes	Firmware version of the tape library.
TapeLibraryDriveCount	int	4	Yes	The number of drives.
TapeLibrarySlotCount	int	4	Yes	The number of slots.
TapeLibrarySerialNumber	nvarchar	32	Yes	Serial number of the tape library.

Managing Tasks

IT Assistant also allows you to remotely run certain tasks on managed systems across the enterprise remotely. These tasks include:

Generic command line execution (the ability to invoke the Dell OpenManage Server Administrator command line interface remotely is also supported if Dell OpenManage 4.3 or later instrumentation is enabled)
Device control, including shutdown and wake up
Scheduled software updates
Ability to execute Intelligent Platform Management Interface (IPMI) commands remotely
Ability to execute Remote Client Instrumentation commands remotely
Ability to deploy the Dell agent (Server Administrator) on systems

NOTE: IPMI and Remote Client Instrumentation command line options may not be available if IT Assistant does not detect the necessary components installed on the IT Assistant Services Tier.

These tasks can be configured to run on specific schedules or execute immediately. For more information, see the Dell OpenManage IT Assistant Online Help.

Creating a Device Control Task

For instance, Jane wants to power control a system through IT Assistant. To perform these tasks in IT Assistant, she would:

Select Manage→ Tasks and right-click Device Control in the left navigation pane.
Select New Task.

The Task Creation wizard appears.

Jane enters a Task Name, then chooses Shutdown Device from the Task Type pull-down menu and clicks Next.
From the Select Shutdown Type window, she chooses:
1. Reboot to reboot a troublesome server that has issued several e-mail alerts
1. Power Cycle (if supported). This option performs a power cycle when IT Assistant communicates to the system through Dell instrumentation using the SNMP. The power to the device is turned off and turned on again. When the power is restored, the device is restarted.
2. Power On to power on an ASF-enabled device.
3. Power Off to power down the system.
4. Shutdown Operating System first. This option performs a graceful shutdown of the operating system before performing the selected shutdown action.

NOTE: Shutdown Operating System first will not display for ASF-enabled devices.

In the Select Devices window, she expands the Servers device list and selects only the server that she wants to reboot.
In Select Schedule, she chooses Run Now.
If she is rebooting an SNMP-enabled system, she must enter the instrumentation user name and password in the Enter Credentials window. If her system is CIM-enabled, she must enter the fully qualified domain user name and password.
In the Summary window, she either confirms her selections or chooses Back to make changes.

The server she specified will begin a reboot immediately after she selects Finish.

Alternately, Jane could choose to power up a device in her group by choosing Wake Up Device as the Task Type in the Task Creation wizard. She could also schedule the task to run at a specified time instead of immediately.

Other Tasks Available in IT Assistant

Other task types available in IT Assistant include:

Generic Command Line

Choosing Generic Command Line from the pull-down menu allows you to execute commands from within your network. Remote Server Administrator Command Line allows you to execute Server Administrator command line interface (CLI) commands remotely.

For a full list of the arguments accepted by IT Assistant, see the online help.

Software Update

Choosing Server Software Upgrade allows you to fully customize the software upgrade process on your managed systems, including defining separate schedules for each component of the upgrade.

For a complete explanation of each task and its function, see the Dell OpenManage IT Assistant Online Help.

IPMI Command Line

Choosing IPMI Command Line from the pull-down menu allows you to execute IPMI commands.

For additional information, see the online help.

Remote Client Instrumentation Command Line

Choosing Remote Client Instrumentation Command Line allows you to execute client instrumentation commands remotely.

For additional information, see the online help.

Server Administrator Software Deployment

Choosing Software Deployment under the Task parent node allows you to deploy the Dell agent on multiple systems.

For additional information, see "Using Server Software Deployment."

Shutdown Device(via in-band)

Choosing Shutdown Device(via in-band) allows you to specifiy the shutdown operation that you want to perform.

NOTE: This task requires CIM or SNMP discovery to be enabled, or Server Administrator to be installed on the managed node.

NOTE: The shutdown task is not supported for devices discovered using IPMI only.

Wake Up Device(via WakeOnLAN)

Choosing Wake Up Device(via WakeOnLAN) allows you to specify the port number of the device that you want to wake up. To wake up a device, IT Assistant uses the MAC addresses and subnet mask that were discovered for that device. If NIC teaming is configured on the device, only one MAC is advertised by the operating system. For Wake-on-LAN (WOL) to work, WOL must be enabled for all NICs in that team. For a WOL packet to reach its intended destination, directed broadcasting (also known as subnet broadcasting) must be enabled on the intermediate routers. Directed broadcasting is typically disabled on the routers, so you must configure this feature on the routers to enable it.

NOTE: Enable the WOL property in the NIC settings and the system BIOS.

Power Control Device(via ASF)

Choosing Power Control Device(via ASF) allows you to perform remote power control operations on the Alert Standard Format (ASF) 2.0 compliant devices.

NOTE: See the system documentation for ASF configuration and setup instructions.

NOTE: IT Assistant uses the in-band Broadcom Windows Management Instrumentation (WMI) provider to verify if a device has ASF capabilities.

IT Assistant also uses the in-band Broadcom WMI provider to detect if a device is enabled for remote secure Remote Management Control Packets (RMCP) operations and whether the administrator roles have sufficient privileges to perform power control operations.

NOTE: You can configure the power control operations through the Broadcom ASF Configuration Utility.

NOTE: Verify that ASF Enabled, Remote Management, and Secure Management(ASF 2.0) options are enabled in the Broadcom ASF Configuration Utility. Also ensure that the Authentication Key and the KG Key are entered in the correct format (Hex or ASCII).

The WMI provider is available as part of the Broadcom ASF Management suite—available on the Dell Support website at support.dell.com—and must be installed on the remote client device.

You can select the devices that are detected as being enabled, in the device selection pane of the ASF power control wizard. If the remote device does not have the WMI provider installed, is not enabled for remote secure RMCP operations, or if the administrator privileges have not been configured for the power control operation correctly, the device will appear disabled in IT Assistant.

NOTE: You can select the disabled devices, if you select the Enable All option.

If the settings are altered, rediscover the device to enable IT Assistant to use the updated configuration to enable/disable the client devices in the wizard.

Back to Contents Page