OUTPUT_CONSTRAINTS{
template = template-key
format = export-file-format (csv or par)
row = items-to-be-output (row)
group_membership = group-of-the-host
condition = condition
unicode = Y-or-N-indicating-whether-a-CSV-file-in-Unicode-is-to-be-output
}

• template=template-key
  In template-key, specify the template key for the template you want to use for exporting the inventory information. The items you can export with the template are the same as the items that the CSV output utility outputs to a CSV-formatted file. For details, see 9.1.1 Items eligible for output to a CSV-formatted file in the manual Administrator's Guide Volume 1.
  You can specify any template when exporting inventory information in CSV format. However, some templates cannot be specified when you export inventory information in the parameter file format. The following shows the templates and the export formats that can be specified.
  

  Table 4-23 Export file formats and templates that can be specified

  Template key	Corresponding template	CSV format	Parameter file format
  HOST_ATTR	Host attributes	Y	Y#
  PKG_INFO	Package attributes	Y	Y
  PKG_FILES	Package contents	Y	N
  SYS_INFO	System information	Y	N
  USR_INV	User inventory information	Y	N
  INSTLD_PKG	Installed package information	Y	Y#
  J_STAT	Job status	Y	Y
  REG_DEFS	Registry acquisition item	Y	N
  USER	User information	Y	N
  SOFT_INV	Software inventory	Y	N
  LICENSE	License information	Y	N
  MS_OFFICE	Microsoft Office products	Y	N
  VIRUS	Anti-virus products	Y	N
  NO_CLIENT	Information on hosts on which JP1/Software Distribution is not installed	Y	N
  DISCOVERY_INFO	Host search results	Y	N
  DETER_HIST	Boot suppression history	Y	N

  Legend:

  Y: Specifiable.

  N: Not specifiable

  #

  Outputs information on the host having the same operating key as the managing server that executes the command. If a relay manager having a different operating key exists, host information on that relay manager and any subordinate hosts is not output.

  
  When you export inventory information to a file in the parameter file format by specifying a template that is indicated in Table 4-23 as being not specifiable, the command results in an error.
  
• format=export-file-format
  Specify either of these keywords as the export format of the output file:
  

  csv

  Exports the inventory information to the result output file in CSV format.

  par

  If you specify this keyword, the command exports the inventory information to the result output file in the parameter file format. When you export the inventory information to a file in the parameter file format, the tag information to be output differs depending on the template you use. The following shows the template keys and the tags that are displayed.

  Table 4-24 Tags to be output to a file in the parameter file format

  Template key	Tag to be output
  HOST_ATTR (host attribute)	JOB_DESTINATION
  PKG_INFO (package attribute)	PACKAGING_INFORMATION
  INSTLD_PKG (installed package information)	JOB_DESTINATION
  J_STAT (job status)	JOB_DESTINATION

  If you specify the export format in both a command argument and the parameter file, the command argument prevails. If you specify the export format in neither a command argument nor the parameter file, csv is used by default.
  
