The CSV output utility provides templates for output of information. The following table lists the templates and the items that can be output to a CSV file.

Table 9-1 Items eligible for output to a CSV file

Template name	Output item
Host attributes	Host name, IP address, Host ID, MAC address, Type, Route, Member of#1, Hold report, Suspend file transfer#2, Comment, Registration date/time#3, Creation date/time#4, Update date/time#4, Installed package information last update date#4, System information last update date#4, User inventory information last update date#4, Registry information last update date#4, Software inventory information last update date#4, Final update date/time of software operation information#4, Applied software operation monitoring policy#5
Host group attributes#3	Group name, Member of
ID group attributes#3	ID name, Relay managing the ID
Package attributes	Cabinet name, Cabinet ID, Package name, Package ID, Version, Generation, Package size, Transfer package size, Packaging date, Expiration date, Package type, Installation mode, Package compression, Restoration, Specify restart, Display processing message
Package contents	Cabinet name, Cabinet ID, Package name, Package ID, Version, Generation, File name, Size, Update date
System information#6	For details about the output items, see 2.2.1 Acquiring system information in the manual Description and Planning Guide. The differences between the available system information and the information output in CSV format are as follows: You can output the following items: Host name, IP address (key item in the system configuration), Host ID, and BitLocker You cannot output the following item: Name of OS family If you select Disk details for the output items, the following information is output for each drive: Logical drive name, Drives (Device name), Free space (Free hard disk space), and Partition size If you select Disk details and then select File system for the output items, the File system is also output as detailed disk information. If you select Total sizes for the output items, the following information is output as a total for all drives: Total free space and Total size of partitions
User inventory information	Host name, IP address, Host ID, User inventory information
Installed package information#6, #7	Host name, IP address, Host ID, Package name, Package ID, Installation, New version, New generation, Previous version, Previous generation, Installation or search date/time
Job status#8	Folder name, Job name, Job attribute, Execution date/time at the server, Scheduled execution date/time at the server, Execution time limit at the server, Scheduled registration date/time at the server, Job destination name, Job type, Job execution date/time by destination, Package name, Package ID, Cabinet ID, DM ID code, Version, Generation, Installation date/time at the client, Restoration,#3 Result, Status
Registry collection item#6	Host name, IP address, Host ID, Registry collection item, Attributes, Data, Registry path
User information#4	System information,#9 User inventory information, Directory information
Software inventory#4	Host name, IP address, Host ID, Software name, Software version, Organization, Language, Path, File name, File version, Size, Update date, Search date, Description, Update date/time (UTC)#10
License information#4, #11	Software name, Software version, Count, Number of owned licenses, Number of licenses for warning
Microsoft Office products#4, #6	Host name, IP address, Host ID, Software name, Software version, Company name, Language, Path, Size, Search date, Installation date, Product ID, Registered company name, Registered owner name, Software indicator ID
Anti-Virus products#4, #6	Host name, IP address, Host ID, Software name, Software version, Company name, Language, Path, Size, Search date, Installation date, Registered company name, Registered owner name, Virus detecting engine version, Virus definition file version, Virus detection resident/nonresident, Software indicator ID
Start suppression log	Time, Host name, IP address, Host ID, File name, File version, Language, Software name, Product version, Execute account, Logon user

#1

The names of the host group and ID groups to which the host belongs are output.

#2

This item is output only in JP1/Software Distribution Manager.

#3

This is an item that is output only in JP1/Software Distribution Client (relay system), or it is a template that can be used only in JP1/Software Distribution Client (relay system).

#4

This is an item that is output only in JP1/Software Distribution Manager, or it is a template that can be used only in JP1/Software Distribution Manager.

#5

This is an item that is output only in JP1/Software Distribution Manager, or it is a template that can be used only in JP1/Software Distribution Manager. This item is output automatically to Applied software operation monitoring policy version.

#6

This template can output CSV files in Unicode.

#7

For JP1/Software Distribution Manager, information about unapplied patches is also output. For unapplied patches, Unapplied is displayed in the Installation column.

#8

The following table shows the details of the job execution status.

Table 9-2 Additional job execution status items

Output item	Explanation
Job attribute	Folder, Host group job, ID group job, or All-lower-clients job is output.
Execution date/time at the server	The date and time when the job was executed at the managing server is output.
Scheduled execution date/time at the server	The date and time specified as Execution time in the Schedule page during job execution is output.
Execution time limit at the server	The date and time specified as Execution time limit on the Schedule page during job execution is output.
Scheduled registration date/time at the server	The date and time specified as Registration time on the Schedule page during job execution is output.
Job execution date/time by destination	The date and time when the managing server executed the job is output.
DM ID code	Whether the distributed package originates from a PC or workstation is output.
Installation date/time at the client	For a remote installation job, the installation date and time specified in the Schedule page during packaging or specified on the Package page during job execution are output. For an inventory information acquisition job, the client-side job execution date and time specified as Set the execution date/time in the Detailed Scheduling dialog box are output.
Restoration	When restoration is enabled during execution of a remote installation job, Yes is output.
Result	The execution status of the job is output. Now being deleted is not output.
Status	The maintenance code in the detailed information displayed by choosing Details in the Job Status window is output.

#9

The output system information excludes Logical drive name, Device name, Free space, Partition size, and File system.

#10

This date/time has been converted to the local time of the managing server that outputs the CSV file.

#11

** to the right of a software program means that its owned licenses are exceeded; * to the right of a software program means that its owned licenses are not exceeded but the number of licenses for warning has been exceeded.