{"id":2217,"date":"2015-06-05T16:26:08","date_gmt":"2015-06-05T07:26:08","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=2217"},"modified":"2020-11-19T13:51:41","modified_gmt":"2020-11-19T04:51:41","slug":"%e6%96%b0%e8%a6%8f%e3%82%ab%e3%82%b9%e3%82%bf%e3%83%a0%e3%83%ac%e3%83%9d%e3%83%bc%e3%83%88%e3%81%ab%e3%81%8a%e3%81%91%e3%82%8b%e6%97%a2%e7%9f%a5%e3%81%ae%e5%95%8f%e9%a1%8c","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=2217","title":{"rendered":"\u65b0\u898f\u30ab\u30b9\u30bf\u30e0\u30ec\u30dd\u30fc\u30c8\u306b\u304a\u3051\u308b\u65e2\u77e5\u306e\u554f\u984c"},"content":{"rendered":"<p><strong>\u3010\u30a8\u30e9\u30fc\u5185\u5bb9\u3011<\/strong><br \/>\n\u30ec\u30dd\u30fc\u30c8\u30bf\u30d6&gt;&gt;\u65b0\u898f\u30ab\u30b9\u30bf\u30e0\u30ec\u30dd\u30fc\u30c8\u3000\u306b\u304a\u3044\u3066\u3001\u30ab\u30b9\u30bf\u30e0\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u969b\u3001<br \/>\n\u4ee5\u4e0b\u306e\u624b\u9806\u3067\u4f5c\u6210\u3092\u884c\u3046\u3068\u3001\u30ec\u30dd\u30fc\u30c8\u304c\u51fa\u529b\u3055\u308c\u306a\u3044\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n<p>1.\u30e2\u30b8\u30e5\u30fc\u30eb\u9078\u629e\u306b\u304a\u3044\u3066\u3001\u300cCMDB\u300d&gt;&gt;\u300cwnidows server\u300d\u3092\u9078\u629e\u3057\u307e\u3059<br \/>\n\uff08\u30ec\u30dd\u30fc\u30c8\u30bf\u30a4\u30d7\u306f\u3069\u3061\u3089\u3067\u3082\u69cb\u3044\u307e\u305b\u3093\uff09<br \/>\n2.\u300c\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u30a6\u30a3\u30b6\u30fc\u30c9\u306b\u9032\u3080\u300d\u3092\u9078\u629e\u3057\u307e\u3059<br \/>\n3.\u300c\u30b9\u30c6\u30c3\u30d71:\u8868\u793a\u3059\u308b\u306e\u30ab\u30e9\u30e0\u3092\u9078\u629e\u300d\u306b\u304a\u3044\u3066\u3001\u8868\u793a\u3059\u308b\u30ab\u30e9\u30e0\u306b<br \/>\n\u300c\u30b5\u30fc\u30d3\u30b9\u30d1\u30c3\u30af\u300d\u3092\u542b\u3081\u307e\u3059<br \/>\n(\u305d\u306e\u4ed6\u306e\u30b9\u30c6\u30c3\u30d7\u306f\u3069\u306e\u3088\u3046\u306a\u8a2d\u5b9a\u3092\u3055\u308c\u3066\u3082\u69cb\u3044\u307e\u305b\u3093)<br \/>\n4.\u300c\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u300d\u306b\u9032\u307f\u307e\u3059<\/p>\n<p>\u4e0a\u8a18\u624b\u9806\u3067\u51fa\u529b\u3092\u884c\u3046\u3068\u3001<br \/>\n\u300cError executing SQL statement for : ManageEngine Report Framework \u300d<br \/>\n\u3068\u3044\u3046\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><strong>\u3010\u56de\u907f\u7b56\u3011<\/strong><br \/>\n\u3053\u3061\u3089\u306e\u56de\u907f\u7b56\u30fb\u624b\u9806\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<br \/>\n1. ServiceDesk Plus\u5185\u3067\u3001\u30ec\u30dd\u30fc\u30c8\u30bf\u30d6&gt;&gt;\u65b0\u898f\u30af\u30a8\u30ea\u30ec\u30dd\u30fc\u30c8 \u3068\u9032\u307f\u3001<br \/>\n\u4f5c\u6210\u753b\u9762\u3067\u3001\u4ee5\u4e0b\u306eSQL\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059<br \/>\nselect * from reportcolumndetails where column_name=' ' and display_name = 'sdp.inventory.detailWS.osServicePack';<br \/>\n2. \u4e0a\u8a18SQL\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3001\u300cColumn_id\u300d\u3092\u53d6\u5f97\u3057\u307e\u3059<br \/>\n3. \u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u958b\u304d\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u307e\u3059<br \/>\n\uff0a\u63a5\u7d9a\u65b9\u6cd5\u306f\u4ee5\u4e0b\u306e\u30ea\u30f3\u30af\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"TMKM3YZEl8\"><p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=389\">PostgreSQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u624b\u9806<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;PostgreSQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u624b\u9806&#8221; &#8212; ServiceDesk Plus \u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u7248 \u30ca\u30ec\u30c3\u30b8\u30d9\u30fc\u30b9\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=389&#038;embed=true#?secret=rY4JQxw8gq#?secret=TMKM3YZEl8\" data-secret=\"TMKM3YZEl8\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\n4. \u63a5\u7d9a\u3057\u305f\u5f8c\u306b\u3001\u4ee5\u4e0b\u306eSQL\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u307e\u3059<br \/>\nupdate reportcolumndetails set column_name = 'SERVICEPACK' where column_id = column_id;<br \/>\n\uff0a\u6700\u5f8c\u306e column_id\u306b\u306f\u624b\u9806\uff12\u3067\u53d6\u5f97\u3057\u305f\u300ccolumn_id\u300d\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<br \/>\n\uff08\u4f8b\uff09update reportcolumndetails set column_name = 'SERVICEPACK' where column_id = 1506;<br \/>\n5. \u4e0a\u8a18\u624b\u9806\u3092\u5b8c\u4e86\u3057\u305f\u3089\u3001ServiceDesk Plus\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059<br \/>\n6.<strong>\u3010\u30a8\u30e9\u30fc\u5185\u5bb9\u3011<\/strong>\u306b\u8a18\u8f09\u3057\u305f\u624b\u9806\u3067\u518d\u5ea6\u30ec\u30dd\u30fc\u30c8\u3092\u51fa\u529b\u3057\u307e\u3059<\/p>\n<p>\u3053\u3061\u3089\u306e\u624b\u9806\u3067\u30ec\u30dd\u30fc\u30c8\u51fa\u529b\u30a8\u30e9\u30fc\u306e\u56de\u907f\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3010\u30a8\u30e9\u30fc\u5185\u5bb9\u3011 \u30ec\u30dd\u30fc\u30c8\u30bf\u30d6&gt;&gt;\u65b0\u898f\u30ab\u30b9\u30bf\u30e0\u30ec\u30dd\u30fc\u30c8\u3000\u306b\u304a\u3044\u3066\u3001\u30ab\u30b9\u30bf\u30e0\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u969b\u3001 \u4ee5\u4e0b\u306e\u624b\u9806\u3067\u4f5c\u6210\u3092\u884c\u3046\u3068\u3001\u30ec\u30dd\u30fc\u30c8\u304c\u51fa\u529b\u3055\u2026 <a href=\"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=2217\" class=\"more\">\uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[5],"tags":[],"class_list":["post-2217","post","type-post","status-publish","format-standard","hentry","category-knownissue-sdp"],"modified_by":"takaaki","_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/2217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2217"}],"version-history":[{"count":2,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/2217\/revisions"}],"predecessor-version":[{"id":5677,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/2217\/revisions\/5677"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}