• row=items-to-be-output (row)
  To output inventory information to a CSV-formatted file, individually specify the items (rows) in the template that are to be output. Use a semicolon (;) to separate each item. The spaces before and after semicolons are ignored. The following shows the format of the row parameter:
  

   
  row = item-1;item-2;item-3...
   

  If you do not specify the row parameter, the command outputs the information for all items.
  The output item specification by the row parameter is valid only when you use any of the following templates to export the inventory information to a file in the CSV format:
  
  • HOST_ATTR (host attribute)
  • SYS_INFO (system information)
  • INSTLD_PKG (installed package information)
  • J_STAT (job status)
  • VIRUS (anti-virus products)
  • NO_CLIENT (information on hosts on which JP1/Software Distribution is not installed)
  • DISCOVERY_INFO (host search results)
  When you use a template other than the preceding to export the inventory information to a file in CSV format, you cannot specify the items you want to output. The command outputs the information for all items. If you export the inventory information to a file in the parameter file format, the row parameter is ignored.
  Tables 4-25 to 4-31 list the items you can specify in the row parameter in each template.
  

  Table 4-25 Items that can be specified in the row parameter with the HOST_ATTR (host attribute) template

  Items that can be specified in the row parameter	Explanation
  host	Host name
  ipaddr	IP address
  hid	Host ID
  macaddr	MAC address
  type	Type
  route	Route
  group	Group to which the host belongs
  holdrep	Notification hold
  suspended	File transfer suspended at relay system
  cmnt	Comment
  cdate	Creation date/time
  date	Update date/time
  pkgupdate	Installed package information last update date
  syupdate	System information last update date
  uupdate	User inventory information last update date
  rupdate	Registry information last update date
  sfupdate	Software inventory information last update date
  smiupdate	Software operation information last update date
  smpolicy	Operation monitoring policy for the applied software and the policy's version

  Table 4-26 Items that can be specified in the row parameter with the SYS_INFO (system information) template

  Items that can be specified in the row parameter	Explanation
  host	Host name
  ipaddr	IP address (value of a system configuration key item)
  hid	Host ID
  cpu	CPU type
  copr	Coprocessor
  ram	Installed RAM
  memslot	Memory slot capacity
  freephymem	Available physical memory
  totalvirmem	Total capacity of virtual memory
  freevirmem	Available virtual memory
  pagefile	Page file capacity
  mtype	Workstation type
  clocks	CPU clock speed
  extclock	Clock speed of external CPU
  processor	Number of processors
  maker	Maker name
  model	Model
  muuid	Machine UUID
  msernum	Machine serial number
  biosmaker	BIOS manufacturer
  biosdate	BIOS release date
  biosver	BIOS version
  smbiosver	BIOS version (SMBIOS)
  amtfmvr	AMT firmware version
  pribus	Type of primary bus
  secbus	Type of secondary bus
  os	OS
  distribution	Linux distribution name
  ospatch	OS build number/OS patch information
  osl	OS license
  osv	OS version
  ossv	OS sub-version
  ossernum	OS serial number
  locale	Locale
  oslang	OS language
  timezone	Current time zone
  insdate	OS installation date/time
  lastbootdate	Last startup time/date
  bootdev	Boot device
  windir	Windows directory
  sysdir	System directory
  wmi	WMI
  wininst	Windows Installer
  mbsa	MBSA
  wua	Windows Update Agent
  ie	Internet Explorer version
  iepatch	IE patch
  domain_wrkgrp	Domain/Workgroup
  domain	Domain type
  owner	Owner
  org	Company name
  pcname	Computer name
  comdesc	Computer description
  logonname	Logon user name
  username	Full name of user
  userdesc	User description
  cltver	Client version
  disk	Disk details#1
  filesystem	File system#2
  totalsize	Total sizes#3
  hdmodel	Model of hard disk
  hdesize	Hard disk capacity
  hdinterface	Hard disk interface
  hdpartition	Number of hard disk partitions
  cdrom	CD-ROM drive
  umem	Available user memory size
  sysres	Available system resource size
  keyboard	Keyboard
  mouse	Mouse
  mousenum	Number of mouse buttons
  monitor	Monitor type
  vdriver	Video driver
  vchip	Video chip
  vram	VRAM
  display	Display
  soundmaker	Sound card manufacturer
  soundname	Sound card product name
  macaddr	MAC address
  nwkad	Network adapter
  defra	Default router address
  subnet	Subnet mask
  ipaddr_inv	IP address (inventory information)
  pridns	Primary DNS server address
  secdns	Secondary DNS server address
  dhcp	DHCP
  dhcpsrv	DHCP server address
  dhcpexp	DHCP lease expiration date
  dhcpobt	DHCP lease acquired date/time
  wins	WINS server address
  prtname	Printer name
  prtdrv	Printer driver
  prtpaper	Printer sheet size
  prtkind	Printer type
  prtshare	Shared name of printer
  prtserver	Printer server name
  prtport	Printer port
  guestaccount	Guest account
  weakpasswod	Weak password#4
  account	Account#5
  dayupdpass	Elapsed days since a password modification#5
  indefinitepass	Non-expiring password#4
  autologon	Autologon setting
  sharedfolder	Shared folder
  anonymousrefer	Anonymous connection
  screensaver	Screensaver
  scrpassword	Screensaver password protection function
  poweronpass	Power on password
  winfirewall	Windows Firewall settings
  winautoupdate	Windows Automatic Updates
  needlesssrv	Unnecessary service
  bitlocker	BitLocker settings
  driveencryption	Drive encryption information
  turnoffmonitor_ac	Turn off monitor (AC)
  turnoffmonitor_dc	Turn off monitor (DC)
  procsthrottle_ac	Processor throttle (AC)
  procsthrottle_dc	Processor throttle (DC)
  turnoffharddisks_ac	Turn off hard disk (AC)
  turnoffharddisks_dc	Turn off hard disk (DC)
  standby_sleep_ac	System standby/sleep (AC)
  standby_sleep_dc	System standby/sleep (DC)
  systemhibernate_ac	System in hibernate status (AC)
  systemhibernate_dc	System in hibernate status (DC)

  #1

  This is a generic representation of the information items for a single drive. The information items include the logical drive name, device name, free space, and partition size. Specifying disk outputs these four data items.

  #2

  This is the information for a single drive. If you specify disk (note 1 above) and also filesystem, the information is output as a single disk details item.

  #3

  This is a generic representation of the information items about the total size of all drives. The information items include total free space and total size of partitions (each partition size is output by specifying disk). Specifying totalsize outputs these two data items.

  #4

  Use the semi-colon (;) to specify conditions for consecutive character strings.

  #5

  A condition specified here outputs information for all targeted machines.

  
  

  Table 4-27 Items that can be specified in the row parameter with the INSTLD_PKG (installed package information) template

  Items that can be specified in the row parameter	Explanation
  host	Host name
  ipaddr	IP address
  hid	Host ID
  pname	Package name
  pid	Package ID
  install	Installation
  newver	New version
  newgen	New generation
  oldver	Old version
  oldgen	Old generation
  date	Installation or software search date/time

  Table 4-28 Items that can be specified in the row parameter with the J_STAT (job status) template

  Items that can be specified in the row parameter	Explanation
  folder	Folder name
  jname	Job name
  jattr	Job attribute
  execdate	Execution date/time at the server
  execsch	Scheduled execution date/time at the server
  sduedate	Execution time limit at the server
  sregdate	Scheduled registration date/time at the server
  dstname	Job destination name
  jtype	Job type
  dexecdate	Job execution date/time by destination
  pname	Package name
  pid	Package ID
  cabid	Cabinet ID
  dmcode	DM ID code
  pver	Version
  pgen	Generation
  cexecdate	Installation date/time at the client
  result	Result
  status	Status

  Table 4-29 Items that can be specified in the row parameter (VIRUS (anti-virus product) template)

  Items that can be specified in the row parameter	Explanation
  host	Host name
  ipaddr	IP address
  hid	Host ID
  sname	Software name
  sver	Software version
  org	Company name
  lang	Language
  path	Path
  size	Size
  sdate	Search date/time
  idate	Date installed
  regorg	Registered company name
  reguser	Name of registered owner
  virusver	Virus detection engine version
  vfilever	Virus definition file version
  vstation	Virus detection resident/non-resident
  softwareid	Software indicator ID

  Table 4-30 Items that can be specified in the row parameter (NO_CLIENT (information on hosts on which JP1/Software Distribution is not installed) template)

  Items that can be specified in the row parameter	Explanation
  ipaddr	IP address
  type	Node type
  host	Node name
  macaddr	MAC address
  subnet	Subnet mask
  netaddr	Network address
  datetime	Detection date/time
  lastupdate	Last update date/time
  cmnt	Comment on node

  Table 4-31 Items that can be specified in the row parameter (DISCOVERY_INFO (host search result) template)

  Items that can be specified in the row parameter	Explanation
  ipaddr	IP address
  type	Node type
  host	Node name
  macaddr	MAC address
  subnet	Subnet mask
  netaddr	Network address
  lastupdate	Last update date/time
  cmnt	Comment on node

  
  
