{"id":8668,"date":"2023-10-02T10:14:07","date_gmt":"2023-10-02T01:14:07","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=8668"},"modified":"2023-10-02T15:16:31","modified_gmt":"2023-10-02T06:16:31","slug":"%e5%95%8f%e9%a1%8c%e3%81%ae%e3%83%a1%e3%83%a2%e3%82%92%e5%87%ba%e5%8a%9b%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=8668","title":{"rendered":"\u554f\u984c\u306e\u30e1\u30e2\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"
\n

\u672c\u30ca\u30ec\u30c3\u30b8\u306e\u56de\u7b54\u306f\u30b0\u30ed\u30fc\u30d0\u30eb\u306e\u30ca\u30ec\u30c3\u30b8\u300cProblem Notes<\/a>\u300d\u3092\u53c2\u8003\u306b\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\n

\u3054\u8cea\u554f<\/h5>\n

\u554f\u984c\u306e\u30e1\u30e2\u306e\u5185\u5bb9\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u3059\u304b\u3002<\/p>\n

\u56de\u7b54<\/h5>\n

\u306f\u3044\u3001\u30ec\u30dd\u30fc\u30c8\u6a5f\u80fd\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001
\n\u554f\u984c\u306e\u30e1\u30e2\u3092\u30ec\u30dd\u30fc\u30c8\u3068\u3057\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u624b\u9806\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n

    \n
  1. \uff3b\u30ec\u30dd\u30fc\u30c8\uff3d\u30bf\u30d6\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/li>\n
  2. \uff3b\u65b0\u898f\u30ec\u30dd\u30fc\u30c8\uff3d\u2192\uff3b\u30af\u30a8\u30ea\u30ec\u30dd\u30fc\u30c8\uff3d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
  3. \u300c\u30af\u30a8\u30ea\u300d\u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u30b3\u30d4\u30fc&\u30da\u30fc\u30b9\u30c8\u3057\u307e\u3059\u3002
    \n

    SELECT prob.PROBLEMID \"Problem ID\",<\/p>\n

    prob.TITLE \"Title\",
    \nownaaa.FIRST_NAME \"Technician\",
    \nlongtodate(prob.REPORTEDTIME) \"Reported Date\",
    \nsdno.description \"Notes\" FROM Problem prob<\/div>\n

    LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID
    \nLEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID
    \nLEFT JOIN problemtonotes prono ON prob.PROBLEMID=prono.PROBLEMID
    \nLEFT JOIN problemnotes sdno ON prono.NOTESID=sdno.NOTESID
    \nORDER BY 1<\/p><\/blockquote>\n<\/li>\n

  4. \uff3b\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\uff3d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n
    \n
    \n
    \u30af\u30a8\u30ea\/\u30b9\u30af\u30ea\u30d7\u30c8\u30b5\u30dd\u30fc\u30c8\u306e\u6709\u511f\u5316\u306b\u3064\u3044\u3066<\/h5>\n

    2023\u5e744\u670820\u65e5\u3088\u308a\u3001ServiceDesk Plus\u304a\u3088\u3073ServiceDesk Plus Cloud\u3067\u306f\u3001
    \n\u30af\u30a8\u30ea\/\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30b5\u30dd\u30fc\u30c8\u5bfe\u5fdc\u304c\u4e00\u90e8\u6709\u511f\u3068\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n

    \u305d\u306e\u305f\u3081\u3001\u73fe\u5728\u516c\u958b\u3057\u3066\u3044\u308b\u30af\u30a8\u30ea\/\u30b9\u30af\u30ea\u30d7\u30c8<\/span>\u3092\u9664\u3044\u305f\u3001
    \n\u305d\u306e\u4ed6\u30af\u30a8\u30ea\/\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f5c\u6210\u4f9d\u983c\u306b\u3064\u3044\u3066\u306f\u3001\u305d\u306e\u63d0\u4f9b\u306e\u524d\u306b\u3001
    \n\u65e2\u306b\u8cfc\u5165\u3057\u3066\u3044\u305f\u3060\u3044\u3066\u3044\u308b\u30e9\u30a4\u30bb\u30f3\u30b9\u3068\u306f\u5225\u306b\u304a\u652f\u6255\u3044\u304c\u5fc5\u8981<\/span>\u3067\u3059\u3002<\/p>\n

    \n

    \u8a73\u3057\u304f\u306f\u300c\u30af\u30a8\u30ea\/\u30b9\u30af\u30ea\u30d7\u30c8\u30b5\u30dd\u30fc\u30c8\u306e\u6709\u511f\u5316\u306b\u3064\u3044\u3066<\/a>\u300d\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    \u672c\u30ca\u30ec\u30c3\u30b8\u306e\u56de\u7b54\u306f\u30b0\u30ed\u30fc\u30d0\u30eb\u306e\u30ca\u30ec\u30c3\u30b8\u300cProblem Notes\u300d\u3092\u53c2\u8003\u306b\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002 \u3054\u8cea\u554f \u554f\u984c\u306e\u30e1\u30e2\u306e\u5185\u5bb9\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u3059\u2026 \uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":89,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[3612272,8,7],"tags":[200,591,552,150,3612120],"class_list":["post-8668","post","type-post","status-publish","format-standard","hentry","category-faq-sdp","category-queryrep-sdp","category-config-sdp","tag-200","tag-591","tag-552","tag-150","tag-problem"],"modified_by":"daiki","_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/8668","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\/89"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8668"}],"version-history":[{"count":41,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/8668\/revisions"}],"predecessor-version":[{"id":8709,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/8668\/revisions\/8709"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}