The patch list CSV file can be downloaded from the following window of the management console.
The patch list window of the management console
The application status of all patches is output. By outputting the information to a CSV file, it is possible to collate servers where patches have been applied and servers where patches have not been applied.
Clicking the Download CSV file button displays the window to select the storage destination of a CSV file where the list information for each window can be saved.
File Name
The name of the CSV file will have the following format:
patch_list_<Patch type>_date.csv |
File Location
Any folder |
Character Encoding for the CSV File
The CSV file will be output using the character encoding for the operating system on the admin server.
CSV Output Format
The following information is output.
Item No. | Item name | Maximum length (bytes) | Value format | Remarks |
|---|---|---|---|---|
1 | Patch ID | 16 | Text | This item indicates the patch ID of the OS patch. |
2 | Class | 16 | Text | This item indicates the classification level of the OS patch. |
3 | Patch type | 32 | Text | This item indicates the patch type (the class of WSUS update program). |
4 | Product name | 256 | Text | This item indicates the product name. |
5 | Release date | 10 | Text | This item indicates the release date of the OS patch. This item is not output for middleware patches. |
6 | Overview | 256 | Text | This item indicates an overview (title) of the patch. |
7 | Server name | 256 | Text | This item indicates the server name. |
8 | Application status | 16 | Text | This item indicates the application status.
|
9 | L-Platform name | 256 | Text | This item indicates the L-Platform name. |
10 | Tenant name | 64 | Text | This item indicates the tenant name. |
11 | IP address | 15 | Text | This item indicates the IP address. |
12 | Host name | 256 | Text | This item indicates the host name. |
13 | User ID | 64 | Text | This item indicates the user ID of the contact user. |
Item No. | Item name | Maximum length (bytes) | Value format | Remarks |
|---|---|---|---|---|
1 | Package name | 64 | Text | This item indicates the package name. |
2 | Version | 32 | Text | This item indicates the version of the package. |
3 | Release | 32 | Text | This item indicates the release number of the package. |
4 | Architecture | 16 | Text | This item indicates the architecture for the package. |
5 | Release date | 10 | Text | This item indicates the date when the package information was registered with Systemwalker Software Configuration Manager. |
6 | Overview | 256 | Text | This item indicates an overview (summary) of the package. |
7 | Server name | 256 | Text | This item indicates the server name. |
8 | Application status | 16 | Text | This item indicates the application status.
|
9 | L-Platform name | 256 | Text | This item indicates the L-Platform name. |
10 | Tenant name | 64 | Text | This item indicates the tenant name. |
11 | IP address | 15 | Text | This item indicates the IP address. |
12 | Host name | 256 | Text | This item indicates the host name. |
13 | User ID | 64 | Text | This item indicates the user ID of the contact user. |
Item No. | Item name | Maximum length (bytes) | Value format | Remarks |
|---|---|---|---|---|
1 | Patch ID | 16 | Text | This item indicates the patch ID. |
2 | Class | 16 | Text | This item outputs the classification level for the Fujitsu middleware patch. |
3 | Importance | 32 | Text | This item indicates the importance level of the patch.
|
4 | Update type | 16 | Text | This item indicates the update type of the patch.
|
5 | Product name | 256 | Text | This item indicates the product name. |
6 | OS | 16 | Text | This item indicates the operating system (platform). |
7 | Update title | 256 | Text | This item indicates a summary (title) of the patch. |
8 | Release date | 10 | Text | This item indicates the date when the package information was registered with Systemwalker Software Configuration Manager. |
9 | Server name | 256 | Text | This item indicates the server name. |
10 | Application status | 16 | Text | This item indicates the application status.
|
11 | L-Platform name | 256 | Text | This item indicates the L-Platform name. |
12 | Tenant name | 64 | Text | This item indicates the tenant name. |
13 | IP address | 15 | Text | This item indicates the IP address. |
14 | Host name | 256 | Text | This item indicates the host name. |
15 | User ID | 64 | Text | This item indicates the user ID of the contact user. |
Output Examples
Windows patches
Patch ID,Class,Patch type,Product name,Release date,Overview,Server name,Application status,L-Platform name,Tenant name,IP address,Host name,User ID KB2618451,Required,Security Updates,Windows Server 2008 R2,2011-12-14,Cumulative security update program for ActiveX Killbits for Windows Server 2008 R2 x64 Edition (KB2618451),kaihatu3_db(VR7NYBNV6W0001),Not applied,Development Department III,Kobe Office (KOBE),192.168.99.7,VR7NYBNV6W0001,smith_jane KB2618451,Required,Security Updates,Windows Server 2008 R2,2011-12-14,Cumulative security update program for ActiveX Killbits for Windows Server 2008 R2 x64 Edition (KB2618451),kaihatsu2_db(V3JZAPW36Y0001),Not applied,Development Department II,Kobe Office (KOBE),192.168.99.5,V3JZAPW36Y0001,smith_jane KB2618444,Required,Security Updates,Windows Server 2008 R2,2011-12-14,Cumulative security update program for Internet Explorer 8 for Windows Server 2008 R2 x64 Edition (KB2618444),kaihatsu1_ap(VHXDO1JI7D0001),Applied,Development Department I,Tokyo Head Office(TOKYO),192.168.99.4,VHXDO1JI7D0001,smith_john KB2618444,Required,Security Updates,Windows Server 2008 R2,2011-12-14,Cumulative security update program for Internet Explorer 8 for Windows Server 2008 R2 x64 Edition (KB2618444),eigyo2_web(VIYEP46HB80001),Not applied,Sales Department II,Tokyo Head Office(TOKYO),192.168.99.3,VIYEP46HB80001,smith_john KB2607047,Recommended,Updates,Windows Server 2008 R2,2011-12-14,Update program for Windows Server 2008 R2 x64 Edition(KB2607047),kanri_web(VGWCN21KMH0001),Applied,Admin Department,Tokyo Head Office(TOKYO),192.168.99.18,VGWCN21KMH0001,smith_john KB2607047,Recommended,Updates,Windows Server 2008 R2,2011-12-14,Update program for Windows Server 2008 R2 x64 Edition (KB2607047),keiri_db(VZFV6IMIMW0001),Not applied,Accounting Department,Tokyo Head Office(TOKYO),192.168.99.11,VZFV6IMIMW0001,smith_john KB2641690,Required,Critical Updates,Windows Server 2008 R2,2011-11-11,Update program for Windows Server 2008 R2 x64 Edition (KB2641690),kanri_web(VGWCN21KMH0001),Applied,Admin Department,Tokyo Head Office(TOKYO),192.168.99.18,VGWCN21KMH0001,smith_john KB2641690,Required,Critical Updates,Windows Server 2008 R2,2011-11-11,Update program for Windows Server 2008 R2 x64 Edition (KB2641690),keiri_db(VZFV6IMIMW0001),Applied,Accounting Department,Tokyo Head Office (TOKYO),192.168.99.11,VZFV6IMIMW0001,smith_john
Linux patches
Package name,Version,Release,Architecture,Release date,Overview,Server name,Application status,L-Platform name,Tenant name,IP address,Host Name,User ID glibc,2.12,1.47.el6_2.56,x86_64,2011-12-06,GNU libc library,kaihatu3_db(VR7NYBNV6W0001),Not applied,Development Department III,Kobe Office(KOBE),192.168.99.7,VR7NYBNV6W0001,smith_jane glibc-common,2.12,1.47.el6_2.5,x86_64,2011-12-06,generic binary for glibc,locale data,kaihatu3_db(VR7NYBNV6W0001),Not applied,Development Department III,Kobe Office (KOBE),192.168.99.7,VR7NYBNV6W0001,smith_jane nscd,2.12,1.47.el6_2.5,x86_64,2011-12-06,Naming service caching daemon(nscd),kaihatu3_db(VR7NYBNV6W0001),Not applied,Development Department III,Kobe Office(KOBE),192.168.99.7,VR7NYBNV6W0001,smith_jane
Fujitsu middleware patches
Patch ID,Importance,Update type,Product name,OS,Update title,Release date,Server name,Application status,L-Platform name,Tenant name,IP address,Host name,User ID T004726WP-01,Security,Urgent,Interstage Application Server Enterprise Edition,Windows,2010/11/11,Interstage HTTP Server security patch,2010-11-11,kaihatu3_db(VR7NYBNV6W0001),Applied,Development Department III,Kobe Office,192.168.99.7,VR7NYBNV6W0001,smith_jane T004726WP-03,Security,Urgent,Interstage Application Server Enterprise Edition,Windows,2011/12/20,Interstage HTTP Server security patch,2011-12-20,kaihatu3_db(VR7NYBNV6W0001),Not applied,Development Department III,Kobe Office(KOBE),192.168.99.7,VR7NYBNV6W0001,smith_jane T004726WP-03,Security,Urgent,Interstage Application Server Enterprise Edition,Windows,2011/12/20,Interstage HTTP Server security patch,2011-12-20,kaihatu3_db(VR7NYBNV6W0001),Not applied,Sales Department II,Tokyo Head Office(TOKYO),192.168.99.3,VIYEP46HB80001,smith_john T005158WP-02,Recommended,Urgent,Interstage Application Server Enterprise Edition,Windows,2011/12/20,Update patch for Interstage J2EE Common Resource,2011-12-20,kaihatu3_db(VR7NYBNV6W0001),Not applied,Development Department III,Kobe Office(KOBE),192.168.99.7,VR7NYBNV6W0001,smith_jane