• group_membership=group-of-the-host
  In group-of-the-host, specify the group to which the target host belongs as a condition for extracting the information to be output. You can specify one of the group types: relay manager/system, host group, and ID group. You can specify more than one group of the same type. When you specify more than one group, use a semicolon (;) to separate each of the groups or write more than one group_membership parameter line. The specified groups are evaluated with the OR condition. The following shows the format of the group_membership parameter:
  

   
  group_membership = [relay-manager/systems | host-groups | ID-groups]
   

  relay-manager/systems

  In relay-manager/systems, specify one or more relay managers/systems. You can specify paths consisting of names delimited by backslashes (\).

  host-groups

  In host-groups, specify one or more host group names that begin with a backslash (\). You can specify paths consisting of names delimited by backslashes (\).

  ID-groups

  In ID-groups, specify an ID group name that begins with \%.

  The templates that allow you to use the group_membership parameter for extracting information differ depending on the export file format. The following shows the export file formats for which the template supports the group_membership parameter.
  

  Table 4-32 Templates supporting the group_membership parameter

  Template key	Corresponding template	CSV format	Parameter file format
  HOST_ATTR	Host attributes	O	O
  PKG_INFO	Package attributes	X	X
  PKG_FILES	Package contents	X	--
  SYS_INFO	System information	O	--
  USR_INV	User inventory information	O	--
  INSTLD_PKG	Installed package information	O	X
  J_STAT	Job status	X	X
  REG_DEFS	Registry acquisition item	O	--
  SOFT_INV	Software inventory	O	--
  LICENSE	License information	X	--
  USER	User information	O	--
  MS_OFFICE	Microsoft Office products	O	--
  VIRUS	Anti-virus products	O	--
  NO_CLIENT	Information on hosts on which JP1/Software Distribution is not installed	X	--
  DISCOVERY_INFO	Host search results	X	--
  DETER_HIST	Boot suppression history	O	--

  Legend:

  O: Can specify the group_membership parameter.

  X: Cannot specify the group_membership parameter.

  --: Template that cannot be used in parameter file format.

  
  
• condition=condition
  In condition, specify a comparison condition expression for limiting the range of values you want to output. You can use items (rows) of the template as the keys for extracting information to create a comparison condition expression.
  The templates that allow you to use the condition parameter differ depending on the export file format. You can use the condition parameter for all the templates available for exporting to a file in the parameter file format. The table below shows the export file formats for which the template supports the condition parameter.
  

  Table 4-33 Templates supporting the condition parameter

  Template key	Corresponding template	CSV format	Parameter file format
  HOST_ATTR	Host attributes	X	O#
  PKG_INFO	Package attributes	X	O#
  PKG_FILES	Package contents	X	--
  SYS_INFO	System information	O	--
  USR_INV	User inventory information	X	--
  INSTLD_PKG	Installed package information	O	O
  J_STAT	Job status	O	O
  REG_DEFS	Registry acquisition item	X	--
  SOFT_INV	Software inventory	X	--
  LICENSE	License information	X	--
  USER	User information	X	--
  MS_OFFICE	Microsoft Office products	X	--
  VIRUS	Anti-virus products	O	--
  NO_CLIENT	Information on hosts on which JP1/Software Distribution is not installed	O	--
  DISCOVERY_INFO	Host search results	O	--
  DETER_HIST	Boot suppression history	X	--

  Legend:

  O: Can specify the condition parameter.

  X: Cannot specify the condition parameter.

  --: Template that cannot be used in parameter file format.

  #

  You can only extract the information by using a command, but not by using the CSV output utility.

  
  The following shows the format of the condition parameter:
  

   
  condition = condition [{AND|OR} condition [{AND|OR} condition] ]...
   

  Use the AND and/or OR operators to combine operands to create a condition expression. The conditional expression AND is executed first. The following shows examples of expressions:
  

  X AND Y AND Z

  The program extracts the information that satisfies all of the conditions X, Y, and Z.

  X AND Y OR Z

  The program extracts the information that satisfies both the conditions X and Y, and extracts the information that satisfies the condition Z.

  X OR Y AND Z

  The program extracts the information that satisfies both the conditions Y and Z, or the condition X.

  X OR Y OR Z

  The program extracts the information that satisfies any of the conditions X, Y, and Z.

  When you use more than one comparison condition, remember the following points:
  
  • A single condition statement line can include up to 15 combined comparison conditions.
  • When writing more than one condition statement line, use AND operators to combine them.
  • You can write up to 15 condition statement lines.
  The table below shows the formats of the comparison conditions you can use.
  

  Table 4-34 Formats of comparison conditions

  Comparison condition	Explanation
  A=X	The value of the item A is equal to the condition value X.
  A<X	The value of the item A is less than the condition value X.
  A>X	The value of the item A is greater than the condition value X.
  A<=X	The value of the item A is less than or equal to the condition value X.
  A>=X	The value of the item A is greater than or equal to the condition value X.
  A<>X	The value of the item A is not the condition value X.
  A: X1-X2	The value of the item A is within the range of the condition values X1 to X2.
  A: X1, X2, ... Xn	The value of the item A is any of the condition values X1, X2, ... and Xn.
  A=[*]X*	The value of the item A includes the character string X. An asterisk (*) stands for an indefinite number of characters. A question mark (?) stands for a single character (1 byte). Examples: dmp60?: Information such as dmp600, dmp601, and dmp602 is output. dmp?00: Information such as dmp100, dmp300, and dmp600 is output. dmp60*: Information such as dmp600, dmp6000, and dmp60000 is output.
  A<>X1-X2	The value of the item A is not within the range from the condition values X1 to X2.
  A<>X1, X2, ... Xn	The value of the item A is not any of the condition values X1, X2, ... and Xn.
  A<>[*]X*	The value of the item A does not include the character string X. An asterisk (*) stands for an indefinite number of characters. A question mark (?) stands for a single character (1 byte). <>dmp60?: Information other than strings such as dmp600, dmp601, and dmp602 is output. <>dmp60*: Information other than strings such as dmp600, dmp6000, and dmp60000 is output.

  Notes
  
  • The value A in the comparison condition indicates an item used as a key for extracting information. For the items that can be specified in the condition parameter, see Tables 4-35 to 4-44.
  • If a required entry is missing or there is a conflict in the condition expression, the program returns a syntax error and outputs an error message to the event log.
  • You can place 0 or more spaces between a value and an operator (=, >, etc.).
  • You can use wildcards only when the comparison condition is in an A =[*]X* or A <>[*]X* format.
  • If you want to use an asterisk (*) as a wildcard in a condition expression, always append a semicolon (;) to the expression. You can write a comment after the semicolon. If you do not append a semicolon, the program skips the portion after an asterisk, assuming the portion to be a comment.
  • If you want to use =, <, >, :, -, AND, or OR as a character string in a condition expression, prefix a backslash (\) to them.
    For example, if you want to use a host with the name AND as a condition, specify:
    host=\AND
    
  The items that can be specified in the condition expression of a condition parameter differ depending on the export file format (the CSV format or parameter file format). If you use an item that cannot be used as a comparison condition, an error occurs and a return code 2 is returned.
  Tables 4-35 to 4-40 list the items you can specify in the condition parameter when exporting information to a file in CSV format.
  

  Table 4-35 Items that can be specified in the condition parameter with the SYS_INFO (system information) template when exporting to a file in CSV format

  Item	Explanation	Setting the values and conditions
  host	Host name	Inclusion of , or > causes a syntax error.
  ipaddr	IP address (key value in the system configuration)	Inclusion of , or > causes a syntax error. The number of periods is not checked.
  hid	Host ID	Inclusion of , or > causes a syntax error.
  cpu	CPU type#1	Use a code consisting of numbers only. You can use the following comparison condition formats: A=X, A<>X, A:X1,X2,... Xn, and A<>X1,X2, ... Xn.
  ram	Installed RAM	Use only a number in megabytes without including the unit. You cannot include * or ? in the condition. If you use * or ?, an error occurs.
  memslot	Memory slot capacity	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  freephymem	Available physical memory	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  totalvirmem	Total capacity of virtual memory	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  freevirmem	Available virtual memory	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  pagefile	Page file capacity	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  mtype	Workstation type	Inclusion of , or > causes a syntax error.
  cpuspeed	CPU clock speed	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  extclock	Clock speed of external CPU	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  processor	Number of processors	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  maker	Maker name	Inclusion of , or > causes a syntax error.
  model	Model	Inclusion of , or > causes a syntax error.
  muuid	Machine UUID	Inclusion of , or > causes a syntax error.
  msernum	Machine serial number	Inclusion of , or > causes a syntax error.
  biosmaker	BIOS manufacturer	Inclusion of , or > causes a syntax error.
  biosver	BIOS version	Inclusion of , or > causes a syntax error.
  smbiosver	BIOS version (SMBIOS)	Inclusion of , or > causes a syntax error.
  amtfmvr	AMT firmware version	Inclusion of , or > causes a syntax error.
  pribus	Type of primary bus	Inclusion of , or > causes a syntax error.
  secbus	Type of secondary bus	Inclusion of , or > causes a syntax error.
  os	OS type#1	Use a code consisting of numbers only. You can use the following comparison condition formats: A=X, A<>X, A:X1,X2,... Xn, and A<>X1,X2,... Xn.
  distribution	Linux distribution name	Inclusion of , or > causes a syntax error.
  osv	OS version	Inclusion of , or > causes a syntax error.
  ossernum	OS serial number	Inclusion of , or > causes a syntax error.
  bootdev	Boot device	Inclusion of , or > causes a syntax error.
  windir	Windows directory	Inclusion of , or > causes a syntax error.
  sysdir	System directory	Inclusion of , or > causes a syntax error.
  wmi	WMI	Inclusion of , or > causes a syntax error.
  wininst	Windows Installer	Inclusion of , or > causes a syntax error.
  mbsa	MBSA	Inclusion of , or > causes a syntax error.
  wua	Windows Update Agent	Inclusion of , or > causes a syntax error.
  ie	Internet Explorer version	Inclusion of , or > causes a syntax error.
  iepatch	IE patch	Inclusion of , or > causes a syntax error.
  domain_wrkgrp	Domain Work group	Inclusion of , or > causes a syntax error.
  domain	Domain type#1	Use a code consisting of numbers only. You can use the following comparison condition formats: A=X, A<>X, A:X1,X2,... Xn, and A<>X1,X2,... Xn.
  owner	Owner	Inclusion of , or > causes a syntax error.
  org	Company name	Inclusion of , or > causes a syntax error.
  pcname	Computer name	Inclusion of , or > causes a syntax error.
  comdesc	Computer description	Inclusion of , or > causes a syntax error.
  logonname	Logon user name	Inclusion of , or > causes a syntax error.
  username	Full name of user	Inclusion of , or > causes a syntax error.
  userdesc	User description	Inclusion of , or > causes a syntax error.
  client	Client#1	Use a code indicating a client. You can use the following comparison condition formats: A=X, A<>X, A:X1,X2,... Xn, A<>X1,X2,... Xn.
  clientv	Client version	Inclusion of , or > causes a syntax error.
  device	Device name	Inclusion of , or > causes a syntax error.
  freedisk	Free space	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  dcapa	Partition size	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  hdmodel	Model of hard disk	Inclusion of , or > causes a syntax error.
  hdesize	Hard disk capacity	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  hdinterface	Hard disk interface	Inclusion of , or > causes a syntax error.
  hdpartition	Number of hard disk partitions	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  cdrom	CD-ROM drive	Inclusion of , or > causes a syntax error.
  umem	Available user memory size	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  sysres	Available system memory size	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  usp	UNIX special file#2	Inclusion of , or > causes a syntax error.
  umt	UNIX mount path#2	Inclusion of , or > causes a syntax error.
  keyboard	Keyboard	Inclusion of , or > causes a syntax error.
  mouse	Mouse	Inclusion of , or > causes a syntax error.
  mousenum	Number of mouse buttons	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  monitor	Monitor type	Inclusion of , or > causes a syntax error.
  vdriver	Video driver	Inclusion of , or > causes a syntax error.
  vchip	Video chip	Inclusion of , or > causes a syntax error.
  vram	VRAM	Use only a number in megabytes without including the unit. Inclusion of * or ? causes a syntax error.
  display	Display	Inclusion of , or > causes a syntax error.
  soundmaker	Sound card manufacturer	Inclusion of , or > causes a syntax error.
  soundname	Sound card product name	Inclusion of , or > causes a syntax error.
  macaddr	MAC address	No limit; the number of spaces is not checked.
  nwkad	Network adapter	Inclusion of , or > causes a syntax error.
  defra	Default router address	Inclusion of , or > causes a syntax error.
  subnet	Subnet mask	Inclusion of , or > causes a syntax error.
  ipaddr_inv	IP address (inventory information)	Inclusion of , or > causes a syntax error.
  pridns	Primary DNS server address	Inclusion of , or > causes a syntax error.
  secdns	Secondary DNS server address	Inclusion of , or > causes a syntax error.
  dhcp	DHCP	Specify either of the following codes: 0: Invalid 1: Valid
  dhcpsrv	DHCP server address	Inclusion of , or > causes a syntax error.
  wins	WINS server address	Inclusion of , or > causes a syntax error.
  prtname	Printer name	Inclusion of , or > causes a syntax error.
  prtdrv	Printer driver	Inclusion of , or > causes a syntax error.
  prtpaper	Printer sheet size	Inclusion of , or > causes a syntax error.
  prtkind	Printer ID	Inclusion of , or > causes a syntax error.
  prtshare	Shared name of printer	Inclusion of , or > causes a syntax error.
  prtserver	Printer server name	Inclusion of , or > causes a syntax error.
  prtport	Printer port	Inclusion of , or > causes a syntax error.
  guestaccount	Guest account	Specify one of the following codes: 0: Disabled 1: Enabled 2: No guest account
  weakpasswod	Weak password	Inclusion of , or > causes a syntax error. Specify @None to indicate no weak password as a condition.
  account	Account	Inclusion of , or > causes a syntax error.
  dayupdpass	Elapsed days since a password modification	Specify numeric characters only (unit: days). You do not need to enter the unit. Inclusion of * or ? causes a syntax error.
  indefinitepass	Non-expiring password	Inclusion of , or > causes a syntax error. Specify @None to indicate a non-expiring password as a condition.
  autologon	Autologon setting	Specify either of the following codes: 0: Not present 1: Present
  sharedfolder	Shared folder	Specify either of the following codes: 0: Not present 1: Present
  anonymousrefer	Anonymous connection	Specify either of the following codes: 0: Enabled (anonymous connections are restricted) 1: Disabled (anonymous connections are not restricted)
  screensaver	Screensaver	Specify either of the following codes: 0: Disabled 1: Enabled
  scrpassword	Screensaver password protection function	Specify either of the following codes: 0: Disabled 1: Enabled
  poweronpass	Power on password	Specify one of the following codes: 0: Setting is not present 1: Setting is present 2: Not implemented 3: Unknown
  winfirewall	Windows Firewall settings	Specify one of the following codes: 0: Disabled 1: Enabled (exceptions allowed) 2: Enabled (exceptions not allowed)
  winautoupdate	Windows Automatic Updates	Specify either of the following codes: 0: Disabled 1: Enabled
  needlesssrv	Unnecessary service	Specify either of the following codes: 0: Not present 1: Present
  harddiskencryption	Hard disk encryption information	Specify either of the following codes: 0: None 1: Partial 2: All
  turnoffmonitor_ac	Turn off monitor (AC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.
  turnoffmonitor_dc	Turn off monitor (DC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.
  procsthrottle_ac	Processor throttle (AC)	Specify one of the following codes: NONE: None ADAPTIVE: Adaptive DEGRADE: Degrade CONSTANT: Constant N/A: Unknown
  procsthrottle_dc	Processor throttle (DC)	Specify one of the following codes: NONE: None ADAPTIVE: Adaptive DEGRADE: Degrade CONSTANT: Constant N/A: Unknown
  turnoffharddisks_ac	Turn off hard disk (AC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.
  turnoffharddisks_dc	Turn off hard disk (DC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.
  standby_sleep_ac	System standby/sleep (AC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.
  standby_sleep_dc	System standby/sleep (DC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.
  systemhibernate_ac	System in hibernate status (AC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.
  systemhibernate_dc	System in hibernate status (DC)	Specify numeric characters only (unit: seconds). You do not need to enter the unit. Specification of a condition that includes * or ? is not allowed; if specified, an error results.

  #1

  For a list of the codes that can be specified, see the dm_systeminf value of each item in C.23 netmdm_inventry in the manual Description and Planning Guide. For client items, see the values of dm_exkind in the client version (0x21). When specifying NETM/DM/P as a condition, specify a 0 instead of a space.

  #2

  The template does not include this item but you cannot specify this item in the condition parameter.

  
  

  Table 4-36 Items that can be specified in the condition parameter with the INSTLD_PKG (installed package information) template when exporting to a file in CSV format

  Item	Explanation	Setting the values and conditions
  host	Host name	Inclusion of , or > causes a syntax error.
  ipaddr	IP address	Inclusion of , or > causes a syntax error. The number of periods is not checked.
  hid	Host ID	Inclusion of , or > causes a syntax error.
  pname	Package name	Inclusion of , or > causes a syntax error.
  pid	Package ID	Inclusion of , or > causes a syntax error.
  newver	New version	Inclusion of , or > causes a syntax error.
  newgen	New generation	Inclusion of , or > causes a syntax error.
  oldver	Old version	Inclusion of , or > causes a syntax error.
  oldgen	Old generation	Inclusion of , or > causes a syntax error.
  date	Installation or software search date/time	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#

#

In YYYY (year), specify a value in the range from 1970 to 2038. If you do not specify a value within this range, an error occurs and the return code 2 is returned. You can omit the portions other than YYYY. The omitted portions are set to their minimum values. If you specify a single-digit value, prefix a 0 to align the digits. If you do not align the digits, an error occurs. The following examples show you how to use date representation correctly:

200

Error

2004

0:00 on January 1, 2004

2003101

Error

20031010

0:00 on October 10, 2003

200401010101

1:01 on January 1, 2004

200312312359

23:59 on December 31, 2003

If you use a date/time representation in the following comparison conditions, an error occurs: A=X, A<>X, A:X1,X2,... Xn, A=[*]X*, A<>X1,X2,... Xn, or A<>[*]X*.

Table 4-37 Items that can be specified in the condition parameter with the J_STAT (job status) template when exporting to a file in CSV format

Item	Explanation	Setting the values and conditions
jname	Job name	Inclusion of , or > causes a syntax error.
execdate	Execution date/time at the server	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
execsch	Scheduled execution date/time at the server	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
sduedate	Execution time limit at the server	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
sregdate	Scheduled registration date/time at the server.	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
dstname	Job destination name	Inclusion of , or > causes a syntax error. Use ! or \ for hierarchical representation.
dexecdate	ob execution date/time by destination	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
pname	Package name	Inclusion of , or > causes a syntax error.
pid	Package ID	Inclusion of , or > causes a syntax error.
cabid	Cabinet ID	Inclusion of , or > causes a syntax error.
pver	Version	Inclusion of , or > causes a syntax error.
pgen	Generation	Inclusion of , or > causes a syntax error.
status	Status	You can specify the first 1 to 6 characters of the maintenance code for Remote Installation Manager. You can use * or ? in the condition. If you include , or >, a syntax error occurs. The following comparison conditions cannot be specified: A:X1-X2, A:X1,X2,... Xn, A<>X1-X2, and A<>X1,X2,... Xn.

#

For details about how to represent the date/time and examples of date/time representation, see Table 4-36.

Table 4-38 Items that can be specified in the condition parameter during output to a CSV-formatted file (VIRUS (anti-virus product) template)

Item	Explanation	Setting the values and conditions
host	Host name	Inclusion of , or > causes a syntax error.
ipaddr	IP address	Inclusion of , or > causes a syntax error. The number of periods is not checked.
hid	Host ID	Inclusion of , or > causes a syntax error.
sname	Software name	Inclusion of , or > causes a syntax error.
sver	Software version	Inclusion of , or > causes a syntax error.
org	Company name	Inclusion of , or > causes a syntax error.
lang	Language	Specify a numeric-only code. Comparison conditions can be specified in the following formats: A=X, A<>X, A:X1, X2, ... Xn, and A<>X1, X2, ... Xn.
path	Path	Inclusion of , or > causes a syntax error.
size	Size	Specify size in numeric only (in bytes). The unit is not required. A condition containing * or ? cannot be coded; if specified, such a code can cause an error.
sdate	Search date/time	Specify year, month, day, hour, minute in the YYYYMMDDhhmm format, using numeric only.#1
idate	Installation date	Specify year, month, day in the YYYYMMDD format, using numeric only.#2
regorg	Registered company name	Inclusion of , or > causes a syntax error.
reguser	Name of registered owner	Inclusion of, or > causes a syntax error.
virusver	Virus detection engine version	Inclusion of , or > causes a syntax error.
vfilever	Virus detection file version	Inclusion of , or > causes a syntax error.
vstation	Virus detection resident/non-resident	Specify in the following code: 0: non-resident 1: resident

#1

For details about how to represent the date/time and examples of date/time representation, see Table 4-36.

#2

The date format to be used is YYYYMMDD. Although dates require the same specification method as the YYYYMMDDhhmm format, entering hh and mm parts can cause an error. For details about how to represent the date/time, see Table 4-36.

Table 4-39 Items that can be specified in the condition parameter during output to a CSV-formatted file (NO_CLIENT (information on a host on which JP1/Software Distribution is not installed) template)

Item	Explanation	Setting the values and conditions
ipaddr	IP address	Inclusion of , or > causes a syntax error. The number of periods is not checked.
type	Node type#1	Specify a numeric-only code. Comparison conditions can be specified in the following formats: A=X, A<>X, A:X1, X2, ... Xn, and A<>X1, X2, ... Xn.
host	Node name	Inclusion of , or > causes a syntax error.
macaddr	MAC address	No limit; the number of spaces is not checked.
subnet	Subnet mask	Inclusion of , or > causes a syntax error.
netaddr	Network address	Inclusion of , or > causes a syntax error. The number of periods is not checked.
datetime	Detection date/time	Specify year, month, day, hour, minute in the YYYYMMDDhhmm format, using numeric only.#2
lastupdate	Explanation	Specify year, month, day, hour, minute in the YYYYMMDDhhmm format, using numeric only.#2
cmnt	Comment on node	Inclusion of, or > causes a syntax error.

#1

For details about the codes that can be specified, see the dm_nodetype values in C.18 netmdm_host_withoutdm in the manual Description and Planning Guide.

#2

For details about how to represent the date/time and examples of date/time representation, see Table 4-36.

Table 4-40 Items that can be specified in the condition parameter during output to a CSV-formatted file (DISCOVERY_INFO (host search results) template)

Item	Explanation	Setting the values and conditions
ipaddr	IP address	Inclusion of , or > causes a syntax error. The number of periods is not checked.
type	Node ID#1	Specify a numeric-only code. Comparison conditions can be specified in the following formats: A=X, A<>X, A:X1, X2, ... Xn, and A<>X1, X2, ... Xn.
host	Node name	Inclusion of , or > causes a syntax error.
macaddr	MAC address	No limit; the number of spaces is not checked.
subnet	Subnet mask	Inclusion of , or > causes a syntax error.
netaddr	Network address	Inclusion of , or > causes a syntax error. The number of periods is not checked.
lastupdate	Last update date/time	Specify year, month, day, hour, minute in the YYYYMMDDhhmm format, using numeric only.#2
cmnt	Comment on node	Inclusion of, or > causes a syntax error.

#1

For details about the codes that can be specified, see the dm_nodetype values in C.12 netmdm_discovery_info in the manual Description and Planning Guide.

#2

For details about how to represent the date/time and examples of date/time representation, see Table 4-36.

Tables 4-41 to 4-44 list the items you can specify in the condition expression of a condition parameter when exporting to a file in the parameter file format. Unlike when the CSV output utility is used, when you use a command to output a file in parameter file format, you can use the Host attributes and Package attributes template to narrow the conditions.

Table 4-41 Items that can be specified in the condition parameter with the HOST_ATTR (host attribute) template when exporting to a file in the parameter file format

Item	Explanation	Setting the values and conditions
host	Host name	Inclusion of , or > causes a syntax error.
ipaddr	IP address	Inclusion of , or > causes a syntax error. The number of periods is not checked.
cmnt	Comment	Inclusion of , or > causes a syntax error.
cdate	Creation date/time	Use only numbers to represent the date/time in the YYYYMMDDhhmm format.#
date	Update date/time	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
pkgupdate	Installed package information last update date	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
syupdate	System information last update date	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
uupdate	User inventory information last update date	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
rupdate	Registry information last update date	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
sfupdate	Software inventory information last update date	Use only numbers to represent the date/time in the YYYYMMDDhhmm format.#

#

For details about how to represent the date/time and examples of date/time representation, see Table 4-36.

Table 4-42 Items that can be specified in the condition parameter with the PKG_INFO (package attribute) template when exporting to a file in the parameter file format

Item	Explanation	Setting the values and conditions
pname	Package name	Inclusion of , or > causes a syntax error.
pid	Package ID	Inclusion of , or > causes a syntax error.
cabid	Cabinet ID	Inclusion of , or > causes a syntax error.
dmcode	DM ID code	Specify PC or WS. Any other specification causes an error.
pver	Version	Inclusion of , or > causes a syntax error.
pgen	Generation	Inclusion of , or > causes a syntax error.
cabname	Cabinet name	Inclusion of , or > causes a syntax error.

#

The template does not include this item, but it can be specified in the condition parameter.

Table 4-43 Items that can be specified in the condition parameter with the INSTLD_PKG (installed package information) template when exporting to a file in the parameter file format

Item	Explanation	Setting the values and conditions
host	Name of the host where the package is installed	Inclusion of , or > causes a syntax error.
ipaddr	IP address of the host where the package is installed	Inclusion of , or > causes a syntax error. The number of periods is not checked.
pname	Package name	Inclusion of , or > causes a syntax error.
pid	Package ID	Inclusion of , or > causes a syntax error.
install	Installation	Inclusion of , or > causes a syntax error.
newver	New version	Inclusion of , or > causes a syntax error.
newgen	New generation	Inclusion of , or > causes a syntax error.
oldver	Old version	Inclusion of , or > causes a syntax error.
oldgen	Old generation	Inclusion of , or > causes a syntax error.
date	Installation or software search date/time	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#

#

For details about how to represent the date/time and examples of date/time representation, see Table 4-36.

Table 4-44 Items that can be specified in the condition parameter with the J_STAT (job status) template when exporting to a file in the parameter file format

Item	Explanation	Setting the values and conditions
folder	Folder name	Inclusion of , or > causes a syntax error.
jname	Job name	Inclusion of , or > causes a syntax error.
jattr	Job attribute	Inclusion of , or > causes a syntax error.
execdate	Execution date/time at the server	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
execsch	Scheduled execution date/time at the server	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
sduedate	Execution time limit at the server	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
sregdate	Scheduled registration date/time at the server	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
dstname	Job destination name	There are no restrictions. Use ! or \ for hierarchical representation.
jtype	Job type	Inclusion of , or > causes a syntax error.
dexecdate	Job execution date/time by destination	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
pname	Package name	Inclusion of , or > causes a syntax error.
pid	Package ID	Inclusion of , or > causes a syntax error.
cabid	Cabinet ID	Inclusion of , or > causes a syntax error.
dmcode	DM ID code	Specify PC or WS. Any other specification causes an error.
pver	Version	Inclusion of , or > causes a syntax error.
pgen	Generation	Inclusion of , or > causes a syntax error.
cexecdate	Installation date/time at the client	Use numbers only to represent the date/time in the YYYYMMDDhhmm format.#
result	Result	Inclusion of , or > causes a syntax error.
status	Status	You can specify the first 1 to 6 characters of the maintenance code for Remote Installation Manager. You can use * or ? in the condition. If you include , or >, a syntax error occurs. The following comparison conditions cannot be specified: A:X1-X2, A:X1,X2,... Xn, A<>X1-X2, and A<>X1,X2,... Xn

#

For details about how to represent the date/time and examples of date/time representation, see Table 4-36.

• unicode=Y-or-N-indicating-whether-a-CSV-file-in-Unicode-is-to-be-output

Specify Y or N to indicate whether a CSV file in Unicode is to be output.

Y

Outputs a CSV file in Unicode. Note that only UTF-8 encoding is supported for output of CSV files in Unicode.

This parameter is effective only when the following conditions are satisfied:

JP1/Software Distribution Manager is used for command execution

The following relational database is used in JP1/Software Distribution:

Microsoft SQL Server 2005 or later

One of the following output templates is specified:

System information

Installed package information

Registry collection item

Microsoft Office products

Anti-Virus products

If you have specified par in the format parameter, Y is ignored, if specified.

N

Outputs a CSV file that has not been converted to Unicode.

Note that an error results if you make the specification for output of a CSV file in Unicode both as a command argument and in the parameter file. If you omit this specification from both the command argument and the parameter file, the registry setting for output of CSV files in Unicode becomes effective. For details about the registry setting, see 4.6 Registry settings (JP1/Software Distribution Manager) in the manual Setup Guide.

When a CSV file is output in Unicode, the conversion rules are applied. The conversion rules are the same as for the CSV output utility. For details, see 9.1.4 Conversion rules for outputting CSV files in Unicode in the manual Administrator's Guide Volume 1.

If the number of specified comparison conditions or groups to which the targets belongs increases, an RDB access error might occur depending on the limitations of DBMS. In case of the error, reduce the number of them.

For your reference, see the following sample maximum values of "Host name" conditions that can be specified.

DBMS type	Version	Maximum value of "Host name" conditions that can be specified
Embedded RDB	08-51#	255
Microsoft SQL Server	7.0	2,041
Oracle	9i	1,000

#

Version of Job Management Partner 1/Software Distribution Manager